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 → Functional Dependency 3

Which of the following is an unary operation?
generalized selection
click to copy
Report generators are used to
both retrieve information from files and answer queries
click to copy
Large collection of files are called
database
click to copy

DBMS → SQL Basics 3

Which SQL Query is use to remove a table and all its data from the database?
drop table
click to copy
Which of the following is true of a network structure?
it allows a many-to-many relationship
click to copy
A transparent DBMS
keeps its physical structure hidden from users
click to copy

DBMS → DDL Commands 3

In precedence of set operators the expression is evaluated from:
left to right
click to copy
A record management system
can be used to extract information stored in a computer file
click to copy
A file produced by a spreadsheet
is generally stored on disk in an ascii text fromat
click to copy

DBMS → DML Commands 3

In DBMS, FD stands for _______
functional dependency
click to copy
One data dictionery software package is called
db/dc dictionary
click to copy
The model for a record management system might be
all of the options
click to copy

DBMS → Joins 2

How many types of keys in Database Design?
all of the options
click to copy
The function of a database is ...
to collect and organize input data
click to copy

DBMS → Views 2

Which of the following is based on Multi Valued Dependency?
fourth
click to copy
A command that lets you change one or more fields in a record is
modify
click to copy

DBMS → Indexes 2

Which of the following is the structure of the Database?
schema
click to copy
What is the language used by most of the DBMSs for helping their users to access data?
query language
click to copy

DBMS → Transactions 2

The minimal set of super key is called
candidate key
click to copy
Information can be transferred between the DBMS and a
all of the options
click to copy

DBMS → Concurrency Control 2

______________ is a classical approach to database design?
top – down approach
click to copy
The relational database environment has all of the following components except
separate files
click to copy

DBMS → Deadlock 2

_____________ refers to the correctness and completeness of the data in a database?
data integrity
click to copy
The ascending order of a data hirerchy is:
bit-byte-field-record-file-database
click to copy

DBMS → Database Security 2

A table that displays data redundancies yields ____________ anomalies
all of the options
click to copy
Primitive operations common to all record management system include
look-up
click to copy

DBMS → PL/SQL 2

A lock that allows concurrent transactions to access different rows of the same table is known as a
field-level lock
click to copy
Which of the following is not a relational database?
reflex
click to copy

DBMS → Introduction to DBMS 2

A type of query that is placed within a WHERE or HAVING clause of another query is called
sub query
click to copy
A top-to-bottom relationship among the items in a database is established by a
hierarchical schema
click to copy

DBMS → Database Architecture 2

A form defined
where data is placed on the screen
click to copy
Choose the RDBMS which supports full fledged client server application development
oracle 7.1
click to copy

DBMS → Data Models 2

Which of the following is a problem of file management system?
all of the options
click to copy
The highest level in the hierarchy of data organization is called
data base
click to copy

DBMS → ER Model 2

Which of the following is not an advantage of the database approach
all of the above
click to copy
The management information system (MIS) structure with one main computer system is called a
centralized mis structure
click to copy

DBMS → Relational Model 2

An audit trail
is the recorded history of operations performed on a file
click to copy
In the DBMS approach, application programs perform the
processing functions
click to copy

DBMS → Normalization 2

One approach to standardization storing of data?
codasyl specification
click to copy
Batch processing is appropriate if
none of the options
click to copy