单选题Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the

题目

单选题

Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL> DROP TABLE emp；Table dropped. What happens in this scenario？（）

The table is moved to the SYSAUX tablespace.

The table is moved to the SYSTEM tablespace.

The table is removed from the database permanently.

The table is renamed and remains in the TBSFD tablespace.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Examine the following set of RMAN commands:Which statement is true when the RMAN RUN block Is executed?()

A. The execution of the script fails because multiple channels cannot coexist.

B. The script is executed and both the channels are used for the script execution.

C. The new channel, CHI, is Ignored because a channel has been configured already.

D. ration parameter DC1 is overridden because a new channel is allocated in RMAN RUN block.

参考答案：D

第2题：

Which of the following commands should Karen, a technician, use to examine and restoreprotected system files?（）

A、SFC
B、RECOVER
C、REPLACE
D、COPY

正确答案:A

第3题：

Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）

A. Flashback logging is not enabled for the database.

B. The changes made to the table are not committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.

参考答案：B

第4题：

You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

A、 The time when the last flashback operation in your database was performed.
B、 The time when the first flashback operation in your database was performed.
C、 A list of flashback operations performed in your database using SCN and time.
D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.

正确答案:D

第5题：

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN> BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）

A、 control file
B、 all datafiles
C、 password file
D、 online redo log file
E、 archive redo log file
F、 server parameter file
G、 only the SYSTEM datafile

正确答案:A,B,F

第6题：

Examine the following commands and their output:View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）

A. Flashback logging is not enabled for the database.

B. The changes made to the table are not committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.

参考答案：B

第7题：

Which of the following commands displays the number of system calls per second that are being executed？（）

A、 sar
B、 pstat
C、 iostat
D、 filemon

正确答案:A

第8题：

In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:Which statement is true about the outcome?（）

A. Only one channel is allocated and the backup is created in the flash recovery area

B. Only one channel is allocated and the backup is created in the destination specified for channel

C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2

D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

参考答案：A

第9题：

You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

A、renaming the control files
B、dropping a user in your database
C、enabling or disabling redo log archiving
D、dropping a tablespace in your database
E、re-creating the control files， after you lost all the control files in your database

正确答案:C

第10题：

What is the impact of the following backup if it exceeds the duration allowance？（） Backup as compressed backupset duration 2：00 partial minimize load database ；

A、 The entire backup will fail.It will not be usable for recovery.
B、 The entire backup will failbut any datafile successfully backed up will be usable for recovery.
C、 If this backup fails，subsequent backups will prioritize datafiles not backed up.
D、 If this backup fails，an error will be raised and any other commands will not be executed.
E、 If this backup fails，no error will be raised and any other commands will be executed.

正确答案:B

Examine the following commands executed in your database： SQ

题目

相似问题和答案

更多相关问题

相关内容