多项选择题

Archive file format LOG_ARCHIVE_FORMAT is defined as arch_%s.arc. A week ago， you just archived arch_4.arch to tape， then removed all archived files to save disk space. Yesterday you saw arch_10.arc and arch_11.arc on the disk. Today， you see arch_3.arc in the archive directory.
Which two could you happened？（）

A.Redo logs were restored from tape for recovery.
B.The file names are only used when they are copied to tape.
C.The database was opened with the RESETLOGS option and log numbers restarted.
D.Log names run in circular fashion; arch_3.arc is re-created by the ARCn process.
E.A file name is randomly chosen by the archive process; as long as it is unique, it does not have to be sequential.

<上一题目录下一题>

热门试题

多项选择题InRMAN，whentheRESYNCCATALOGcommandisissued，inwhichtwosituationsdoesthecommandfileactuallyperformsynchronization？（）

A.After the COPY command.
B.After adding a data file in the target database.
C.After adding a tablespace in the target database.
D.After adding a tablespace in the catalog database.
E.After dropping a data file in the catalog database.
F.After running SQL Loader to load a large amount of data.

多项选择题Which three statements about direct path exports are true？（）

A.A
B.B
C.C
D.D
E.E
F.F

多项选择题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；