巴啦啦大魔王

2018年4月19日

Backup database plus archivelog delete input;

摘要： Backup database plus archivelog 会备份归档日志Backup database plus archivelog delete input;会备份归档日志并且会在备份结束后删除默认目录下的归档日志、datafile copy还有backup set。适用于单个归档dest 阅读全文

posted @ 2018-04-19 12:18 巴啦啦大魔王阅读(492) 评论(0) 推荐(0)

2018年3月23日

oracle查询日期列表

摘要： --月份 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... 阅读全文

posted @ 2018-03-23 10:07 巴啦啦大魔王阅读(466) 评论(0) 推荐(0)

2018年3月22日

oracle建立不同块大小的表空间

摘要： Oracle 删除数据文件阅读全文

posted @ 2018-03-22 18:18 巴啦啦大魔王阅读(978) 评论(0) 推荐(0)

052-251(新增70题2018)

摘要： Which three statements are true regarding the logical structure of the Oracle database? (Choose three.)A. It is possible to have tablespaces of differ 阅读全文

posted @ 2018-03-22 16:49 巴啦啦大魔王阅读(214) 评论(0) 推荐(0)

052-250(新增70题2018)

摘要： 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 阅读全文

posted @ 2018-03-22 16:29 巴啦啦大魔王阅读(126) 评论(0) 推荐(0)

052-249(新增70题2018)

摘要： Which two database operations can be performed at the MOUNT stage of database startup? (Choose two.)A. renaming of control filesB. multiplexing of con 阅读全文

posted @ 2018-03-22 16:13 巴啦啦大魔王阅读(124) 评论(0) 推荐(0)

052-248(新增70题2018)

摘要： 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 阅读全文

posted @ 2018-03-22 15:53 巴啦啦大魔王阅读(170) 评论(0) 推荐(0)

052-247(新增70题2018)

摘要： 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 阅读全文

posted @ 2018-03-22 15:32 巴啦啦大魔王阅读(123) 评论(0) 推荐(0)

052-246(新增70题2018)

摘要： 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 阅读全文

posted @ 2018-03-22 15:19 巴啦啦大魔王阅读(119) 评论(0) 推荐(0)

052-245(新增70题2018)

摘要： 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 阅读全文

posted @ 2018-03-22 15:13 巴啦啦大魔王阅读(129) 评论(0) 推荐(0)

公告