0

Oracle 9i

Description: Oracle 9i
Number of Questions: 15
Created by:
Tags: Oracle Java/Oracle /C/C++
Attempted 0/15 Correct 0 Score 0

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()


Correct Option: B
Explanation:

This character function in Oracle gives ASCII value of the integer number.

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()


Correct Option: C
Explanation:

This is a conversion function in Oracle, which translates a string in any data type to a unicode string that can be in the fully normalized form of the input string.

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


Correct Option: B
Explanation:

This view is an extension of relational view that allows a user to use relational data in object oriented applications.

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


Correct Option: A
Explanation:

This type of partitioning in Oracle is the one in which each partition is specified by a list of values of the partitioning key.

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


Correct Option: B
Explanation:

This type of client installation allows Oracle Universal Installer to install networking services and support files.

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


Correct Option: A
Explanation:

This data type in Oracle stores file pointers to manage file systems external to the database.

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


Correct Option: D
Explanation:

This data type in Oracle is used for storing byte oriented data having the maximum size of 255 bytes.

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


Correct Option: A
Explanation:

This is also called the smallest logical component of an Oracle database.

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

  1. Synonym

  2. View

  3. Table

  4. Role

  5. Index


Correct Option: C
Explanation:

This is a database object that holds data in Oracle.

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


Correct Option: C
Explanation:

This statement in Oracle is a group of privileges that are collected together and granted to users.

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


Correct Option: B
Explanation:

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

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


Correct Option: C
Explanation:

This type of lock in Oracle locks the table allowing other user to only query but not insert, update or delete rows in table.

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


Correct Option: D
Explanation:

This component of select statement tells the database how a user wants the data to be summarised.

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)


Correct Option: B
Explanation:

This function is used in Oracle to convert a value to the largest integer smaller than or equal to the value,  i.e. Floor (6.7) = 7

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


Correct Option: C
Explanation:

This constraint in Oracle allows an entity to represent a table and each row of the table represents an instance of that entity.

- Hide questions