随笔分类 - OCP
OCP考试学习
摘要：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
阅读全文
摘要：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
阅读全文
摘要：Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the databas
阅读全文
摘要：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
阅读全文
摘要：You decided to increase the value for the SHARED_SERVERS parameter by using the following command:SQL> ALTER SYSTEM SET SHARED_SERVERS=3 SCOPE=?;Which
阅读全文
摘要：View the Exhibit to see the structure of EMPLOYEES, DEPARTMENTS and EMP_DEP tables. User A wants to insert rows from EMPLOYEES and DEPARTMENTS table i
阅读全文
摘要：You have three databases, FINDB, PAYDB and ADMINDB, located in Sydney, Tokyo and Singapore respectively. You want to perform administrative tasks whic
阅读全文
摘要：You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler ge
阅读全文
摘要：View the Exhibit to see the data in the emp table. You created a PRIMARY KEY constraint on the empno column of the emp table, and the constraint is no
阅读全文
摘要：You are creating a locally managed tablespace to meet the following requirements: All the extents should be of the same size. The data should be sprea
阅读全文
摘要：In your database, you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would y
阅读全文
摘要：Your database is in the MOUNT state and you execute the following command to open it:ALTER DATABASE OPEN;What two actions are performed as a result of
阅读全文
摘要：Anyone who knows just the host name and the listener name can have full control over the listener. They can stop the listener and also obtain detailed
阅读全文
摘要：You are working on a 24x7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file
阅读全文
摘要：Because of a power outage, instance failure has occurred.From what point in the redo log does recovery begin and where does it end?A. current redo log
阅读全文
摘要：It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager
阅读全文
摘要：One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member's status? A. LOST B. INVALID
阅读全文
摘要：While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals with
阅读全文
摘要：User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of lock
阅读全文
摘要：When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed:TZ set to America/New_yorkOC4J
阅读全文
浙公网安备 33010602011771号