单选题William specified the following initialization parameter settings in the pfile:   BACKGROUND_DUMP_DEST = ’u01/oradata/dir_A’   USER_DUMP_DEST = ’u01/oradata/dir_B’   DB_CREATE_FILE_DEST = ’u01/oradata/dir_C’   DB_CREATE_ONLINE_LOG_DEST_n = ’u01/oradata/dir_D’   William enabled the change-tracking feature because he does not want to scan the entire datafile during backup. What is the default storage location for the change tracking file?()A ’u01/oradata/dir_A’B ’u01/oradata/dir_B’C ’u01/oradata/dir_C’D ’u01/oradata/dir_D’

单选题
William specified the following initialization parameter settings in the pfile:   BACKGROUND_DUMP_DEST = ’u01/oradata/dir_A’   USER_DUMP_DEST = ’u01/oradata/dir_B’   DB_CREATE_FILE_DEST = ’u01/oradata/dir_C’   DB_CREATE_ONLINE_LOG_DEST_n = ’u01/oradata/dir_D’   William enabled the change-tracking feature because he does not want to scan the entire datafile during backup. What is the default storage location for the change tracking file?()
A

 ’u01/oradata/dir_A’

B

 ’u01/oradata/dir_B’

C

 ’u01/oradata/dir_C’

D

 ’u01/oradata/dir_D’


参考解析

解析: 暂无解析

相关考题:

单选题You have a disk group, DGROUP1, with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group:  ALTER DISKGROUP dgroup1  ADD TEMPLATE my_temp  ATTRIBUTES (MIRROR FINE);  Which statement is true?()AWhen a file is created in DGROUP1 with the template, it would have three­way mirroring. BWhen a file is created in DGROUP1, the MY_TEMP template becomes the default template.CWhen a file is created in DGROUP1 with the template, it would have two­way mirroring and file striping.DWhen a file is created in DGROUP1 with the template, it would have three­way mirroring and file striping.EWhen a file is created in DGROUP1 with the template, it would have two­way mirroring but no file striping.

单选题You want to implement the backup and recovery strategy in your database using Recovery Manager (RMAN). You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication?()A rman TARGET / NOCATALOGB rman TARGET sys/passwordC rman TARGET sys/password AS SYSDBAD rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

单选题While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following:  a) high availability of data  b) faster primary key access to the table data  c) compact storage for the table  Which type of tables would you use to achieve these objectives?()Aheap tablesBobject tablesCpartitioned tablesDindex­organized tables (IOTs)

多选题Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be able to perform when the database is being accessed by users?()ABackup of offline tablespaces.BBackup of read-only tablespaces.CBackup of system-critical tablespaces.DBackup of online, locally managed tablespaces.EBackup of read/write dictionary-managed tablespaces.

单选题Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()A DBWnB RECOC RVWRD LGWR

单选题You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs?()A LGWRB DBWRC MMOND RVWR

多选题You have the following online redo log configuration:    Group       Member   1     ’/disk1/oradata/redo01a.log’   2     ’/disk2/oradata/redo02a.log’   3     ’/disk3/oradata/redo03a.log’   You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files?()AALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1;BALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1;CALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2;DALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2;EALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3;FALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3;