IT-6203 - Database Management System 2 (Oracle 10g Admin) oed answer key

Showing 1 to 20 of 187 total answers.

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

This is also known as unit of work.

Answer

Transaction

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

It is formed when a join condition is omitted.

Answer

Cartesian Product

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Which of the following is the example of an entity

Answer

Workers

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

This is used to deactivate an integrity constraint.

Answer

DISABLE CONSTRAINT

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

What are the two forms of key integrity constraint?

Answer

Foreign key and Primary Key

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Holds information about changes made to the database

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Which of the following joins are mutually exclusive.

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

This is used to remove a privilege granted to a user.

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Which of the following is not possible causes of lock.

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Which of the following is the example of an attribute?

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

It holds information about changes made to the database

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Which of the following is the example of an attributes?

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Based on the table EMPLOYEES, DEPARTMENTS and LOCATIONS.

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

A transaction start when the first ____________ is issued.

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

It is a type of privilege that gain access to the database

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Also known as Oracle Database backup and restore operations

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Which of the following is not part of single to subqueries?

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Which of the following is the correct example of an entity.

#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Which of the following is the example of derived attribute?

Page 1 of 10