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 → Concurrency Control 3

The relational database environment has all of the following components except
separate files
click to copy
In an Entity-Relationship Diagram Rectangles represents
entity sets
click to copy
For each attribute of a relation, there is a set of permitted values, called the                   of that attribute.
domain
click to copy

DBMS → Deadlock 3

The ascending order of a data hirerchy is:
bit-byte-field-record-file-database
click to copy
Which of the following represents a relationship among a set of values.
a row
click to copy
A domain is atomic if elements of the domain are considered to be                           units.
indivisbile
click to copy

DBMS → Database Security 3

Primitive operations common to all record management system include
look-up
click to copy
A Relation is a
subset of a cartesian product of a list of domains
click to copy
The subset of a super key is a candidate key under what condition?
no proper subset is a super key
click to copy

DBMS → PL/SQL 3

Which of the following is not a relational database?
reflex
click to copy
In mathematical term Table is referred as
relation
click to copy
A            is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
key
click to copy

DBMS → Introduction to DBMS 2

A top-to-bottom relationship among the items in a database is established by a
hierarchical schema
click to copy
In mathematical term Row is referred as
tuple
click to copy

DBMS → Database Architecture 2

Choose the RDBMS which supports full fledged client server application development
oracle 7.1
click to copy
Which of the following is Relation-algebra Operation
all of the above
click to copy

DBMS → Data Models 2

The highest level in the hierarchy of data organization is called
data base
click to copy
Who proposed the relational model?
e.f. codd
click to copy

DBMS → ER Model 2

The management information system (MIS) structure with one main computer system is called a
centralized mis structure
click to copy
Snapshot of the dta in the database at a given instant of time is called
database instance
click to copy

DBMS → Relational Model 2

In the DBMS approach, application programs perform the
processing functions
click to copy
In an Entity-Relationship Diagram “Ellipses” represents
attributes
click to copy

DBMS → Normalization 2

Batch processing is appropriate if
none of the options
click to copy
In an Entity-Relationship Diagram “Diamonds” represents
relationship sets
click to copy

DBMS → Functional Dependency 2

Large collection of files are called
database
click to copy
Which algebra is widely used in DBMS?
relational algebra
click to copy

DBMS → SQL Basics 2

A transparent DBMS
keeps its physical structure hidden from users
click to copy
In DBMS FD stands for _______
functional dependency
click to copy

DBMS → DDL Commands 2

A file produced by a spreadsheet
is generally stored on disk in an ascii text fromat
click to copy
A relation that has no partial dependencies is in which normal form
second
click to copy

DBMS → DML Commands 2

The model for a record management system might be
all of the options
click to copy
A functional dependency between two or more non-key attributes is called
transitive dependency
click to copy

DBMS → Joins 2

Database management systems are intended to
all of the options
click to copy
A logical description of some portion of database that is required by a user to perform task is called as
user view
click to copy

DBMS → Views 2

The language used application programs to request data from the DBMS is referred to as the
dml
click to copy
A transaction completes its execution is said to be
committed
click to copy

DBMS → Indexes 2

A set of programs that handle a firm's database responsibilities is called
all of the options
click to copy
A                  in a table represents a relationship among a set of values.
row
click to copy

DBMS → Transactions 2

In a large DBMS
each user can "see" only a small part of the entire database
click to copy
The term                is used to refer to a row.
tuple
click to copy