摘要：
Oracle 删除数据文件 阅读全文
posted @ 2018-03-22 18:18
巴啦啦大魔王
阅读(981)
评论(0)
推荐(0)
摘要：
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
巴啦啦大魔王
阅读(218)
评论(0)
推荐(0)
摘要：
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
巴啦啦大魔王
阅读(129)
评论(0)
推荐(0)
摘要：
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
巴啦啦大魔王
阅读(126)
评论(0)
推荐(0)
摘要：
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
巴啦啦大魔王
阅读(172)
评论(0)
推荐(0)
摘要：
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
巴啦啦大魔王
阅读(125)
评论(0)
推荐(0)
摘要：
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)
摘要：
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
巴啦啦大魔王
阅读(131)
评论(0)
推荐(0)
摘要：
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it? A. uses undo data for r 阅读全文
posted @ 2018-03-22 15:05
巴啦啦大魔王
阅读(108)
评论(0)
推荐(0)
摘要：
Initially, for the Automatic Workload Repository (AWR) statistics, the retention period is set to 7 days, the collection interval is set to 30 minutes 阅读全文
posted @ 2018-03-22 14:56
巴啦啦大魔王
阅读(136)
评论(0)
推荐(0)
摘要：
You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL> CREATE USE 阅读全文
posted @ 2018-03-22 14:43
巴啦啦大魔王
阅读(180)
评论(0)
推荐(0)
摘要：
Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled 阅读全文
posted @ 2018-03-22 14:41
巴啦啦大魔王
阅读(129)
评论(0)
推荐(0)
摘要：
You are using the following command to clear the log file group:ALTER DATABASE CLEAR LOGFILE GROUP 2;In which case would the command be successful?A. 阅读全文
posted @ 2018-03-22 14:37
巴啦啦大魔王
阅读(134)
评论(0)
推荐(0)
摘要：
You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces, a 阅读全文
posted @ 2018-03-22 14:29
巴啦啦大魔王
阅读(119)
评论(0)
推荐(0)
摘要：
QUESTION 238 In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A database user updates the rows of the ORDE 阅读全文
posted @ 2018-03-22 14:00
巴啦啦大魔王
阅读(152)
评论(0)
推荐(0)
摘要：
Users in your PROD database complain about the slow response of the transactions. While investigating the reason, you find that the transactions are w 阅读全文
posted @ 2018-03-22 13:48
巴啦啦大魔王
阅读(166)
评论(0)
推荐(0)
摘要：
The customer and order tables are often used in joins, thereby resulting in complex queries. You created views to simplify the writing of queries. The 阅读全文
posted @ 2018-03-22 11:31
巴啦啦大魔王
阅读(135)
评论(0)
推荐(0)
摘要：
You manually create an additional listener process, L1, for databases PROD, PAYDB and FINDB. While starting up the listener process, you get the follo 阅读全文
posted @ 2018-03-22 10:58
巴啦啦大魔王
阅读(129)
评论(0)
推荐(0)
摘要：
In your database, you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. Y 阅读全文
posted @ 2018-03-22 10:53
巴啦啦大魔王
阅读(177)
评论(0)
推荐(0)
摘要：
Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this 阅读全文
posted @ 2018-03-22 10:29
巴啦啦大魔王
阅读(147)
评论(0)
推荐(0)
摘要：
The following are the details of your database: Instance name : test Host name : tech1.us.oracle.com IP address : 145.33.230.186 Enterprise Manager Co 阅读全文
posted @ 2018-03-22 10:21
巴啦啦大魔王
阅读(101)
评论(0)
推荐(0)
摘要：
You find today's performance of your production database to be the best ever. Therefore, you want to be notified in the future whenever the performanc 阅读全文
posted @ 2018-03-22 10:13
巴啦啦大魔王
阅读(121)
评论(0)
推荐(0)
摘要：
Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the databas 阅读全文
posted @ 2018-03-22 10:04
巴啦啦大魔王
阅读(115)
评论(0)
推荐(0)
摘要：
Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defrag 阅读全文
posted @ 2018-03-22 09:32
巴啦啦大魔王
阅读(101)
评论(0)
推荐(0)
浙公网安备 33010602011771号