1Z0-052多項(xiàng)選擇題每日一練(2019.05.09)

Examine the following output：
SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ -----------
EIND UNUSABLE
Which two statements about the above index are true（）

You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The FlashRecovery Area is specified as the destination for the archived redo log files. You notice this warning in thealert log file： 
ORA-19815： WARNING： db_recovery_file_dest_size of 3221225472 bytes is 100.00% used， and has 0remaining bytes available. 
What would you do to reclaim the used space in the Flash Recovery Area（）

Which two operations can be performed on an external table（）

You are managing an Oracle Database 11g database. The database is open， and you plan to perform
Recovery Manager （RMAN） backups. 
Which three statements are true about these backups（）

User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted： INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） * 
ERROR at line 1： 
ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem.（）