移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

计算机考试 | Oracle认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

多选题 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 Scheduler view(s) can be queried to see which jobs are currently executing? ()

A

DBA_SCHEDULER_JOB_RUN_DETAILS

B

DBA_SCHEDULER_RUNNING_JOBS DBA

C

DBA_SCHEDULER_CURRENT_JOBS

D

DBA_SCHEDULER_JOBS DBA

E

DBA_SCHEDULER_EXECUTING_JOBS

单选题 Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? ()

A

SQL statements that are part of the AWR baseline only 

B

SQL statements based on the AWR top SQL identification

C

SQL statements that are part of the available SQL Tuning Set (STS) only 

D

SQL statements that are available in the cursor cache and executed by a user other than SYS 

单选题 An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?()

A

TEST_TBS is a small file tablespace.

B

TEST_TBS is a bigfile tablespace (BFT).

C

TEST_TBS is the default temporary tablespace.

D

TEST_TBS is a dictionary-managed tablespace.

单选题 After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()

A

Opening the database in RESTRICTED mode

B

Opening the database with the RESETLOGS option

C

Setting a new DBID for the newly restored database

D

Restoring the server parameter file (SPFILE) to the new host

单选题 You executed the following commands in an RMAN session for your database instance that has failures: RMAN> LIST FAILURE; After some time, you executed the following command in the same session: RMAN> ADVISE FAILURE; But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?()

A

It produces a warning for new failures before advising for CRITICAL and HIGH failures.

B

It ignores new failures and considers the failures listed in the last LIST FAILURE command only.

C

It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

D

It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

单选题 Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?()

A

The shrink operation touches every block in the BOOKING table

B

The high-water mark (HWM) for the BOOKING table is shifted from its original position

C

The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table

D

The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation

单选题 A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: What happens when the whole CONTROLLER1 Failure group is damaged?()

A

The transactions that use the disk group will halt.

B

The mirroring of allocation units occurs within the CONTROLLER2 failure group.

C

The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.

D

The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.

单选题 On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? ()

A

Check the alert log file

B

Query the V$FLASHBACK_DATABASE_LOG view

C

Query the V$RECOVERY_FILE_DEST_SIZE view

D

Query the V$FLASHBACK_DATABASE_STAT view

E

Check the value assigned for the UNDO_RETENTION parameter

最新资讯

首页 上一页 1 2 3 4 5 下一页 尾页 /

到第