Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology databases

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

  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.
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology databases

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 ?

  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.
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology databases

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?

  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
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology databases

Which statement is true regarding RMAN components?

  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.
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology databases

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 _________________.

  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.
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology databases

Which statement is ture regarding checkpoints and recovery ?

  1. A checkpoint defines the highest system change number (SCN)

  2. All redo entries higher or at the SCN are known to be written to the data files.

  3. Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.

  4. The LOG_CHECKPOINT_INTERVAL initialization paramter specifies the amount of time beteen incremental checkpoints.
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology databases

Consider this syntax MERGE INTO t1 USING t2 ON (join predicate) .... What does the MERGE syntax do ?

  1. It performs a merge join of the row from T2 only if it does'nt exist in the T1 table.

  2. It creates a natural join of table T1 and T2 for all columns that have the same name.

  3. It creates a Cartesian prodcut of table T1 and table T2 for all columns that have the same name.

  4. For each row from T2, it updates the row if it exists witin table T1, otherwise it inserts the row into T1.
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology databases

Examine the statement : DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES; What is the result of the statement?

  1. The contents and data files belonging to the IND2 tablespace are dropped.

  2. The statement will only succeed if the IND2 tablespace was built using Oracle-Managed Files (OMF) data files.

  3. The statement will only succeed if the data files belonging to the IND2 tablespace are Oracle Managed Files (OMF) or of the database was created using OMF.

  4. The contents of the tablespace are dropped along with all its data files except those identical with Oracle-Managed Files (OMF) naming convention.
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology databases

A user is running a long update batch file. Many tables are updated and all the statements are in one transaction. Before the process is finished, the user machine lost power. When the user calls you, what should you do as DBA?

  1. Do nothing, the PMON process handles everything.

  2. Shut down the database and restore all the tables the user was updating.

  3. Log in as DBA, clean up the partial updates in those tables, and do another manual backup.

  4. Use LogMiner to find out which records are changed based on the user’s ID, then roll back all those changes.
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation