Font size
WorksheetsOracle Architecture
Total questions: 30
Worksheet time: 20mins
The two main components of Oracle RDBMS are ____ and ____ ? (use 2 comma delimited answer)
(a)
An instance consist of ____ and ____ process (Use 2 comma delimited answer)
(a)
Name some components of System Global Area (SGA), at least three comma delimited answer.
(a)
List some background processes, at least 3 comma delimited answer .
(a)
The (a) process writes the dirty buffers to data files.
The (a) process writes the redo logs to the log files.
Name some files associated with an Oracle Database, at least 3 comma delimited answer.
(a)
Some of the logical structures of an Oracle Database are: (at least 3 comma delimited answer)
(a)
The (a) process copies the redo log files to an archive destination.
The (a) contains data and control information for a server or a background process
The SGA includes the Database buffer cache and the Redo log buffer.
True
False
Each server process and background process has its own Program Global Area (PGA)
True
False
User Processes run the Application or Oracle Tool Code.
True
False
Which of the following components comprise an Oracle architecture?
Database related background processes
Tablespaces
Datafiles
All of the Mentioned
Which process is an instance made of Oracle?
Oracle background processes
Memory processes
Data processes
All of the Mentioned
What is the use of extent in Oracle?
Stores user data within the database
Minimize the amount of wasted (empty) storage
Stores rollback information used when data must be rolled back
All of the Mentioned
The Oracle environment of database is called as ___________ .
Database Schema
Database Instances
Data Structure
All of the Mentioned
Which is the smallest unit of storage in an Oracle database?
Data Block
Segment
Extent
Data File
What are the valid Oracle database schemas?
Logical Schema
Physical Schema
Logical and Physical Schema
None of the Mentioned
Collection of information stored in database at particular instance of time is called as ____________.
Instance of Database
Objects in Databases
Database Instances
None of the Mentioned
Map entities, attributes and relations in Oracle is represented by_________.
Logical Schema
Conceptual Schema
Physical Schema
All of the Mentioned
Oracle server configuration is dedicated for ________.
One server process – Many user processes
Many server processes – One user process
One server process – One user process
Many server processes – Many user processes
In an E-R diagram, an entity set is represented by a ______.
Rectangle
Ellipse
Diamond box
Circle
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Data Definition Language(DDL)
Data Manipulation Language(DML)
DML and DDL
All of the Mentioned
________clause is an additional filter that is applied to the result.
Select
Group-by
Order by
Having
Which command is used for removing a table and all its data from the database:
Create command
Drop table command
Alter table command
All of the Mentioned
___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
Column
Constraint
Index
Trigger
Super Key
Secondary Key
Foreign Key
Candidate Key
The __________ process writes the dirty buffers to the datafiles
CKPT
LGWR
DBWN
SMON
The __________ process writes the redo entries to the online redo log files
SMON
DBWn
CKPT
LGWR
