单选题You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files?()A ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ;B ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH;C ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’;D ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’;

单选题
You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files?()
A

 ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ;

B

 ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH;

C

 ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’;

D

 ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’;


参考解析

解析: 暂无解析

相关考题:

Why are you working in a field other than the one in which you have a degree?

Why are you interesting in working with this firm?

According to your resume, you have had some experience working in a foreign company. May I ask you why you left?

If you know that the vessel you are about to call on the VHF radio maintains a radio watch on both the working and the calling frequencies, which frequency should you call on ?______.A.Calling frequencyB.Distress frequencyC.Urgency frequencyD.Working frequency

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 employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record, the SQL statement that will undo the deletion, and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks?()A、 Only the Flashback TableB、 Both the Flashback Transaction Query and the Flashback Version QueryC、 Only the Flashback DropD、 Only the Flashback Version

You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention?()A、 V$FLASHBACK_DATABASE_LOGB、 V$FLASHBACK_DATABASE_STATC、 V$DATABASED、 V$UNDOSTAT

Which view will you use to view information regarding the jobs that are currently running in a database?()A、DBA_SCHEDULER_RUNNING_JOBSB、DBA_SCHEDULER_JOB_RUN_DETAILSC、DBA_SCHEDULER_JOBSD、DBA_SCHEDULER_JOB_LOG

You are working on a 24x7 (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.

In which two cases would you perform only consistent backup?()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.

You executed the following procedure to collect statistics regarding an index:       SQLANALYZE INDEX EMP_ID VALIDATE STRUCTURE;   Which view will you use to determine whether you need to rebuild the index or not?() A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE

You issued the following statement to monitor the usage of the index:        SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE;   Which view will you query to ensure that the index is being monitored?()  A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE

You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job?()A、 DBA_SCHEDULER_JOB_RUN_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_JOBSD、 DBA_SCHEDULER_JOB_LOG

You have an Exchange Server 2010 organization.  The organization contains a global security group named Group1.  You plan to deploy a monitoring solution for the Exchange servers in your organization.  You need to recommend a solution that allows members of Group1 to monitor the performance ofExchange Server 2010 servers.  Your solution must prevent members of Group1 from modifying the configurations of the ExchangesServer 2010 organization.  What should you include in the solution?()A、Delegation of Control WizardB、Federation TrustsC、Reliability MonitorD、Role Based Access Control (RBAC)

You have an Exchange Server 2010 organization.  You plan to delegate administration of the organization.  You have a group named Technicians that contains all the level-two technicians in the organization. You need to ensure that the Technicians group can manage the properties of all the mailbox databases. The solution must minimize the number of permissions assigned to the Technicians group.  Which management role should you assign to the Technicians group?()A、Help DeskB、Organization ManagementC、Recipient ManagementD、Server Management

单选题You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention?()A V$FLASHBACK_DATABASE_LOGB V$FLASHBACK_DATABASE_STATC V$DATABASED V$UNDOSTAT

单选题You are working on a 24x7 (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?()AThe database crashes.BThe DBA needs to re-create the file.CThe file gets re-created automatically.DThe file gets restored automatically from the last backup.EThe DBA needs to perform a complete database recovery.FThe DBA needs to perform an incomplete database recovery.

单选题You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology, you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation, you make the following changes in your initialization parameter file:LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d:/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database?()A The archived redo logs are stored in an operating system-dependent location.B The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.C The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.D The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.

单选题You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record, the SQL statement that will undo the deletion, and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks?()A Only the Flashback TableB Both the Flashback Transaction Query and the Flashback Version QueryC Only the Flashback DropD Only the Flashback Version

单选题You decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()AThe location can be changed only if the flash recovery area is empty.BAfter executing the command, all new flash recovery area files will be created in the new location.CThe command will generate an error because you cannot change the flash recovery area while the database is open.DAll the existing files in the flash recovery area will be moved to the new location, and all new Flash Recovery Area files will be created in the new location.

单选题You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job?()A DBA_SCHEDULER_JOB_RUN_DETAILSB DBA_SCHEDULER_RUNNING_JOBSC DBA_SCHEDULER_JOBSD DBA_SCHEDULER_JOB_LOG

多选题You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()AFlashback logs are not archived.BFlashback logs are maintained in redo log files.CFlashback logs are maintained in the Flash Recovery Area.DFlashback logs are used to maintain Flashback Database related errors.EFlashback logs need to be cleared manually after you disable Flashback Database.

单选题You executed the following procedure to collect statistics regarding an index:       SQLANALYZE INDEX EMP_ID VALIDATE STRUCTURE;   Which view will you use to determine whether you need to rebuild the index or not?()A INDEX_STATSB DBA_INDEXESC DBA_IND_COLUMNSD V$OBJECT_USAGE

单选题You have an Exchange Server 2010 organization.  You have a group named Help Desk that contains all the help desk users in the organization.  You need to ensure that the Help Desk group can manage all the mailboxes and mail-enabled contacts in the organization.  The solution must minimize the number of permissions assigned to the Help Desk group.  Which management role should you assign to the Help Desk group?()AMail RecipientsBMail Recipient CreationCOrganization Client AccessDRecipient Policies

单选题You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files?()A ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ;B ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH;C ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’;D ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’;

单选题You issued the following statement to monitor the usage of the index:        SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE;   Which view will you query to ensure that the index is being monitored?()A INDEX_STATSB DBA_INDEXESC DBA_IND_COLUMNSD V$OBJECT_USAGE

单选题You have many users complaining about slow inserts into a large table. While investigating the reason, you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this?()Aenable index monitoring and query the DBA_OBJECTS viewBenable index monitoring and query the DBA_INDEXES viewCenable index monitoring and query the V$OBJECT_USAGE viewDenable index monitoring and view the DBA_INDEXTYPE_COMMENTS view

单选题You have an Exchange Server 2010 organization.  You plan to delegate Exchange administrative rights to some users in the organization.  You need to recommend a solution that tracks all changes made to the Exchange organization.  What should you include in the solution?()Aadministrator audit loggingBcircular loggingCdiagnostic loggingDWindows Security Auditing