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 → Joins 3

Where performance and reliability are both important, RAID level          is used.
0+1
click to copy
Large collection of files are called
database
click to copy
In case the buffer manager do not write the blocks properly then the buffer manager uses
crash recovery system
click to copy

DBMS → Views 3

                       is popular for applications such as storage of log files in a database system since it offers the best write performance.
raid level 1
click to copy
Which of these is not a feature of Hierarchical model?
child node can have any number of parent nodes
click to copy
The technique where the blocks which have been used are replaced is called
most recently used
click to copy

DBMS → Indexes 3

                             which increases the number of I/O operations needed to write a single logical block, pays a significant time penalty in terms of write performance.
raid level 1
click to copy
Which of these data models is an extension of the relational data model?
object-relational data model
click to copy
                                       frees the space occupied by a block as soon as the final tuple of that block has been processed.
toss immediate strategy
click to copy

DBMS → Transactions 3

Tertiary storage is built with :
removable media
click to copy
The information about data in a database is called                
metadata
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 → Concurrency Control 2

Operating system is responsible for
all of the mentioned
click to copy
A data dictionary is a special file that contains?
all of the mentioned
click to copy

DBMS → Deadlock 2

A typical tape drive is                  a typical disk drive.
more expensive than
click to copy
The DBMS acts as an interface between what two components of an enterprise-class database system?
database application and the database
click to copy

DBMS → Database Security 2

During recovery from a failure
each pair of physical block is examined
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

A magneto-optic disk is :
tertiary storage
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

The replacement of a bad block generally is not totally automatic because
data in bad block is usually lost
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

The surface area of a tape is                  the surface area of a disk.
much larger than
click to copy
A tablespace is further broken down into
segments
click to copy

DBMS → Data Models 2

Which one of the following is not a secondary storage?
ram
click to copy
                     is a contiguous group of
database
click to copy

DBMS → ER Model 2

Which level of RAID refers to disk mirroring with block striping?
raid level 1
click to copy
                 is the smallest unit of allocation in an Oracle database.
database block
click to copy

DBMS → Relational Model 2

A unit of storage that can store one or more records in a hash file organization is denoted as
buckets
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

The file organization which allows us to read records that would satisfy the join condition by using one block read is
clustering file organization
click to copy
The                is that part of main memory available for storage of copies of disk blocks.
buffer
click to copy

DBMS → Functional Dependency 2

What are the correct features of a distributed database?
users see the data in one global schema.
click to copy
A major goal of the database system is to minimize the number of block transfers between the disk and memory. This is achieved by
buffer
click to copy

DBMS → SQL Basics 2

Each tablespace in an Oracle database consists of one or more files called
datafiles
click to copy
The subsystem responsible for the allocation of buffer space is called the
buffer manager
click to copy

DBMS → DDL Commands 2

Choose the RDBMS which supports full fledged client server application development
oracle 7.1
click to copy
In the buffer where there is no space for another block, the block can be inserted using
buffer replacement strategy
click to copy

DBMS → DML Commands 2

An audit trail                        
is the recorded history of operations performed on a file
click to copy
A block that is not allowed to be written back to disk is said to be                              
pinned
click to copy