IT-6203 - Database Management System 2 (Oracle 10g Admin) oed answer key
Showing 101 to 120 of 187 total answers.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the correct example of creating a user ANNA with password ANN01?
Answer
CREATE USER ANNAIDENTIFIED BY ANN01;
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the example of modifying a view where salary manager_id is null?
Answer
CREATE OR REPLACE VIEW WORKERS (EMPLOYEE_ID, SURNAME,FIRSTNAME, MANAGER_ID)AS (EMPLOYEE_ID, LASTNAME, FIRSTNAME, MANAGER_ID)FROM EMPLOYEES WHERE MANAGER_ID IS NULL);
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
An automatic rollback is issued by the oracle under the following circumstances. (Choose 2)
Answer
The correct answers are: The user encounter system failure, Closes the sqlplus normally by closing he isqlplus using x button
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
If WITH READ ONLY is added on the view (see sample code below) what is/are the restriction?
Answer
NO DML operations allowed on this view.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is a type of privilege that is used to manipulating the content of the database objects.
Answer
Object
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is a type of process structure that writes the redo log buffer to a redo log file on disk
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
This is acquired automatically as needed to support a transaction based on isolation levels.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
If WITH CHECK OPTION is added on the view (see sample code below) what is/are the restriction?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
This is use to connect to the Oracle instance and is started when a user establishes a session
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the example of changing a password to user ANNA from ANNA01 to AN01?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
A join condition that is based on all the columns in two or more table that have the same name.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the example of granting create session and create table to user ANNA?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
A type of model that is based on the notion of real-world entities and relationships among them.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
An automatic commit is issued by the Oracle Server under the following circumstances. (Choose 2)
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is part of the System Global Area which is used to provide memory for Oracle Streams processes
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
A state where a transaction data changes must be available, even in the event of database failure.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following are mandatory tablespaces that are created at the time of database creation
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the correct example of modifying a view where salary manager_id is null?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)