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
A: A
B: B
C: C
D: D
举一反三
- In which scenario will you use the Flashback Transaction Query feature？（） A: when you want to restore an important table that is dropped from the Recycle Bin B: when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction C: when you want to restore a dropped user’s schema D: when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
- In which scenario will you use the Flashback Transaction Query feature？（） A: A when you want to restore an important table that is dropped from the Recycle Bin B: B when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction C: Cwhen you want to restore a dropped user’s schema D: D when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
- Which of the following statement is not the reason why Service department costs are charged to operating departments？ A: to encourage operating departments to wisely use service department resources. B: to provide operating departments with more complete cost data for making decisions. C: to help measure the profitability of service departments. D: to create an incentive for service departments to operate efficiently.
- When you report the details of the table, you have to describe everything listed in the table. A: 正确 B: 错误
- Which of the followings are good table manners? A: Wait until the host/hostess and the guest of honor to unfold their napkins before quietly unfolding yours and laying it on your lap. B: Use the napkin to wipe your lips. C: Put the napkin on your chair if you want to leave the table for a while. D: Put you elbow on the table.