Questions(31-40)

QUESTION 31:

Which phrase best describes RMAN multiplexed backup sets?
A. Stripes a single backup set across multiple channels.
B. Identical copies of backup pieces within a backup set.
C. Multiple backup sets with multiple channels configured.
D. Simultaneous reads from multiple files and writes into the same backup piece.
Answer: C
Explanation:RMAN multiplexes multiple backup sets with multiple channels configured.

QUESTION 32:
Which modifier is used to change listener parameters in the Listener Control utility
environment?
A. SET
B. ALTER
C. CHANGE
D. UPDATE
Answer: A
Explanation:
The SET command enables you to dynamically set the values for the listener parameters. The
values persist till the listener is stopped.
 Some examples as

• SET
  
• SET CURRENT_LISTENER
  
• SET DISPLAYMODE
  
• SET INBOUND_CONNECT_TIMEOUT
  
• SET LOG_DIRECTORY
  
• SET LOG_FILE
  
• SET LOG_STATUS
  
• SET SAVE_CONFIG_ON_STOP
  
• SET TRC_DIRECTORY
  
• SET TRC_FILE
  
• SET TRC_LEVEL
  

QUESTION 33:
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: B, C, D
Abort will shutdown database in inconsistent mode and backup at this point in time will be fruitless.

To perform an offline whole database backup the database needs to be shut down normally
using one of the following options: IMMEDIATE, TRANSACTIONAL, or NORMAL.

QUESTION 34:
Which three initialization parameters are no longer needed when
FAST_START_MTTR_TARGET is defined? (Choose three)
A. TARGET_REDO_BLKS
B. FAST_START_IO_TARGET
C. LOG_CHECKPOINT_TIMEOUT
D. RECOVERY_ESTIMATED_IOS
E. LOG_FILE_SIZE_REDO_BLKS
F. LOG_CHECKPOINT_INTERVAL
Answer: B, C, F
Explanation:
The initialization parameter FAST_START_MTTR_TARGET enables you to specify the
amount of time (in seconds) the database should take to perform crash recovery of a single
instance. This value is internally converted to a set of parameters that are as follows
1>FAST_START_IO_TARGET :- It indicated number of block transfer required during crash recovery.

2>LOG_CHECKPOINT_INTERVAL:- It indicated max time gap between 2 consecutive checkpoint operation and

3>LOG_CHECKPOINT_TIMEOUT :- It indicated max time from last checkpoint.
Setting these parameters to active values obstructs the normal functioning of
FAST_START_MTTR_TARGET, thereby resulting in unpredictable results.


QUESTION 35:
In a dedicated sever configuration, which two statements describe the actions that can be
taken to complete a client/server connection when the client and server are NOT on the
same computer? (Choose two)
A. The listener hands the connection request directly to a dispatcher.
B. The dedicated sever inherits the connection request from the listener.
C. The listener issues a redirect message to the client, containing the protocol address of a
dispatcher.
D. The application initiating the session spawns a dedicated server process for the
connection request.
E. The dedicated sever informs the listener of its listening protocol address.
The listener passes the protocol address to the client in a redirect message and
terminates the connection.
The client connects to the dedicated server directly using the protocol address.
Answer: B, E
Explanation:
The dedicated sever inherits the connection request from the listener. The PMON process is
responsible for registering information about the dedicated server processes with the listener.
Whenever a client request arrives for a connection, the listener starts a dedicated server
process and passes the connection to the dedicated server process. This is known as a
bequeathed session. In order for this method to be used, the listener must be running on the
same server as the node; that is, the listener cannot bequeath a connection to another node.
Once the client connection is established with the server process with the help of the listener,
the client will now directly communicate with the server process. Since the client's
connection with the listener is transient and its connection with the server is permanent, you
can shut down the listener without affecting the existing connections.

QUESTION 36:
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
Explanation:
Power Failure has occurred client side and hence only connection between that particular client and server in disconnected.PMON is a process that continuously monitors connection between users and server processes,and when it gets disconnected,PMON frees dead dispatchers,resources and rollbacks uncommitted transactions.

A process failure is due to the abnormal termination of a process. Oracle handles these types
of failures by using a background process called PMON. PMON identifies the terminated
session and resets the status of the active transaction table, releases locks, and removes the
process ID from the list of active processes.

QUESTION 37:
For which two tasks would it be best NOT to use the utility SQL*Loader? (Choose two)
A. When loading selected rows into each table.
B. When loading data from an export dump file.
C. When loading data from disk, tape, or named pipes.
D. When your data is NOT being inserted from a flat file.
E. When using a record management system to access data files.
Answer: B, D
Explanation:
SQL* LOADER utility is used to load data from other data source into Oracle. For example, if you have a table in FOXPRO, ACCESS or SYBASE or any other third party database, you can use SQL Loader to load the data into Oracle Tables. SQL Loader will only read the data from Flat files. So If you want to load the data from Foxpro or any other database, you have to first convert that data into Delimited Format flat file or Fixed length format flat file, and then use SQL loader to load the data into Oracle. 

Question is when should we not use it.
1>To get data from dump file we use export utility.hence B

2>We use SQL*LOADER for Flat file data transfer.hence D

QUESTION 38:
Your database is running in NOARCHIVELOG mode. Every night there is a backup
taken using RMAN. During your startup this morning you received en error regarding
DISK 3 on your server. This is the location of your data file for the SYSTEM tablespace.
Which option is open to you?
A. The data file needs to be restored by using operating system commands, because a data
file movement must take place, and then the database can be recovered from RMAN.
B. The data file needs to be restored by using operating system commands, since a data
file movement must take place, and then the database must be recovered manually.
C. From RMAN you can issue the commands RESTORE and RECOVER.
RMAN automatically restores the data file on DISK 3 to another disk, based upon
utilization statistics.
D. From RMAN you can issue a SET NEWNAME command to update the data file
location information in the control file, and then issue the RESTORE and RECOVER
commands to recover the database.
Answer: D
Explanation:
Question says that there is some problem with DISK 3 and hence we cant restore datafile to disk 3.and in order to restore the datafile to new location we need to first specify new location using SET NEWNAME
command.Manually its not possible to set new location in controlfile hence we need to use rman.
RMAN enables you to restore the data files to a non-default location. Relocating the data files
to an alternative location is useful when storage is limited or when you need to reorganize the
database to improve performance. You need to create a RMAN script that will perform the
following actions: setting a new location for the data file, restoring the data file, recovering
the data file.

QUESTION 39:
The multithreaded agent architecture for heterogeneous services is similar to the Oracle
multithreaded server architecture. The principal difference is that it used threads
instead of processes.
What are thee kinds of threads that it uses? (Choose three)
A. TCP
B. Task
C. Monitor
D. Dispatcher
E. Shared Server
F. Shutdown address
Answer: B, C, D
Explanation:
Multithreaded agent architecture for heterogeneous services.
Its an method of providing Oracle like architecture to Non-oracle systems.

• A single monitor thread. The monitor thread is responsible for the following:
  
  
  • Maintaining communication with the listener
    
  • Monitoring the load on the process
    
  • Starting and stopping threads when required
    
  
  
• Several dispatcher threads. The dispatcher threads are responsible for the following:
  
  
  • Handling communication with the Oracle server
    
  • Passing task requests to the task threads
    
  
  
• Several task threads. The task threads handle requests from the Oracle processes.
  
  These three thread types roughly correspond to the Oracle multithreaded server PMON, dispatcher, and shared server processes, respectively.

QUESTION 40:
You created a database by using the Database Configuration Assistant. What must you
do to access a user account in the sample schemas?
A. Create the user account and unlock the account.
B. Create the user account and define a password.
C. Unlock the user account and define a password.
D. Set the 07_DICTIONARY_ACCESSIBILITY parameter to TRUE.
Answer: C
Explanation:
To access a user account in the sample schemas you need to unlock the user account and
define a password.