（单选题）
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？（）
AA
BB
CC
DD
正确答案
答案解析
略
相似试题
（单选题）
You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically， and not have to do it manually. What should you do？（）
（单选题）
Your boss at Certkiller .com wants you to clarify Oracle 10g. What statement about the Shared Server configuration is valid？（）
（单选题）
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）
（单选题）
You want to configure and schedule offline database backups to run automatically. Which tool or utilitywould you use to achieve this（）
（单选题）
You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this？ （）
（单选题）
You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter should you specify to control the speed of the rebalancing activity？（）
（单选题）
You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure. Which configuration will you do to accomplish the task（）
（单选题）
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）
（单选题）
You want to use RMAN to create compressed backups. Which statement is true about the compression algorithms that RMAN can use？（）
