IT-6203 - Database Management System 2 (Oracle 10g Admin) oed answer key
Showing 21 to 40 of 187 total answers.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is a type a Oracle environment where Oracle Products run.
Answer
ORACLE_HOME
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the example of enabling constraint?
Answer
ALTER TABLE BOOKSENABLE CONSTRAINT STUD_ID;
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the syntax for creating a new user?
Answer
CREATE USER hrIDENTIFIED BY hr;
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
This is used to delete child row when a parent key is deleted.
Answer
ON DELETE CASCADE
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is not part of multiple row subqueries?
Answer
MAX
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the correct example of an attribute?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the correct example of an attributes?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the example of multiple row subquery?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is the key in solving the problems of information management.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is the key to solving the problems of information management.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
A join condition used when a table has columns with match values.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is a join of two or more table that returns only matched rows.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is not included in the oracle environment?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the example of creating a role STUDENT?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
A transaction ends when either of the following occurs. (Choose 5)
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is a state of operational database with data at any given time.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the correct example of derived attribute?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the example of create a default constraint
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)