Which is the memory area that is created when a dedicated server process is started， and contains data and control information for that server process？（）

A.SGA
B.PGA
C.Shared Pool
D.Streams Pool

点击查看答案

上一题目录下一题

相关考题

单项选择题

You execute the following command to audit the database activities：
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；
What is the effect of this command？（）

A.One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B.One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C.One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D.One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E.One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

单项选择题

Your database is not configured for session failover. Your tnsnames.ora file contains the following details：
test.us.oracle.com= （DESCRIPTION=
（ADDRESS_LIST= （LOAD_BALANCE=off）
（FAILOVER=ON）
（ADDRESS= （PROTOCOL=tcp）（HOST=test1-server）（PORT=1521））
（ADDRESS= （PROTOCOL=tcp）（HOST=test2-server）（PORT=1521）））
（CONNECT_DATA= （SERVICE_NAME=test.us.oracle.com）））
Which feature is enabled in this case？（）

A.Load balancing
B.Instance failover
C.Database failover
D.Connect-time failover
E.Transparent Application Failover （TAF）

单项选择题

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

备案号：湘ICP备2022003000号-1

关注
顶部

微信扫一扫,加关注免费搜题