Testpassport 1z0-032 Exam Features

1.You performed an open database backup of each tablespace by putting the tablespaces in backup mode using the ALTER TABLESPACE .. BEGIN BACKUP command.
However, you forgot to end the backup of one of the tablespaces by using the ALTER TABLESPACE .. END BACKUP command. What would happen if you execute the SHUTDOWN IMMEDIATE command in this situation?
A.The database is closed but not dismounted.
B.The database remains open and the command to shut down fails.
C.The database instance shuts down leaving the tablespace as it is.
D.The database instance shuts down by taking the tablespace out of the backup mode automatically.
Answer : B

2.In this scenario, assume that you archive logs 101 to 104 to two archiving destinations, /log1 and /log2. The control file contains archived log records as follows:
Sequence Filename
101 /log1/log_1_101.arc
101 /log2/log_1_101.arc
102 /log1/log_1_102.arc
102 /log2/log_1_102.arc
103 /log1/log_1_103.arc
103 /log2/log_1_103.arc
104 /log1/log_1_104.arc
104 /log2/log_1_104.arc
You accidentally delete logs 102 and 104 from log 1.
You run this command:
BACKUP ARCHIVELOG FROM SEQUENCE 101 UNTIL SEQUENCE 105; What happens?
A.RMAN aborts and sends an error message to the alert log.
B.An error message is returned by RMAN, and the ALTER SYSTEM ARCHIVE LOG CURRENT  command must be provided for RMAN to continue using log2.
C.RMAN creates a backup set with log2, then returns an error before moving to the next log file. RMAN resumes once the BACKUP BACKUPSET 102; and BACKUP BACKUPSET 104; commands are provided as appropriate.
D.RMAN automatically continues without any notifications as follows:
   Sequence RMAN Searches For RMAN Finds and Backs Up
   121 /log1/log_1_101.arc /log1/log_1_101.arc
   122 /log1/log_1_102.arc /log2/log_1_102.arc
   123 /log1/log_1_103.arc /log1/log_1_103.arc
   124 /log1/log_1_104.arc /log2/log_1_104.arc
Answer : D

3.In your production database (running in ARCHIVELOG mode):
- there are three online redo log groups
- the current log sequence number is 198
- the most recent closed database backup has been performed last Friday On Monday morning, you find that the users.dbf data file, which belongs to the USERS tablespace, is corrupted. On further investigation, you find that the archived redo log file for the log sequence number 196 does not exist.
Which recovery method would you use to recover the users.dbf data file?
A.Complete Database Recovery
B.Incomplete Recovery using UNTIL CANCEL
C.Incomplete Recovery using UNTIL SEQUENCE
D.Incomplete Recovery using USING BACKUP CONTROLFILE
Answer : A

4.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

5.When you are performing media recovery and an archived log is lost or corrupt, which type of recovery must you perform?
A.until SCN
B.until time
C.until cancel
D.recovery using backup control file
Answer : C

6.Which statement is true regarding a Recovery Manager (RMAN) incomplete database recovery using UNTIL SEQUENCE?
A.RMAN will reset the current sequence number to the number specified.
B.RMAN will restore data files from the most appropriate backup, and then recover them up to   the specified sequence number.
C.RMAN will ignore the number specified if the THREAD option is not specified and continue the normal restore and recovery processes.
D.RMAN will restore the data files up to the sequence number specified, from the most appropriate backup and then recover by applying all available archived redo log files up to the number specified.
Answer : B

7.You would like to create an RMAN recovery catalog in which to store information about your DB01 database.
You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recovery catalog are not displayed in the correct order. Which displays the correct order?
1.Grant the appropriate privileges (CONNECT and RESOURCE) and roles (RECOVERY_CATALOG_OWNER)
to the user responsible for performing backup and recovery operations.
2.Register the target database in the catalog.
3.Create the catalog using the RMAN command line interpreter.
4.Create a user and schema which will own the recovery catalog.
5.Create a tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog.
6.Connect to the target database using SYSDBA privileges.
A.4, 1, 5, 6, 3, 2
B.4, 3, 1, 5, 6, 2
C.4, 5, 1, 3, 2, 6
D.5, 4, 1, 3, 2, 6
E. 5, 4, 1, 3, 6, 2
Answer : E

8.Using the Oracle Export utility you want to perform a Direct-Path Export of the contents of the APPS tablespace that contains your application tables. Which option of the Oracle Export Utility would you use in order to improve the performance while exporting the data?
A.BUFFER
B.RECORD
C.CONSISTENT
D.RECORDLENGTH
E.OBJECT_CONSISTENT
Answer : D

9.On the last working day of every month, you get data from your regional offices in text format that you need to insert into tables in your production database. Which option would you use to insert the data?
A.the Oracle Import utility
B.the SQL INSERT command
C.the Oracle SQL*Loader utility
D.the SQL*Plus COPY command
E.the Oracle Migration Workbench
Answer : C

10.In a shared server configuration, which two describe the actions that the listener can take to service a client request? (Choose two.)
A.The listener hands the connection request directly to a dispatcher.
B.A dedicated server inherits the connection request from the listener.
C.The client connects to a dedicated server directly using a protocol address provided by the listener.
D.The application initiating the session spawns a dedicated server process for the connection request.
E.The listener issues a redirect message to the client, containing the protocol address of a 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 : AE

11.The three tasks shown have been completed in order to configure a naming method:
Task 1: Installed on server and client: Oracle Net Services, TCP/IP, TCP/IP protocol adaptor
Task 2: Started default listener on port 1521
Task 3: Added global database name to the listener.ora file
Which naming method was configured?
A.host naming method
B.local naming method
C.directory naming method
D.external naming method
Answer : A

12.The Oracle Shared Server architecture reduces memory usage by reducing the number of   server processes required. To process a request for a server process, the following tasks are performed:
1. A shared server picks up the request from the request queue and processes the request.
2. The dispatcher retrieves the response from the response queue.
3. A user sends a request to its dispatcher.
4. The dispatcher returns the response to the user.
5. The shared server places the response on the calling dispatcher's response queue.
6. The dispatcher places the request into the request queue in the SGA.
Put the above tasks in the order in which they are performed.
A.3, 1, 6, 2, 5, 4
B.3, 6, 1, 5, 2, 4
C.3, 1, 2, 3, 4, 5
D.6, 1, 3, 5, 2, 4
E.6, 3, 1, 2, 4, 5
F.6, 3, 1, 2, 5, 4
Answer : B

13.A user is running a long update batch file. Many tables are updated and all the statements are in one transaction.

Before the process is finished, the user machine lost power. When the user calls you, what should you do as DBA?
A.Do nothing, the PMON process handles everything.
B.Shut down the database and restore all the tables the user was updating.
C.Log in as DBA, clean up the partial updates in those tables, and do another manual backup.
D.Use LogMiner to find out which records are changed based on the user's ID, then roll back all those changes.
Answer : A

14.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 files
Answer : B

15.You execute this command in MOUNT mode:
ALTER DATABASE ARCHIVELOG;
Where is the information that the database is now in ARCHIVELOG mode stored?
A.SPFILE
B.archive log
C.control file
D.system tablespace
Answer : C

16.Which three features are provided by Oracle Net Services? (Choose three.)
A.data encryption
B.user authentication
C.transparent data conversion
D.configuration and administration mechanisms
E.support for multiple network transport protocols
Answer : CDE

17.Which Oracle Net utility is integrated with Oracle Enterprise Manager?
A.Oracle Net Manager
B.Listener Control utility
C.Oracle Names Control utility
D.Oracle Net Configuration Assistant
Answer : A

18.Which Oracle tool or utility would you use to configure directory server access?
A.Oracle Net Manager
B.Listener Control utility
C.Oracle Enterprise Manager
D.Oracle Connection Manager
E.Oracle Net Configuration Assistant
Answer : E

19.Which two are characteristics of user-managed backup and recovery operations? (Choose two.)
A.Recovery is initiated using SQL*Plus.
B.Database files are backed up using SQL commands.
C.Database files are backed up with Recovery Manager.
D.Database files are restored using Recovery Manager.
E.Database files are backed up using operating system commands.
Answer : AE

20.In user-managed backup and recovery procedures, how are data files backed up?
A.using SQL commands
B.using SQL*Plus commands
C.using operating system commands
D.using Recovery Manager commands
Answer : C

21.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 : AC

22.Your database is in NOARCHIVELOG mode. You added a data file to one of the tablespaces in your database. As a DBA, you need to perform a backup after you make any structural changes in the database.
Which user-managed backup would you perform in this event?
A.only a control file backup
B.individual tablespace backups
C.a consistent, whole database backup
D.backup of all the data files except the new one
Answer : C

23.Which user-managed backup performed on your database can be labeled as consistent?
A.a backup performed when the database is open
B.a backup performed on a tablespace after putting the tablespace into backup mode
C.a backup performed when the database is closed by using the SHUTDOWN ABORT command
D.a backup performed when all data files and control files are checkpointed with   respect to the same system change number (SCN)
Answer : D

24.Which two file types must be included in a closed database backup taken with operating system commands? (Choose two.)
A.data files
B.control file
C.password file
D.online redo log files
E.initialization parameter file
Answer : AB

25.You plan to take a closed database backup using operating system commands.   Which three SHUTDOWN options are appropriate for this type of backup? (Choose three.)
A.ABORT
B.NORMAL
C.IMMEDIATE
D.TRANSACTIONAL
Answer : BCD

26.You work on a database that is used for application development and operates in NOARCHIVELOG mode. The database has 10 tablespaces out of which two are read only. As a DBA, you know that database downtime can be tolerated and have designed a backup strategy containing a weekly closed database backup. Which files can you exclude from the weekly user-managed backup? (Choose all that apply.)
A.control files
B.sqlnet.ora file
C.tnsnames.ora file
D.data files associated with read-only tablespaces
E.data files associated with read/write tablespaces
Answer : BCD

27.You work on a database that is used for application development and operates in ARCHIVELOG mode. As a DBA, you know that database downtime can be tolerated   and have designed a backup strategy containing a weekly closed database backup. The local naming method is used by clients to connect to the database.
Which files should you include in this weekly user-managed backup? (Choose all that apply.)
A.control file
B.sqlnet.ora file
C.archived log files
D.tnsnames.ora file
E.listener configuration file
Answer : AC

28.You issue this SQL command to perform an online backup of the USER_DATA tablespace: ALTER TABLESPACE user_data BEGIN BACKUP;
Next, you issue an operating system command to back up user_data01.dbf, the file that  belongs to the USER_DATA tablespace.
You then experience an instance failure. Which three statements are true? (Choose three.)
A.The user_data01.dbf file needs to be restored from an earlier backup and recovered.
B.The online backup of the USER_DATA tablespace can be ended with an ALTER DATABASE command.
C.The backup of user_data01.dbf is unusable for future recoveries if the operating system copy was not completed before the instance failure.
D.The database open fails because the header of the user_data01.dbf data file is not synchronized with the other database files.
E.The user_data01.dbf file is corrupted because of the instance failure during the online backup of the data file.
Answer : BCD

29.You just completed a manual open database backup. However there seems to be a problem with the database performance. You discover that the database is generating many log switches and the LGWR is consuming lots of CPU time. You have an idea of what the problem is and you begin looking at the information in V$BACKUP and in V$DATAFILE_HEADER.
What do you suspect is the problem?
A.One or more data files have a status of ACTIVE.
B.One or more data files have a status of ONLINE.
C.One or more data files have a status of OFFLINE.
D.One or more data files have a status of NOT ACTIVE.
Answer : A

30.Because your business requirements do not permit you to shut down the database   to perform backups, you decide to perform online backups. You use the ALTER TABLESPACE .. BEGIN BACKUP command to perform the backups. The command returns the following error:
ERROR at line 1:
ORA-01123: cannot start online backup; media recovery not enabled
What could be the reason for this error?
A.The database is in the MOUNT state.
B.The database is in NOARCHIVELOG mode.
C.The command was executed on the SYSTEM tablespace.
D.The command was executed on a temporary tablespace.
E.The command was executed on a read-only tablespace.
Answer : B