×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You enable Flashback Database with the following command:
ALTER DATABASE FLASHBACK ON;
Which view would you query to determine whether the Flashback Database has been enabled?
ALTER DATABASE FLASHBACK ON;
Which view would you query to determine whether the Flashback Database has been enabled?
2.
Examine the following parameter settings from an initialization (init.oraa)file:
DB_CREATE_FILE_DEST = '/u01/oradata/'
DB_CREATE_ONLINE_LOGDEST 1 = '/u02/oradata/'
DB_CREATE_ONLINE_LOG_DEST2 = '/u03/oradata/'
If you create an Oracle Managed Files (OMF) database using these settings, what is the result?
DB_CREATE_FILE_DEST = '/u01/oradata/'
DB_CREATE_ONLINE_LOGDEST 1 = '/u02/oradata/'
DB_CREATE_ONLINE_LOG_DEST2 = '/u03/oradata/'
If you create an Oracle Managed Files (OMF) database using these settings, what is the result?
3.
The Oracle 10G LogMiner needs a data dictionary copy to display the object names.
From which three locations can LogMiner retrieve the data dictionary information?
4.
Examine this startup script called startmydb.sql:
CONNECT myid/mypwd AS SYSDBA
STARTUP
EXIT
In Oracle 8i, you could have executed this script by invoking server manager with the command:
Svrmgr1 @startmydb.sql
Which alternative command could you use to run the startmydb.sql script with SQL*Plus to start your Oracle
10g database?
CONNECT myid/mypwd AS SYSDBA
STARTUP
EXIT
In Oracle 8i, you could have executed this script by invoking server manager with the command:
Svrmgr1 @startmydb.sql
Which alternative command could you use to run the startmydb.sql script with SQL*Plus to start your Oracle
10g database?
5.
After changing the PCTFREE value of the automatic space management table EMPLOYEES, which task can you perform in order for your change to take effect
immediately?
immediately?
6.
What is true regarding a shared, server-side parameter file for a Real Application Cluster database?
7.
Online table redefinition includes which three features?
8.
Examine this statement, which creates a Cartesian product of the COUNTRIES and REGION tables:
SQL> SELECT C.COUNTRY_name.
2> r.region_name
3> FROM countries c, region r;
Oracle SQL 1999syntax supports the same functionality with which join type?
SQL> SELECT C.COUNTRY_name.
2> r.region_name
3> FROM countries c, region r;
Oracle SQL 1999syntax supports the same functionality with which join type?
9.
Which data dictionary view would you query to find the name of the default permanent tablespace of the database?
10.
The list below display four step that you need to execute in order to switch from the primary database role to the standby database role.
Choose the correct order of execution for the steps;
1.Shut down and start up the former primary instance without mounting the database.
2.Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command.
3.Issue the ALTER DATABASE MOUNT STANDBY DATABASE comman. 4.End read or update activity on the former primary and standby database.
Choose the correct order of execution for the steps;
1.Shut down and start up the former primary instance without mounting the database.
2.Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command.
3.Issue the ALTER DATABASE MOUNT STANDBY DATABASE comman. 4.End read or update activity on the former primary and standby database.