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&e

时间：2022-10-12 02:13:01 所属题库：1Z0-031题库

相似题目

You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?（）

A . Backup compression should be enabled B . Parallelism for the channel should be set to 2 C . All the files must be backed up as backup sets D . The backup may be stored either on disk or on media with media manager

查看答案
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 performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）

A . You must ensure that the SALES database is mounted or open. B . You must restore a backup control file to perform a block media recovery. C . You must take the tools01.dbf data file offline before you start a block media recovery. D . You must put the database in NOARCHIVELOG mode to perform a block media recovery. E . You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.

查看答案
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.

查看答案
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）

A . Oracle Net Manager B . Listener Control utility C . Database Configuration Assistant D . Oracle Net Configuration Assistant

查看答案
You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）

A . One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST. B . One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST. C . One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST. D . One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.

查看答案
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.

查看答案
You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）

A . SYSTEM B . OUTLN C . INTERNAL D . SYS

查看答案
You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）

A . user managed complete recovery B . user managed incomplete recovery C . RMAN-based complete recovery D . RMAN-based incomplete recovery

查看答案
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）

A . To store the backup information of multiple database B . To restrict the amount of space that is used by the backups C . To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter. D . To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

查看答案
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? （）(Choose two.)

A . Backup compression should be enabled B . Parallelism for the channel should be set to 2 C . All the files must be backed up as backup sets D . The backup may be stored either on disk or on media with media manager

查看答案
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup？（）

A . Database Datafiles B . Database Control Files C . Online redo logs D . Archived redo logs E . The database SPFILE F . None of the above，all these files are backed u

查看答案
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 files B . alert log files C . control file D . datafiles associated with the SYSTEM tablespace

查看答案
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）

A . Database Datafiles B . Database Control Files C . Online redo logs D . Archived redo logs E . The database SPFILE F . None of the above, all these files are backed up.&e

查看答案
our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

A . Oracle Net Manager B . Listener Control utility C . Database Configuration Assistant D . Oracle Net Configuration Assistant

查看答案
You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation？（）

A . Backup compression should be enabled B . Parallelism for the channel should be set to 2 C . All the files must be backed up as backup sets D . The backup may be stored either on disk or on media with media manager

查看答案
Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

A . Oracle Net Manager B . Listener Control utility C . Database Configuration Assistant D . Oracle Net Configuration Assistant

查看答案
You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）

A . Datafiles B . Current control file C . Server parameter file （spfile） D . Password file

查看答案
Which view will you use to view information regarding the jobs that are currently running in a database？（）

A . DBA_SCHEDULER_RUNNING_JOBS B . DBA_SCHEDULER_JOB_RUN_DETAILS C . DBA_SCHEDULER_JOBS D . DBA_SCHEDULER_JOB_LOG

查看答案
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.

查看答案
You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2； Which components are included in the backup？（）

A . Only the data files. B . Only the data files and the online logs. C . The data files， control files， and the online logs. D . The data files and control files， but not the online logs.

查看答案
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？（）

A . To recover a dropped table. B . To recover a dropped schema. C . To recover data from a truncated table. D . To view changes made by all the transactions during a given period of time. E . To view changes made by a single transaction during a given period of time.

查看答案
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 want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? （）

A . An object type is a user-defined composite data type. B . The attributes of an object type can be those of other object types. C . A PL/SQL table of records is an example of a nested object type. D . An object type must be declared as a type before the actual object itself can be declared.

查看答案

推荐题目