可学答题网 > 问答 > OCP 11G认证考试题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You executed the following SQL statem


You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?()

  • A The EMPLOYEES table will be changed to read-only mode during the shrink operation.
  • B The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
  • C The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
  • D Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
参考答案
参考解析:
分类:OCP 11G认证考试题库
相关推荐

1、You execute the follow

You execute the following command to enable a session in resumable mode: SQL> ALTER SESSION&en...

2、You execute the follow

You execute the following command to audit the database activities:  SQL> AUDIT DROP ANY ...

3、You execute the following PL/SQL:Which

You execute the following PL/SQL:Which two statements are true?()A Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS...

4、You executed the following commands i

You executed the following commands in a database session:What could have caused the recycle bin to clean up?()A There is demand for space f...

5、You executed the following PL/SQL blo

You executed the following PL/SQL block successfully:The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis.()A with the...

6、You execute the following commands to

You execute the following commands to audit database activities:SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;SQL > AUDIT SELECT TA...