IT-6203 - Database Management System 2 (Oracle 10g Admin) oed answer key
Showing 81 to 100 of 187 total answers.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is not included in the disk requirements of oracle database?
Answer
3 GB for the preconfigured database (required)
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the correct example of disabling an integrity constraint?
Answer
ALTER TABLE STUDENTS DISABLE CONSTRAINT usn_pk;
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Also known as the application or tool that connects to the Oracle Database Processes
Answer
session
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the correct Disk space requirement when installing Oracle?
Answer
3.8 GB
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the correct example of granting role STUDENT to USER ANNA?
Answer
GRANT STUDENT TO ANNA;
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is a communication pathway between a user process and an Oracle Database instance.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is the skeleton structure that represents the logical view of the entire database.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Supposed that a user performs the query as shown below, what will happen to the data?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is not included in the memory requirements of oracle database.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which one (1) Data Definition Language is considered as part of Database Transaction.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
This is a join clause used to specify arbitrary conditions of specify columns to join.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
A type of lock that is acquired when an application updates, inserts, or deletes a row.
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
In the given complex view example what will be the possible output if this code is run?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
It is also known as specific connection of a user to an instance through a user process
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which one (1) DCL (Data Control Langauge) is considered as part of Database Transaction
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is the correct example of referencing the BOOKS table to AUTHORS?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following system privileges is not part of the task by the database admin.?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Which of the following is not included in the required operating system users and groups?
#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)