Q. Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly.One of the data files that has been deleted belongs to the USERS tablespace and the other belongs to the SYSTEM tablespace. How can you recover from this situation?
A. Shut down the database, restore the two data files and then start up the database.
B. Take the system and users tablespaces offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online.
C. Shut down the database, restore the two data files, start up the database in MOUNT mode, recover
the two data files, and then alter the database open.
D. Taken the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the
SYSTEM and USERS tablespaces online.
Q. Which component of the Oracle networking architecture provides character set and data type conversion between different character sets on the client and server?
A. SQL*plus
B. Oracle Net
C. Two-Task Common (TTC)
D. Oracle Protocol Support (OPS)
Q. Your database runs in ARCHIVELOG mode, and is backed up very Sunday night using RMAN scripts. On Friday your database crashes. Now you want to use the backups from last Sunday night to restore your database. How can you do this?
A. You need to perform the restore manually, because your database was running in ARCHIVELOG mode.
B. Issue the RECOVER command from with RMAN. RMAN determines which data files to restore, and which archive logs to use.
C. Issue the RESTORE and RECOVER commands from within RMAN.RMAN determines which data files to restore, and which archive logs to use.
D. Issue the RESTORE DATAFILES, RESTORE ARCHIVELOGS, and RECOVER commands from within RMAN.RMAN. determines which data files to restore,and which archive logs to use.
Answer : C
Q. You notice that your RMAN scrip used to copy the datafiles, control files, and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script speed up the COPY commands? (Choose two).
A. NOCHECKSUM
B. MAXCORRUPT.
C. CHECK LOGICAL
D. BACKUP INCREMENTAL
E. CONFIGURE DEVICE TYPE....PARALLELISM.
Q. You want to create to copy of the DEPARTMENTS table. When that is complete, you want to truncate the new DEPARTMENTS Which CREATE statement should you use?
A. CREATE TABLE departments2 as SELECT * FROM departments.TRUNCATE TABLE departments2;
INSERT /*+append*/INTO departments2nologging
SELECT * FROM departments;COMMIT;
B. CREATE TABLE departments2 as SELECT * FROM departments.TRUNCATE TABLE departments2;
INSERT INTO departments2 SELECT * FROM departments;
COMMIT;
C. CREATE TABLE departments2 SELECT * FROM departments;
TRUNCATE TABLE departments2;INSERT /*+append*/INTO departments2 SELECT * FROM departments;COMMIT;
D. CREATE TABLE departments2 as SELECT * FROM departments.TRUNCATE TABLE departments2;
INSERT /*+append*/INTO departments2nologging;
SELECT * FROM departments;COMMIT;
Answer : A
Q. You need to import all definitions of objects belonging to the TS_EMPLOYEES tablespace by using the export file expdat.dmp. Which import statement is correct?
A. imp hr/hr TABLES = (ts_employees) rows=y
B. imp system/manager FROMUSER=hr file=expdat.dmp
C. imp hr/hr TRANSPORT_TABLESPACE=y file=expdat.dmp
D. imp system/manager TRANSPORT_TABLESPACE=Y TABLESPACES=ts_employees.
Answer : D
Q. In a shared serve configuration, which two describe the actions that the listener can take to service a client request? (Choose two.)
A. The listener hands to connection request directly to a dispatcher.
B. A dedicated server inherits the connection request from the listener.
C. The client connects to a dedicated serve directly using a protocol address provided by the listener.
D. The application initiating the session spawn a dedicated serve process for the connection request.
E. The listeners issues a redirect message to the client, containing the protocol address of a dispatcher. The client terminates the network session to the listener and establishes a network session to the dispatcher.The client then terminates the network session to the listener and establishes a network session to the dispatcher, using the network address provided in the redirect message.
Answer : A,E
Q. When you are allowing RMAN to backup your archived redo log files, how does RMAN know which archived redo logs to back up from your archive log dehitbation?
A. RMAN keeps a list of archive logs in a text file.
B. The DBA must manually tell RMAN which archive logs to backup.
C. RMAN has access to target control file and/or catalog information.
D. RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.
Answer : C
Q. You issue this statement:ALTER DATABASE BACKUP CONTROLFILE TO `control01.bkp'; What does the statement generate?
A. A text copy of the control file
B. A binary copy of the control file.
C. A file containing a SQL statement which will re-create the database.
D. A file containing a SQL statement which will re-create the control file.
Answer : B
Q. Which RMAN command is used to verify the status of a backup or copy, and also updates the repository when files have been deleted using operating system commands?
A. CHANGE
B. RESYNC
C. CATALOG
D. CROSSCHECK
Answer : D
Q. You execute this command in MOUNT mode:ALTER DATABASE ARCHIVELOG; Where is the information that the database is now in ARCHIVELOG mode stored?
A. SPPFILE
B. archive log
C. control file
D. system tablespace
Answer : C
Q. There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.There was only one data file on this disk; it belongs to the USERS tablespace in your PROD database.Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken.The users need to be able to across the data in the USERS tablespace before the replacement disk arrives.You have already taken the USERS tablespace offline and have restored the data file from last night's backup to a new disk. Which additional steps are required in order to make the USERS tablespace available?
A. only bring the tablespace back online.
B. Only recover the tablespace and then bring the tablespace back online.
C. Shut down the database, recover the data file and then start up the database.
D. Issue the ALTER DATABASE RENAME FILE command, recover the tablespace, and then bring the tablespace online.
E. Recover the tablespace, issue the ALTER DATABASE RENAME FILE command, and then bring the tablespace online.
Answer : D
Q. You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests. Which naming method can you use?
A. Only host
B. Only local
C. Either host or local
D. Both host and local
Answer : B
Q. Management has decided that the database must be available 24 hours a day, 7 day a week. Given this requirement, which type of backup is required?
A. user-managed backups
B. partial database backups
C. Consistent database backups
D. inconsistent database backups.
Answer : D
Q. You have discovered that a disk failure occurred on DISK1 where the data files belonging to the SYSTEM and USER_DATA tablespaces is stored. The database is currently open and you need to recover the data files. You will restore the data files to DISK2. What is the correct sequence of RMAN commands to restore and recover the data files?
A. RUN{RESTORE DATABASE;RECOVER DATABASE;ALTER DATABASE OPEN;}
B. RUN{SET NEWNAME FOR`/DISK1/system01.dbf TO`/DISK2/system01.dbf`/DISK1/user_data01.dbf
TO`/DISK2/user_data01.dbf;RESTORE DATABASE;SWITCH DATAFILE ALL;RECOVER DATABASE;ALTER DATABASE OPEN;}
C. RUN{RESTORE DATABASE;SET NEWNAME FOR `/DISK1/system01.dbf TO`/DISK2/system01.dbf
`/DISK1/user_data01.dbf TO`/DISK2/user_data01.dbf; SWITCH DATAFILE ALL;RECOVER DATABASE;ALTER DATABASE OPEN;}
D. RUN{SET NEWNAME FOR`/DISK1/system01.dbf TO`/DISK2/system01.dbf`/DISK1/user_data01.dbf
TO`/DISK2/user_data01.dbf;RESTORE DATABASE;RECOVER DATABASE;ALTER DATABASE OPEN;}
Answer: B
Q.Which statement is true regarding the Archiver (ARCn) process, archived log files, and recovery?
A. A data base backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure.
B. During recovery the ARCn back ground process copies its redo entries identified for recovery by the control file to the data files.
C. After each write to an archived log, the mandatory, background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file.
D. At database recovery time, an archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.
Answer: A
Q.Which statement is true regarding remote archive log file destination?
A. Only two destinations per remote database can be specified.
B. Destination is an Oracle Net alias specified by using the SERVICE keyword.
C. The REOPEN attribute must be used when using remote archive log file destinations.
D. The service name is resolved by searching sqlnet. or a file for the remote database name.
Answer: B
Q. Which three types of information does the control file contain? (Choose three.)
A. current log sequence
B. recovery tuning parameters
C. redo log names and locations
D. data file names and locations
E. undo segment names and locations
Answer: A,C,D
Q. Which two RMAN commands initiate a resynchronization of the recovery catalog with the target database control file?(Choose two).
A. COPY
B. BACKUP
C. CHANGE
D. DELETE
E. EMON
F. SMON
Answer: E
Q. Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day, 7 days a week production environment? (Choose two.)
A. ARCHIVELOG mode
B. NOARCHIVELOG mode
C. open database backups
D. consistent whole backups
Answer: A,C
Continue.....