-
To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()
A . Multiple change tracking files can be created for a database.
B . The change tracking file must be created after the first level 0 backup.
C . RMAN does not support backup and recovery of the change tracking file.
D . The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
-
You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
A . Information about each Oracle Net connection.
B . Information about each entry in theLinstener.orafile
C . Information about the changed done in the database
D . Information about the different listeners in your system
E . Information about all thenondatabasefiles required to operate the database
-
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task?()
A . Enable supplemental logging for the database.
B . Specify undo retention guarantee for the database
C . Create Flashback Data Archive in the tablespace where the tables are stored.
D . Create Flashback Data Archive and enable Flashback Data Archive for specific table
-
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()
A . ’SQL ALTER DATABASE OPEN’;
B . SQL ALTER DATABASE ’OPEN’;
C . OPEN DATABASE;
D . DATABASE OPEN
-
You create a Web site with membership and personalization enabled. You must use an existing CRM database for storing the membership information. You need to implement the Membership Provider. What should you do?()
A . Modify the connection string in the Web.config file to connect to the CRM database.
B . Add new a SqlMembershipProvider to the Web.config file.
C . Create a custom Membership Provider inheriting from MembershipProvider.
D . Create a custom MembershipUser inheriting from MembershipUser.
-
You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true? ()(Choose three.)
A . Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
B . A resumable statement is suspended only if an out of space error occurs.
C . When a resumable statement is suspended, the transaction that contains the statement is also suspended.
D . A resumable statement can only be suspended and resumed once during the execution of the statement.
E . You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a sessio
-
You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
A . Set the UNDO_RETENTION parameter to AUTO.
B . Create an initial undo segment in undotablespace.
C . Set the UNDO_RETENTION parameter to 900 or more
D . Set the initialization parameter UNDO_MANAGEMENT to AUTO
E . Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
-
Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?()
A . The database must be running in ARCHIVELOG mode.
B . No special setup is required, and the feature is enabled by default.
C . The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.
D . The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.
E . Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.
-
Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?()
A . The database must be running in ARCHIVELOG mode.
B . No special setup is required, and the feature is enabled by default.
C . The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.
D . The Enterprise Manager Support Workbench can be enabled only if the background process manage ability monitor (MMON) is configured.
E . Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.
-
You are managing a single instance Oracle 10g database that utilizes the following parameters: Which of the following set of commands must you execute to enable Flashback Database?()
A . STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN;
B . STARTUP MOUNT ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN RESETLOGS;
C . STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG; ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN RESETLOGS;
D . STARTUP MOUNT ALTER DATABASE ARCHIVELOG; ALTER DATABASE FLASHBACK ON; ALTER DATABASE OPEN;
-
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?()
A . the system change number
B . the locations of the redo log files
C . the locations of the datafiles
D . the physical location of all the database change
-
You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.Which three statements about resumable space allocation are true? ()
A . Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
B . A resumable statement is suspended only if an out of space error occurs. (Out of space condition Maximum extents reached condition,Space quota exceeded condition)
C . When a resumable statement is suspended, the transaction that contains the statement is also suspended.
D . A resumable statement can only be suspended and resumed once during the execution of the statement.
E . You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.
-
You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required?()
A . V$DATABASE
B . V$FLASHBACK_DATABASE_STAT
C . V$FLASHBACK_DATABASE_LOG
D . V$RECOVERY_FILE_DEST
-
What are the prerequisites for enabling Flashback Database? ()
A . The database must be started in the MOUNT EXCLUSIVE state.
B . The database must have multiplexed control files.
C . The database must be opened by using a text-based parameter file instead of a server parameter file (SPFILE).
D . The database must be in ARCHIVELOG mode.
E . The database must be in the NOMOUNT state.
F . The database must be opened in RESTRICTED mode.
-
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 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
-
In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?()
A . Password file
B . Initialization file
C . Datafile
D . Control file
E . Nothing - SYSDBA privileges are not required for these actio
-
To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? ()(Choose two.)
A . Multiple change tracking files can be created for a database.
B . The change tracking file must be created after the first level 0 backup.
C . RMAN does not support backup and recovery of the change tracking file.
D . The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
-
You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
A . Information about each Oracle Net connection.
B . Information about each entry in theLinstener.orafile
C . Information about the changed done in the database
D . Information about the different listeners in your system
E . Information about all thenondatabasefiles required to operate the database
-
To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file?()
A . Multiple change tracking files can be created for a database.
B . The change tracking file must be created after the first level 0 backup.
C . RMAN does not support backup and recovery of the change tracking file.
D . The database clears the change tracking file and starts tracking changes again,after whole database restore and recovery operations.
-
Which of the following would you use to enable automatic media recovery for a database?()
A . SET AUTORECOVERY ON
B . SET RECOVERY ON
C . SET AUTO ON
D . You cannot enable automatic media recovery.
-
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?()
A . Enable supplemental logging for the database.
B . Specify undo retention guarantee for the database
C . Create Flashback Data Archive in the tablespace where the tables are stored.
D . Create Flashback Data Archive and enable Flashback Data Archive for specific table
-
he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?()
A . SYS.SOURCE$
B . SYS.AUD$
C . DBA_SOURCE
D . DBA_AUDIT_TRAIL
-
You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?()
A . RBAL
B . CKPT
C . SMON
D . PMON
E . MMON
F . CTWR
G . DBWR