×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
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?
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?
2.
You experience a loss of the disk on which the USER_DATA tablespace data files are stored. You have three
online redo log file groups and your current log sequence number is 50. You attempt to recover the data files
but discover that the archived redo log file with sequence number 45, which is needed to perform complete
recovery, is invalid. You then perform an incomplete recovery through redo log sequence 44. After the recovery
is complete, which command should you execute?
online redo log file groups and your current log sequence number is 50. You attempt to recover the data files
but discover that the archived redo log file with sequence number 45, which is needed to perform complete
recovery, is invalid. You then perform an incomplete recovery through redo log sequence 44. After the recovery
is complete, which command should you execute?
3.
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?
Task 2: Started default listener on port 1521.
Task 3: Added global database name to the listener.ora file.
4.
Which of the following architectures is used to support the agent or the application tier?
5.
Which of the following file should be configured for dynamic service registration?
6.
The Oracle Net architecture is based on which of the following?
7.
Connection Manager features cannot be used with which of the following naming method?
8.
Which of the following files can be used to configure connection pooling in the shared server environment?
9.
Which of the following statement is incorrect regarding RMAN?
10.
Which background process is responsible for writing the dirty buffers from the write list to the data files during a
checkpoint?
checkpoint?