单选题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 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_LOG
B
V$FLASHBACK_DATABASE_STAT
C
V$DATABASE
D
V$UNDOSTAT
参考解析
解析：
暂无解析
相关考题：
According to your resume, you have had some experience working in a foreign company. May I ask you why you left?
You connect your computer to a wireless network. You discover that this new connection fails to show in the Connect to a network window.You need to view this connection in the Connect to a network window.What should you do?（）A.AB.BC.CD.D
You install a new hardware router that provides wireless network connectivity between your computer and the Internet. You connect to the router by using a wireless network adapter.Your computer is able to access the Internet but is unable to discover other computers in the local wireless network.You need to configure the wireless connection to allow your computer to discover other computers.What should you do?（）A.AB.BC.CD.D
As a Pass Guide instructor you are giving a lecture on the historical context of Cisco. You point out that a computer scientist started the Cisco Corporation. One of the attendants asks you when and where Cisco was founded. What should you respond? （）A. 1978B. 1984C. 1991D. 1996E.Massachusetts Institute of TechnologyF.California Polytechnic InstituteG.HarvardH.Stanford
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
As a Pass Guide instructor you are giving a lecture on the historical context of Cisco. You point out that a computer scientist started the Cisco Corporation. One of the attendants asks you when and where Cisco was founded. What should you respond? （）A、1978B、1984C、1991D、1996E、Massachusetts Institute of TechnologyF、California Polytechnic InstituteG、HarvardH、Stanford
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 maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）A、 SQL Tuning AdvisorB、 Undo AdvisorC、 ADDMD、 Memory Advisor
You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（） A、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.B、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.C、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.D、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.
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 are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMANBACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.
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 maintaining a Microsoft ASP.NET Web Application that was created by using the Microsoft .NET Framework version 3.5. You obtain the latest version of the project from the source control repository. You discover that an assembly reference is missing when you attempt to compile the project on your computer. You need to compile the project on your computer. What should you do？（）A、Add a reference path in the Property Pages of the project to the location of the missing assembly. B、Add a working directory in the Property Pages of the project to the location of the missing assembly. C、Change the output path in the Property Pages of the project to the location of the missing assembly. D、Delete the assembly reference. Add a reference to the missing assembly by browsing for it on your computer.
单选题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
单选题While maneuvering, you discover heavy smoke coming from the turbocharger casing, you should （）Acheck the air filter for dirtBcheck for an exhaust leakCcheck the cooling water temperatureDnotify the bridge that you are going to shut the engine down
单选题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 maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）A SQL Tuning AdvisorB Undo AdvisorC ADDMD Memory Advisor
单选题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 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 are working as a DBA at NetFx Corporation. A user， Scott， is maintaining the records of all the employees in the EMPLOYEEtable. Initially， the salary of the employee， ’E0025’， was $1800. On 1 May 2004， the salary of the employee， ’E0025’， was increased by $200. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’： SQLUPDATE EMPLOYEE SET SALARY = 2000 WHERE EMPNO = ’E0025’； SQLCOMMIT； On December 1， 2004， the salary of the employee， ’E0025’， was increased by $400. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’： SQLUPDATE EMPLOYEE SET SALARY = 2400 WHERE EMPNO = ’E0025’； SQLCOMMIT； On July 1， 2005， the salary of the employee， ’E0025’， was increased by $500. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’ SQLUPDATE EMPLOYEE SET SALARY = 2900 WHERE EMPNO = ’E0025’； SQLCOMMIT； On July 5， 2005， the HR manager asked you to generate the increment report of the employee， ’E0025’， for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report？（）A Flashback DropB Flashback TableC Flashback DatabaseDFlashback Version Query
单选题You have a portable computer that runs Windows XP Professional. When the computer is disconnected from the network, you receive a message in the notification area that says you are working offline. The message reappears every hour. You need to prevent the message from appearing while you are working offline. What should you modify?（）ADisk Quota settingsBMy Documents propertiesCOffline Files propertiesDSynchronization settings
单选题A user reports that their computer suddenly will not boot. When the technician arrives, they discover that the user is very worried they will not be able to complete a research paper theyve been working on which is due by the end of the day. Which of the following is an appropriate response to the users concerns? （）AA Trojan may have infected the OS or worked its way into the MBR. What did you download recently that caused the problem?BI understand your concern, and will try to have your computer working again as quickly as possible so that you can finish your report.CIf the paper was so important to you, you should have created a backup copy so you could finish it on another computer.DI do not understand why you are upset. I am sure your professor will understand and you will be able to turn in the paper tomorrow.
多选题As a Pass Guide instructor you are giving a lecture on the historical context of Cisco. You point out that a computer scientist started the Cisco Corporation. One of the attendants asks you when and where Cisco was founded. What should you respond? （）A1978B1984C1991D1996EMassachusetts Institute of TechnologyFCalifornia Polytechnic InstituteGHarvardHStanford
单选题You have failed two tests. You'd better start working harder,_____ you won't pass the course.AandBbutCorDso