A.AB.BC.CD.DYou experienced a loss of data files in you……

多项选择题You received this error message because Oracle Net Services cannot locate the connect descriptor specified in the tnsnames.ora configuration file：   ORA_12154： TNS：could not resolve service name Which three actions would be appropriate in helping to resolve the error？（）

A.A
B.B
C.C
D.D
E.E
F.F

单项选择题You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist.  Which command should you now use to check if any of the files were missing？（）

A.LIST EXPIRED
B.DELETE EXPIRED
C.DELETE OBSOLETE
D.CHANGE UNCATALOG

单项选择题WhatdoestheCharacterSetScannercommandlineutilitydo？（）

A.Reports only on any Unicode character conversions required.
B.Performs character set conversions to the new specified character set.
C.Scans on any character set conversion required， then converts the data.
D.Checks for any character definitions that will fail conversion to the new character set.

多项选择题Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table.  Which two steps are you recommended to do prior to issuing thedbms_redefinition_start_redef table procedure call？（）

A.Grand privileges on the interim table.
B.Invoke the dbms_redefinition.can_redef_table procedure.
C.Invoke the dbms_redefinition.sync_interim_table procedure.
D.Create any triggers， indexes， or constraints on the interim table.
E.Create an empty interim table with all the desired characteristics.

单项选择题Youareresponsibleforadatawarehouseapplicationthatusesrecordsfromanexternaltabletoupdateoneofthedimensiontablesperiodically.Therecordsintheexternaltablemaycontaindatafornewrowsinthedimensiontable，orforupdatestoitsexistingrows.WhichtypeofSQLcommandwouldyouusetotransferthedatafromtheexternaltabletothedimensiontableasefficientlyaspossible？（）

A.MERGE
B.SELECT …CROSS JOIN
C.INSERT ALL …SELECT
D.CREATE VIEW …CONSTRAINT