单选题Which of the following provides a logical grouping of database objects?（）A ViewB TableC SchemaD Buffer pool

题目
单选题
Which of the following provides a logical grouping of database objects?（）
A

View

B

Table

C

Schema

D

Buffer pool

相似考题

1.On which of the following database objects may the SELECT privilege be controlled?()A.SequenceB.SchemaC.GroupD.View

2.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

3.A trigger can be created on which of the following objects?()A.ViewB.Catalog TableC.Stored ProcedureD.Global Temporary Table

4.Which of the following database objects is considered executable using SQL?()A.ViewB.TableC.RoutineD.Package

更多“单选题Which of the following provides a logical grouping of database objects?（）A ViewB TableC SchemaD Buffer pool”相关问题

  • 第1题：

    Which of the following provides a logical grouping of database objects?()

    A.View

    B.Table

    C.Schema

    D.Buffer pool


    参考答案：C

  • 第2题：

    Which of the following provides a logical grouping of database objects?（）

    • A、View
    • B、Table
    • C、Schema
    • D、Buffer pool

    正确答案:C

  • 第3题：

    On which of the following database objects may the SELECT privilege be controlled?（）

    • A、Sequence
    • B、Schema
    • C、Group
    • D、View

    正确答案:D

  • 第4题：

    Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）

    • A、View
    • B、Alias
    • C、Table
    • D、Package

    正确答案:B

  • 第5题：

    The WebSphere Application Server provides a Dynamic Cache Monitor.  Which of the following can be monitored using this tool？（）

    • A、Servlet Response Times
    • B、Cache Statistics
    • C、Database Connection Pool Statistics
    • D、Disk Statistics

    正确答案:B,D

  • 第6题：

    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.

    正确答案:B,D

  • 第7题：

    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

    正确答案:B

  • 第8题：

    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=Y
    • B、DIRECT=Y
    • C、CONSISTENT=Y
    • D、BUFFER=Y

    正确答案:C

  • 第9题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    Which of the following describes the objects of a DB2 database and their relationships?（）
    A

    Instance

    B

    Table space

    C

    System catalog

    D

    Schema repository


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    A trigger can be created on which of the following objects?（）

    • A、View
    • B、Catalog Table
    • C、Stored Procedure
    • D、Global Temporary Table

    正确答案:A

  • 第14题：

    Which of the following database objects is considered executable using SQL?（）

    • A、View
    • B、Table
    • C、Routine
    • D、Package

    正确答案:C

  • 第15题：

    Which of the following database objects can be used to raise an error if a table is updated?（）

    • A、Package
    • B、Trigger
    • C、Stored Procedure
    • D、Informational Constraint

    正确答案:B

  • 第16题：

    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、Alias
    • B、View
    • C、Schema
    • D、Trigger

    正确答案:B

  • 第17题：

    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、FULL
    • B、SCHEMAS
    • C、REMAP_SCHEMA
    • D、REMAP_DATAFILES
    • E、REMAP_TABLESPACE

    正确答案:C

  • 第18题：

    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.

    正确答案:E

  • 第19题：

    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 pool
    • B、streams pool
    • C、keep buffer cache
    • D、recycle buffer cache

    正确答案:A

  • 第20题：

    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.

    正确答案:E

  • 第21题：

    单选题
    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 pool

    B

    streams pool

    C

    keep buffer cache

    D

    recycle buffer cache


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    Which of the following database objects is considered executable using SQL?（）
    A

    View

    B

    Table

    C

    Routine

    D

    Package


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    Which of the following provides a logical grouping of database objects?（）
    A

    View

    B

    Table

    C

    Schema

    D

    Buffer pool


    正确答案： D
    解析： 暂无解析

  • 第24题：

    多选题
    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_BUFFER

    B

    DB_CACHE_SIZE

    C

    JAVA_POOL_SIZE

    D

    LARGE_POOL_SIZE

    E

    SHARED_POOL_SIZE

    F

    STREAMS_POOL_SIZE


    正确答案： E,A
    解析： 暂无解析

相关内容