Category «1z0-042»

What is the correct sequence of steps that you would follow to recover the control file?

Your database instance is started using the server parameter file (SPFILE). Control files aremultiplexed and stored on different disks. Because of a disk failure, you lost one of these controlfiles. You replaced the damaged disk. What is the correct sequence of steps that you would followto recover the control file?1. Shut down the instance, if …

What would you do to overcome the error?

View the Exhibit to see the source and target databases. You have created a database link, devdb.us.oracle.com, between the databases PRODDB andDEVDB. You want to import schema objects of the HR user using Oracle Data Pump from thedevelopment database, DEVDB, to the production database, PRODDB. You execute the followingcommand on the target database server:$impdp system/manager …

Which three options would you choose to create the tablespace?

You want to create a tablespace with the following specifications:1. The tablespace extends automatically.2. Used and free extents should be managed by bitmaps.3. Default PCTUSED attribute is set to 60.4. All the extents would be of size 1 MB.Which three options would you choose to create the tablespace? (Choose three.) A.tablespace with segment space management …

What happens in this scenario?

Examine the following commands executed in your database:SQL> ALTER SESSION RECYCLEBIN=ON;Session alteredSQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;Table created.Further, you executed the following command to drop the table:SQL> DROP TABLE emp;Table dropped.What happens in this scenario? A.The table is moved to the SYSTEM tablespace. B.The table is renamed and remains in …

Why does HR still see the old data?

The user SCOTT executes the following command successfully to increase the salary values inone of his sessions: SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20;Before SCOTT ends the transaction, user HR who has the privileges on EMP table executes aquery to fetch the salary details but finds the old salary values instead of the increased values.Why …

What could be the reason for this?

In your database, the snapshot interval is set to 10 minutes for the Automatic Workload Repository(AWR). The database instance is running for the past 30 days.View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) task. The ADDM task is performed every 10 minutes, except the last task. What could be the reason for …

What could be the two reasons for this?

You plan to use static database registration for a new listener when you create it. What could bethe two reasons for this? (Choose two.) A.The Oracle Enterprise Manager is to be used to monitor an Oracle9i database. B.More than one database is to be registered with the listener. C.The listener is not configured on the …