网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Which of the following provides a logical grouping of database objects?（）
- A、View
- B、Table
- C、Schema
- D、Buffer pool
参考答案
更多 “Which of the following provides a logical grouping of database objects?（）A、ViewB、TableC、SchemaD、Buffer pool” 相关考题
考题
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
考题
Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?()
A.ViewB.AliasC.TableD.Package
考题
A trigger can be created on which of the following objects?()
A.ViewB.Catalog TableC.Stored ProcedureD.Global Temporary Table
考题
Which of the following provides a logical grouping of database objects?()
A.ViewB.TableC.SchemaD.Buffer pool
考题
A trigger can be created on which of the following objects?（）A、ViewB、Catalog TableC、Stored ProcedureD、Global Temporary Table
考题
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
考题
Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）A、ViewB、AliasC、TableD、Package
考题
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
考题
The WebSphere Application Server provides a Dynamic Cache Monitor. Which of the following can be monitored using this tool？（）A、Servlet Response TimesB、Cache StatisticsC、Database Connection Pool StatisticsD、Disk Statistics
考题
You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）A、FULLB、SCHEMASC、REMAP_SCHEMAD、REMAP_DATAFILESE、REMAP_TABLESPACE
考题
The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）A、 LOG_BUFFERB、 DB_CACHE_SIZEC、 JAVA_POOL_SIZED、 LARGE_POOL_SIZEE、 SHARED_POOL_SIZEF、 STREAMS_POOL_SIZE
考题
Which of the following statements are true regarding the Recycle Bin？（）A、 The Recycle Bin is a physical storage area for dropped objects.B、 The Recycle Bin is a logical container for dropped objects.C、 The Recycle Bin stores the results of a Flashback Drop operation.D、 The objects in the Recycle Bin are stored in the tablespace in which they were created.
考题
You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）A、Configure Java Pool to cache the java objects.B、Configure Streams Pool to enable parallel processing.C、Increase Shared Pool size to cache more PL/SQL objects.D、Increase Database Buffer Cache size to increase cache hits.E、Configure Large Pool to be used by RMAN and shared server.F、Increase the total System Global Area （SGA） size to increase memory hits.
考题
Records from the data dictionary information are stored in which of the following database memory areas?（）A、Library cache B、Row cache C、Session UGA D、Buffer cache
考题
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
考题
Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area （UGA） information and improve the shared pool performance？（）A、large poolB、streams poolC、keep buffer cacheD、recycle buffer cache
考题
Which one of the following parameters must be specified when exporting objects that has integrity constraints referencing objects that are currently being accessed by other users？（）A、IGNORE=YB、DIRECT=YC、CONSISTENT=YD、BUFFER=Y
考题
You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）A、Configure Java Pool to cache the java objects.B、Configure Streams Pool to enable parallel processing.C、Increase Shared Pool size to cache more PL/SQL objects.D、Increase Database Buffer Cache size to increase cache hits.E、Configure Large Pool to be used by RMAN and shared server.F、Increase the total System Global Area （SGA） size to increase memory hits.
考题
多选题Which of the following statements are true regarding the Recycle Bin？（）AThe Recycle Bin is a physical storage area for dropped objects.BThe Recycle Bin is a logical container for dropped objects.CThe Recycle Bin stores the results of a Flashback Drop operation.DThe objects in the Recycle Bin are stored in the tablespace in which they were created.
考题
单选题Which of the following provides a logical grouping of database objects?（）A
ViewB
TableC
SchemaD
Buffer pool
考题
多选题The WebSphere Application Server provides a Dynamic Cache Monitor. Which of the following can be monitored using this tool？（）AServlet Response TimesBCache StatisticsCDatabase Connection Pool StatisticsDDisk Statistics
考题
多选题The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）ALOG_BUFFERBDB_CACHE_SIZECJAVA_POOL_SIZEDLARGE_POOL_SIZEESHARED_POOL_SIZEFSTREAMS_POOL_SIZE
热门标签
最新试卷
