Fundamentals of Oracle and Distributed Databases
Covers Oracle database architecture components, storage structures, and distributed database concepts including fragmentation, site autonomy, and federated systems.
Questions
Which of the following files is required for oracle database to function?
- Datafile
- Redo Log File
- Control file
- The password file
- The document file
Which of the following components of oracle architecture is able to store, manage and manipulate data in the database?
- The oracle instance
- The oracle server
- The oracle database
- Cursor
- Trigger
The SQL command used to create an instance, so that the database will be mounted and then opened for all the users is
- force
- mount
- unmount
- open
- recover
In Oracle 9i, the file used to store the transferred contents of redo log files into it is the
- parameter file
- control file
- datafile
- archive file
- spreadsheet file
The schema in DBMS architecture which provides mapping between global relations and fragments is
- global schema
- allocation schema
- fragmentation schema
- local mapping schema
- logical data structure
The _____________ component of oracle consist of contiguous group of blocks allocated for use as part of a table, index and so forth.
- database block
- extent
- data dictionary
- schema
- attributes
The _______________ component of oracle consists of a set of extents allocated for a single type of object.
- segment
- extent
- schema
- database block
- instance
The type of fragmentation which requires that each global relation be selected in one and only one fragment is
- primary fragmentation
- derived horizontal fragmentation
- vertical fragmentation
- mixed fragmentation
- replication
The type of administration in oracle distributed database refers that each server participating in a distributed database is administered independently from other databases is
- enterprise manager
- site autonomy
- SNMP support
- third party administration tools
- data localization
The _______ level of RAID is a block interleaved parity organization that uses block level striping and in addition keeps a parity block on a separate disk for corresponding blocks from N other disks.
- RAID level 1
- RAID level 2
- RAID level 3
- RAID level 4
- RAID level 5
The type of issue in federated distributed database which provides facilities for specification and implementation that vary from system to system is
- differences in data models
- differences in constraints
- differences in query languages
- differences in query contents
- enterprise manager
The ________________ advantage of DBMS refers to the correctness of data in the database.
- data availibility
- data integrity
- controlled data redundancy
- concurrent use
- data persistence
The ____________ component of transaction control statement consists of a node that hosts a database from which a client requests data.
- client
- database server
- global coordinator
- local coordinator
- commit point site
The ____________ data model is a model in which data is represented by a collection of records and the relationships are represented by links.
- network
- relational
- hierarchical
- ER
- DBTG
The __________ terminology in relational data model is defined as a set of allowed values for one or more attributes in a relation.
- attribute
- tuple
- domain
- degree
- cardinality