多項選擇題

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.

你可能感興趣的試題

單項選擇題

You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）

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

單項選擇題

What does the Metadata Application Programming Interface （API） allow you to do？（）

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

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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？（）

你可能感興趣的試題

What does the Metadata Application Programming Interface （API） allow you to do？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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？（）

What does the Metadata Application Programming Interface （API） allow you to do？（）