网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
On which of the following database objects may the SELECT privilege be controlled?（）
A
Sequence
B
Schema
C
Group
D
View
参考答案
参考解析
解析：
暂无解析
更多 “单选题On which of the following database objects may the SELECT privilege be controlled?（）A SequenceB SchemaC GroupD View” 相关考题
考题
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 processB. Server processC. System Monitor (SMON)D. Process Monitor (PMON)E. Checkpoint process (CKPT)
考题
You executed the following command to drop a user:DROP USER scott CASCADE;Which two statements regarding the above command are correct?()
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.
考题
Which of the following database objects can be used to raise an error if a table is updated?()
A.PackageB.TriggerC.Stored ProcedureD.Informational Constraint
考题
On which of the following database objects may the SELECT privilege be controlled?()
A.SequenceB.SchemaC.GroupD.View
考题
Which of the following database objects is considered executable using SQL?()
A.ViewB.TableC.RoutineD.Package
考题
Which of the following describes the objects of a DB2 database and their relationships?()
A.InstanceB.Table spaceC.System catalogD.Schema repository
考题
An AIX system has a rootvg plus a separate volume group for database application. Which of the following commands are sued to backup the entire system?()
A.smitty mksysb (select additional volume group)B.mkszfile mksysb /dev/rmt0C.smitty mksysb AND smitty savevgD.smitty savevg (select additional volume group)
考题
Which of the following database objects is considered executable using SQL?（）A、ViewB、TableC、RoutineD、Package
考题
On which of the following database objects may the SELECT privilege be controlled?（）A、SequenceB、SchemaC、GroupD、View
考题
Which of the following database objects can be used to raise an error if a table is updated?（）A、PackageB、TriggerC、Stored ProcedureD、Informational Constraint
考题
An insurance provider maintains a claims database where claims adjusters are adding new claims and updating existing claims everyday. In the evening， a batch process is run to analyze data entered throughout the day. To reduce costs， a shared storage solution is being considered. Which of the following questions should the consultant ask to select the best performing storage configuration that meets their budget requirements？（）A、What database is being used？B、Which client operating systems will access the database？C、Which vendor’s Fibre Channel switch do they prefer？D、What volume of data is analyzed each evening？
考题
Which statement is true about the database and database-user used during installation of IMS Server？（）A、A preexisting database user may be used but a new database has to be created during installation.B、A preexisting database may be used but a new database user has to be created during installation.C、A preexisting database and user may be used or a new database and user are created during installation.D、A preexisting database and user cannot be used； a new database and user are created during installation.
考题
Marry wants to create a new application on his laptop that does not have any design elements in it. Which one of the following should he do to begin his process?（）A、 select file-Database-new and give it a filename of “blank.nsf” B、 select file-Database-new,choose local as the server,and chose the blank template C、 select file-Database-new,choose local as the server,and chose the default.ntf template D、 select file-Database-new,give it a filename of “blank.nsf”,and chose the blank template
考题
Which of the following are types of routine objects?（）A、Package and functionB、Function and userexitC、Procedure and packageD、Function and procedure
考题
A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?（）A、AliasB、ViewC、SchemaD、Trigger
考题
Select valid reasons for IT performance issues that cannot be universally solved by adding more hardware：（）A、 adding hardware may exacerbate inefficiency， which can lead to over provisioning and lower utilizationB、 performance may degrade due to bottlenecks such as database connections that won’t scale in lock step with other dimensions such as computing capacity or memoryC、 both A and B are validD、 neither A nor B are valid
考题
A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）A、The value for MINEXTENTS setting B、The value for PCTINCREASE setting C、The value for MAXEXTENTS setting D、By default, Oracle allocates six extents to all database objects
考题
单选题Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）A
Materialized views B
Indexes C
Index-organized tables D
Hash clusters
考题
单选题A trigger can be created on which of the following objects?（）A
ViewB
Catalog TableC
Stored ProcedureD
Global Temporary Table
考题
多选题You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）AAll the objects of scott are moved to the Recycle Bin.BAny objects in the Recycle Bin belonging to scott are purged.CAll the objects owned by scott are permanently dropped from the database.DAll the objects of scott in the Recycle Bin must be purged before executing the DROP command.EAny objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
考题
单选题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 processB
Server processC
System Monitor （SMON）D
Process Monitor （PMON）E
Checkpoint process （CKPT）
考题
单选题A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）A
The value for MINEXTENTS setting B
The value for PCTINCREASE setting C
The value for MAXEXTENTS setting D
By default, Oracle allocates six extents to all database objects
考题
单选题An AIX system has a rootvg plus a separate volume group for database application. Which of the following commands are sued to backup the entire system?（）A
smitty mksysb (select additional volume group)B
mkszfile mksysb /dev/rmt0C
smitty mksysb AND smitty savevgD
smitty savevg (select additional volume group)
考题
单选题Select valid reasons for IT performance issues that cannot be universally solved by adding more hardware：（）A
adding hardware may exacerbate inefficiency， which can lead to over provisioning and lower utilizationB
performance may degrade due to bottlenecks such as database connections that won’t scale in lock step with other dimensions such as computing capacity or memoryC
both A and B are validD
neither A nor B are valid
考题
单选题A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）A
Acquire locks on table queried B
Generate redo for statement C
Fetch data from disk into memory D
Write changes to disk
考题
单选题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 processB
Server processC
System Monitor (SMON)D
Process Monitor (PMON)E
Checkpoint process (CKPT)
考题
单选题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）A
V$DATABASE B
DBA_TABLES C
SYSAUD$ D
EMP
考题
单选题Which statement is true about the database and database-user used during installation of IMS Server？（）A
A preexisting database user may be used but a new database has to be created during installation.B
A preexisting database may be used but a new database user has to be created during installation.C
A preexisting database and user may be used or a new database and user are created during installation.D
A preexisting database and user cannot be used； a new database and user are created during installation.
热门标签
最新试卷