A.AB.BC.CD.DE.EF.FWhich three statements about direct p……

多项选择题Some data storage and transfer media have fixed-length physical records.  When the data records are short， more then one can be stored in a single， physical record to use the storage space efficiently. Consider this data：   1119 Smith 1120 Yvonne 1121 Albert 1130 Thomas   Which two statements can you use to load the data into the EMP table？（）

A.A
B.B
C.C
D.D

单项选择题Data file DF1 belongs to tablespace TS1.，and the database is in ARCHIVELOG mode. You did an incomplete recover in the following steps：   1. Take data file DF1 offline.  2. Copy a backup copy of DF1 into the current DF1 location.  3. Execute RECOVER DATAFILE UNTIL TIME sometime in the past.  4. Bring DF1 online.  5. Execute ALTER DATABASE OPEN RESETLOGS.   To guarantee that the database is recoverable in the future， what is the least amount of work needed？（）

A.Back up the data file.
B.Bring tablespace TS1 online.
C.Copy redo logs to the backup directory.
D.Make a complete backup right after opening the database.

单项选择题Anindex-organizedtable（IOT）calledSPARSEhashadmanyrecordsdeleted.WhichcommandreorganizestheIOTsothattheemptyspaceisremoved，whileminimizingtheimpactforusers？（）

A.EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.
B.ALTER TABLE … COALESCE ；
C.ALTER INDEX …REBUILD ONLINE；
D.CREATE TABLE …AS SELECT_ONLINE；

多项选择题The CURSOR_SHARING parameter is set to SIMILAR at the instance level and you issue these SELECT statements in the order shown below：   SELECT * FROM employees WHERE department_id=50；  SELECT * FROM employees WHERE department_id=70； There is an index on the DEPARTMENT ID column of the 1，000，000 row EMPLOYEES table. Ninety percent of the employees are part of the DEPARTMENT_ID 50. In which two scenarios will Oracle9i share the corresponding cursors for the two statements？（）

A.A
B.B
C.C
D.D

单项选择题ThedirecthandoffconnectionmethodtoanOracle9iSharedServerinvolvesfewermessagesthaninpreviousreleasesofthemultithreadedarchitecture.Whichtypeofmessagehasbeeneliminated？（）

A.The initial request from the client to the listener.
B.Messages between the dispatcher and the shared server background processes.
C.A redirect message from the listener to the client during client connections.
D.Round-trip messages between the listener and the shared server background processes.