摘要:
Backup database plus archivelog 会备份归档日志Backup database plus archivelog delete input;会备份归档日志并且会在备份结束后删除默认目录下的归档日志、datafile copy还有backup set。适用于单个归档dest 阅读全文
摘要:
--月份 SELECT TO_CHAR(ADD_MONTHS(SYSDATE, - (ROWNUM - 1)), 'yyyy-mm') yyyymmdd FROM DUAL CONNECT BY ROWNUM < MONTHS_BETWEEN(SYSDATE, TO_DATE ('201711', 'yyyymm'))+1 --天 select to_char(sysdate-(ROWNUM-1... 阅读全文
摘要:
Oracle 删除数据文件 阅读全文
摘要:
Which three statements are true regarding the logical structure of the Oracle database? (Choose three.)A. It is possible to have tablespaces of differ 阅读全文
摘要:
Which three statements are true about the stages of database startup? (Choose three.) A. Data files and redo log files can be renamed at the MOUNT sta 阅读全文
摘要:
Which two database operations can be performed at the MOUNT stage of database startup? (Choose two.)A. renaming of control filesB. multiplexing of con 阅读全文
摘要:
You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb Which three statements are correct reg 阅读全文
摘要:
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on 阅读全文
摘要:
You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this 阅读全文
摘要:
You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synch 阅读全文