0

Oracle and DBMS

Description: Oracle
Number of Questions: 15
Created by:
Tags: Oracle Database
Attempted 0/15 Correct 0 Score 0

Which of the following normal forms is depicted when a relation where primary key contains multiple attributes and no non-key attributes should be functionally dependent on a part of the primary key?

  1. 1 NF

  2. 2 NF

  3. 3 NF

  4. 5 NF

  5. BCNF


Correct Option: B
Explanation:

Second normal form (2 NF) is depicted when a relation where the primary key contains multiple attributes and no non-key attributes should be functionally dependent on a part of the primary key.

Which of the following data types in Informix Universal Server database is used to extend an existing type through inheritance?

  1. Opaque type

  2. Row type

  3. Distinct type

  4. Collection type

  5. Varchar2 type


Correct Option: C
Explanation:

This data type in Informix Universal Server database is used to extend an existing type through inheritance.

Which one of the following objects in object-oriented databases has a type hierarchy and set/subset constraints have been enforced on it?

  1. Inheritance

  2. Operator overloading

  3. Extents

  4. Polymorphism

  5. Encapsulation


Correct Option: C
Explanation:

This is an object in object-oriented databases, which has a type hierarchy and set/subset constraints have been enforced on it.

Which one of the following objects in Oracle is a group of records from one or more tables is physically stored in a mixed file?

  1. Synonyms

  2. Sequence

  3. Indexes

  4. Cluster

  5. Triggers


Correct Option: D
Explanation:

This object in Oracle is a group of records from one or more tables physically stored in a mixed file.

Which of the following objects in the processing of a high-level query has the task of producing an execution plan?

  1. Query optimiser

  2. Query code generator

  3. Runtime database processor

  4. Query parser

  5. DML compilers


Correct Option: A
Explanation:

This object in the processing of high-level query has the task of producing an execution plan.

Which one of the following DBMS software modules processes and checks the specification of a database scheme in the DDL and stores that description in the catalog?

  1. Query and DML compilers

  2. Query and DML optimiser

  3. DDL compilers

  4. Query and DML parser

  5. DBA


Correct Option: C
Explanation:

This DBMS software module processes and checks the specification of a database schema in the DDL and stores that description in the catalog.

Which one of the following failures in a database may decide to abort the transaction to be restarted later because it violates serialisability or because several transactions are in a state of deadlock?

  1. Computer failure

  2. A transaction or system error

  3. Local errors

  4. Concurrency control

  5. Disk failure


Correct Option: D
Explanation:

This failure in the database may decide to abort the transaction to be restarted later because it violates serialisability or because several transactions are in a state of deadlock.

Which of the following data type is used in Oracle to store unstructured information such as sound clips, video files etc. in an Oracle table?

  1. Long raw

  2. CLOB

  3. Date

  4. LOB

  5. BLOB


Correct Option: D
Explanation:

This data type is used in oracle to store unstructured information such as sound clips, video files etc. in an Oracle table.

Which of the following is the simplest and also substantial means to improve performance of Oracle using partitioning?

  1. Partition-wise joins

  2. Partitioning pruning

  3. Global partitioned indexes

  4. Composite range hash partitioning

  5. Global non-partitioned indexes


Correct Option: B
Explanation:

This is the simplest and also the most substantial means to improve performance of Oracle using partitioning. It improves query performance by several orders of magnitude.

Which of the following constraints is used in Oracle to prevent the duplication of values within the rows of specified column or a set of columns in a table?

  1. Domain integrity constraints

  2. Check constraints

  3. Unique constraints

  4. Referential integrity constraints

  5. Tuple constraints


Correct Option: C
Explanation:

This constraint is used in Oracle to prevent the duplication of values within the rows of a specified column or a set of columns in a table.

Which of the following cost components for query execution is the cost of searching for reading and writing data blocks that reside on secondary storage mainly on disks?

  1. Storage cost

  2. Computation cost

  3. Memory usage cost

  4. Access cost to secondary storage

  5. Communication cost


Correct Option: D
Explanation:

This cost component for query execution is the cost of searching for reading and writing data blocks that resides on secondary storage mainly on disks.

Which of the following components of select command is used to summarize the data of the table?

  1. From

  2. Select

  3. Where

  4. Order by

  5. Group by


Correct Option: E
Explanation:

This component of select command is used to summarize the data of the table.

Which of the following attribute of cursor command in Oracle is used to return no more records from the cursor when it is failed?

  1. %FOUND

  2. %NOT FOUND

  3. %ISOPEN

  4. %ROWCOUNT

  5. %COUNT


Correct Option: B
Explanation:

This attribute of cursor command in Oracle is used to return no more records from the cursor if it fails.

Which of the following is/are used in Oracle to connect to non-Oracle data stores by using either a Heterogeneous Services ODBC agent or a Heterogeneous Services OLE DB agent?

  1. Transparent Gateway Agents

  2. Database link

  3. Generic connectivity

  4. Cursor

  5. Triggers


Correct Option: C
Explanation:

This method is used in Oracle to connect to non-Oracle data stores by using either a heterogeneous services ODBC agent or heterogeneous services OLE DB agent.

Which one of the following transactions is a transaction that includes one or more statements that, individually or in a group update, data on two or more distincts of a distributed database?

  1. Remote transaction

  2. Two-Phase commit mechanism

  3. Distributed transaction

  4. SNMP

  5. Enterprise manager


Correct Option: C
Explanation:

This transaction is a transaction that includes one or more statements that, individually or in a group, update data on two or more distincts of a distributed database.

- Hide questions