The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? ()(Choose two)
AAll the related indexes and views are automatically dropped
BThe flashback drop feature can recover only the table structure
COnly the related indexes are dropped whereas views are invalidated
DThe flashback drop feature can recover both the table structure and its data
相关问题推荐
-
Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?()
A、It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
B、It will be successful only if the memory is available from the auto tuned components
C、It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
D、It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
-
在Windows Server 2003下若选择安全登录,则首先需要按(38)组合键。
A.Shiff+Alt+Esc
B.Ctrl+Alt+Tab
C.Ctrl+Shiff
D.Ctrl+Alt+Delete
-
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?()
Athe SQL text
Bthe execution plan
Cthe execution context
Dthe execution frequency
Ethe system change number (SCN)
-
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?()
A、 Data Pump Export and Import
B、 conventional export and import
C、 the CONVERT command of RMAN
D、 the BACKUP AS COPY. command of RMAN
-
用Linux ls-al命令列出下面的文件列表,(33)是块设备文件。
A.drwx----1 hel users 1024 Sep 10 08:10 aaa
B.-rw----2 hel-s users 56 Sep 09 11:05 bbb
C.brw----2 hel-s users 56 Sep 09 11:05 ccc
D.1rwx----1 hel users 2024 Sep 12 08:12 ddd