问题:单选题You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance, you notice that the system identifier (SID) for the instance is set to ’+ASM’. What is the purpose of this instance?()AThis instance is being used to manage the operating system files.BThis instance is being used to manage the files of other databases.CThis instance is being used to manage the instances of other databases.DThis instance is being used to manage the background processes of other instances.
查看答案
问题:多选题You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup?()ABy using the trace file.BBy using the alert log file.CBy using the database IDDBy using the server parameter file.EBy using the V$CONTROLFILE view.FBy using the autobackup format configuration setting.
问题:单选题You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%, respectively. From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?()A The EVENT parameter was not set.B The SQL_TRACE parameter is set to FALSEC The Enterprise Manager Grid Control is not used.D The STATISTICS_LEVEL parameter is set to BASICE The TIMED_STATISTICS parameter is set to FALSE
问题:单选题Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’.’hh12:mi’);Ato undo the changes made to the EMP table since the specified timeBto restore the EMP table that was wrongly dropped from the databaseCto view the transactions that have modified the EMP table since the specified timeDto view the changes made to the EMP table for one or more rows since the specified time
问题:单选题On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct?()A You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.B You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.C You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.D You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
问题:单选题You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table?()AYou must enable the block change tracking feature.BYou must have enable the flashback feature.CYou must use the OMF in your database.DYou must define the tablespace of the SCOTT.EMP table for automatic segment space management.
问题:多选题For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files?()ARMAN image copies.BRMAN database backups.CRMAN tablespace backups.DUser-managed backups placed in the flash recovery area.EUser-managed backups that have been cataloged with RMAN.FUser-managed data file backups for which the pull path name is specified.
问题:单选题The DB_BLOCK_CHECKINGinitialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles, every time the DBWn writes?()AThe Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.BThe DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.CThe Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.DThe Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.EThe Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent.
问题:多选题You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting? ()ADATEBTIMESTAMPCINTERVAL YEAR TO MONTHDINTERVAL DAY TO SECONDETIMESTAMP WITH LOCAL TIME ZONE
问题:多选题You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? ()Alog bufferBJava poolCLarge poolDFixed SGAEShared poolFStreams poolGKeep buffer cacheHDatabase buffer cache
问题:单选题You want to estimate the size of a table by using the Oracle Enterprise Manager. On which data is the size of the table NOT based?()Acolumn sizesBcolumn data typesCPCTFREEDprojected number of rowEPCTUSED
问题:单选题A user executes a query on the EMPtable, which contains thousands of rows, to get details about employees in one of the departments. The user receives the following error: SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal; SELECT ename FROM emp WHERE deptno=10 ORDER BY sal ERROR at line 1: ORA-01157: cannot identify/lock data file 201 - see DBWR trace file ORA-01110: data file 201:’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason?()AThe tempfile belonging to the default temporary tablespace is missing.BThe database is opened in restricted mode, so queries are not allowedCThe default temporary tablespace required to execute the query is offline.DThe default temporary tablespace required to execute the query is dropped.EThe default temporary tablespace required to execute the query is read-only.
问题:单选题You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area?()A the location used for control filesB the location used for redo log filesC the location set by using $ORACLE_BASED the location set by using $ORACLE_HOMEE the location set by using CORE_DUMP_DESTF the location set by using BACKGROUND_DUMP_DEST
问题:单选题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).
问题:单选题A redo log file is corrupted while the database is open; as a consequence, database operations are stopped because archiving cannot continue. What would you do to solve the problem?()Aclear the redo log groupBperform redo log file importCperform an incomplete recoveryDperform a redo log recovery using Recovery Manager (RMAN)Eshut down the database and open the database in the NOARCHIVELOG mode
问题:单选题You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEES table. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()A perform pointintime recoveryB perform a Flashback Table operation to restore the table to the state it was in two days ago C perform a Flashback Database operation to restore the database to the state it was in two days agoD perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery
问题:多选题In the parameter file of your production database, the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery, you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files?()Athe V$LOG viewBthe V$DBFILE viewCthe V$LOGFILE viewDthe V$INSTANCE_RECOVERY viewEOracle Enterprise Manager Database Control
问题:单选题Consider the following command to add a new disk group called "tdgroupA" with two failover groups: CREATE DISKGROUP tdgroupA NORMAL REDUNDANCY FAILOVERGROUP control01 DISK ’/devices/A1’, ’/devices/A2’, ’/devices/A3’ FAILOVERGROUP control02 DISK ’/devices/B1’, ’/devices/B2’, ’/devices/B3’m The disk "/devices/A1" is currently a member disk of a disk group by the name "tdgroup1". Which task would be accomplished by the command?()AThis command would result in an error because a disk group can have only one failover group.BThis command would result in an error because the /devices/A1 disk is a member of another disk group tdgroup1.CA new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will get reattached to the new disk group without being detached from the existing one.DA new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will be ignored for the new disk group because it is a member of an existing disk group tdgroup1.EA new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk gets detached from the existing disk group tdgroup1 and attached to the new disk group tdgroupA
问题:多选题You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? ()Abackup piecesBcontrol file autobackupsCcopies of all the parameter filesDtrace file generated using BACKUP CONTROLFILE TO TRACE