ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
第1题:
You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. While studying the parameter file of the ASM instance, you find the following entry: ASM_DISKSTRING = /devices/* What could be the reason for this setting?()
第2题:
You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting?()
第3题:
If you create your database using Oracle Managed Files (OMF), what is true?()
第4题:
You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically, and not have to do it manually. What should you do?()
第5题:
You have an Automatic Storage Management (ASM) instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager(RMAN), you migrate the complete production database to use the ASM instance. Which statement is true?()
第6题:
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
第7题:
The Oracle kernel will be placed in this location.
The Oracle software will be placed in this location.
The server parameter file (SPFILE) will be placed in this location.
The database files will be placed in this location, if not specified explicitly.
The location will be considered for the base of Oracle Managed Files (OMF).
The location will be considered for the base of Optimal Flexible Architecture (OFA).
第8题:
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
第9题:
You must use Oracle predefined names to identify raw partitions that will hold OMF structures.
You must define directories for two online redo log groups and three copies of the control file.
If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically.
You must use only OMF data files when adding new tablespaces or data files to your database in the future.
第10题:
RMAN would relocate all the database files to an ASM disk group.
RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
RMAN would relocate all the data files to an ASM disk group and other files to an operating system location, defined using Oracle Managed Files (OMF).
RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location, defined using OMF
第11题:
RMAN would relocate all the data files to an ASM disk group and other files to an operating system location, defined using Oracle Managed Files (OMF).
RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location, defined using OMF
RMAN would relocate all the database files to an ASM disk group.
RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
第12题:
Flashback logs are not deleted.
Flashback logs are deleted automatically.
Flashback logs are deleted only if you are using Recovery Manager (RMAN).
Flashback logs are deleted only if you are using Oracle Managed Files (OMF).
Flashback logs are deleted only if you are using Automatic Storage Management (ASM).
第13题:
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 will you use to enable the block change tracking feature?()
第14题:
While planning to manage more than one database in your system, you perform the following activities: 1. Organize different categories of files into independent subdirectories. 2. Use consistent naming convention for database files. 3. Separate administrative information pertaining to each database. Which option corresponds to the type of activities performed by you?()
第15题:
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?()
第16题:
You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; statement to enable the block change tracking feature. What information will be written in the change tracking file?()
第17题:
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?()
第18题:
If the FORMAT option to the RMAN BACKUP command is specified, then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files (OMF) format.
If any local destinations for LOG_ARCHIVE_DEST_n are set, then archived redo logs are stored in these destinations as well as in the flash recovery area.
If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter, then the RMAN backup of Oracle managed datafiles (OMF) only will go to the flash recovery area by default.
If no other destination is configured for recovery files, then RMAN places the control file autobackups in the flash recovery area by default.
第19题:
Flashback log files
Backups that have become obsolete
User managed backups of the data files and control files
Archived redo log files that have multiple copies in a different archive location and not backed up
第20题:
Use the DROP DATAFILE command.
Use the DROP TABLESPACE command.
Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.
Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
第21题:
OMF cannot be used in a database that already has data files created with user-specified directions.
The file system directions that are specified by OMF parameters are created automatically.
OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
OMF automatically creates unique file names for table spaces and control files.
OMF may affect the location of the redo log files and archived log files.
第22题:
to enable the ASM instance to identify the alert log file
to enable the ASM instance to identify the server parameter file
to enable the ASM instance to define the locations for Oracle Managed Files (OMF)
to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory
第23题:
Use Oracle Managed Files (OMF).
Specify the SEED FILE_NAME_CONVERT clause.
Specify the PDB_FILE_NAME_CONVERT initialization parameter.
Specify the DB_FILE_NAMECONVERT initialization parameter.
Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
第24题:
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING