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

Showing 61 to 80 of 187 total answers.

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

Which of the following is the correct representation of one-to-one relation?

Answer

The correct answer is:

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

Which of the following is the Disk space requirement when installing Oracle?

Answer

8 GB

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

Which of the following is the example of granting role STUDENT to USER ANNA?

Answer

GRANT STUDENT TO ANNA;

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

A process where an application waits indefinitely to obtain any needed locks.

Answer

Lockwait

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

Which of the following is not part or Oracle Installation System Requirement.

Answer

File Manager

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

Which of the following is the correct example of create a default constraint.

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

Which of the following is the correct representation of one-to-many relation?

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

This is also known collection of objects such as tables, views, and sequences.

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

This is used to enable a currently disable constraint in the table definition.

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

Which of the following is the correct representation of many-to-many relation?

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

Supposed that table: Workers and Employees is consists of the following values.

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

Which of the following is the correct example of adding primary key constraint?

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

Which of the following is the example of referencing the BOOKS table to AUTHORS?

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

In planning to install Oracle which of the following is not important to consider.

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

This is a type of attribute that is atomic value, which cannot be divided further.

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

Which of the following is not true about complex view when using DELETE statement?

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

Which of the following is not true about complex view when using INSERT statement?

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

Which of the following is not true about complex view when using UPDATE statement?

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

Which of the following is the correct example of saving changes made on the table?

Page 4 of 10