默认题库 - 1z0-043

单选题

You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）

A. The target database must be in the MOUNT mode to ensure restoration of the datafiles.
B. You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.
C. The control file must be recreated.
D. The database must be opened with the RESETLOGS option.

查看答案

单选题

In which scenario will you issue the following command？（） SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING BACKUP CONTROLFILE；

A. when all the control files are missing and only a binary backup of the current control file exists
B. when a multiplexed copy of the current control file is missing
C. when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists
D. when the SPFILE is missing

查看答案

单选题

You have created a password file using the following command： ORAPWD file=d：\oracle\ora9i\orapwU01 password=change_on_install entries=3 Which of the following is true about this password file？（）

A. If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.
B. If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.
C. If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file is
D. If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.

查看答案

单选题

Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace. On Monday， you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace. On Tuesday， you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15. When you try to open the database on Wednesday morning， you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table？（）

A. The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.
B. The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.
C. The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.
D. The SALES table can be recovered by restoring the SALESTB tablespace from the backup， but the rows inserted on Tuesday need to be inserted again.

查看答案

单选题

In which case would you use the Flashback Database feature to perform a recovery？（）

A. to recover a dropped tablespace
B. to recover data from a truncated table
C. to recover a data file that has been shrunk
D. to recover a database to the state that existed before the RESETLOGS operatio

查看答案

单选题

You have created an Oracle 10g database named SALES， which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option？（）

A. The index can be changed from NOLOGGING to LOGGING
B. The index cannot be recovered even in the ARCHIVELOG mode.
C. The index can only be created if the base table is created with the NOLOGGING option.
D. The index can be recovered if you perform a backup after the CREATE INDEX statement.

查看答案

单选题

Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）

A. DROP TABLESPACE temp1；
B. DROP TABLESPACE temp1 INCLUDING CONTENTS；
C. DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；
DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；

查看答案

单选题

Your database is in NOARCHIVELOG mode. The database has three online redo log groups， and each group contains three online redo log members. The online redo log members are stored across three hard disks， E， F， and G， respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database？（）

A. The database will operate normally without generating any redo.
B. The database will hang， and you must shut down and restart the instance.
C. The database will crash， and you must recover the database from the point of failure.
D. The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.

查看答案

单选题

You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature. What information will be written in the change tracking file？（）

A. the system change number
B. the locations of the redo log files
C. the locations of the datafiles
D. the physical location of all the database change

查看答案

多选题

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN> BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）

A. control file
B. all datafiles
C. password file
D. online redo log file
E. archive redo log file
F. server parameter file
G. only the SYSTEM datafile

查看答案