Home › Quizzes › Oracle 9i

Oracle 9i

Covers Oracle 9i database concepts including data types, functions, partitioning, DDL commands, and database objects

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following character functions in Oracle gives ASCII value of the integer number?

  1. ASCII()
  2. CHR()
  3. INITCAP()
  4. INSTR()
  5. LENGTH()
Question 2 Multiple Choice (Single Answer)

Which of the following conversion functions in Oracle translates a string in any data type to a unicode string that can be in the fully normalized form of the input string?

  1. ASCIISTR()
  2. CAST()
  3. COMPOSE()
  4. CONVERT()
  5. DECODE()
Question 3 Multiple Choice (Single Answer)

Which of the following views in Oracle allows a user to use relational data in object oriented applications?

  1. Relational view
  2. Object view
  3. Synonym
  4. Sequence
  5. Index
Question 4 Multiple Choice (Single Answer)

Which of the following types of partitioning in Oracle is the one in which each partition is specified by a list of values of the partitioning key?

  1. List partitioning
  2. Range partitioning
  3. Composite range-hash partitioning
  4. Composite range-list partitioning
  5. Index
Question 5 Multiple Choice (Single Answer)

In Oracle, which of the following client installations allows Oracle Universal Installer to instal networking services and support files?

  1. Administrator
  2. Runtime
  3. Custom
  4. Oracle internet directory
  5. User
Question 6 Multiple Choice (Single Answer)

Which of the following data types in Oracle stores file pointers to manage file systems external to the database?

  1. BFILE
  2. BLOB
  3. Raw
  4. CLOB
  5. Long raw
Question 7 Multiple Choice (Single Answer)

Which of the following data types in Oracle is used for storing byte oriented data having the maximum size of 255 bytes?

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

Which of the following is also called the smallest logical component of an Oracle database?

  1. Data block
  2. Extent
  3. Segment
  4. Table space
  5. Primary key
Question 9 Multiple Choice (Single Answer)

In Oracle, which of the following is a database object that holds data?

  1. Synonym
  2. View
  3. Table
  4. Role
  5. Index
Question 10 Multiple Choice (Single Answer)

In Oracle, which of the following is a group of privileges that are collected together and granted to users?

  1. Revoke
  2. Grant
  3. Role
  4. Synonym
  5. View
Question 11 Multiple Choice (Single Answer)

Create, Revoke, Grant and Drop commands are parts of _____________ language in Oracle.

  1. DML
  2. DDL
  3. Object-Oriented language
  4. Procedural language
  5. Assembly language
Question 12 Multiple Choice (Single Answer)

Which of the following locks in Oracle locks the table allowing other users to only query but not insert, update or delete rows in a table?

  1. Share update lock
  2. Exclusive lock
  3. Share lock
  4. Deadlock
  5. Keylock
Question 13 Multiple Choice (Single Answer)

Which of the following components of select statement tells the database how a user wants the data to be summarised?

  1. From statement
  2. Where statement
  3. Order by statement
  4. Group by statement
  5. Between statement
Question 14 Multiple Choice (Single Answer)

Which of the following functions is used in Oracle to convert a value to the largest integer, which is smaller than or equal to the value?

  1. Ceil(value)
  2. Floor(value)
  3. Cos(value)
  4. Ln(value)
  5. Sign(value)
Question 15 Multiple Choice (Single Answer)

Which of the following constraints in Oracle allows an entity to represent a table, and each row of the table represents an instance of that entity?

  1. Check constraint
  2. Integrity constraint
  3. Entity integrity constraint
  4. Unique constraint
  5. Referential integrity constraint
← Back to Quizzes