IT-6203 - Database Management System 2 (Oracle 10g Admin) oed answer key
Showing 121 to 140 of 187 total answers.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following follows the order of designing, implementing and mainting and Oracle Database
Answer
Evaluating the database server hardwareInstalling the Oracle softwarePlanning the database and security strategyCreating, migrating, and opening the databaseBacking up the databaseEnrolling system users and planning for their Oracle Network accessImplementing the database designRecovering from database failureMonitoring database performance
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the correct example of changing a password to user ANNA from ANNA01 to AN01?
Answer
ALTER USER ANNAIDENTIFIED BY AN01;
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the example of granting SELECT and INSERT on table EMPLOYEES to roleSTUDENT?
Answer
GRANT SELECT, INSERTON EMPLOYEESTO STUDENT;
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the example revoking a priviledge to INSERT, UPDATE and DELETE to USER ANNA?
Answer
REVOKE INSERT, UPDATE, DELETEON EMPLOYEESTO ANNA;
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the correct example of granting create session and create table to user ANNA?
Answer
GRANT CREATE SESSION, CREATE TABLETO ANNA;
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the example of selecting all columns from employees table using the user BEN?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
A type of transaction that is ends the current transactions by making all pending data changes permanent.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is part of the System Global Area (SGA) that hold copies of data blocks that are read from data files.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is used to ensure that data values inside a database follow defines rules for values, range and format
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
This is a schema that pertains to the actual storage of data and its form of storage like files, indices.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is used to ensures that data values inside a database follow defines rules for values, range and format
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
This is a join clause used when the columns in two or more tables have the same but of different data type.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is not included in the optional requirement for operating system of oracle database?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is a type process structure that records checkpoint information in Control file on each data file header.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
This is a join clause used when the columns in two or more tables have the same but of different data types.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following follows the correct order of designing, implementing and mainting and Oracle Database.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is a type of process structure that records checkpoint information in Control file on each data file header
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the correct example of granting SELECT and INSERT on table EMPLOYEES to roleSTUDENT?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)