***SHORT QUIZ 1***
Which of the following is the correct Disk space requirement when installing
Oracle?
Answer: 3.8 GB
Which of the following is not part or Oracle Installation System Requirement.
Answer: File Manager
Which of the following follows the correct order of designing, implementing and
mainting and Oracle Database.
Answer:
Evaluating the database server hardware
Installing the Oracle software
Planning the database and security strategy
Creating, migrating, and opening the database
Backing up the database
Enrolling system users and planning for their Oracle Network access.
Implementing the database design
Recovering from database failure
Monitoring database performance
In planning to install Oracle which of the following is not important to consider.
Answer: Any Oracle version will do even when multiple products are involved
It is a type a Oracle environment where Oracle Products run.
Answer: ORACLE_HOME
***SHORT QUIZ 2***
It is a named group of related privileges that can be granted to the user. This
method makes it easier to revoke and maintain privileges.
Answer: Role
It is a type of privilege that gain access to the database
Answer: System
It is a type of privilege that is used to manipulating the content of the database
objects.
Answer: Object
This is also known collection of objects such as tables, views, and sequences.
Answer: Schema
This is used to remove a privilege granted to a user.
Answer: REVOKE
Which of the following is the correct example of passing a privilege (INSERT and
UPDATE) to user HR coming from a user scott?
Answer:
GRANT INSERT, UPDATE
ON SYSTEM.EMPLOYEES
TO HR;
Which of the following is the correct example of passing a privilege (INSERT and
UPDATE) to user HR coming from a SYSTEM?
Answer:
GRANT INSERT, UPDATE
ON EMPLOYEES
TO HR
WITH GRANT OPTION;
Which of the following is the correct syntax for creating a new user?
Answer:
CREATE USER hr
IDENTIFIED BY hr;
Which of the following System Privileges is not part of SYSTEM privilege?
Answer: CREATE INDEX
Which of the following system privileges is not part of the task by the database
admin.?
Answer: Managing user environment
***LONG QUIZ 1***
Which of the following is the correct example of granting INSERT, UPDATE and DELETE
to user ANNA with an option to pass the privilege to other user?
Answer:
GRANT INSERT, UPDATE, DELETE
ON EMPLOYEES
TO ANNA
WITH GRANT OPTION;
It represents the state of a current user login to the database instance.
Answer: Session (not sure)
It is a type process structure that automatically connects to other databases
involved in in- doubt distributed transactions.
Answer: Recoverer Process
Which of the following is the correct example revoking a privilege to INSERT,
UPDATE and DELETE to user ANNA from user BEN?
Answer:
REVOKE INSERT, UPDATE, DELETE
ON SYSTEM.EMPLOYEES
TO ANNA;
Holds information about changes made to the database
Answer: Redo Log Buffer
Which of the following is not included in the disk requirements of oracle database?
Answer: 3 GB for the preconfigured database (required)
Which of the following is the correct example of granting SELECT and INSERT on
table EMPLOYEES to role STUDENT?
Answer:
GRANT SELECT, INSERT
ON EMPLOYEES
TO STUDENT;
It is a type process structure that records checkpoint information in Control file
on each data file header.
Answer: Checkpoint Process (CKPT)
It is part of the System Global Area which is used to provide memory for Oracle
Streams processes
Answer: Java Pool
Which of the following is not included in the required operating system users and
groups?
Answer: sysdba
Which of the following system privileges is not part of the task by the database
admin.?
Answer: Managing user environment
It is a type of privilege that gain access to the database
Answer: System
Which of the following is not included in the optional requirement for operating
system of oracle database?
Answer: Dba
It is a type process structure that cleans up the database buffer cache
Answer: Process Monitor Process (PMON)
It is the key to solving the problems of information management.
Answer: Database server
Also known as the application or tool that connects to the Oracle Database
Processes
Answer: User process
It is a communication pathway between a user process and an Oracle Database
instance.
Answer: Connection
Which of the following is not included in the memory requirements of oracle
database.
Answer: 3GB for the ASM instance
It is part of the System Global Area (SGA) that hold copies of data blocks that are
read from data files.
Answer: Data Buffer Cache
Which of the following is the correct example of selecting all columns from
employees table using the user BEN?
Answer: SELECT * FROM SYSTEM.STUDENT;
Which of the following is the correct example of changing a password to user ANNA
from ANNA01 to AN01?
Answer:
ALTER USER ANNA
IDENTIFIED BY AN01;
This is use to connect to the Oracle instance and is started when a user
establishes a session
Answer: Server process
Which of the following is not included in the oracle environment?
Answer: Oracle_instance
Which of the following is the correct example of creating a role STUDENT?
Answer: CREATE ROLE STUDENT;
It is a collection of data treated as a unit. The purpose of a database is to store
and retrieve related information.
Answer: Oracle database
It is a type of privilege that is used to manipulating the content of the database
objects.
Answer: Object
Which of the following is the correct example of creating a user ANNA with password
ANN01?
Answer:
CREATE USER ANNA
IDENTIFIED BY ANN01;
Which of the following is the correct example of granting create session and create
table to user ANNA?
Answer:
GRANT CREATE SESSION, CREATE TABLE
TO ANNA;
Which of the following is the correct example revoking a priviledge to INSERT,
UPDATE and DELETE to USER ANNA?
Answer:
REVOKE INSERT, UPDATE, DELETE
ON EMPLOYEES
TO ANNA;
Which of the following is the correct example of granting role STUDENT to USER
ANNA?
Answer: GRANT STUDENT TO ANNA;
***SHORT QUIZ 3***
An automatic rollback is issued by the oracle under the following circumstances.
Answers:
1. The user encounter system failure
2. Closes the sqlplus normally by closing he isqlplus using x button
A transaction ends when either of the following occurs.
Answers:
1. The user type in Commit
2. CREATE TABLE is issued
3. The user closes the isqlplus
4. The user type in Rollback
5. The user encounter system failure
Which one (1) DCL (Data Control Langauge) is considered as part of Database
Transaction
Answer: COMMIT
A transaction start when the first ____________ is issued.
Answer: DML
Which one (1) Data Definition Language is considered as part of Database
Transaction.
Answer: CREATE TABLE
An automatic commit is issued by the Oracle Server under the following
circumstances.
Answers:
1. Closes the sqlplus normally by typing exit
2. CREATE TABLE is issued
Which three (3) of thefollowing is the three Data Manipulation Langauge that is
considered as part of database transaction.
Answers:
1. INSERT
2. UPDATE
3. DELETE
***SHORT QUIZ 4***
A type of lock that is acquired when an application wants to read and prevent
others from updating the same row.
Answer: Sharelock (S locks)
This is also known as unit of work.
Answer: Transaction
A process where an application waits indefinitely to obtain any needed locks.
Answer: Lockwait
This is acquired automatically as needed to support a transaction based on
isolation levels.
Answer: Lock
It occurs when two or more applications wait indefinitely for a resources.
Answer: Deadlock
Which of the following transaction rules is not included in the group?
Answer: Redundancy
Which of the following is not possible causes of lock.
Answer: Lost Update
A type of transaction that is ends the current transactions by making all pending
data changes permanent.
Answer: COMMIT
A type of lock that is acquired when an application updates, inserts, or deletes a
row.
Answer: Exclusive Lock (X Lock)
A type of transaction that rolls back the current transaction to the specified
savepoint, thereby discarding any changes or savepoint created after the savepoint
to which you are rolling back.
Answer: ROLLBACK TO SAVEPOINT
