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

Showing 81 to 100 of 187 total answers.

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

Which of the following is not included in the disk requirements of oracle database?

Answer

3 GB for the preconfigured database (required)

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

Which of the following is the correct example of disabling an integrity constraint?

Answer

ALTER TABLE STUDENTS DISABLE CONSTRAINT usn_pk;

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

Also known as the application or tool that connects to the Oracle Database Processes

Answer

session

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

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

Answer

3.8 GB

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

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

Answer

GRANT STUDENT TO ANNA;

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

It is a communication pathway between a user process and an Oracle Database instance.

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

It is the skeleton structure that represents the logical view of the entire database.

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

Supposed that a user performs the query as shown below, what will happen to the data?

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

Which of the following is not included in the memory requirements of oracle database.

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

Which one (1) Data Definition Language is considered as part of Database Transaction.

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

This is a join clause used to specify arbitrary conditions of specify columns to join.

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

A type of lock that is acquired when an application updates, inserts, or deletes a row.

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

In the given complex view example what will be the possible output if this code is run?

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

It is also known as specific connection of a user to an instance through a user process

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

Which one (1) DCL (Data Control Langauge) is considered as part of Database Transaction

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

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

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

Which of the following system privileges is not part of the task by the database admin.?

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

Which of the following is not included in the required operating system users and groups?

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

A type of constraint that is used to limit the value range that can be placed in a column.

Page 5 of 10

1...34567...10