我做错的或怀疑答案错的，不一定是大家容易错的
5. In the Oracle9i Data Guard architecture, what is the purpose of the Log Transport Services


7. For which two tasks would it be best NOT to use the utility SQL*Loader? (Choose two)
9. 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 these kinds of threads that it uses? (Choose three)
10. You company has four DBAs. You need to know which DBA added a column to the JOB_HISTORY table. The database cannot be offline during work hours. Which LogMiner command can you use to find out which user made the table change

A.
SELECT username, operation, sql_redo from V$LOGMNR_CONTENTS where operation='DDL';

11. Consider this RMAN command:
RMAN> CONFIGURE RETENTION POLICY CLEAR;
What is the effect of this command?

12. You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist.


Which command should you now use to check if any of the files were missing?

A.
LIST EXPIRED
13. You received this error message because Oracle Net Services cannot locate the connect descriptor specified in the tnsnames.ora configuration file:


ORA_12154: TNS:could not resolve service name


Which three actions would be appropriate in helping to resolve the error? (Choose three)
14. You experienced a loss of data files in your database. You did not lose any of your control files. You are going to use RMAN to restore and recover the database. Currently, your instance is shut down.


Which sequence of commands is correct to restore and recover your database?
15. Click the Exhibit button and examine the diagram. You are running a database that takes advantage of features provided by Connection Manager, heterogeneous services, and external procedures. The diagram depicts the components used for the naming method you just configured.


Which naming method are you using?
17. You discover that a disk failure occurred on DISK3 where the data file belonging to the USER_DATA tablespace is stored. The database is currently open and you need to recover the data file. You will restore the data file from the backup on DISK5 to DISK2.


What is the correct sequence of commands to restore and recover the data file?

19. You have just run this syntax to start the listener from the Listener Control utility:

LSNRCTL>START
Starting /mstgelai/oracle/bin/tnslsnr: please wait...
System parameter file is /u01/oracle/network/admin/listener.ora
Log messages written to /u01/oracle/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stc-sun01-server)(PORT=1521)))
Connecting to...
The command completed successfully
What is the name of the Listener you started?
21. Which phrase best describes RMAN multiplexed backup sets
24. Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined? (Choose three
26. The EMPLOYEES table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table's primary key is stored in the INDX tablespace. Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which objects will be exported by this command?


exp system/manager tablespaces=SAMPLE
29. Which two statements regarding the control file and Recovery Manager are true? (Choose two)
30. You discover that a disk failure occurred on DISK3 where the data file belonging to the USER_DATA table space is stored. The database is currently open and you need to recover the data file. You will restore the data file to DISK2.


What is the correct sequence RMAN commands to restore and recover the data file?  
32. When performing an incomplete recovery of the whole database, what must be true about the data files that are restored


35. When performing incomplete recovery using UNTIL SEQUENCE with RMAN, which two pieces of information are required? (Choose two
39. In which three cases does a checkpoint occur? (Choose three
40. You issue this RMAN command:
RMAN> create script Level0Backup {

backup

incremental level 0

format '/u01/db01/backup/%d_%_Sp'

fileperset 5

(database include current controlfile);

sql 'alter database archive log current';

}


Which three statements are true about the Level0Backup script you just created? (Choose three
43. What is the new Oracle Shared Server
A.
An improved version of multithreaded server configuration.

44. You can control instance recovery performance by setting parameters to define targets for ______.
49. Oracle Net Services is composed of several communication layers, known as a stack, which enables clients and database severs to share, modify, and manipulate data. Which reveals the correct architecture, in hierarchical order, of the client-side stack
52. Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance
53. The direct handoff connection method to an Oracle9i Shared Server involves fewer messages than in previous releases of the multithreaded architecture
A.
ich type of message has been eliminated?
55. Some data storage and transfer media have fixed-length physical records. When the data records are short, more then one can be stored in a single, physical record to use the storage space efficiently.


Consider this data:
1119 Smith
1120 Yvonne
1121 Albert
1130 Thomas


Which two statements can you use to load the data into the EMP table? (Choose two)
56. Which three statements about direct path exports are true? (Choose three)

60. Click the Exhibit button and examine the diagram, which illustrates the components performing tasks within an Oracle Shared Sever environment.
Which task is being performed by component 4?
61. You need to recover five data files that are spread across multiple disks. Which initialization parameter should you set to speed up redo application

64. Which four occur during the processing of a request using Oracle Shared Server? (Choose four)
66. Oracle Net Configuration Assistant is a post-installation tool that configures basic network components after installation. Which four components are included in the configuration? (Choose four)
67. Management has decided that the database must be available 24 hours a day, 7 days a week. Given this requirement, which type of backup is required?
70. You would like to create an RMAN recover 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 recover catalog are not displayed in the correct order. Which displays the correct order?
74. 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 destination?
80. Which statement is true regarding remote archive log file destinations?
83. 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?
84. Which two SQL*Loader instructions are used to assemble logical records? (Choose two)
85. You database runs in ARCHIVELOG mode, and is backed up every Sunday. The archive logs are copied to tape, and then removed every night. The database consists of 10 redo log groups.


On Wednesday afternoon the server has an unscheduled shutdown. Upon restarting the database, corruption in the SYSTEM tablespace data file is reported. You also notice that there have been 17 log switches since Sunday.


Which solution should you use in order to minimize both down time and data loss?
88. The database is configured for automatic archive logging. Along with the other required parameters, this entry is in the initialization file:


LOG_ARCHIVE_DEST_2="SERVICE=standby_db1 MANDATORY REOPEN=600"


From where does the database resolve standby_db1?
90. Assume your situation can be described as follows:
A full backup taken using RMAN is available on disk.
The current control files were NOT damaged and do not need to be restored.
All data files are damaged or lost.
The database is in NOARCHIVELOG mode.
Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database?

1 RMAN> STARTUP MOUNT
2 RMAN> RESTORE DATABASE;
3 RMAN>
4 RMAN> ALTER DATABASE OPEN;
96. When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON, RMAN automatically performs a control file autobackup in which three situations? (Choose three)
99. You issue this SQL statement:


ALTER DATABASE RENAME FILE '/ORADATA/u02/user_data01.dbf' TO '/ORADATA/u04/user_data01.dbf';


What does this SQL statement do?
100. Which tool can be used to create and configure listeners to receive client connections?
102. Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database, each with three members, making a total of 30 redo log files.


At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible?
104. When you use the Oracle Net Configuration Assistant to specify the naming method, which file is updated?
106. 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?

108. The SET CONTROLFILE AUTOBACKUP FORMAT command, which you can specify either within a RUN block or at the RMAN prompt, overrides the configured autobackup in the session only. What is the order of precedence?


1 SET within RUN


2 SET at RMAN prompt


3 CONFIGURE
109. The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens.


Which type of recover is used in this situation?
111. A single SQL* Loader input data file might contain records in a variety of formats.与前面相反的答案


Click the Exhibit button and examine the data shown, in which EMP and DEPT records are intermixed (DEPT records are indicated by 1 and EMP records are indicated by 2).

1 50 Manufacturing -- DEPT record
2 1119 Smith 50 -- EMP record
2 1120 Snyder 50
1 60 Shipping
2 1121 Stevens 60

Which two statements can you use to load the data shown in the Exhibit into the DEPT and EMP tables? (Choose two.)



112. SQL*Loader reads a set of records from a file, generates INSERT commands, and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes.
怀疑dp不用拼INSERT

Which SQL*Loader mode is used in this scenario?
113. You notice that your RMAN script 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 to speed up the COPY commands? (Choose two)
114. When importing a table into a database, the import process performs these tasks:
1 Triggers are imported.
2 Data is imported.
3 New tables are created.
4 Indexes are built.
5 Any bitmap, functional, and/or domain indexes are built.
6 Integrity constraints are enabled on the new tables.

Which option shows the tasks in the order in which they are performed?
115. You want to perform an incomplete recovery of your database. You plan to use these commands to recover your database:
SET UNTIL TIME = `2000-12-09:11:44:00';
RESTORE DATABASE;
RECOVER DATABASE;

How should the commands be executed?
124. When performing an incomplete recovery of the whole database, which data files must you restore?
127. You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands:
STARTUP MOUNT;
BACKUP
FORMAT '/BACKUP/df_%d_%s %p.bus'
DATABASE filesperset = 2;

Which components are included in the backup?

还真不少

032做错的题-3


135. Oracle Net is responsible for establishing and maintaining the connection between the client

application and the server.


On the client side, Oracle Net is responsible for which three connectivity issues? (Choose three)
137. 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?
141. Which two RMAN commands initiate a resynchronization of the recovery catalog with the target

database control file? (Choose two)
144. After running the CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS command, what has been

accomplished?
147. Which component of the Oracle networking architecture provides character set and data type

conversion between different character sets on the client and server?
QUESTION 154


--------------------------------------------------------------------------------

In your organization, you have a single functional database and you are setting up a
network connection between the Oracle database server and the Oracle clients.
Because there are only a few Oracle clients, you want the clients to use the host
naming method to connect to the database server. Which option must you specify in
the listener.ora file to enable the listener process to receive connection requests from
clients?


QUESTION 155


--------------------------------------------------------------------------------

In which scenario would you open the database with the RESETLOGS option after
recovering the database in NOARCHIVELOG mode?
QUESTION 158


--------------------------------------------------------------------------------

You need to set an encrypted password for the listener, LSNR. Which two options
could you use to set the password? (Choose two.)

QUESTION 159


--------------------------------------------------------------------------------

View the Exhibit.
You configured local naming as the naming method by using Oracle Net Manager.
As a result, which configuration file will be modified?
Exhibit:


QUESTION 164


--------------------------------------------------------------------------------

You are working in a dedicated server environment. You require the PMON
process to register with a local listener, lsnr1, which does not use TCP/IP, port 1521.
The protocol address of lsnr1 is available in the listener.ora file. What would you do?


QUESTION 165


--------------------------------------------------------------------------------

While starting up the database on a Monday morning, you get the following error
after the database is mounted:
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: '/u01/oracle/app/oradata/orcl/users01.dbf'
On investigation, you find that the file system, u01, on the operating system is
corrupted and you need to recover the data file to a new location. The database is
running in ARCHIVELOG mode and the database was backed up on last Friday.
You must ensure that the database is not accessible till the data file is recovered.
Which two tasks must you have accomplished before applying the archived redo log
files? (Choose two.)
QUESTION 168


--------------------------------------------------------------------------------

Which statement correctly describes the checkpoint position?
QUESTION 170


--------------------------------------------------------------------------------

In your database server, you discovered that a data file that belongs to one of the
users tablespaces is corrupted and, therefore, requires a recovery. To perform the
recovery, which are the files that you may need to restore from the recent backup?
(Choose all that apply.)


QUESTION 171


--------------------------------------------------------------------------------

You executed the following RMAN script to perform a backup:
RUN
ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
ALLOCATE CHANNEL c2 DEVICE TYPE sbt;
ALLOCATE CHANNEL c3 DEVICE TYPE sbt;
BACKUP DATAFILE5,6,7;
{
Which statement regarding channel allocation is true?


QUESTION 174


--------------------------------------------------------------------------------

Which two statements are correct regarding the listener process? (Choose two.)
QUESTION 180


--------------------------------------------------------------------------------

You are working on a database in which due to an instance failure all the
transactions are terminated. As soon as the database opens, you want to access a
row that is locked by a transaction, which was terminated. You want to access the
row without waiting for all parts of the terminated transaction to be rolled back.
How do you configure this phase of instance recovery?
QUESTION 183


--------------------------------------------------------------------------------

You are using RMAN for backup and recovery of your database. You set the
retention policy to NONE by executing the following command:
RMAN>CONFIGURE RETENT POLICY TO NONE;
What would be the impact of this setting?


QUESTION 185


--------------------------------------------------------------------------------

You are using RMAN to perform a backup of your database. Which statement is
true regarding image copy backups?


image也要检查块？
QUESTION 186


--------------------------------------------------------------------------------

You decided to use RMAN to perform backup and recovery of your database.
During the process of creating the recovery catalog you executed the following
command:
RMAN>register database;
Why do you need to execute this command?


QUESTION 189


--------------------------------------------------------------------------------

You back up your database, which is running in ARCHIVELOG mode, at regular
intervals. On Monday morning, you find that one of the data files is corrupted and
the database administrator is recovering the file by executing the following
command after restoring the file from a backup:
SQL>RECOVER AUTOMATIC datafile 8; QUESTION 200


--------------------------------------------------------------------------------

Which two statements are true regarding the Recovery Manager (RMAN)
CROSSCHECK command? (Choose two.)



What is the objective of using the AUTOMATIC option with the RECOVER command?
QUESTION 201


--------------------------------------------------------------------------------

You are using Recovery Manager (RMAN) to back up your database at regular
intervals. On Monday morning, you realize that the data file, users.dbf, is
corrupted. You need to restore the data file to a different location from the current
location of the data file, by using the RMAN back up of the data file. Which task
must you accomplish after you execute the SET NEWNAME command to change
the location of the data file?


QUESTION 205


--------------------------------------------------------------------------------

You are working in an Oracle Shared Server environment. You added one more
dispatcher to handle TCP requests. How would you verify that the dispatcher has
been registered when the instance was started?

共勉。我也在准备032。你准备何时考？

thanks a lot

今天上午刚考完，错了一个题