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

VPD provides authorization at the level of specific tuples, or rows, of a relation, and is therefore said to be a                             mechanism.
row-level authorization
click to copy
                   is the time from when a read or write request is issued to when data transfer begins.
access time
click to copy
Which one of the following is not a secondary storage?
ram
click to copy

DBMS → ER Model 3

                       is widely used today for protecting data in transit in a variety of applications such as data transfer on the Internet, and on cellular phone networks.
encryption
click to copy
The time for repositioning the arm is called the                  and it increases with the distance that the arm must move.
seek time
click to copy
Which level of RAID refers to disk mirroring with block striping?
raid level 1
click to copy

DBMS → Relational Model 3

In a database where the encryption is applied the data is cannot be handled by the unauthorised user without
decryption key
click to copy
                   is around one-half of the maximum seek time.
average seek time
click to copy
A unit of storage that can store one or more records in a hash file organization is denoted as
buckets
click to copy

DBMS → Normalization 3

Which of the following is not a property of good encryption technique?
none of the mentioned
click to copy
Hybrid disk drives are hard-disk systems that combine magnetic storage with a smaller amount of flash memory, which is used as a cache for frequently accessed data.
disk drivers
click to copy
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

DBMS → Functional Dependency 2

In which of the following encryption key is used to encrypt and decrypt the data?
symmetric key
click to copy
Optical disk technology uses
raid
click to copy

DBMS → SQL Basics 2

Encryption of small values, such as identifiers or names, is made complicated by the possibility of                      
dictionary attacks
click to copy
With multiple disks, we can improve the transfer rate as well by                        data across multiple disks.
striping
click to copy

DBMS → DDL Commands 2

Which one of the following uses a 128bit round key to encrypt the data using XOR and use it in reverse to decrypt it?
advanced encryption standard
click to copy
                             partitions data and parity among all N+1 disks, instead of storing data in N-disks and parity in one disk.
block interleaved distributed parity
click to copy

DBMS → DML Commands 2

Which of the following requires no password travel across the internet?
challenge–response system
click to copy
The RAID level which mirroring is done along with stripping is
both raid 1+0 and raid 0
click to copy

DBMS → Joins 2

The                    is the fastest and most costly form of storage, which is relatively small; its use is managed by the computer system hardware.
cache
click to copy
Where performance and reliability are both important, RAID level          is used.
0+1
click to copy

DBMS → Views 2

Which of the following stores several gigabytes of data but usually lost when power failure?
main memory
click to copy
                       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

DBMS → Indexes 2

The flash memory storage used are
nor flash
click to copy
                             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

DBMS → Transactions 2

                     is increasingly being used in server systems to improve performance by caching frequently used data, since it provides faster access than disk, with larger storage capacity than main memory.
flash memory
click to copy
Tertiary storage is built with :
removable media
click to copy

DBMS → Concurrency Control 2

The primary medium for the long-term online storage of data is the                       where the entire database is stored on magnetic disk.
magnetic disks
click to copy
Operating system is responsible for
all of the mentioned
click to copy

DBMS → Deadlock 2

Optical disk                systems contain a few drives and numerous disks that can be loaded into one of the drives automatically (by a robot arm) on demand.
jukebox
click to copy
A typical tape drive is                  a typical disk drive.
more expensive than
click to copy

DBMS → Database Security 2

There are “record-once” versions of the compact disk and digital video disk, which can be written only once; such disks are also called                      disks.
write-once, read-many (worm)
click to copy
During recovery from a failure
each pair of physical block is examined
click to copy

DBMS → PL/SQL 2

In magnetic disk                  stores information on a sector magnetically as reversals of the direction of magnetization of the magnetic material.
disk arm
click to copy
A magneto-optic disk is :
tertiary storage
click to copy

DBMS → Introduction to DBMS 2

A                      is the smallest unit of information that can be read from or written to the disk.
sector
click to copy
The replacement of a bad block generally is not totally automatic because
data in bad block is usually lost
click to copy

DBMS → Database Architecture 2

The disk controller uses                  at each sector to ensure that the data is not corrupted on data retrieval.
checksum
click to copy
The surface area of a tape is                  the surface area of a disk.
much larger than
click to copy