单选题Which files must be synchronized in order for a database to start？（）Atemp filesBonline data filesCoffline data filesDread only data files
单选题
Which files must be synchronized in order for a database to start？（）
A
temp files
B
online data files
C
offline data files
D
read only data files
参考解析
解析：
暂无解析
相关考题：
Which two statements are correct about database transportation?() (Choose two.) A. The source and target platforms must be the sameB. Redo logs, control files and temp files are also transportedC. The transported database must have the same database identifier (DBID) as the source database and cannot be changedD. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedE. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?() (Choose three.) A. Both source and target database must be the same character setB. Both source and target database must have the same endian formatC. The COMPATIBLE parameter must be the same in the source and target databases.D. The minimum compatibility level for both the source and target database must be 10.0.0.E. All read-only and offline data files that belong to the tablespace to be transported must be platform aware.
Which statement is true concerning dropping a pluggable database (PDB)?() A. The PDB must be open in read-only mode.B. The PDB must be in mount state.C. The PDB must be unplugged.D. The PDB data files are always removed from disk.E. A dropped PDB can never be plugged back into a multitenant container database (CDB).
A system administrator needs to backup datavg which contains a database that pre-allocates files by padding them with nulls, similar to treating them as sparse files. In order to effectively backup and be able to restore the datavg files, which backup method should be used?（）A.savevgB.tarC.cpioD.mksysb
Which two statements are correct about database transportation？（） A、 The source and target platforms must be the sameB、 Redo logs，control files and temp files are also transportedC、 The transported database must have the same database identifier （DBID） as the source database and cannot be changedD、 The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedE、 Recovery Manager （RMAN） is used to convert the necessary data files of the database if the target platform is different and has different endian format
When setting up a modem， which of the following files MUST be edited in order to configure it？（）A、/etc/rc.tcpipB、/etc/uucp/DevicesC、/etc/rc.netD、/etc/uucp/Dialcodes
Which statement is true concerning dropping a pluggable database (PDB)?（）A、The PDB must be open in read-only mode.B、The PDB must be in mount state.C、The PDB must be unplugged.D、The PDB data files are always removed from disk.E、A dropped PDB can never be plugged back into a multitenant container database (CDB).
When performing an incomplete recover of the whole database， which data files must you restore？ （）A、Only the damaged or lost data files.B、All of the data files of the database.C、Only the data files belonging to the SYSTEM tablespace.D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.
In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?（）A、Password file B、Initialization file C、Datafile D、Control file E、Nothing - SYSDBA privileges are not required for these actions
You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）A、 SYSDATE should not be used with TIMESTAMP.B、 The database must have multiplexed redo log files.C、 The database must be in the MOUNT state to execute the command.D、 The database must be opened with the RESETLOGS option after the flashback operation.E、 The entire database needs to be restored from the most recent backup before the flashback operation.
What are the prerequisites for enabling Flashback Database？ （）A、 The database must be started in the MOUNT EXCLUSIVE state.B、 The database must have multiplexed control files.C、 The database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）.D、 The database must be in ARCHIVELOG mode.E、 The database must be in the NOMOUNT state.F、 The database must be opened in RESTRICTED mode.
Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion？（）A、 The database must be in read-write mode.B、 The database must have no external files.C、 The database must open in read-only mode.D、 The database must be mounted but not opened.
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）A、The database will open, and the tablespace automatically comes out of the backup modeB、The database will be mounted, and recovery must be performed on the USERS tablespace.C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
单选题In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?（）APassword file BInitialization file CDatafile DControl file ENothing - SYSDBA privileges are not required for these actions
多选题Which two statements are correct about database transportation? （）AThe source and target platforms must be the sameBRedo logs, control files and temp files are also transportedCThe transported database must have the same database identifier (DBID) as the source database and cannot be changedDThe COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedERecovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
多选题Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（）ABoth source and target database must be the same character setBBoth source and target database must have the same endian formatCThe COMPATIBLE parameter must be the same in the source and target databases.DThe minimum compatibility level for both the source and target database must be 10.0.0.EAll read-only and offline data files that belong to the tablespace to be transported must be platform aware.
多选题Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（） (Choose three.)ABoth source and target database must be the same character setBBoth source and target database must have the same endian formatCThe COMPATIBLE parameter must be the same in the source and target databases.DThe minimum compatibility level for both the source and target database must be 10.0.0.EAll read-only and offline data files that belong to the tablespace to be transported must be platform aware.
单选题A system administrator needs to backup datavg which contains a database that pre-allocates files by padding them with nulls, similar to treating them as sparse files. In order to effectively backup and be able to restore the datavg files, which backup method should be used?（）AsavevgBtarCcpioDmksysb
多选题You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area （FRA） for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
单选题When setting up a modem， which of the following files MUST be edited in order to configure it？（）A/etc/rc.tcpipB/etc/uucp/DevicesC/etc/rc.netD/etc/uucp/Dialcodes
单选题When performing an incomplete recover of the whole database， which data files must you restore？ （）AOnly the damaged or lost data files.BAll of the data files of the database.COnly the data files belonging to the SYSTEM tablespace.DThe data files belonging to the SYSTEM tablespace and the damaged or lost data files.
单选题Which statement is true concerning dropping a pluggable database (PDB)?（）AThe PDB must be open in read-only mode.BThe PDB must be in mount state.CThe PDB must be unplugged.DThe PDB data files are always removed from disk.EA dropped PDB can never be plugged back into a multitenant container database (CDB).
单选题If you create your database using Oracle Managed Files （OMF）， what is true？（）AYou must use Oracle predefined names to identify raw partitions that will hold OMF structures. BYou must define directories for two online redo log groups and three copies of the control file. CIf your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. DYou must use only OMF data files when adding new tablespaces or data files to your database in the future.
单选题To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）AThe database will open, and the tablespace automatically comes out of the backup mode.BThe database will be mounted, and recovery must be performed on the USERS tablespace.CThe database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.DThe database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
多选题What are the prerequisites for enabling Flashback Database？ （）AThe database must be started in the MOUNT EXCLUSIVE state.BThe database must have multiplexed control files.CThe database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）.DThe database must be in ARCHIVELOG mode.EThe database must be in the NOMOUNT state.FThe database must be opened in RESTRICTED mode.
多选题Examine the following impdp command to import a database over the network from a pre-12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?（）AThe import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.BAll the user-defined tablespaces must be in read-only mode on the source database.CThe export dump file must be created before starting the import on the target database.DThe source and target database must be running on the same platform with the same endianness.EThe path of data files on the target database must be the same as that on the source database.FThe impdp operation must be performed by the same user that performed the expdp operation.
单选题Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion？（）A The database must be in read-write mode.B The database must have no external files.C The database must open in read-only mode.D The database must be mounted but not opened.