Home › Quizzes › Oracle 9i

Oracle 9i

Oracle 9i database concepts including datatypes, transactions, distributed databases, and SQL features

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

In an Oracle distributed database system, which of the following is the one in which each server participating in a distributed database is administered independently from all other databases?

  1. Authentication through database links
  2. Distributed database security
  3. Auditing database links
  4. Administration tools
  5. Site autonomy
Question 2 Multiple Choice (Single Answer)

In Oracle, commit and savepoint commands come under

  1. Data Definition Language
  2. Data Manipulation Language
  3. Transaction Control Language
  4. Object Oriented Language
  5. Procedure Oriented Language
Question 3 Multiple Choice (Single Answer)

Which of the following calls is made in Oracle to perform work at some remote database?

  1. Rollback
  2. Commit
  3. Remote procedure calls
  4. System change number
  5. Savepoint
Question 4 Multiple Choice (Single Answer)

Which of the following phases in commit mechanism is the one in which the coordinator asks all other nodes to commit the transaction?

  1. Prepare phase
  2. Forget phase
  3. Commit phase
  4. Global coordinator
  5. Client
Question 5 Multiple Choice (Single Answer)

Which of the following transactions in distributed databases guarantees that all statements in a transaction either commit or rollback as a unit?

  1. Remote transaction
  2. Distributed transaction
  3. Two-phase commit mechanism
  4. Global database name
  5. None of these
Question 6 Multiple Choice (Single Answer)

Which of the following objects in distributed database receives a request for information from another node?

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

Which of the following datatypes in Oracle stores file pointers to large objects managed by file systems external to the database?

  1. BLOB
  2. BFILE
  3. LOB
  4. CLOB
  5. Raw
Question 8 Multiple Choice (Single Answer)

Which of the following objects in oracle does not return any value after execution of the program?

  1. Function
  2. Procedure
  3. Triggers
  4. Cursor
  5. None of these
Question 9 Multiple Choice (Single Answer)

Which of the following database objects is used to increase the performance of data retrieval by providing faster access path to the table data?

  1. Synonym
  2. Sequence
  3. Trigger
  4. Partitioning
  5. Index
Question 10 Multiple Choice (Single Answer)

In Oracle, which of the following administration tools allows an oracle database server to be located and queried by any SNMP based network management system?

  1. Enterprise Manager
  2. SNMP Support
  3. Third-Party Administration Tool
  4. Remote Query
  5. Distributed Query
Question 11 Multiple Choice (Single Answer)

Which of the following components in oracle 9i facilitates communication between oracle and non-oracle databases?

  1. Generic connectivity
  2. Heterogeneous services
  3. Database server
  4. Transparent gateway agents
  5. Homogeneous distributed database systems
Question 12 Multiple Choice (Single Answer)

Which of the following links in Oracle is a link between a local server process and remote database?

  1. Shared database link
  2. Database link
  3. Connected user link
  4. Fixed user link
  5. Global database name
Question 13 Multiple Choice (Single Answer)

Which of the following constraints in Oracle maintains the 'Not Null' constraint to specify a column in a table?

  1. Integrity constraint
  2. Domain integrity constraint
  3. Check constraint
  4. Entity integrity constraint
  5. Referential integrity constraint
Question 14 Multiple Choice (Single Answer)

Which of the following functions in Oracle translates a string in any datatype to a unicode string?

  1. Cast
  2. ASCII str
  3. Compose
  4. Convert
  5. Decode
Question 15 Multiple Choice (Single Answer)

Which of the following components in select statement in Oracle is used to sort the data in the database?

  1. From
  2. Where
  3. Group by
  4. Order by
  5. Distinct
← Back to Quizzes