Oralcle數(shù)據(jù)庫技術(shù)培訓考題

1、Oralcle 數(shù)據(jù)庫技術(shù)培訓考題1: You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays, to tape. Which two statements are true about differential incremental backups? (Choose two.)A.The backup performed on Sundays contains all the blocks that have

2、 ever been used in the database.B.The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.C.The backup performed on each working day contains all the blocks that have changed since the last level 0 backup.D.The backup performed on Monday contains all t

3、he blocks that have changed since the level 0 backup, and every other working day contains all the blocks that have changed since the level 1 backup.2: Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command:LSNRCTL STOPWhat happe

4、ns 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 affected and continue to function normally.C.The sessions are terminated and the active transactions are rolled back.D.The sessions are not allowed to perfo

5、rm 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 file 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

6、.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. Tablespace4. 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,

7、 3, 4, 5C.5, 2, 1, 3, 4D.2, 1, 5, 4, 35: View the Exhibit.Which statements are true regarding the USERS tablespace? (Choose all that apply.)A.A bitmap is used to record free extents.B.Free extents information is managed within the tablespace.C.Free extents information is managed in the SYSAUX tables

8、pace.D.The data dictionary tables are updated when extents are allocated or deallocated.6: Which two statements are true regarding undo tablespaces? (Choose two.)A.The database can have more than one undo tablespace.B.The UNDO_TABLESPACE parameter is valid in both automatic and manual undo managemen

9、t.C.Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions.D.An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start u

10、p.7: You want to move all objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?A.FULL B.SCHEMASC.TRANSFORMD.REMAP_SCHEMAE.REMAP_TABLESPACE8: The instance abnormally terminates because of a power ou

11、tage. Which statement is true about redo 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 required to accomplish instance recovery.C.All redo log entries after the last checkpoint are applied from re

12、do log files to data files.D.All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files.9: You have issued a SHUTDOWN ABORT command to bring down your database instance.Consider the steps that will be performed later when you open the database:

13、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 parameter file or the initialization parameter file is read.Which option has the correct order in which these

14、 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 databases are to be registered with the listenerB.when DBAs need to connect remotely to start up the databa

15、se 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 shared server mode11: View the Exhibit and examine the undo tablespace attributes.Your database instance is experiencing

16、a large volume of transactions from non-DBA users in the last one hour. The undo tablespace UNDOTBS1 is full with transactions and no transaction was committed 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 command

17、s will fail.B.The undo data generated by the DML is stored in one of the two other undo tablespaces.C.The undo data generated by the DML will overwrite the extents that contain committed undo data.D.The undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM tablespace.12:

18、Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?A.It is the time period after which the undo data becomes obsolete.B.It is the time period after which the committed undo data would be transferred to a temporary tablespace.C.It is the minimum time pe

19、riod up to which the committed undo data would be retained if free undo space is available.D.It is the time period after which the undo data is transferred to the Flash Recovery Area to provide read consistency.13: You used the IMMEDIATE option to shut down your database instance. Consider the steps

20、 that may occur when a database instance is started and database is opened:1. SGA is allocated.2. Control file is read.3. Redo log files are opened.4. Instance recovery is started.5. Background processes are started.6. Data file headers are checked for consistency.7. Server parameter file or the ini

21、tialization parameter file is read.Which option has the correct order in which these steps occur?A.7, 1, 5, 2, 3, 6, 4B.1, 5, 7, 2, 3, 6; step 4 is not requiredC.7, 1, 5, 2, 3, 6; step 4 is not requiredD.1, 2, 3, 5, 6, 4; step 7 is not required14: You are managing an Oracle Database 11g database wit

22、h the following backup strategy:1) On Sunday, an incremental level 0 tape backup is performed.2) Monday through Saturday, a cumulative incremental level 1 tape backup is performed.Which two statements are true regarding the backups performed? (Choose two.)A.The backup performed in step 1 backs up al

23、l blocks that have ever been in use in the database.B.The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.C.The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.D.The backup performed in step 2 backs up all

24、blocks that have changed since the most recent incremental backup at level 1.15: You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.Which statement is true in thi

25、s situation?A.The online redo log files and archived redo log files are required to accomplish the recovery.B.The uncommitted transaction will be committed at the next startup of the database instance.C.The uncommitted transaction is rolled back automatically at the next opening of the database.D.Th

26、e DBA has to perform the recovery on the database to recover the uncommitted transaction.16: Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two.)A.An extent cannot spread across data files.B.A segment cannot spread across data fi

27、les.C.A data file can belong to only one tablespace.D.A data file can have only one segment created in it.E.A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.17: You execute this command to drop the ITEM table, which has the primary key ref

28、erred in the ORDERS table:SQL DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;Which two statements are true about the effect of the command? (Choose two.)A.No flashback is possible to bring back the ITEM table.B.The ORDERS table is dropped along with the ITEM table.C.The dependent referential integr

29、ity constraints in the ORDERS table are disabled.D.The dependent referential integrity constraints in the ORDERS table are removed.E.The table definition of the ITEM table and associated indexes are placed in the recycle bin.18: Which naming method uses the tnsnames.ora file to store the connect des

30、criptor used by the client while connecting to the database instance from a remote machine?A.host naming methodB.local naming methodC.external naming methodD.directory naming method19: You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (R

31、MAN) backups. Which three statements are true about these backups?(Choose three.)A.The backups would be consistent.B.The backups would be inconsistent.C.The backups would be possible only if the database is running in ARCHIVELOG mode. D.The backups would be possible only if the database is running i

32、n NOARCHIVELOG mode. E.The backups need to be restored and the database has to be recovered in case of a media failure.20: Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)A.An SPFILE is a binary file.B.An SPFILE cannot reside on a client.C.An SPFILE canno

33、t contain static parameters.D.An SPFILE can store changes persistently across instance restarts.E.An SPFILE can be read by the database server, but it is not written to by the server.F.An SPFILE must be created manually, before creating a database, even if you use the Database Configuration Assistan

34、t (DBCA) to create the database.21: View the Exhibit and examine the attributes of an undo tablespace.In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the

35、following error:ORA-01555: snapshot too oldWhat could be the reason for this error?A.The query is unable to get a read-consistent image.B.There is not enough space in Flash Recovery Area.C.There is not enough free space in the flashback archive.D.The query is unable to place data blocks in undo tabl

36、espace.22: After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database:SQL ALTER DATABASE OPEN;Which two statements are true? (Choose two.)A.The online redo log files and online data files are opened. B.All the o

37、nline data file headers are checked for consistency.C.Instance recovery is performed before opening the database.D.The path and existence of all the log file members are checked.23: Consider the following scenario for your database:-Backup optimization is enabled in RMAN. The recovery window is set

38、to 7 days in RMAN. The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.The TOOLS tablespace is read-only since November 4, 2007.On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOL

39、S tablespace?A. The RMAN backup fails because the TOOLS tablespace is read-onlyB. The RMAN skips the backup of the tablespace because backup optimization is enabledC. The RMAN makes backup because optimization can be enabled only for backups to diskD. The RMAN makes the backup because no backup of t

40、he tablespace exists within the seven day window24: In your production database, you:-Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals set the control file autobackup to on-Are maintaining image copies of the database filesYou have lost t

41、he server parameter tile (SPFILE) and the control file. Which option must you consider before restoring the SPFILIE: and the control file by using the control file autobackup?A. setting DBID for the databaseB. using the RMAN SWITCH commandC. using the RMAN SWITCH commandD. starting up the database I

42、nstance In the NOMOUNT state25: You enable block change tracking. You issue the following command:BACKUP INCREMENTAL LEVEL 0 DATABASE;The next day, you issue the following command:BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which statement about the use of the change tracking file is true?A. RMAN

43、 reads the block change tracking file only when it performs the incremental level 0 backup.B. RMAN reads the block change tracking file when it performs both incremental backups.C. RMAN reads the block change tracking file only when it performs the incremental level 1 backup.D. RMAN does not read the block change tracking file when it performs either incremental backup.26: The application tables owned by the user TEST in a test database need