Tag: databases

Questions Related to databases

Which background process reads the redo log buffer and writes it to a file ?

technology databases

  1. ARCn

  2. DBWn

  3. CKPT

  4. LGWR

  5. PMON

  6. SMON

Show answer
Correct Option: D

In user-managed backup and recover procedure, how are data files backed up ?
technology databases

  1. Using SQL commands.

  2. Using SQL*Plus Commands.

  3. Using operating system commands.

  4. Using Recover Manager commands.

Show answer
Correct Option: C

You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist. Which command should you now use to check if any of the files were missing?
technology databases

  1. LIST EXPIRED

  2. DELETE EXPIRED

  3. DELETE OBSOLETE

  4. CHANGE UNCATALOG

Show answer
Correct Option: A

CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_01.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1 MB?
technology databases

  1. Extent

  2. Segement

  3. Oracle block

  4. Operating system block

Show answer
Correct Option: A

The employees table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table's primary key is stored in INDX tablespace. Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which object will be exported by this command ? exp system/manager tablespace=SAMPLE
technology databases

  1. Only the EMPLOYEES table.

  2. Only the EMPLOYEES table and its corresponding primary key index.

  3. The EMPLOYEES table and partition P1.

  4. The EMPLOYEES table, IPK_EMP index, and the SALES table.

Show answer
Correct Option: D

You want to drop the TBSI tablespace from your database. You also want to delete corresponding data files automatically, and not have to do it manually. What should you do ?
technology databases

  1. User the DROP DATAFILE command.

  2. Use the DROP TABLESPACE command.

  3. Ensure that all database files are Oracle Managed Files(OMF) before using the DROP TABLESPACE command.

  4. Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.

Show answer
Correct Option: B

You have performed the first step in placing your database into ARCHIVELOG mode. The second step is deciding whether the online redo log files are to be archived automatically or manually. which action should you take to enable archiving an instance startup?
technology databases

  1. Set the LOG_ARCHIVE_START parameter to TRUE in the initialization parameter file.

  2. Automatic archive is the default when ARCHIVELOG mode is set. No further actions are required.

  3. Set the LOG_ARCHIVE_MAX_PROCESSES parameter to n (where n is the number of Archiver process) in the initialization parameter file.

  4. Immediately after setting the database in ARCHIVELOG mode, in SQL*Plus select automatic archiving using the syntax : ALTER DATABASE SET LOG_ARCHIVE_START=TRUE

Show answer
Correct Option: A

You issue this statement ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What does the statment generate ?

technology databases

  1. A text copy of the control file.

  2. A binary copy of the control file.

  3. A file containing a SQL statement which will re-create the database.

  4. A file containing a SQL statement which will re-create the control file.

Show answer
Correct Option: D

Which statement is true regarding RMAN components?
technology databases

  1. Each target database requires its own recover catalog.

  2. RMAN scripts can be stored in the recovery catalog or the targer control file.

  3. A channel is a stream of data to a device type and corresponds to one server session.

  4. The RMAN executable interprets server session commands and establishes connections to the target database.

Show answer
Correct Option: C

To increase the availability of an Advanced Replication environment, you can add a new master to a replication group without quiescing the group. This is achived _________________.
technology databases

  1. Only when the new master site already has existing replication groups.

  2. By issuing a single command to create , populate, and activate the new master.

  3. When the master definition site is not the same for all of the master grouups.

  4. Without impacting end users who are executing data manipulation language (DML) commands on the replicated tables.

Show answer
Correct Option: D