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 → DDL Commands 3

Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by
Unique-role assumption
click to copy
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 3

Designers use which of the following to tune the performance of systems to support timecritical operations?
Denormalization
click to copy
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 3

In the schema (dept name, size) we have relations total inst 2007, total inst 200Q:8) Which dependency have lead to this relation ?
Dept name, year->size
click to copy
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 3

Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
BCNF
click to copy
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

Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
Snapshot
click to copy
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

DBMS → Transactions 2

Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.
Cross-tabs
click to copy
The information about data in a database is called _______
Metadata
click to copy

DBMS → Concurrency Control 2

Data Model is collection of conceptual tools for describing -
All of these
click to copy
A data dictionary is a special file that contains?
All of the mentioned
click to copy

DBMS → Deadlock 2

Data Models in DBMS are classified into ______ categories.
5
click to copy
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

DBMS → Database Security 2

Object based logical model(s) are used to describe data at - [Select Appropriate Option(s)]
Physical Level
click to copy
Relational schemas and other metadata about relations are stored in a structure called the ____________
Data Dictionary
click to copy

DBMS → PL/SQL 2

Which of the following is example of Object based logical model ?
Entity Relationship Model
click to copy
___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.
Instance
click to copy

DBMS → Introduction to DBMS 2

Entity Relationship model consists of collection of basic objects called _________ and relationship among these objects.
entities
click to copy
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

DBMS → Database Architecture 2

Which of the following gives a logical structure of the database graphically?
Entity-relationship diagram
click to copy
A tablespace is further broken down into ________
Segments
click to copy

DBMS → Data Models 2

Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality
One to one
click to copy
__________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.
Extent
click to copy

DBMS → ER Model 2

We indicate roles in E-R diagrams by labeling the lines that connect ___________ to __________
Diamond, rectangle
click to copy
________ is the smallest unit of allocation in an Oracle database.
Database Block
click to copy

DBMS → Relational Model 2

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

DBMS → Normalization 2

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

DBMS → Functional Dependency 2

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

DBMS → SQL Basics 2

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