单选题On which of the following database objects may the SELECT privilege be controlled?（）ASequenceBSchemaCGroupDView
单选题
On which of the following database objects may the SELECT privilege be controlled?（）
A
Sequence
B
Schema
C
Group
D
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?（）AMaterialized views BIndexes CIndex-organized tables DHash clusters
单选题A trigger can be created on which of the following objects?（）AViewBCatalog TableCStored ProcedureDGlobal 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?（）AThe value for MINEXTENTS setting BThe value for PCTINCREASE setting CThe value for MAXEXTENTS setting DBy 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?（）Asmitty mksysb (select additional volume group)Bmkszfile mksysb /dev/rmt0Csmitty mksysb AND smitty savevgDsmitty 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?（）AAcquire locks on table queried BGenerate redo for statement CFetch data from disk into memory DWrite 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?（）AUser processBServer processCSystem Monitor (SMON)DProcess Monitor (PMON)ECheckpoint process (CKPT)
单选题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）AV$DATABASE BDBA_TABLES CSYSAUD$ DEMP
单选题Which statement is true about the database and database-user used during installation of IMS Server？（）AA preexisting database user may be used but a new database has to be created during installation.BA preexisting database may be used but a new database user has to be created during installation.CA preexisting database and user may be used or a new database and user are created during installation.DA preexisting database and user cannot be used； a new database and user are created during installation.