Sequence
Schema
Group
View
第1题:
A.Package
B.Trigger
C.Stored Procedure
D.Informational Constraint
第2题:
A.View
B.Table
C.Routine
D.Package
第3题:
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?()
A. User process
B. Server process
C. System Monitor (SMON)
D. Process Monitor (PMON)
E. Checkpoint process (CKPT)
第4题:
On which of the following database objects may the SELECT privilege be controlled?()
第5题:
A.smitty mksysb (select additional volume group)
B.mkszfile && mksysb /dev/rmt0
C.smitty mksysb AND smitty savevg
D.smitty savevg (select additional volume group)
第6题:
A.Sequence
B.Schema
C.Group
D.View
第7题:
A.Instance
B.Table space
C.System catalog
D.Schema repository
第8题:
A. All the objects of scott are moved to the Recycle Bin.
B. Any objects in the Recycle Bin belonging to scott are purged.
C. All the objects owned by scott are permanently dropped from the database.
D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
第9题:
Which of the following database objects is considered executable using SQL?()
第10题:
Which of the following database objects can be used to raise an error if a table is updated?()