You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：   SQL> ALTER SYSTEM SWITCH LOGFILE；   Which two tasks are performed when the statement is executed？ （）

相似题目

• You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（） 

  A .  The audit trail is stored in an operating system file. B .  Auditing is disabled for all privileges. C .  The audit trail is stored in the database. D .  Auditing is enabled for all privileges. E .  Auditing is enabled for certain privileges related to database security.

  查看最佳答案

• You are working on the Certkiller database.  What is the default name of the alert log file in this database？（）

  A . alert_ Certkiller .log B . alertlog_ Certkiller .log C . alert_log_ Certkiller .log D . Certkiller _alert_log.log E . log_alert_： Certkiller .log F . trace_alert_ Certkiller .log

  查看最佳答案

• You are analyzing the performance of a SQL Azure database.   You need to recommend an approach for identifying the indexes that should be added to improve database performance.  What should you recommend？（）

  A .  Use SQL Server Profiler to identify missing indexes. B .  Use the Database Engine Tuning Advisor to identify missing indexes. C .  Use a Dynamic Management View to analyze query plans. D .  Use a DynamicManagement View to ascertain the number of pending I/O requests.

  查看最佳答案

• You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created?（）

  A . It is a list of remote database links stored in the XML file that are available to the users of the database. B . It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts. C . It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts. D . It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.

  查看最佳答案

• You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

  A .  Flashback logs are not archived. B .  Flashback logs are maintained in redo log files. C .  Flashback logs are maintained in the Flash Recovery Area. D .  Flashback logs are used to maintain Flashback Database related errors. E .  Flashback logs need to be cleared manually after you disable Flashback Database.

  查看最佳答案

• You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）

  A . a table name which has 100s of records B . a table name which has 10s of records C . a table name which has empty records D . a table name which has 1000s of records E . never use a table name

  查看最佳答案

• You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？ （）

  A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）

  A .  This operation resets the SCN for the database. B .  This operation creates a new incarnation of the database. C .  This operation moves all the redo log files to a different location. D .  This operation deletes the old redo log files and creates new redo log files. E .  This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

  A .   STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN； B .   STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS； C .   STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS； D .   STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

  查看最佳答案

• You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）

  A .  One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST. B .  One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST. C .  One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST. D .  One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.

  查看最佳答案

• You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）

  A .  SYSDATE should not be used with TIMESTAMP. B .  The database must have multiplexed redo log files. C .  The database must be in the MOUNT state to execute the command. D .  The database must be opened with the RESETLOGS option after the flashback operation. E .  The entire database needs to be restored from the most recent backup before the flashback operation.

  查看最佳答案

• You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）

  A .  user managed complete recovery B .  user managed incomplete recovery C .  RMAN-based complete recovery D .  RMAN-based incomplete recovery

  查看最佳答案

• You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）

  A . The source database backup must be copied over the net for test database. B . The source database must be run in ARCHIVELOG mode if the database is open. C . The source database must be shut down cleanly if the database is in mounted state. D . A net service name should be set up and a listener configured with the target as well as the source database.

  查看最佳答案

• You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

  A .  online redo log files B .  alert log files C .  control file D .  datafiles associated with the SYSTEM tablespace

  查看最佳答案

• You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

  A . One tablespace has only one datafile B . Many tablespaces can share one datafile C . One tablespace can have many datafiles D . One datafile can contain many tablespace

  查看最佳答案

• You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task（）

  A . Multiplex all database files B . Configure the Flash Recovery Area. C . Configure the database instance for ARCHIVELOG mode. D . Configure the FAST_START_MTTR_TARGET initialization parameter.

  查看最佳答案

• You are managing an Oracle Database 11g database. The database is open， and you plan to  performRecovery Manager （RMAN） backups.  Which three statements are true about these backups（）

  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 in NOARCHIVELOG mode. E . The backups need to be restored and the database has to be recovered in case of a media failure.

  查看最佳答案

• You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups.  Which three statements are true about these backups（）

  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 in NOARCHIVELOG mode. E . The backups need to be restored and the database has to be recovered in case of a media failure

  查看最佳答案

• You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）

  A . You must shut down the database instance to perform the backups. B . You must configure the Flash Recovery Area （FRA） for the database. C . You can perform complete database backups without closing the database. D . All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

  查看最佳答案

• You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）

  A . SYSDATE should not be used with TIMESTAMP. B . The database must have multiplexed redo log files. C . The database must be in the MOUNT state to execute the command. D . The database must be opened with the RESETLOGS option after the flashback operation. E . The entire database needs to be restored from the most recent backup before the flashback operation.

  查看最佳答案

• You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）

  A . Multiplex all database files. B . Configure the Flash Recovery Area. C . Configure the database instance for ARCHIVELOG mode. D . Configure the FAST_START_MTTR_TARGET initialization parameter

  查看最佳答案

• You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）

  A .  To recover a dropped table. B .  To recover a dropped schema. C .  To recover data from a truncated table. D .  To view changes made by all the transactions during a given period of time. E .  To view changes made by a single transaction during a given period of time.

  查看最佳答案

• You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

  A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? （）

  A . An object type is a user-defined composite data type.  B . The attributes of an object type can be those of other object types.  C . A PL/SQL table of records is an example of a nested object type.  D . An object type must be declared as a type before the actual object itself can be declared.

  查看最佳答案

• You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario（）

  A . You must shut down the database instance to perform the backups. B . You must configure the Flash Recovery Area （FRA） for the database. C . You can perform complete database backups without closing the database. D . All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

  查看最佳答案