网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()
A

 You do not need to restore all the data files.

B

 You do not need to open the database with the RESETLOGS operation

C

 You do not need to perform a full backup after the RESETLOGS operation.

D

 You do not need to recover all the data files to the same system change number (SCN).


参考答案

参考解析
解析: 暂无解析
更多 “单选题You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()A  You do not need to restore all the data files.B  You do not need to open the database with the RESETLOGS operationC  You do not need to perform a full backup after the RESETLOGS operation.D  You do not need to recover all the data files to the same system change number (SCN).” 相关考题
考题 You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?()A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE path;C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE path;D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

考题 Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?() A. By default, EM express is available for a database after database creation.B. You can use EM express to manage multiple databases running on the same server.C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.D. You cannot start up or shut down a database Instance by using EM express.E. You can create and configure pluggable databases by using EM express.

考题 You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achieve this?()A. Use Oracle Managed Files (OMF).B. Specify the SEED FILE_NAME_CONVERT clause.C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.D. Specify the DB_FILE_NAMECONVERT initialization parameter.E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

考题 Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true?()A、Displays only the list of default valuesB、Displays only the list of all basic parametersC、Displays the currently in effect parameter valuesD、Displays only the list of all advanced parametersE、Displays the list of all the parameter files of a databaseF、Displays the current contents of the server parameter file.

考题 Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()A、The database is in mount state.B、One of the tablespaces is offline.C、One of the tablespaces is read only.D、The database operates in ARCHIEVELOG mode. E、The database operates in NOARCHIEVELOG mode.

考题 You work as a database administrator for Certkiller .com. You want to administer your database servers,which are running on different host machines,using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective?()A、Application Server ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control

考题 You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces?()A、SQL*PlusB、iSQL*PlusC、Management ServerD、Management RepositoryE、Oracle Enterprise Manager 10g Database Control

考题 You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.C、 The control file must be recreated.D、 The database must be opened with the RESETLOGS option.

考题 Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database()A、You can perform online whole database backups.B、You can performofflinewhole database backups.C、You cannot perform schema-level export/import operations.D、You can perform the backup of only the SYSTEM tablespace when the database is open.

考题 You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A、 online redo log filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace

考题 You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb  Which three statements are correct regarding the connection string?()A、mydb is a service name.B、test.us.oracle.com is a database name.C、1521 is the listener port number.D、mydb is a host name.E、test.us.oracle.com is a net service name.F、hr is a username.G、test.us.oracle.com is an instance name.

考题 You are maintaining your database in Oracle10g. On Tuesday at 8:00 A.M., while starting the database, you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6:00 P.M. Which type of recovery will you perform?()A、 incomplete recoveryB、 complete recoveryC、 recovery using the Flashback Database featureD、 recovery using the export/import utility

考题 Which statement is true regarding remote archive log file destinations?()A、Only two destinations per remote database can be specified.B、Destination is an Oracle Net alias specified by using the SERVICE keyword.C、The REOPEN attribute must be used when using remote archive log file destinations.D、The service name is resolved by searching sqlnet.ora file for the remote database name.

考题 You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()A、 You do not need to restore all the data files.B、 You do not need to open the database with the RESETLOGS operationC、 You do not need to perform a full backup after the RESETLOGS operation.D、 You do not need to recover all the data files to the same system change number (SCN).

考题 单选题You are maintaining your database in Oracle10g. On Tuesday at 8:00 A.M., while starting the database, you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6:00 P.M. Which type of recovery will you perform?()A  incomplete recoveryB  complete recoveryC  recovery using the Flashback Database featureD  recovery using the export/import utility

考题 单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true?()A Transactions are rolled back using redo log files.B Transactions are rolled forward using redo log files.C Transactions are rolled back using redo log files and archived log files.D Transactions are rolled forward using redo log files and rolled back using redo log files.

考题 单选题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?()A ALTER DATABASE ENABLE BLOCK CHANGE TRACKINGB ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING

考题 单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A  online redo log filesB  alert log filesC  control fileD  datafiles associated with the SYSTEM tablespace

考题 单选题You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? ()A Clone B Copy C Template D Terminal 

考题 单选题You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()A  You do not need to restore all the data files.B  You do not need to open the database with the RESETLOGS operationC  You do not need to perform a full backup after the RESETLOGS operation.D  You do not need to recover all the data files to the same system change number (SCN).

考题 单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true?()A Displays only the list of default valuesB Displays only the list of all basic parametersC Displays the currently in effect parameter valuesD Displays only the list of all advanced parametersE Displays the list of all the parameter files of a databaseF Displays the current contents of the server parameter file.

考题 多选题You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?()AUse Oracle Managed Files (OMF).BSpecify the SEED FILE_NAME_CONVERT clause.CSpecify the PDB_FILE_NAME_CONVERT initialization parameter.DSpecify the DB_FILE_NAMECONVERT initialization parameter.ESpecify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

考题 多选题You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb  Which three statements are correct regarding the connection string?()Amydb is a service name.Btest.us.oracle.com is a database name.C1521 is the listener port number.Dmydb is a host name.Etest.us.oracle.com is a net service name.Fhr is a username.Gtest.us.oracle.com is an instance name.

考题 单选题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.  Which statement should you use to enable the block change tracking feature?()A  ALTER DATABASE ENABLE BLOCK CHANGE TRACKINGB  ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C  ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D  ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING

考题 单选题You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()A  The target database must be in the MOUNT mode to ensure restoration of the datafiles.B  You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.C  The control file must be recreated.D  The database must be opened with the RESETLOGS option.

考题 单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()A The database is in mount state.B One of the tablespaces is offline.C One of the tablespaces is read only.D The database operates in ARCHIEVELOG mode.E The database operates in NOARCHIEVELOG mode.

考题 多选题You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario?()AThe database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.BRDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.CThe RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.DASM compatibility controls which features for the ASM will be enabled.

考题 单选题Which statement is true regarding remote archive log file destinations?()A Only two destinations per remote database can be specified.B Destination is an Oracle Net alias specified by using the SERVICE keyword.C The REOPEN attribute must be used when using remote archive log file destinations.D The service name is resolved by searching sqlnet.ora file for the remote database name.