you need to start the database in the MOUNT state?

You executed the STARTUP MOUNT command to start your database. For which databaseoperation do you need to start the database in the MOUNT state? A.dropping a user in your database B.dropping a tablespace in your database C.enabling or disabling redo log archiving D.renaming the control files E.re-creating the control files, after you lost all the […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More