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 queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?
select job, sum(sal) from emp where comm is null group by job having sum(sal) > 2500;
click to copy
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 3

Which of the following data structure is not linear data structure?
none of the mentioned
click to copy
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 3

Which of the following data structure is linear data structure?
arrays
click to copy
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 3

The operation of processing each element in the list is known as
traversal
click to copy
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

Finding the location of the element with a given value is:
search
click to copy
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

DBMS → Views 2

Arrays are best data structures
for relatively permanent collections of data
click to copy
Which of the following stores several gigabytes of data but usually lost when power failure?
main memory
click to copy

DBMS → Indexes 2

Linked lists are best suited
for the size of the structure and the data in the structure are constantly changing
click to copy
The flash memory storage used are
nor flash
click to copy

DBMS → Transactions 2

Each array declaration need not give, implicitly or explicitly, the information about
the first data from the set to be stored
click to copy
                     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

DBMS → Concurrency Control 2

In                                    attacks, the attacker manages to get an application to execute an SQL query created by the attacker.
sql injection
click to copy
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

DBMS → Deadlock 2

A Web site that allows users to enter text, such as a comment or a name, and then stores it and later display it to other users, is potentially vulnerable to a kind of attack called a                                        attack.
cross-site scripting
click to copy
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

DBMS → Database Security 2

                   is an attack which forces an end user to execute unwanted actions on a web application in which he/she is currently authenticated.
cross-site request forgery
click to copy
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

DBMS → PL/SQL 2

A single                              further allows the user to be authenticated once, and multiple applications can then verify the user’s identity through an authentication service without requiring reauthentication.
sign-on system
click to copy
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

DBMS → Introduction to DBMS 2

The                                        is a standard for exchanging authentication and authorization information between different security domains, to provide cross- organization single sign-on.
security assertion markup language (saml)
click to copy
A                      is the smallest unit of information that can be read from or written to the disk.
sector
click to copy

DBMS → Database Architecture 2

                               allows a system administrator to associate a function with a relation; the function returns a predicate that must be added to any query that uses the relation.
virtual private database (vpd)
click to copy
The disk controller uses                  at each sector to ensure that the data is not corrupted on data retrieval.
checksum
click to copy

DBMS → Data Models 2

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

DBMS → ER Model 2

                       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

DBMS → Relational Model 2

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

DBMS → Normalization 2

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