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

Showing 141 to 160 of 187 total answers.

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

A type of lock that is acquired when an application wants to read and prevent others from updating the same row.

Answer

Sharelock (S locks)

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

Which of the following is the example of passing a privilege (INSERT and UPDATE) to user HR coming from a SYSTEM?

Answer

GRANT INSERT, UPDATEON EMPLOYEESTO HRWITH GRANT OPTION;

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

Which of the following is the example of adding a CHECK constraint where CODE should start with the character ‘BS’

Answer

The answers are: CREATE TABLE COURSE(CODE CHAR(4) PRIMARY KEY,TITLE VARCHAR(20),CONSTRAINT CODE_ck CHECK (CODE LIKE ‘BS%’));b, ‘BS’));

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

Which of the following is the example revoking a privilege to INSERT, UPDATE and DELETE to user ANNA from user BEN?

Answer

REVOKE INSERT, UPDATE, DELETEON SYSTEMEMPLOYEESTO ANNA;

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

A type constraint that uniquely identifies each record in a database table and can be applied on one or more column.

Answer

Unique

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

A state of the data where a transaction must be fully complete, saved (committed) or completely undone (rolled back).

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

It is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information.

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

It is join between two tables that return the result of an Inner Join as well as the results of Left and Right joins.

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

This is a type of schema that has the power to change the physical data without impacting the schema or logical data.

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

Which of the following is the example of adding a check constraint on column BOOK_ID to accept value greater that 10?

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

Which of the following is the example of passing a privilege (INSERT and UPDATE) to user HR coming from a user scott?

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

Which of the following is the example of creating a view where LASTNAME ends with letter S rename LASTNAME to SURNAME?

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

Which of the following is the example of creating a subquery that copy the values from employees table to workers table?

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

It is a type of process structure that can collect transaction, redo data and transmit that data to standby destinations.

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

Which of the following is the correct example of passing a privilege (INSERT and UPDATE) to user HR coming from a SYSTEM?

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

SELECT EMPLOYEES.EMPLOYEE_ID, EMPLOYEES.LASTNAME,EMPLOYEES.DEPARTMENT_ID,DEPARTMENTS.DEPARTMENT_ID,DEPARTMENTS.LOCATION_ID

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

Which of the following is the correct example of adding a CHECK constraint where CODE should start with the character ‘BS’.

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

Which of the following is the correct example revoking a privilege to INSERT, UPDATE and DELETE to user ANNA from user BEN?

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

Which three (3) of thefollowing is the three Data Manipulation Langauge that is considered as part of database transaction.

Page 8 of 10