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)