Home › Quizzes › Oracle and SQL

Oracle and SQL

Covers Oracle database architecture, PL/SQL programming, SQL cursor operations, transaction management, and database recovery concepts including RMAN

14 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following operations in SQL retrieves the rows from the active set, one row at a time?

  1. Declaring the cursor
  2. Opening a cursor
  3. Fetching data from cursor
  4. Closing the cursor
  5. Active data set
Question 2 Multiple Choice (Single Answer)

Which of the following objects in PL/SQL returns data value at the end?

  1. Procedure
  2. Triggers
  3. Cursor
  4. Function
  5. Alert
Question 3 Multiple Choice (Single Answer)

In distributed database systems, each server participating in a distributed database is administered independently from all other databases means

  1. enterprise manager
  2. third party administration tools
  3. SNMP support
  4. site autonomy
  5. replication transparency
Question 4 Multiple Choice (Single Answer)

Which of the following properties of transaction management requires that if a transaction is interrupted by a failure, its partial results are not at all taken into consideration and the whole operation has to be repeated?

  1. Durability
  2. Atomicity
  3. Serializability
  4. Isolation
  5. Concurrency
Question 5 Multiple Choice (Single Answer)

Which of the following roles in distributed transaction refers to a node that is forced to reference data on other nodes to complete its part of the transaction?

  1. Database server
  2. Commit point site
  3. Local coordinator
  4. Global coordinator
  5. Client
Question 6 Multiple Choice (Single Answer)

Which of the following is an area or automatic storage management disk group that serves as the default storage area for files related to recovery?

  1. Oracle flashback database
  2. Incrementally updated backups
  3. Flash recovery area
  4. Disk topology and automatic performance tuning
  5. Automatic datafile creation
Question 7 Multiple Choice (Single Answer)

Which of the following components of recovery manager is a vendor specific application that allows RMAN to backup to a storage system such as tape?

  1. Media management application
  2. Duplicate database
  3. Standby database
  4. Recovery catalog database
  5. Media management catalog
Question 8 Multiple Choice (Single Answer)

Which of the following components of recovery manager is a copy of the primary database that is updated using archived logs created by the primary database?

  1. Recovery catalog database
  2. Standby database
  3. Duplicate database
  4. Media management application
  5. Recovery catalog schema
Question 9 Multiple Choice (Single Answer)

Which of the following database objects in PL/SQL groups objects and programs together into a single entity?

  1. Select statement
  2. Database triggers
  3. Cursor
  4. Packages
  5. Update statement
Question 10 Multiple Choice (Single Answer)

Which of the following explicit cursor attributes evaluates, true if the cursor is opened?

  1. %NOTFOUND
  2. %FOUND
  3. %ISOPEN
  4. %ROWCOUNT
  5. %ISCLOSED
Question 11 Multiple Choice (Single Answer)

_____________ is the data stored in the cursor of a PL/SQL program.

  1. Database
  2. Relation
  3. Active data set
  4. Entity
  5. Attributes
Question 12 Multiple Choice (Single Answer)

Which of the following objects in Oracle consists of physical files and memory components?

  1. Oracle server
  2. Oracle instance
  3. Oracle database
  4. Redo log buffer
  5. Database buffer cache
Question 13 Multiple Choice (Single Answer)

The database writer, log writer and checkpoint processes are _______________ type of processes in Oracle 9i.

  1. user
  2. background
  3. Server processes
  4. Session memory
  5. SQL work area
Question 14 Multiple Choice (Single Answer)

Which of the following pools in System Global Area consists of memory area that is shared by multiple users?

  1. Stream pool
  2. Large pool
  3. Java pool
  4. Shared pool
  5. Library cache
← Back to Quizzes