Tag: programming languages

Questions Related to programming languages

Which two operations can be flashed back using Flashback Technology?

technology programming languages

  1. DROP TABLESPACE USERS

  2. ALTER TABLE SALES_REP DROP PARTITION P1

  3. DROP TABLE EMPLOYEES

  4. DROP USER SMITH

  5. ALTER TABLE EMPLOYEES DROP COLUMN DESIGN_ID

Show answer
Correct Option: C,D

AI Explanation

To answer this question, you need to understand the concept of Flashback Technology in Oracle Database.

Flashback Technology is a feature in Oracle Database that allows you to view and manipulate past data and database states. It provides a way to recover a database or a table to a previous point in time without the need for performing a complete database restoration.

Based on the given options, the two operations that can be flashed back using Flashback Technology are:

C. DROP TABLE EMPLOYEES - This option is correct because when you drop a table using the DROP TABLE statement, you can use Flashback Technology to recover the dropped table and its data. By using the FLASHBACK TABLE statement, you can restore the dropped table to a previous point in time.

D. DROP USER SMITH - This option is correct because when you drop a user using the DROP USER statement, you can use Flashback Technology to recover the dropped user and its objects. By using the FLASHBACK DATABASE statement, you can restore the dropped user and its objects to a previous point in time.

Therefore, the correct answer is C. DROP TABLE EMPLOYEES and D. DROP USER SMITH. These options can be flashed back using Flashback Technology.

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

  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 programming languages

  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 programming languages

  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 programming languages

  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 programming languages

  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 programming languages

  1. Control file and password file

  2. Password file

  3. Control file

  4. Listener control file

Show answer
Correct Option: B

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

technology programming languages

  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

Which two statements are true about the role in Oracle Database?
technology programming languages

  1. A role can contain both system and object privileges.

  2. A role cannot be assigned external authentication.

  3. A role can be granted to itself.

  4. Roles are owned by the SYS user

  5. Roles can be granted to other roles

Show answer
Correct Option: A,E

Which three information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control?
technology programming languages

  1. The database services to be registered with the listener

  2. The log file and trace file destination for the listener.

  3. The protocol used by the listener

  4. The server name where the listener runs.

  5. The port used by the listener.

Show answer
Correct Option: C,D,E