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

Showing 101 to 120 of 187 total answers.

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

Which of the following is the correct example of creating a user ANNA with password ANN01?

Answer

CREATE USER ANNAIDENTIFIED BY ANN01;

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

Which of the following is the example of modifying a view where salary manager_id is null?

Answer

CREATE OR REPLACE VIEW WORKERS (EMPLOYEE_ID, SURNAME,FIRSTNAME, MANAGER_ID)AS (EMPLOYEE_ID, LASTNAME, FIRSTNAME, MANAGER_ID)FROM EMPLOYEES WHERE MANAGER_ID IS NULL);

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

An automatic rollback is issued by the oracle under the following circumstances. (Choose 2)

Answer

The correct answers are: The user encounter system failure, Closes the sqlplus normally by closing he isqlplus using x button

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

If WITH READ ONLY is added on the view (see sample code below) what is/are the restriction?

Answer

NO DML operations allowed on this view.

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

It is a type of privilege that is used to manipulating the content of the database objects.

Answer

Object

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

It is a type of process structure that writes the redo log buffer to a redo log file on disk

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

This is acquired automatically as needed to support a transaction based on isolation levels.

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

If WITH CHECK OPTION is added on the view (see sample code below) what is/are the restriction?

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

This is use to connect to the Oracle instance and is started when a user establishes a session

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

Which of the following is the example of changing a password to user ANNA from ANNA01 to AN01?

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

A join condition that is based on all the columns in two or more table that have the same name.

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

Which of the following is the example of granting create session and create table to user ANNA?

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

A type of model that is based on the notion of real-world entities and relationships among them.

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

An automatic commit is issued by the Oracle Server under the following circumstances. (Choose 2)

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

It is part of the System Global Area which is used to provide memory for Oracle Streams processes

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

A state where a transaction data changes must be available, even in the event of database failure.

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

Which of the following are mandatory tablespaces that are created at the time of database creation

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

Which of the following is the correct example of modifying a view where salary manager_id is null?

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

It is an attribute or collection of attributes that uniquely identifies an entity among entity set.

Page 6 of 10

1...45678...10