单项选择题
What does the Character Set Scanner command line utility do?()
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 -
单项选择题
WhatdoestheMetadataApplicationProgrammingInterface(API)allowyoutodo?()
A.Repair damaged data dictionary entries.
B.Delete data dictionary information about database objects you no longer need.
C.Extract data definition commands from the data dictionary in a variety of formats.
D.Prepare pseudocode modules for conversion to Java or PL/SQL programs with a Metadata code generator
