-
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()
A . statistics recommendations
B . SQL Profile recommendations
C . Index-related recommendations
D . restructuring of SQL recommendatio
-
You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go? ()
A . 3 hours
B . 6 months
C . until last year
D . until last commit
E . until the point when the undotablespacewas refreshed
F . until the database is shut down and the memory erased
-
The database is configured for automatic archive logging. Along with the other required parameters, this entry is in the initialization file:log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1?()
A . control file
B . tnsnames.ora
C . data dictionary
D . initialization parameter file
-
A customer is deploying a new database on a PS701 Blade in a BladeCenter H, and requires redundant network and SAN adapters. Which configuration supports the customer requirement?()
A . Configure 2CFFh combination fibre channel / gigabit Ethernet adapters
B . Configure 1CFFh 2-port fibre channel adapter and 1 CIOv 2-port gigabit Ethernet adapter
C . Configure 1CIOv 2-port fibre channel adapter and 1 CFFh combination fibre channel / gigabit Ethernet adapter
D . Configure 1CIOv 2-port gigabit Ethernet adapter and 1 CFFh combination fibre channel / gigabit Ethernet adapter
-
You are configuring a failover cluster for a database server. You are assigning four nodes to the cluster. Allnodes have access to a SAN,and adequate storage is available. Which of the following options should youchoose for your quorum configuration?()
A . Node Majority
B . Node And Disk Majority
C . Node And File Share Majority
D . No Majority: Disk Only
-
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?()
A . Enable flashback logging.
B . Start the database in the ARCHIVELOG mode.
C . Issue the ALTER DATABASE FLASHBACK ON; command.
D . Set the FAST_START_MTTR_TARGET initialization parameter.
-
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
A . statistics recommendations
B . SQL profile recommendations
C . index-related recommendations
D . restructuring of SQL recommendatio
-
You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files()
A . Archiving will be disabled because the destination for the redo log files is missing.
B . The database instance will shut down and the error details will be logged in the alert log file.
C . Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly.
D . Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.
-
The size of the largest datafile, data1.dbf, in your database is 30MB. You issued the following command: RMAN>CONFIGURE MAXSETSIZE 10MB; What will be the impact of the above setting?()
A . While performing the backup of the datafile,data1.dbf,one backup set is created.
B . While performing the backup of the datafile,data1.dbf,two backup sets are created.
C . While performing the backup of the datafile,data1.dbf,three backup sets are created.
D . While performing the backup of the datafile,data1.dbf,the command for performing a backup of the datafile,data1.dbf,will fail.
-
The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?()
A . Control files
B . Password files
C . Inactive online redo log file
D . Archived log files required to perform recovery
E . Newly created tablespace which is not backed u
-
Your database is configured in shared server mode. However, your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users. What could be the reason for this()
A . To limit the User Global Area (UGA) memory allocated to a session from the SGA
B . To limit the amount of memory to be used for the dispatcher queue of a session in SGA
C . To limit the amount of memory to be used for the request pool in System Global Area (SGA)
D . To control the amount of memory allocated in SGA for the local variables for each shared server proce
-
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
A . statistics recommendations
B . SQL profile recommendations
C . index-related recommendations
D . restructuring of SQL recommendatio
-
The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager (RMAN) against your database: RMAN> REPORT OBSOLETE; What would you see in the output?()
A . a list of all the expired backups and copies
B . a list of all those files that have been deleted in the last two days
C . a list of all those files that have been recovered within the last two days
D . a list of backups and copies that are outside the range covered by the current retention policy
-
Which command is used to alter the attributes of "log type" defined in the alog configuration database?()
A . alog -t
B . alog -s
C . alog -C
D . alog -L
-
Your database is configured in shared server mode. However, your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users. What could be the reason for this()
A . to limit the User Global Area (UGA) memory allocated to a session from the SGA
B . to limit the amount of memory to be used for the dispatcher queue of a session in SGA
C . to limit the amount of memory to be used for the request pool in System Global Area (SGA)
D . to control the amount of memory allocated in SGA for the local variables for each shared server proce
-
You executed the following command in the lsnrctl utility to stop the listener: lsnrctl> STOP L1 What is the effect of this command if L1 is the only listener configured for your database?()
A . It terminates all user sessions.
B . It prevents users from logging in to the database remotely.
C . It halts the server until all user transactions are completed.
D . The server hangs, so users will receive an error asking them to login again.
E . Connected users would get an error with the message "End of communication channel".
-
To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ DB_FLASH_CACHE_SIZE=64G What is the result when you start up the database instance?()
A . It results in an error because these parameter settings are invalid.
B . One 64G flash cache file will be used.
C . Two 64G flash cache files will be used.
D . Two 32G flash cache files will be used.
-
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?()
A . statistics recommendations
B . SQL Profile recommendations
C . Index-related recommendations
D . restructuring of SQL recommendatio
-
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem?()
A . Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
B . Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
C . Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
D . Increase the value of the SGA_TARGET initialization parameter.
-
The online redo log group configuration for your database is as follows: What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database?()
A . The database will hang.
B . The database will be crashed.
C . The database will be shut down.
D . The LGWR process writes redo log entries to the other redo log member of the Group2 grou
-
A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance?()
A . Data Pump
B . Oracle Net Manager
C . Oracle Enterprise Manager
D . Oracle Universal Installer (OUI)
E . Database Configuration Assistant (DBCA)
-
The SQL Tuning Advisor has been configured with default configurations in your database instance.Which recommendation is automatically implemented without the DBA‘s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
A. statistics recommendations
B. SQL profile recommendations
C. index-related recommendations
D. restructuring of SQL recommendations
-
In your database, the flash recovery area (FRA) is configured as the default for RMAN back
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:Which statement is true about the outcome?()
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/4f3f38f4fa50f6813beecdb37f5e123f.jpg' />
A. Only one channel is allocated and the backup is created in the flash recovery area
B. Only one channel is allocated and the backup is created in the destination specified for channel
C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
-
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this:Choose the correct sequence.()
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17133996/81fcc055aa2594a8ac7bbd62b7b620ac.jpg' />
A. 4, 1, 3, 2, 5
B. 4, 3, 1, 2, 5
C. 2, 4, 3, 5, 1
D. 4, 2, 5, 3, 1