An online tablespace，TEST_TBS，is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace.  What could be the reason，if the TEST_TBS tablespace does not include autoextensible data files？（）  

Examine the following parameter settings from an initialization （init.ora） file：   DB_CREATE_FILE_DEST =’/u01/oradata/’  DB_CREATE_ONLINE_LOG_DEST_1 =’/u02/oradata/’  DB_CREATE_ONLINE_LOG_DEST_2 =’/u03/oradata/’   If you create an Oracle Managed Files （OMF） database using these settings， what is the result？（）

单选题查看答案

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

多选题查看答案

You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it.  What action is required for dependent objects when you perform online table redefinition？（）  

单选题查看答案

You issue this SQL command to perform an online backup of the USER_DATA tablespace：ALTER TABLESPACE user_data BEGIN BACKUP；Next， you issue an operating system command to back up user_data01.dbf， the file that belongs to the USER_DATA tablespace. You then experience an instance failure.  Which three statements are true？（）

多选题查看答案

Which are the correct steps， in order， to deal with the loss of an online redo log if the database has not yet crashed？（）   a. Issue a checkpoint.  b. Shut down the database.  c. Issue an alter database open command to open the database.  d. Startup mount the database.  e. Issue an alter database clear logfile command.  f. Recover all database datafiles.

单选题查看答案

What is the correct order of steps to perform an online database backup？（）   a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfile

单选题查看答案

Given： Which code， inserted at line 15， creates an instance of the Point class defined in Line？（）

单选题查看答案

The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.  What action is required for the dependent objects when you perform online redefinition on the table？（）

单选题查看答案

Given：  Which code， inserted at line 15， creates an instance of the Point class defined in Line？（）

单选题查看答案