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

Showing 161 to 180 of 187 total answers.

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

It is a type process structure that automatically connects to other databases involved in in- doubt distributed transactions.

Answer

Checkpoint Process (CKPT)

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

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

Answer

CREATE TABLE BOOKS(BOOK_ID NUMBER,TITLE VARCHAR(10),YEAR NUMBER(4),CONSTRAINT BK_ID CHECK (BOOK_ID > 10));

#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 user scott?

Answer

GRANT INSERT, UPDATEON SYSTEM.EMPLOYEESTO HR;

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

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

Answer

CREATE VIEW WORKERS (EMPLOYEE_ID, SURNAME, FIRSTNAME)AS (EMPLOYEE_ID, LASTNAME, FIRSTNAMEFROM EMPLOYEES WHERE SALARY LASTNAME LIKE '%S');

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

It is a type of process structure that automatically connects to other databases involved in in- doubt distributed transactions

Answer

Recoverer Process

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Which of the following is the correct 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)

A type of that do not exist in the physical database, but their values are derived from other attributes present in the database.

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

It is a collection of data treated as a unit with the main purpose of storing and retrieving related information in the database.

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

A state of the data where a transaction must be fully compliant with the state of the database as it was prior to the transaction.

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

It is a named group of related privileges that can be granted to the user. This method makes it easier to revoke and maintain privileges.

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

This is used to delete a primary key constraint in a parent table and will automatically drop the foreign key constraint in the child table.

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Which of the following is the example of granting INSERT, UPDATE and DELETE to user ANNA with an option to pass the privilege to other user?

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

A state of the data where a transaction data must not be available to other transactions until the original transaction is committed or rolled back.

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

This gives the user more flexibility and control when changing data and they ensure data consistency in the event of user process or system failure.

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Which of the following is the correct example of granting INSERT, UPDATE and DELETE to user ANNA with an option to pass the privilege to other user?

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Which of the following is the example of creating a subquery that will copy all values from employees table to workers where job_id is equal to ST_CLERK;

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

This is a type of schema defines all the logical constraints that need to be applied on the data stored. It defines tables, views, and integrity constraints.

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

Which of the following is the correct example of creating a subquery that will copy all values from employees table to workers where job_id is equal to ST_CLERK;

#IT-6203

Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)

It is a type of process structure that writes modified (dirty) buffers in the database buffer cache asynchronously while performing other processing to advance the checkpoint

Page 9 of 10

1...5 6 7 8 9 10

Introduction to Multimedia

Computer Programming 1

System Integration and Architecture 1

Social and Professional Issues

Kritikal na Pagbasa, Pagsulat at Pagsasalita

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

It is a type process structure that automatically connects to other databases involved in in- doubt distributed transactions.

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

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

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

It is a type of process structure that automatically connects to other databases involved in in- doubt distributed transactions

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

A type of that do not exist in the physical database, but their values are derived from other attributes present in the database.

It is a collection of data treated as a unit with the main purpose of storing and retrieving related information in the database.

A state of the data where a transaction must be fully compliant with the state of the database as it was prior to the transaction.

It is a named group of related privileges that can be granted to the user. This method makes it easier to revoke and maintain privileges.

This is used to delete a primary key constraint in a parent table and will automatically drop the foreign key constraint in the child table.

Which of the following is the example of granting INSERT, UPDATE and DELETE to user ANNA with an option to pass the privilege to other user?

A state of the data where a transaction data must not be available to other transactions until the original transaction is committed or rolled back.

This gives the user more flexibility and control when changing data and they ensure data consistency in the event of user process or system failure.

Which of the following is the correct example of granting INSERT, UPDATE and DELETE to user ANNA with an option to pass the privilege to other user?

Which of the following is the example of creating a subquery that will copy all values from employees table to workers where job_id is equal to ST_CLERK;

This is a type of schema defines all the logical constraints that need to be applied on the data stored. It defines tables, views, and integrity constraints.

Which of the following is the correct example of creating a subquery that will copy all values from employees table to workers where job_id is equal to ST_CLERK;

It is a type of process structure that writes modified (dirty) buffers in the database buffer cache asynchronously while performing other processing to advance the checkpoint

Avail our OED Service!