×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
The database is configured for automatic archive logging. Along with the other required parameters, this entry
is in the initialization file:
is in the initialization file:
log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database
resolve standby_db1?
resolve standby_db1?
2.
You want to create an RMAN recovery catalog in the RC01 database to help you manage the databases
named DB01 and DB02. You need to create a recovery catalog owner in which of your databases?
named DB01 and DB02. You need to create a recovery catalog owner in which of your databases?
3.
Assume your situation can be described as follows:
4.
With dynamic service registration, which process registers instance information with the listener?
5.
Which statement is true regarding Oracle Shared Server architecture?
6.
You are creating a recovery catalog for use with RMAN. You have issued these commands:
SQL> CREATE TABLESPACE rman_ts DATAFILE
'/DISK1/rman_ts01.dbf'
2> SIZE 20M
3> DEFAULT STORAGE (initial 100K next 100K pctincrease
0);
SQL> CREATE USER rman_db01 IDENTIFIED BY rman_db01
2> DEFAULT TABLESPACE rman_ts
3> QUOTA unlimited ON rman_ts;
Which command should you issue next?
'/DISK1/rman_ts01.dbf'
2> SIZE 20M
3> DEFAULT STORAGE (initial 100K next 100K pctincrease
0);
SQL> CREATE USER rman_db01 IDENTIFIED BY rman_db01
2> DEFAULT TABLESPACE rman_ts
3> QUOTA unlimited ON rman_ts;
7.
Which step is required for recover from an instance failure?
8.
You are configuring for Oracle Shared Server. Which service is required?
9.
You issue this SQL statement:
ALTER DATABASE RENAME FILE
'/ORADATA/u02/user_data01.dbf' TO '/ORADATA/u04/user_data01.dbf';
What does this SQL statement do?
'/ORADATA/u02/user_data01.dbf' TO '/ORADATA/u04/user_data01.dbf';
10.
Which tool can be used to create and configure listeners to receive client connections?