0

databases Online Quiz - 139

Description: databases Online Quiz - 139
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

what is true regarding the role Oracle Net provides in a client server connection with no middle tier? (Choose two)

  1. Oracle Net is layered on top of the network protocol.

  2. Oracle Net must reside on both the client and the server for peer-to-peer communication to occur.

  3. On the client side, Oracle Net is responsible for working with the listener to receive incoming connection requests.

  4. On the server side, Oracle Net is responsible for several connectivity issues such as : the location of the server, whatever one or more protocol is involved in the connection, and how to handle exception and interrupts.


Correct Option: A

The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover ? (Choose two)

  1. Restore the data file and perform incomplete recovery.

  2. Restore the data file and perform point-in-time recover.

  3. Drop the tablespace and lose all data in the tablespace.

  4. Restore the database and lose all data since the last backup.


Correct Option: C

Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? (Choose three)

  1. SYNC or ASYNC to identify the network transmission mode.

  2. LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby.

  3. AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.

  4. PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.


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?

  1. Extent

  2. Segement

  3. Oracle block

  4. Operating system block


Correct Option: A

What should you look at to compute the number of undo blocks written per second on disk ?

  1. V$UNDOSTAT

  2. V$TRANSACTION

  3. V$ROLLSTAT

  4. DBA_UNDO_EXTENTS

  5. DBA_ROLLBACK_SEGS


Correct Option: A

When performing recovery of a database in NOARCHIVELOG mode with RMAN, the target database must be in the ______ state to restore the control file.

  1. OPEN

  2. IDLE

  3. MOUNT

  4. NOMOUNT


Correct Option: D

An Oracle instance is executing in a nondistributed configuration. The instance fails because of an operating system failure. Which background process would perform the instance recovery when the atabase is reopened ?

  1. PMON

  2. SMON

  3. RECO

  4. ARCn

  5. CKPT


Correct Option: B

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.


Correct Option: D

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.


Correct Option: D

Which modifier is used to change listener parameters in the Listener Control utility environment?

  1. SET

  2. ALTER

  3. CHANGE

  4. UPDATE


Correct Option: A

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

  1. ARCn

  2. DBWn

  3. CKPT

  4. LGWR

  5. PMON

  6. SMON


Correct Option: D

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?

  1. LIST EXPIRED

  2. DELETE EXPIRED

  3. DELETE OBSOLETE

  4. CHANGE UNCATALOG


Correct Option: A

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.


Correct Option: B

You need to enforce these two business rules: 1. No two rows of a table can have duplicate values in the specified column. 2. A column cannot contain null values. Which type of constraint ensure that both of the above rules are true ?

  1. Check

  2. Unique

  3. Not Null

  4. Primary Key

  5. Foreign Key


Correct Option: D

The ORDERS table has a constant transaction load 24 hours a day, so down time is not allowed. The index become fragmented. Whic statment is true ?

  1. The index need to be dropped, and then re-created.

  2. The resolution of index fragmentation depends on the type of index.

  3. The index can be rebuilt while users continue working on the table.

  4. The fragmented can be ignored because Oracle resolve index fragmentation by means of a freelist.

  5. The index can be rebuilt, but users will not have access to the index during this time.


Correct Option: C

You omit the UNDO tablespace clause in your CREATE DATABASE statment. The UNDO_MANAGEMENT parameter is set to AUTO. What is the result of your CREATE DATABASE statement ?

  1. The oracle server creates no undo tablespace.

  2. The oracle server creates an undo segment in the system tablespace.

  3. The oracle server cerates one undo tablespace with the name SYS_UNDOTBS.

  4. Database creation fails because you did not specify an undo tablespace on the create database statment.


Correct Option: C

AI Explanation

To answer this question, we need to understand the role of the UNDO tablespace in Oracle databases and the impact of different UNDO_MANAGEMENT settings.

In Oracle databases, the UNDO tablespace is used to store undo information, which is necessary for database transactions to maintain data consistency and enable rollback operations. The UNDO_MANAGEMENT parameter specifies how the undo records are managed in the database.

When the UNDO_MANAGEMENT parameter is set to "AUTO", the Oracle server automatically manages the undo records using Automatic Undo Management (AUM). In this case, the database creates and manages one or more undo tablespaces based on the workload and configuration.

Now, let's analyze each option to understand the result of the CREATE DATABASE statement in this scenario:

Option A) The Oracle server creates no undo tablespace. This option is incorrect because when UNDO_MANAGEMENT is set to AUTO, the Oracle server will create and manage one or more undo tablespaces.

Option B) The Oracle server creates an undo segment in the system tablespace. This option is incorrect because when UNDO_MANAGEMENT is set to AUTO, the undo data is not stored in the system tablespace. Instead, it is stored in dedicated undo tablespaces.

Option C) The Oracle server creates one undo tablespace with the name SYS_UNDOTBS. This option is correct. When the UNDO_MANAGEMENT parameter is set to AUTO, and the UNDO tablespace clause is omitted in the CREATE DATABASE statement, the Oracle server will create a default undo tablespace named "SYS_UNDOTBS".

Option D) Database creation fails because you did not specify an undo tablespace on the create database statement. This option is incorrect. When the UNDO_MANAGEMENT parameter is set to AUTO, and the UNDO tablespace clause is omitted, the Oracle server will create a default undo tablespace.

Therefore, the correct answer is C) The Oracle server creates one undo tablespace with the name SYS_UNDOTBS.

John has created a procedure named SALARY_CALC. Which SQL query allow him to view text of procedure?

  1. SELECT text FROM user_source WHERE name = 'SALARY_CALC';

  2. SELECT * FROM user_source WHERE name='SALARY_CALC';

  3. SELECT * FROM user_objects WHERE object_name='SALARY_CALC';

  4. SELECT * FROM user_procedures WHERE object_name='SALARY_CALC';

  5. SELECT text FROM user_source WHERE name='SALARY_CALC' and owner='JOHN'


Correct Option: A
Explanation:

The correct SQL query to view the text of the procedure named SALARY_CALC, created by John, would be:

A. SELECT text FROM user_source WHERE name = 'SALARY_CALC';

This query selects the text column from the user_source table where the name is equal to 'SALARY_CALC'. This will retrieve the text of the procedure.

The other options are incorrect because:

B. SELECT * FROM user_source WHERE name='SALARY_CALC'; This query selects all columns from the user_source table where the name is equal to 'SALARY_CALC'. It will retrieve all details of the procedure, not just the text.

C. SELECT * FROM user_objects WHERE object_name='SALARY_CALC'; This query selects all columns from the user_objects table where the object_name is equal to 'SALARY_CALC'. This will retrieve details about the object, but not the text of the procedure.

D. SELECT * FROM user_procedures WHERE object_name='SALARY_CALC'; This query selects all columns from the user_procedures table where the object_name is equal to 'SALARY_CALC'. This will retrieve details about the procedure, but not the text of the procedure.

E. SELECT text FROM user_source WHERE name='SALARY_CALC' and owner='JOHN'; This query selects the text column from the user_source table where the name is equal to 'SALARY_CALC' and the owner is equal to 'JOHN'. This query assumes that John is the owner of the procedure. If John is indeed the owner, this query will work. However, if John is not the owner, it will not retrieve the text of the procedure.

So, the correct answer is 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

  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.


Correct Option: D

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

  1. Using SQL commands.

  2. Using SQL*Plus Commands.

  3. Using operating system commands.

  4. Using Recover Manager commands.


Correct Option: C
- Hide questions