Oralcle数据库技术培训考题Word格式文档下载.docx

1、2: Your database is open and the LISTENER listener is running. The new DBA of the system stopsthe listener by using the command:LSNRCTL STOPWhat happens to the sessions that are presently connected to the database instance?A.The sessions are able to perform only queries.B.The sessions are not affect

2、ed and continue to function normally.C.The sessions are terminated and the active transactions are rolled back.D.The sessions are not allowed to perform any operations till the listener is started.3: In which of the scenarios will the DBA perform recovery? （Choose all that apply.）A.The alert log fil

3、e is corrupted.B.A tablespace is accidentally dropped.C.One of the redo log members is corrupted.D.A database user terminates the session abnormally.E.The hard disk on which the data file is stored is corrupted.4: Note the following structures in your database server:1. Extents2. OS Blocks3. Tablesp

4、ace4. Segments5. Oracle Data BlockWhich option has the correct arrangement of these structures from the smallest to the largest?A.2, 5, 1, 4, 3B.1, 2, 3, 4, 5C.5, 2, 1, 3, 4D.2, 1, 5, 4, 35: View the Exhibit.Which statements are true regarding the USERS tablespace?A.A bitmap is used to record free e

5、xtents.B.Free extents information is managed within the tablespace.C.Free extents information is managed in the SYSAUX tablespace.D.The data dictionary tables are updated when extents are allocated or deallocated.6:Which two statements are true regarding undo tablespaces?A.The database can have more

6、 than one undo tablespace.B.The UNDO_TABLESPACE parameter is valid in both automatic and manual undomanagement.C.Undo segments automatically grow and shrink as needed, acting as circular storage buffer fortheir assigned transactions.D.An undo tablespace is automatically created if the UNDO_TABLESPAC

7、E parameter is not setand the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.7: You want to move all objects of the APPS user in the test database to the DB_USER schema ofthe production database. Which option of IMPDP would you use to accomplish this task?A.FULL B.SCH

8、EMASC.TRANSFORMD.REMAP_SCHEMAE.REMAP_TABLESPACE8: The instance abnormally terminates because of a power outage. Which statement is true aboutredo log files during instance recovery?A.Inactive and current redo log files are required to accomplish recovery.B.Online and archived redo log files are requ

9、ired to accomplish instance recovery.C.All redo log entries after the last checkpoint are applied from redo log files to data files.D.All redo log entries recorded in the current redo log file until the checkpoint position are appliedto data files.9: You have issued a SHUTDOWN ABORT command to bring

10、 down your database instance.Consider the steps that will be performed later when you open the database:1. SGA is allocated.2. Control file is read.3. Redo log files are read.4. Instance recovery is started.5. Background processes are started.6. Data files are checked for consistency.7. Server param

11、eter file or the initialization parameter file is read.Which option has the correct order in which these steps occur?A.7, 1, 5, 2, 3, 6, 4B.1, 2, 3,7, 5, 6, 4C.7, 1, 4, 5, 2, 3, 6D.1, 7, 5, 4, 2, 3, 610: In which situation would you use static database registration for a listener?A.when multiple dat

12、abases are to be registered with the listenerB.when DBAs need to connect remotely to start up the database instanceC.when users need to connect the database instance using the host naming methodD.when the database instance that is to be registered with the listener is configured in sharedserver mode

13、11: View the Exhibit and examine the undo tablespace attributes.Your database instance is experiencing a large volume of transactions from non-DBA users in thelast one hour. The undo tablespace UNDOTBS1 is full with transactions and no transaction wascommitted more than one hour ago. The database has two more undo tablespaces.What happens to the new DML operations in this scenario?A.The DML commands will fail.B.The undo data generated by the DML