From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.A、UpdatingB、ViewingC、DeletingD、InsertingE、Truncating

第1题：

How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）  

• A、 Issue the grant command from the SYS user （or equivalent） of the target database.
• B、 Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.
• C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
• D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
• E、 Issue the grant command from RMAN when connected to the target database.

第2题：

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

• A、 when you change the name of a datafile
• B、 when you drop a table from the database
• C、 when you take an export of the database
• D、 when you back up the database using OS utilities
• E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
• F、 when you issue a BACKUP command from inside the RMAN run block

第3题：

Which two are attributes of iSQL*Plus? （）

• A、/SQL*Plus commands cannot be abbreviated.
• B、/SQL*Plus commands are accessed from a browser.
• C、/SQL*Plus commands are used to manipulate data in tables.
• D、/SQL*Plus commands manipulate table definitions in the database.
• E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.

第4题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 cluster. According to the company requirement, the failover response of the cluster has to be tested. The company assigns this task to you. On the cluster, you have to implement a manual failover.  What should you do? （） 

• A、The contents of a shared folder on the active node should be encrypted by using Encrypting File System (EFS) 
• B、You should restore a backup to the active node 
• C、You should get rid of the shared array from the active node 
• D、From the active node, you have to uplug the network cable(s)

第5题：

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

In which scenario will you use the Flashback Transaction Query feature？（）

• A、 when you want to restore an important table that is dropped from the Recycle Bin
• B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
• C、when you want to restore a dropped user’s schema
• D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

第14题：

You work as a database administrator for Certkiller .com. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）

• A、PMON coordinates media recovery.
• B、SMON coordinates instance recovery.
• C、PMON coordinates instance recovery.
• D、Undo Advisor would roll back all uncommitted transactions.
• E、SQL*PLUS reports an error with the message asking you to perform instance recovery. 

第15题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a database named Inventory on a SQL Server 2005 computer， and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company’s trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported， and no duplicate manufacturing part numbers should exist in the data which is imported from the text files， and the text files are stored in the Inventory database on SQL01. You should cut the effect on your company’s trading partners and your IT department to the least.  Which action should you perform？（）

• A、First， you should import the data from each text file into a staging table. Second， you should write a query to have a HAVING clause contained so as to migrate replicate values before results are inserted into the Product table.
• B、First， you should make sure that each text file is stored in an Extensible Markup Language （XML） file. Second， you should utilize Extensible Stylesheet Language Transformations （XSLT） to automatically migrate replicates before data is imported into the Product table.
• C、First， you should make sure that the unique key values for manufacturing part numbers are utilized by each of your company’s trading partners utilizes. Second， you should import the text files into the Product table.
• D、You should place a unique index on the PartNum column.

第16题：

Which two are attributes of /SQL*Plus? （）

• A、/SQL*Plus commands cannot be abbreviated.
• B、/SQL*Plus commands are accesses from a browser.
• C、/SQL*Plus commands are used to manipulate data in tables.
• D、/SQL*Plus commands manipulate table definitions in the database.
• E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.

第17题：

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：