1Z0-052 v3补充题目

补充题目

72.Examine the following output: SQL> SELECT index_name,status FROM dba_indexes

WHERE status='UNUSABLE'; INDEX_NAME STATUS EIND UNUSABLE

Which two statements about the above index are true? (Choose two.) A. It is ignored by the query optimizer.

B. It is not used while the index is being rebuilt.

C. The index cannot be rebuilt, and has to be re-created.

D. The index is automatically rebuilt when used the next time. Answer: AB

115.Which of these is true about undo tablespace? A. Undo tablespace is a temporary tablespace. B. Undo tablespace has only one datafile.

C. Undo tablespace has a datafile which is reused in cyclic manner. Answer: A

116.Your database is in shutdown state.

What will happend if you issue next command: SQL> startup

A. instance will started.

B. instance started and DB is mounted.

C. instance started, DB opened and finally mounted. D. instance started, DB mounted and finally opened. Answer: D

177.Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.) A. It can be increased up to the value of the SGA_MAX_SIZE parameter.

B. Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.

C. Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and manually sized components.

D. Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared memory management feature. Answer: AB

201.Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?

A. The DML operations re-create the bitmap index blocks.

B. The bitmap index is rebuilt automatically after a DML operation.

C. The smallest amount of a bitmap that can be locked is a bitmap segment.

D. Additional time is taken to remove NULL values from the bitmap index after a DML operation. Answer: C

16) You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state? A. Dropping a tablespace in your database.

B. re-creating the control files, after you lost all the control files in your database. C. dropping a user in your database. D. renaming the control files.

E. enabling or disabling redo log archiving. Answer: E

75) Note the following points describing various utilities in Oracle Database 11g: Which point describes the Oracle Data Pump utility?

1. It enables the transfer of data from one database to another

2. It provides a complete solution for the backup, restoration and recovery needs of the entire database 3. It enables the loading of data from an external file into tables of an Oracle Database 4. It provides a tape backup management for the Oracle ecosystem A. 1 B. 2 C. 3 D. 4

E. 1 and 3

F. 1, 2, 3 and 4 Answer: A

162) View the Exhibit.

Which statement causes more undo generation? A. DELETE FROM emp WHERE empno=7934;

B. UPDATE emp SET comm=400 WHERE empno=7844;

C. INSERT INTO emp VALUES(7999,?JHON?,?CLERK?,7782,?10-MAY-83′,1500,NULL,10); D. SELECT * FROM emp;

Answer: A

163) Where do you find information about a missing redo log file? A. audit trail B. event viewer C. alert log file D. trace file E. control file Answer: C

164) You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces? A. SQL*Plus B. iSQL*Plus

C. Management Server D. Management Repository

E. Oracle Enterprise Manager 11g Database Control Answer: E

165) The database users are connecting to the PROD database from different applications, thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective? A. set the SESSIONS to 1 in the parameter file

B. create a role with SINGLE SESSION privilege and assign the role to the users C. grant RESTRICTED SESSION privilege to all of the database users D. grant SINGLE SESSION privilege to all of the users

E. set the SESSIONS_PER_USER to 1 in the users? profile Answer: E

166) What advantage would you get if you increase the length of time during which the undo information would be stored in the database?

A. read consistency for long-running transactions B. roll back of large transactions C. roll forward to redo a transaction D. data concurrency for large updates Answer: A

167) One of the users in the PROD database, Adams, complains that his update on the table, TRANS, is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions, and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table, he should get the highest priority. Which method would you use to overcome this problem? A. execute the command, ALTER SYSTEM UNLOCK SESSION .., to release the lock for the blocking session B. execute the command, ALTER SESSION UNLOCK .., to release the lock for the blocking session C. execute the command, ALTER SYSTEM KILL SESSION .., to kill the blocking session D. execute the command, ALTER SESSION KILL .., to kill the blocking session

E. execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session Answer: C

168) Exhibit: Which two options are used to enable the connect-time failover feature? (Choose

two.)

A. Use only the first address.

B. Try one address, selected at random.

C. Try each address, in order, until one succeeds. D. Try each address, randomly, until one succeeds. E. Use each address in order until destination reached. Answer: CD

169) You have created a baseline metric, DISK_IO_BL, for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics.

Which method would you use to remove the DISK_IO_BL baseline metrics? A. The baseline, once created, cannot be removed.

B. Disable the baseline metrics in the Database Control Manage Metrics page.

C. The baseline will be automatically removed once the database performance has been optimized.

D. Drop the baseline metrics by using DBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure. Answer: D

170) View the Exhibit.

Your Oracle 10g database has 6 tablespaces in which: – TEMP is the default temporary tablespace – UNDOTBS1 is the default undo tablespace

– USERS is the default permanent tablespace

In this database, which three tablespaces can be made offline? (Choose three.) A. PROD B. SYSAUX C. USERS D. SYSTEM E. TEMP

F. UNDOTBS1 Answer: ABC

171) A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off from and log on to the database to continue his work. ORA-02392:

exceeded session limit on CPU usage, you are being logged off Which action would you take to increase the session limit on CPU usage?

A. Modify the value for the RESOURCE_LIMIT parameter in the parameter file. B. Modify the profile assigned to the user. C. Modify the roles assigned to the users.

D. Modify the object privileges assigned to the user. E. Modify the system privileges assigned to the users. Answer: B

172) Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users? queries. Which component of the Oracle Instance would you change to improve performance? A. Database buffer cache B. Redo log buffer C. Library cache D. Streams pool E. Shared pool F. Java pool G. Large pool Answer: A

173) User SCOTT wants to export his objects using Oracle Data Pump and executes the following command: $ expdp scott/tiger directory = EXPORT_DIR dumpfile = scott.dmp include = table include = view:”like ?TPARTMENTS%'” content = DATA_ONLY Which task would the command accomplish?

A. Oracle Data Pump would export all of the table structures along with data and all the views.

B. Oracle Data Pump would export all of the table structures and the view definitions with data where view name contains a string named DEPARTMENTS.

C. Oracle Data Pump would export only the data of all of the tables and views.

D. Oracle Data Pump would export the table data and the view definitions with data where view name contains a string named DEPARTMENTS.

E. Oracle Data Pump would export the table data and the view definitions where the view name contains a string named DEPARTMENTS. Answer: E

174) When you try to open your database, you receive the following error: ORA-00205: error in identifying controlfile Where would you find the details required to resolve this error? A. background trace file

B. operating system event viewer C. online trace file D. user trace file E. alert log file F. audit trail Answer: E

175) You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database files. Which two statements are true? (Choose two.)

A. On startup, CKPT coordinates instance recovery. B. On startup, use RMAN to perform instance recovery.

C. Uncommitted changes will be rolled back after the database is opened. D. On startup, perform media recovery and then instance recovery.

E. On startup, all the files will be synchronized and you get both committed and uncommitted data. F. On startup, SMON coordinates instance recovery. Answer: CF

176) You specified extent management as local for a tablespace. How will it affect space management in the tablespace?

A. All the extents will be of the same size.

B. The tablespace will be system managed and the users cannot specify the extent size. C. Free extents will be managed by the data dictionary tables. D. Bitmap will be used to record free and allocated extents. Answer: D

177) Y ou started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old How would you prevent such an error in the future? (Choose three.)

A. change automatic undo management to manual B. guarantee undo retention C. add one more redo log group

D. size the redo log files appropriately

E. size the UNDO tablespace appropriately F. size the SYSTEM tablespace appropriately

G. configure an appropriate undo retention interval Answer: BEG

178) Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true? (Choose two.)

A. The destination may be local or remote for a Standby Database. B. All the destinations are determined by the server automatically. C. A maximum of ten different destinations can be assigned. D. The destination must be global only.

E. The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter. F. A maximum of five destinations can be assigned. Answer: AC

179) You created a new user in your database but missed assigning a default tablespace to that user. The user created a table without specifying the tablespace name. In which tablespace would the table be stored? A. the default undo tablespace

B. the default permanent tablespace C. the default temporary tablespace D. the SYSTEM tablespace E. the SYSAUX tablespace F. the INDEX tablespace G. the USERS tablespace Answer: B

180) Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation?

A. recover using Oracle Flashback Database technology

B. restore the data files from backup and perform a complete recovery C. restore only the corrupted data file and perform tablespace recovery D. restore the data files from backup and perform cancel-based recovery

E. restore the entire database from the most recent backup and start the instance and open the database Answer: E

181) You want the size of the tablespace to increase when it is full. Which option would you use? A. create the tablespace as a bigfile tablespace

B. use the RESIZE clause while creating the tablespace

C. enable AUTOEXTEND for at least one of the data files in the tablespace D. use freelists to manage the free space E. disable threshold for the tablespace F. use automatic extent allocation

G. use automatic segment space management Answer: C

182) Your database performance has degraded due to frequent checkpointing. What would you do in this scenario? A. make the changes as per the advice given by Checkpoint Advisor B. make redo log files smaller

C. increase the size of the checkpoint file

D. make the changes as per the advice given by MTTR Advisor Answer: D

183) View the Exhibit to see the structure of the EMPLOYEES and DEPARTMENTS tables.

Your organization plans to dissolve the department with department ID 30. You execute the following command to delete rows from the DEPARTMENTS table:

SQL>delete from DEPARTMENTS where DEPT_ID = 30; The command fails and displays the following error: ERROR at line 1:

ORA-02292: integrity constraint (HR.SYS_C005374) violated – child record found Which two actions would you take to overcome this error? (Choose two.)

A. first, delete rows from the EMPLOYEES table for department id 30 and then delete the rows from the DEPARTMENTS table for department id 30

B. first, drop the EMPLOYEES table and then delete the rows from the DEPARTMENTS table C. first, drop the DEPARTMENTS table and then delete the rows from the EMPLOYEES table D. alter the foreign key constraint to include the on delete cascade option

E. first, delete all of the rows from EMPLOYEES table and then delete the rows from the DEPARTMENTS table for department id 30

F. alter the foreign key constraint to include the cascade option Answer: AD

184) As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead?

A. Move the application tables to a tablespace with less space usage.

B. Distribute the application tables across multiple tablespaces depending on usage. C. Export and Import the application tables a regular interval. D. Coalesce the application tables at a regular interval.

E. Move the application tables to automatic segment space management tablespace. F. Drop and recreate the application tables at a regular interval. Answer: E

185) On which three can you use Recovery Manager (RMAN) to perform incremental backup? (Choose three.) A. whole database

B. flashback log file H. archived log files I. change tracking file C. parameter file D. password file E. tablespaces F. control files G. data files Answer: AEG

186) Due to media failure you lost one of the data files belonging to the USERS tablespace, and the tablespace is not available to use. Which statement regarding the status of the database is true? A. The database gets dismounted. B. The database becomes read only. C. The database instance gets aborted.

D. The database gets shut down automatically.

E. The status of the database depends on the status of the USERS tablespace. F. The database remains open. Answer: F

187) In which two cases would you perform only consistent backup? (Choose two.) A. You are working on a database where downtime is not tolerated. B. You are working on a database where downtime can be tolerated. C. You are working on a database that operates in ARCHIVELOG mode. D. You are working on a database that operates in NOARCHIVELOG mode.

E. You are working on a database where all the tablespaces are locally managed.

F. You are working on a database where control files and redo log files are multiplexed. G. You are working on a database where control files and redo log files are not multiplexed. Answer: BD

188) You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy read-consistency requirements. How do you change the UNDO_RETENTION value?

A. by executing UPDATE.. statement on V$PARAMETER to change the value of UNDO_RETENTION B. by executing the ALTER SYSTEM .. command

C. by re-creating the control file with a new value for UNDO_RETENTION D. by executing the ALTER DATABASE.. command in the MOUNT state Answer: B

189) You executed the following command in the lsnrctl utility to stop the listener: lsnrctl> STOP L1

What is the effect of this command if L1 is the only listener configured for your database? A. Connected users would get an error with the message “End of communication channel”. B. The server hangs, so users will receive an error asking them to login again. C. It halts the server until all user transactions are completed. D. It terminates all user sessions.

E. It prevents users from logging in to the database remotely. Answer: E

190) You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE DATABASE .. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.

Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications? A. RESTART B. RESTART L1 C. RELOAD L1 D. RELOAD E. START F. REFRESH G. START L1

Answer: C

191) You need to rename a data file of a tablespace. How would you perform this?

A. make the tablespace that contains the data file read only, rename the data file using the operating system, execute the ALTERTABLESPACE… RENAME DATAFILE .. statement to rename the data file, and make the tablespace read/write

B. bring the database to the NOMOUNT state, rename the data file using the operating system, and then execute the ALTER TABLESPACE…RENAME DATAFILE .. statement

C. take the tablespace that contains the data file offline, rename the data file using the operating system, execute the ALTER DATABASE…RENAME DATAFILE .. statement, and bring the tablespace online

D. take the tablespace that contains the data file offline, rename the data file using the operating system, execute the ALTER TABLESPACE…RENAME DATAFILE .. statement, and bring the tablespace online Answer: D

192) When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed: TZ set to America/New_york OC4J Configuration issue.

/u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found.

Which two environment variables do you need to set appropriately to avoid such errors, and start the Database Control successfully? (Choose two.) A. LD_LIBRARY_PATH B. ORACLE_BASE C. ORACLE_HOME D. NLS_LANG E. ORACLE_SID Answer: CE

193) User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to? (Choose two.) A. ROW EXCLUSIVE lock for the row being updated

B. exclusive table-level lock for the table containing the row C. shared row-exclusive lock for the row being updated D. null lock on the table containing the row E. null lock on the row being updated

F. ROW SHARE lock for the row being updated

G. a shareable table lock for the table containing the row Answer: AG

194) While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to achieve the objective?

A. schedule the database backup using Database Configuration Assistant (DBCA) while creating the database B. configure the database to run in ARCHIVELOG mode

C. configure the Flash Recovery Area to enable automatic database backup

D. schedule the database backup using DBMS_JOB package after creating the database E. schedule the database backup using Recovery Manager (RMAN) commands after Answer: A

195) One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member?s status? A. OBSOLETE

B. UNKNOWN C. CORRUPT D. DELETED E. EXPIRED F. LOST G. INVALID Answer: G

196) It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN? A. cannot be used in RMAN

B. by re-creating the target control file to rebuild the RMAN repository C. by using the RECOVER CATALOG command in RMAN D. by starting up the database again

E. by using the CATALOG command of RMAN Answer: A

197) Because of a power outage, instance failure has occurred. From what point in the redo log does recovery begin and where does it end? A. current redo log and inactive redo log B. checkpoint position to end of redo log C. beginning of redo log to end of redo log D. all redo logs before the point of last commit E. beginning of redo log to checkpoint position Answer: B

198) You are working on a 24×7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file accidentally. Which statement in this scenario is true? A. The database crashes.

B. The DBA needs to re-create the file. C. The file gets re-created automatically.

D. The file gets restored automatically from the last backup. E. The DBA needs to perform a complete database recovery. F. The DBA needs to perform an incomplete database recovery. Answer: C

199) Anyone who knows just the host name and the listener name can have full control over the listener. They can stop the listener and also obtain detailed information about the listener,database, and the configuration of the application. How would you avoid this scenario? A. run listener on a remote client B. set a password for the listener C. hide the listener D. lock the listener

E. store listener.ora in a non-default location F. create multiple listeners Answer: B

200) Your database is in the MOUNT state and you execute the following command to open it: ALTER DATABASE OPEN;

What two actions are performed as a result of this command?

(Choose two.)

A. The parameter file is opened. B. All online data files are opened. C. The password file is opened. D. All redo log files are opened E. All control files are opened. Answer: BD

201) In your database, you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace? A. perform point-in-time recovery B. perform a full database recovery C. drop and re-create the tablespace

D. use Recovery Manager (RMAN) to recover the database E. flash back the database Answer: C

202) You are creating a locally managed tablespace to meet the following requirements: All the extents should be of the same size.

The data should be spread across two data files.

A bitmap should be used to record the free space within the allocated extents. Which three options would you choose? (Choose three.) A. set PCTFREE and PCTUSED to 50

B. set segment space management to Automatic C. specify extent allocation as Automatic D. specify extent allocation as Uniform

E. use the RESIZE clause while creating the tablespace F. create the tablespace as smallfile tablespace G. create the tablespace as bigfile tablespace Answer: BDF

203) View the Exhibit to see the data in the emp table.

You created a PRIMARY KEY constraint on the empno column of the emp table, and the constraint is not deferred. Which two statements are true in this scenario? (Choose two.)

A. No index would be created or used in this case.

B. A unique index on the empno column would be created.

C. A CHECK constraint would be enforced on the empno column. D. A NOT NULL constraint would be enforced on the empno column. E. A bitmap unique index would be created on the empno column. Answer: BD

204) You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate? A. PL/SQL script

B. Operating System (OS) script C. Enterprise Manager (EM) script D. Recovery Manager (RMAN) script E. SQL script Answer: D

205) You have three databases, FINDB, PAYDB and ADMINDB, located in Sydney, Tokyo and Singapore

respectively. You want to perform administrative tasks which include starting up and shutting down the databases, creating and managing tablespaces and database users, and taking regular backups, for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective? A. Enterprise Manager with Database Control

B. Enterprise Manager with Generic Database Management C. Operating System Socket for incoming requests D. Enterprise Manager with Grid Control E. Oracle Management Agent

F. Real Application Cluster (RAC) with three instances Answer: E

206) View the Exhibit to see the structure of EMPLOYEES, DEPARTMENTS and EMP_DEP tables.

User A wants to insert rows from EMPLOYEES and DEPARTMENTS table into EMP_DEP table by using following insert command.

INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id) SELECT e.employee_id, e.first_name ||' '|| e.last_name, e.salary, d.department_name, e.manager_id FROM employees e, departments d WHERE e.department_id = d.department_id;

While user A executes the command, it errors out, displaying the following error message:

INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id) *

ERROR at line 1:

ORA-01653: unable to allocate extent table A.EMP_DEP by 8 in tablespace USERS What would have caused the error?

A. The user A does not have space quota.

B. RESOURCE role has not been granted to user A.

C. User A does not have insert privilege on EMP_DEP table. D. The EMP_DEP table is residing on a temporary tablespace.

E. The default tablespace of user A does not have enough free space.

F. The tablespace where EMP_DEP table resides does not have enough free space. Answer: F

207) You decided to increase the value for the SHARED_SERVERS parameter by using the following command: SQL> ALTER SYSTEM SET SHARED_SERVERS=3 SCOPE=?;

Which three values can be specified for the SCOPE clause? (Choose three.) A. INSTANCE B. MEMORY C. SPFILE D. NONE E. BOTH F. ALL G. PFILE Answer: BCE

208) Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member? A. SMON would automatically restore the lost file.

B. You would need to restore the missing log file by copying one of the remaining files from the same group.

C. You would need to use Recovery Manager (RMAN) to restore the lost redo log member. D. You would need to use flashback technology to restore the lost redo log member. E. You would need to restore the whole database from the last backup. F. You would need to restore the file from the last full database backup. Answer: B

209) Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 11g Database Control, which two options would you select to balance the connection load across all the listener processes? (Choose two.) A. Use only the first address.

B. Try one address, selected at random.

C. Try each address, in order, until one succeeds. D. Try each address, randomly, until one succeeds. Answer: BD

210) You find today?s performance of your production database to be the best ever. Therefore, you want to be

notified in the future whenever the performance degrades by 10% of today?s performance. What is the first step that you would take to ensure this?

A. create baseline metrics for today?s performance

B. write the current database metrics to a database table and create a trigger to compare with future database statistics

C. write the current database metrics to a flat file and create an operating script to compare with future database statistics

D. write the current database metrics to a database table and create a procedure to compare with future database statistics

E. write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics Answer: A

211) The following are the details of your database: Instance name : test

Host name :tech1.us.oracle.com IP address : 145.33.230.186

Enterprise Manager Console HTTP Port number : 5500

You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control? (Choose two.) A. http://tech1.us.oracle.com:5500/em

B. http://www.tech1.us.oracle.com:5500/em C. http://test.tech1.us.oracle.com:5500/em D. http://www.145.33.230.186:5500/em E. http://145.33.230.186:5500/em

F. http://test.tech1.us.oracle.com:5500 G. http://test.145.33.230.186:5500/em Answer: AE

212) Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this scenario?

A. If the above operation were successful, instance recovery would be required to bring the tablespace online. B. The operation would fail if tbs_1 were a read-only tablespace. C. The operation would fail if tbs_1 were a read/write tablespace.

D. The operation would fail if tbs_1 were the default tablespace for the database.

E. If the above operation were successful, media recovery would be required to bring the tablespace online. Answer: E

213) In your database, you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this? A. arch_%t_%s_%r.arc B. arch_%d_%s_.dbf C. arch_%t_%d.arc D. arch_%d.arc E. %t_%s.dbf F. arch_%t.arc Answer: A

214) You manually create an additional listener process, L1, for databases PROD, PAYDB and FINDB. While starting up the listener process, you get the following error message: LSNRCTL> start l1

本文来源：https://www.bwwdw.com/article/1lz8.html