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 → Data Models 3

When the                      the backup site takes over processing and becomes the primary.
primary fails
click to copy
DBMS is a collection of ………….. that enables user to create and maintain a database.
Programs
click to copy
The number of tuples in a relation is called it’s …………. While the number of attributes in a relation is called it’s ………………..
Cardinality, Degree
click to copy

DBMS → ER Model 3

The simplest way of transferring control is for the old primary to receive                       from the old backup site.
primary logs
click to copy
In a relational schema, each tuple is divided into fields called
Domains
click to copy
State true or false. i) Select operator is not a unary operator. ii) Project operator chooses subset of attributes or columns of a relation.
i-False, ii-True
click to copy

DBMS → Relational Model 3

The time to process the remote backup can be reduced by
checkpoints
click to copy
In an ER model, ……………. is described in the database by storing its data.
Entity
click to copy
…………… database is used as template for all databases created.
Model
click to copy

DBMS → Normalization 3

A                                configuration can make takeover by the backup site almost instantaneous.
spare
click to copy
DFD stands for
Data Flow Diagram
click to copy
One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values can be assigned to each data items. This is referred to as
Domain Integrity
click to copy

DBMS → Functional Dependency 2

A transaction commits as soon as its commit log record is written to stable storage at the primary site. This is
one safe
click to copy
……………… table store information about database or about the system.
System
click to copy

DBMS → SQL Basics 2

A transaction commits as soon as its commit log record is written to stable storage at the primary and the backup site. This is
two-very safe
click to copy
…………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Schema
click to copy

DBMS → DDL Commands 2

If only the primary is active, the transaction is allowed to commit as soon as its commit log record is written to stable storage at the primary site. This is
two safe
click to copy
……………… clause is an additional filter that is applied to the result.
Having
click to copy

DBMS → DML Commands 2

Which of the following is not a Schema?
Critical Schema
click to copy
A logical schema
is a standard way of organizing information into accessible parts.
click to copy

DBMS → Joins 2

The number of entities associated in relationship is called as it’s.....................
Degree
click to copy
………………… is a full form of SQL.
Structured query language
click to copy

DBMS → Views 2

The DBMS utility...................... allows reconstructing the correct state of database from the backup and history of transactions.
Recovery
click to copy
The candidate key is that you choose to identify each row uniquely is called ……………..
Primary Key
click to copy

DBMS → Indexes 2

In the........... Normal form, a composite attribute is converted to individual attributes.
First
click to copy
…………….. is used to determine whether of a table contains duplicate rows.
Unique predicate
click to copy

DBMS → Transactions 2

In RDBMS, Data is presented as a collection of............
Relations
click to copy
To eliminate duplicate rows ……………… is used
DISTINCT
click to copy

DBMS → Concurrency Control 2

A .................. normal form, normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.
Third
click to copy
State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
i-true, ii-true
click to copy

DBMS → Deadlock 2

To select all columns from the table the syntax is:
Select * from table_name
click to copy
DCL stands for
Data Control Language
click to copy

DBMS → Database Security 2

If an attribute of a composite key is dependent on an attribute of the other composite key, normalization called ................ is needed.
BCNF
click to copy
…………………… is the process of organizing data into related tables.
Normalization
click to copy

DBMS → PL/SQL 2

Identify the criteria for designing database from the point of view of user
All of the above
click to copy
A ………………. does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.
Weak entity
click to copy

DBMS → Introduction to DBMS 2

The ............ operator preserves unmatched rows of the relations being joined.
Outer join
click to copy
…………….. is the complex search criteria in the where clause.
Predicate
click to copy

DBMS → Database Architecture 2

Which are the not user in End-user:
All of these
click to copy
………………… is preferred method for enforcing data integrity
Constraints
click to copy