单项选择题

You want to create a copy of the DEPARTMENTS table. When that is complete， you want to truncate the new DEPARTMENTS table， then restore the data with a direct-load insert from the old DEPARTMENTS table.
Which CREATE statement should you use？（）

A.A
B.B
C.C
D.D

点击查看答案

上一题目录下一题

相关考题

单项选择题

Which are required initialization parameters in an Oracle Shared Server environment？（）

A.DISPATCHERS and SHARED_SERVERS
B.DISPATCHERS and MAX_DISPATCHERS
C.MAX_DISPATCHERS and MAX_SHARED_SERVERS
D.SHARED_SERVER_SESSIONS and DISPATCHERS

多项选择题

Which three types of information does the control file contain？（）

A.Current log sequence.
B.Recover tuning parameters.
C.Redo log names and locations.
D.Data file names and locations.
E.Undo segment names and locations.

单项选择题

You are operating your database in NOARCHIVELOG mode. Your most recent backup includes a copy of all of the data files and the control files taken when the current log sequence number was 45. You experience disk failure on the drive on which your SYSTEM tablespace data files are stored. At the time of the failure， the current log sequence number is 98. Which files should you restore to recover from the loss of the SYSTEM tablespace data files？（）

A.Only the data files.
B.All of the data files and the control files.
C.Only the data files belonging to the SYSTEM tablespace.
D.Only the data files belonging to the SYSTEM tablespace and the control files.

You want to create a copy of the DEPARTMENTS table. When that is complete， you want to truncate the new DEPARTMENTS table， then restore the data with a direct-load insert from the old DEPARTMENTS table. Which CREATE statement should you use？（）

相关考题

You want to create a copy of the DEPARTMENTS table. When that is complete， you want to truncate the new DEPARTMENTS table， then restore the data with a direct-load insert from the old DEPARTMENTS table.
Which CREATE statement should you use？（）