Quick Revision

GK One-Line Question & Answer

15541+ short questions with short answers, covering every category and sub-category on the site — no long articles to scroll through. Good for a fast recap before an exam, or a few minutes of daily practice.

Looking for exam process/strategy questions instead? Try the Exam Preparation FAQ →

DBMS → Relational Model 3

An entity set that does not have sufficient attributes to form a primary key is termed a __________
Weak entity set
click to copy
An Oracle __________ is a set of tables and views that are used as a read-only reference about the database.
Data dictionary
click to copy
Insertion of a large number of entries at a time into an index is referred to as __________ of the index.
Bulk loading
click to copy

DBMS → Normalization 3

For a weak entity set to be meaningful, it must be associated with another entity set, called the
Identifying set
click to copy
A data dictionary is created when a __________ created.
Database
click to copy
While inserting the record into the index, if the search-key value does not appear in the index.
The system inserts an index entry with the search-key value in the index at the appropriate position
click to copy

DBMS → Functional Dependency 3

If you were collecting and storing information about your music collection, an album would be considered a(n) _____
Entity
click to copy
An Oracle object type has two parts the _________ and__________
Specification and body
click to copy
A collection of data designed to be used by different people is called a/an
Database
click to copy

DBMS → SQL Basics 3

What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?
Instance
click to copy
A hash function must meet ________ criteriA:)
Three
click to copy
Which of the following is the oldest database model?
Network
click to copy

DBMS → DDL Commands 2

If a piece of data is stored in two places in the database, then
Storage space is wasted & Changing the data in one spot will cause data inconsistency
click to copy
What is the main limitation of Hierarchical Databases?
Limited flexibility in accessing data
click to copy

DBMS → DML Commands 2

An audit trail ___________
Is the recorded history of operations performed on a file
click to copy
The property (or set of properties) that uniquely defines each row in a table is called the:
Primary key
click to copy

DBMS → Joins 2

Large collection of files are called ____________
Database
click to copy
The separation of the data definition from the program is known as:
Data independence
click to copy

DBMS → Views 2

Which of the following hardware component is the most important to the operation of a database management system?
High speed, large capacity disk
click to copy
The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of ‘database’ system?
Hierarchical
click to copy

DBMS → Indexes 2

Which of the following is not true of the traditional approach to information processing
There is common sharing of data among the various applications
click to copy
The database design that consists of multiple tables that are linked together through matching data stored in each table is called
Relational database
click to copy

DBMS → Transactions 2

The information about data in a database is called _______
Metadata
click to copy
The association role defines:
How tables are related in the database
click to copy

DBMS → Concurrency Control 2

A data dictionary is a special file that contains?
All of the mentioned
click to copy
The purpose of an N-Ary association is:
To deal with relationships that involve more than two tables
click to copy

DBMS → Deadlock 2

A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called
Metadata
click to copy
In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.
Clustered index
click to copy

DBMS → Database Security 2

Relational schemas and other metadata about relations are stored in a structure called the ____________
Data Dictionary
click to copy
Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.
All of the mentioned
click to copy

DBMS → PL/SQL 2

___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.
Instance
click to copy
An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.
Index entry
click to copy

DBMS → Introduction to DBMS 2

A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.
Tablespace
click to copy
In a _______ clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
Dense
click to copy

DBMS → Database Architecture 2

A tablespace is further broken down into ________
Segments
click to copy
In a __________ index, an index entry appears for only some of the search-key values.
Dense
click to copy

DBMS → Data Models 2

__________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.
Extent
click to copy
Incase the indices values are larger, index is created for these values of the index. This is called
Multilevel index
click to copy

DBMS → ER Model 2

________ is the smallest unit of allocation in an Oracle database.
Database Block
click to copy
A search key containing more than one attribute is referred to as a _________ search key.
Composite
click to copy