black

1Z0-042

登录

单项选择题

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? ()

A.The table is moved to the SYSAUX tablespace.
B.The table is moved to the SYSTEM tablespace.
C.The table is removed from the database permanently.
D.The table is renamed and remains in the TBSFD tablespace.

相关考题

单项选择题 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?()

单项选择题 Youhavealargeamountofhistoricaldatainanoperatingsystemfile.Someanalystsinyourorganizationneedtoquerythisdata.Thefileistoolargetoloadintoyourcurrentdatabase.Whichisthemosteffectivemethodtoaccomplishthetask?()

单项选择题 Whichnamingmethodusesthetnsnames.orafiletostoretheconnectdescriptorusedbytheclientwhileconnectingtothedatabaseinstancefromaremotemachine?()

All Rights Reserved 版权所有©建筑考试题库(jzkao.com)

备案号:湘ICP备2020024380号-3