-
Which are the prerequisites for performing flashback transactions on your database?()
A . Undo retention guarantee for the database must be configured.
B . Supplemental log must be enabled for the primary key.
C . Supplemental log must be enabled.
D . Execute permission on the DBMS_FLASHBACK package must be granted to the user.
-
Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database()
A . Avoid coding unnecessary long-running transactions.
B . Allow the database to handle locks in default locking mode.
C . Always explicitly code the locks as per the requirement of the application.
D . Allow escalation of row locks to block locks if too many row locks cause problem.
-
You need to design the database permissions for access from the terminals to the database server. Which action or actions should you perform?()
A . Create a database role named BankTerminals.
B . Grant the BankTerminals role the Execute permission for the WoodgroveBanking database.
C . Grant database access to the Windows Bank Terminals group, and add the group to the BankTerminals role.
D . Grant the BankTerminals role the Execute permission for the Bank schema.
E . Grant the Windows Bank Terminals group the Execute permission for the Bank schema.
F . Grant the BankTerminals role the Execute permission for all stored procedures and user-defined functions in the Bank schema.
-
You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?()
A . a table name which has 100s of records
B . a table name which has 10s of records
C . a table name which has empty records
D . a table name which has 1000s of records
E . never use a table name
-
Which of the following choices identifies a database component that will be used for multiplexing control files?()
A . V$CONTROLFILE
B . V$DATABASE
C . init.ora
D . DBA FILES
-
Which command would you use to determine what database backups are currently available for restore?()
A . list database backup
B . report database backup
C . list backup of database
D . list summary backup
E . report backup of database
-
Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?()
A . Visual Explain
B . Activity Monitor
C . SQL Performance Monitor
D . DB2 Performance Monitor
-
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()
A . renaming the control files
B . dropping a user in your database
C . enabling or disabling redo log archiving
D . dropping a tablespace in your database
E . re-creating the control files, after you lost all the control files in your database
-
Which four are correct guidelines for naming database tables? ()
A . Must begin with either a number or a letter.
B . Must be 1-30 characters long.
C . Should not be an Oracle Server reserved word.
D . Must contain only A-Z, a-z, 0-+, _, *, and #.
E . Must contain only A-Z, a-z, 0-9, _, $, and #.
F . Must begin with a letter.
-
Which option is best practice for creating a recovery catalog owner in the catalog database?()
A . Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner
B . Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user
C . Creating a new tablespace,allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user
D . Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user
-
Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?()
A . A DBA can check specific tables with the DMU
B . The database to be migrated must be opened read-only.
C . The release of the database to be converted can be any release since 9.2.0.8.
D . The DMU can report columns that are too long in the converted characterset.
E . The DMU can report columns that are not represented in the converted characterset.
-
Which option is best practice for creating a recovery catalog owner in the catalog database?()
A . Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner
B . Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user
C . Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user
D . Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user
-
In which situation would you use static database registration for a listener()
A . when multiple databases are to be registered with the listener
B . when DBAs need to connect remotely to start up the database instance
C . when users need to connect the database instance using the host naming method
D . when the database instance that is to be registered with the listener is configured in shared server mode
-
Which tablespaces are mandatory in an Oracle database for it to be operational()
A . Undo tablespace
B . USERS tablespace
C . SYSAUX tablespace
D . SYSTEM tablespace
E . Temporary tablespace
-
Which files are required for a full recovery of the database in ARCHIVELOG mode?()
A . Database datafiles
B . Online redo logs
C . Archived redo logs
D . Backup control file
E . Control file from a backu
-
When a database administrator chooses the dimensions for an MDC table, which two characteristics should beconsidered?()
A . the query transaction rate
B . numeric data versus character data
C . extent size
D . the cardinality of the candidate columns
E . prefetch size&e
-
Which files must be synchronized in order for a database to start?()
A . temp files
B . online data files
C . offline data files
D . read only data file
-
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.
-
Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?()
A . Allocates memory for RMAN backup and restore operations
B . Allocates memory for shared and private SQL areas
C . Contains a cursor area for storing runtime information about cursors
D . Contains stack space
E . Contains a hash area performing hash joins of table
-
Which commands are used for RMAN database recovery?()
A . restore
B . repair
C . copy
D . recover
E . replace
-
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? ()
A . To recover a dropped table.
B . To recover a dropped schema.
C . To recover data from a truncated table.
D . To view changes made by all the transactions during a given period of time.
E . To view changes made by a single transaction during a given period of time.
-
Which of the following represents the correct sequence of events for Database Replay?()
A . Capture,analyze,preprocess,replay
B . Capture,preprocess,analyze,replay
C . Capture,preprocess,replay,analyze
D . Analyze,capture,preprocess,replay
E . None of the above
-
Which command would you use to determine what database backups are currently available for restore?()
A . list database backup
B . report database backup
C . list backup of database
D . list summary backup
E . report backup of database
-
Flashback is enabled for your multitenant container database (CDB), which contains two plu
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”;Examine following commands:1. ALTER PLUGGABLE DATABASE ALL OPEN;2. ALTER DATABASE OPEN;3. ALTER DATABASE OPEN RESETLOGS;Which command or commands should you execute next to allow updates to the flashback back schema?()
A. Only 1
B. Only 2
C. Only 3
D. 3 and 1
E. 1 and 2