Tag: databases

Questions Related to databases

Triggers can be defined on a system catalog table (True or False)

technology databases

  1. True

  2. False

Show answer
Correct Option: B
Explanation:

A system catalog is a group of tables and views that incorporate important information about a database. It includes tables that contain information about schemas, tables, columns, users, and so forth. A database management system (DBMS) typically manages these system catalog tables, and they are used to maintain consistent and reliable database operations.

While it's technically possible to create triggers on regular tables in a database, system catalog tables are typically not allowed to have triggers. The system catalog tables are managed by the DBMS itself, and any modifications to these tables are tightly controlled to avoid inconsistency or corruption of the system catalog. Therefore, DBMSs usually restrict users from creating triggers on system catalog tables.

Let's go through each option to understand why it is correct or incorrect:

Option A) True - This option is incorrect because system catalog tables are managed by the DBMS, and it typically prevents users from creating triggers on these tables.

Option B) False - This option is correct because, as mentioned above, creating triggers on system catalog tables is usually not allowed.

The correct answer is B) False. This option is correct because creating triggers on system catalog tables is typically not permitted by the DBMS to prevent potential data inconsistencies or system corruption.

MERGECOPY utility combines multiple incremental image copies into a full Image copy. ( True or False)
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Your database is in NOARCHIEVELOG mode. After which two operations you should take backup of control file? ( choose two)
technology databases

  1. Adding a new user to database.

  2. Adding a new tablespace to database.

  3. Dropping a table from the database.

  4. Dropping a user from the database.

  5. Dropping a datafile from a tablespace.

Show answer
Correct Option: B,E

Which is the memory area that is created when a dedicated server process is started, and contains data and information for that server process?

technology databases

  1. SGA

  2. Streams Pool

  3. PGA

  4. Shared Pool

Show answer
Correct Option: C

What four data protection components have been enhanced in Oracle database 10g release 2
technology databases

  1. Flashback

  2. Data guard

  3. ASM

  4. Tivoli data protection

  5. Flash recovery.

Show answer
Correct Option: A,B,C,E

Which is the correct description of the significance of the ORACLE_HOME environment variable?
technology databases

  1. It specifies the directory containing the oracle managed files.

  2. It specifies the directory for database files, if not specified explicitly.

  3. It specifies the directory containing the oracle software

  4. It specifies the directory of Optimal Flexible Architecture.

Show answer
Correct Option: C

Which two statements about recovery manager (RMAN) backup are true?
technology databases

  1. Online redo log files can be backed up.

  2. RMAN backup can be taken only if the database is configured in ARCHIEVELOG mode.

  3. Only used data blocks can be backed up as backup sets.

  4. Archived redo log files are backed up.

  5. Only consistent database backed up can be performed.

Show answer
Correct Option: C,D

You want the user APP_DBA to administer the oracle database from remote machine. APP_DBA is granted SYSDBA privilege to perform administrative task on the database. Which file is used by oracle database server to authenticate APP_DBA?
technology databases

  1. Control file and password file

  2. Password file

  3. Control file

  4. Listener control file

Show answer
Correct Option: B
Explanation:

To answer this question, the user needs to know about the authentication mechanism in Oracle databases and the files used to implement it.

In Oracle databases, SYSDBA privilege is required to perform administrative tasks on the database. The user APP_DBA has been granted this privilege to administer the database from a remote machine. To authenticate the user, Oracle uses a password file.

Therefore, the correct answer is:

The Answer is: B. Password file

The junior DBA of your organization has accidentally deleted the alert log file. What will you do to create new alert log file?
technology databases

  1. Create the new text file as ALERT.log

  2. You have to recover the alert log file from the valid backup.

  3. No action required. The file will be created automatically by the instance.

  4. Change the value for the BACKGROUND_DUMP_DEST parameter.

Show answer
Correct Option: C

By default, how much tablespace can any account use for a new table?
technology databases

  1. None

  2. Up to the current free space in the tablespace

  3. Unlimited space, including autoextends

  4. Up to the default quota established at tablespace creation time

Show answer
Correct Option: A