网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format？（）
A
to uniquely identify the archived log files with the restore operation
B
to uniquely identify the archived log files with the redo log group number
C
to uniquely identify the archived log files for each incarnation of the database
D
to uniquely identify the archived log files with the number of recovery operations performed
参考答案
参考解析
解析：
暂无解析
更多 “单选题You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format？（）A to uniquely identify the archived log files with the restore operationB to uniquely identify the archived log files with the redo log group numberC to uniquely identify the archived log files for each incarnation of the databaseD to uniquely identify the archived log files with the number of recovery operations performed” 相关考题
考题
You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
考题
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 work as a database administrator for Supportcenter.cn. You are working on Oracle Database 10g. To forward client connections to an instance， the listener must know information such as the name of the instance and where the instance’s ORACLE_HOME is located. How does the listener get this information？（）A、It gets it from the parameter file.B、The listener prompts for details on startup.C、The listener gathers information from the control file.D、The instance automatically registers with the default listener.E、The listener gets this information through thelistener.orafile.
考题
You are a Database Administrator with WonderWeb. You use a password file to establish connections to the Sales database located on the server. You created the password file using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4 You erroneously deleted the password file while the database was running. You re-create the password file using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=4 However， when you try to connect as the SYS user， you receive the following error： ORA-01031： insufficient privileges What should you do to resolve this error？（）A、 Delete the newly created password file and re-create another password file with the password admin， without shutting down the database.B、 Enable the operating system authentication， shut down the database， disable the operating system authentication， and restart the database using the password file.C、 Enable the operating system authentication， shut down the database， re-create the password file using the same ORAPWD command， and restart the database using the password file.D、 Delete the newly created password file， enable operating system authentication and shut down the database. Then， re-create another password file using the same ORAPWD command and restart the database using this password 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 are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（） A、 by using the RMAN utilityB、 by using the export/import utilityC、 by using the ALTER DATABASE commandD、 by enabling the change tracking feature
考题
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 using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format？（） A、to uniquely identify the archived log files with the restore operationB、to uniquely identify the archived log files with the redo log group numberC、to uniquely identify the archived log files for each incarnation of the databaseD、to uniquely identify the archived log files with the number of recovery operations performed
考题
You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）A、 by using the Flashback Database featureB、 by using RMAN incomplete recoveryC、 by performing a user-managed incomplete recoveryD、 by dropping and re-creating the index tablespace
考题
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
考题
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）A、This operation resets the SCN for the database.B、This operation creates a new incarnation of the database.C、This operation moves all the redo log files to a different location.D、This operation deletes the old redo log files and creates new redo log files.E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
考题
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
考题
单选题Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）A
When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B
When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C
When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D
When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
考题
单选题You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）A
by using the Flashback Database featureB
by using RMAN incomplete recoveryC
by performing a user-managed incomplete recoveryD
by dropping and re-creating the index tablespace
考题
单选题You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands： RMAN CONNECT TARGET sys/sys@APPPROD RMAN CONNECT AUXILIARY sys/sys@DUPDB RMAN DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE PASSWORD FILE SPILE NOFILENAMECHECK； What are the implications of this command？（）A
It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B
It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C
It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D
It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
考题
单选题While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）A
configure the database to run in ARCHIVELOG modeB
configure the Flash Recovery Area to enable automatic database backupC
schedule the database backup using DBMS_JOB package after creating the databaseD
schedule the database backup using Recovery Manager （RMAN）commands after creating the databaseE
schedule the database backup using Database Configuration Assistant （DBCA）while creating the database
考题
单选题You disabled the Flashback Database feature by using the following command： SQL ALTER DATABASE FLASHBACK OFF； What would be the effect of this command on the existing flashback logs？（）A
Flashback logs are not deleted.B
Flashback logs are deleted automatically.C
Flashback logs are deleted only if you are using Recovery Manager （RMAN）D
Flashback logs are deleted only if you are using Oracle Manager Files （OFM）E
Flashback logs are deleted only if you are using Automatic Storage Management （ASM）
考题
单选题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）.
考题
单选题You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）A
by using the RMAN utilityB
by using the export/import utilityC
by using the ALTER DATABASE commandD
by enabling the change tracking feature
考题
多选题You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）AThis operation resets the SCN for the database.BThis operation creates a new incarnation of the database.CThis operation moves all the redo log files to a different location.DThis operation deletes the old redo log files and creates new redo log files.EThis operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
考题
多选题Identify four uses of the Oracle Scheduler.（）Aenables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentBenables Oracle database to do patches according to a DBA-defined scheduleCenables you to schedule the execution of jobs based on timeDenables you to execute jobs in a clustered environmentEenables you to periodically execute operating systemscript files located on the same server as the databaseFenables you to create a job that makes use of saved programs and schedulesGenables you to automate the management of the jobs that are created using the DBMS_JOB package
考题
单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）A
use the external table populationB
use the Oracle Data Pump export and import utilityC
use the conventional path data load of SQL*Loader utilityD
use the direct path data load of Oracle export and import utility
考题
单选题You disabled the Flashback Database feature by using the following command： SQL ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs？（）A
Flashback logs are not deleted.B
Flashback logs are deleted automatically.C
Flashback logs are deleted only if you are using Recovery Manager （RMAN）.D
Flashback logs are deleted only if you are using Oracle Managed Files （OMF）.E
Flashback logs are deleted only if you are using Automatic Storage Management （ASM）.
考题
单选题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 using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format？（）A
to uniquely identify the archived log files with the restore operationB
to uniquely identify the archived log files with the redo log group numberC
to uniquely identify the archived log files for each incarnation of the databaseD
to uniquely identify the archived log files with the number of recovery operations performed
热门标签
最新试卷
