多选题Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?（）AAn EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the

第1题：

SQL*Loader reads a set of records from a file， generates INSERT commands， and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario？（）

• A、direct-path load
• B、conventional path load

第2题：

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）

• A、It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
• B、It fails because no SQL *Loader data file location is specified.
• C、It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
• D、It fails because no SQL *Loader control file location is specified.

第3题：

第4题：

You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader directpath load method to perform this task. The table in which you plan to load data is an important tablehaving various integrity constraints defined on it.  Which constraints will remain enabled by default during this operation（）

• A、CHECK
• B、UNIQUE
• C、NOT NULL
• D、PRIMARY KEY
• E、FOREIGN KEY

第5题：

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.

第6题：

You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; Which two statements are correct？（）

• A、The FLASHBACK TABLE statement will not be written to the alert log file.
• B、The changes made to the EMP table since the specified time will be undone.
• C、The EMP table that was dropped by mistake from the database will be restored.
• D、The FLASHBACK TABLE statement will be executed within a single transaction.
• E、The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table. 
• F、The list of transactions that have modified the EMP table since the specified time will be displayed.

第7题：

Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?（）

• A、An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
• B、The SQL* Loader data file myfile1.dat has the column names for the EMP table.
• C、The SQL* Loader operation fails because no record terminators are specified.
• D、Field names should be the first line in the both the SQL* Loader data files.
• E、The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

第8题：

第9题：

You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it.  Which constraints will remain enabled by default during this operation（）

• A、CHECK
• B、UNIQUE
• C、NOT NULL
• D、PRIMARY KEY
• E、FOREIGN KEY

第10题：

Examine these two statements:Which three are true about the MRKT tablespace?（）

• A、The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
• B、The MRKT tablespace may be dropped if it has no contents.
• C、Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
• D、No more data files can be added to the tablespace.
• E、The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.