IT-6203 - Database Management System 2 (Oracle 10g Admin) oed answer key
Showing 41 to 60 of 187 total answers.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the correct syntax for creating a new user?
Answer
CREATE USER hrIDENTIFIED BY hr;
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following transaction rules is not included in the group?
Answer
Redundancy
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is a type process structure that cleans up the database buffer cache
Answer
Process Monitor Process (PMON)
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the correct example of multiple row subquery?
Answer
SELECT EMPLOYEE_ID, SALARY FROM EMPLOYEES WHERE SALARY =(SELECT MIN(SALARY) FROM EMPLOYEES;
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the example of adding primary key constraint?
Answer
ALTER TABLE AUTHORSADD CONSTRAINT AUTHOR_ID PRIMARY KEY(NUMBER);
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
A type of constraint uniquely identifies each record in a database table.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It represents the state of a current user login to the database instance.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
This is used to quality ambiguous column when joining two or more tables.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the correct example of creating a role STUDENT?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following System Privileges is not part of SYSTEM privilege?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
A single row of a table, which contains a single record for that relation.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
A type of constraint that is used to insert a default value into a column.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is a type of process structure that cleans up the database buffer cache
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It occurs when two or more applications wait indefinitely for a resources.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
This is a join clause that produces a cross-product of two or more tables.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the example of saving changes made on the table?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following statement is not true about Foreign Key constraint?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
This is a type of attribute that is made of more than one simple attribute.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)