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 → DDL Commands 3

The                                  is essentially used to search for patterns in target string.
like predicate
click to copy
Copying files to secondary or specific devices is known as              
backup
click to copy
Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?
two phase lock
click to copy

DBMS → DML Commands 3

                         is a combination of two of more attributes used as a primary key
composite key
click to copy
Which are types of recovery control techniques:
all of the mentioned
click to copy
A system is in a              state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.
deadlock
click to copy

DBMS → Joins 3

Which of the following is not the function of client?
query optimization
click to copy
Which server can join the indexes when only multiple indexes combined can cover the query:
sql
click to copy
The deadlock state can be changed back to stable state by using                             statement.
rollback
click to copy

DBMS → Views 3

                         is a special type of stored procedure that is automatically invoked whenever the data in the table is modified.
trigger
click to copy
In concurrency control policy the lock is obtained on
entire database
click to copy
What are the ways of dealing with deadlock?
all of the mentioned
click to copy

DBMS → Indexes 2

                             requires that data should be made available to only authorized users.
security
click to copy
A concurrency-control policy such as this one leads to              performance since it forces transactions to wait for preceding transactions to finish before they can start.
poor
click to copy

DBMS → Transactions 2

                         allows individual row operation to be performed on a given result set or on the generated by a selected by a selected statement.
curser
click to copy
                     are used to ensure that transactions access each data item in order of the transactions’          if their accesses conflict.
timestamps
click to copy

DBMS → Concurrency Control 2

Which s essential a business problem not a data problem:
database design
click to copy
In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?
to create a grouping for expressions or columns specified within a group by clause in one direction, from right to left for calculating the subtotals
click to copy

DBMS → Deadlock 2

McFadden has defined normalization in his which book                       
modern database management
click to copy
Which statement is true regarding external tables?
the create table as select statement can be used to unload data into regular table in the database from an external table
click to copy

DBMS → Database Security 2

The database design prevents some data from being represented due to                
insertion anomalies
click to copy
SNAPSHOT is used for (DBA)
dynamic data replication
click to copy

DBMS → PL/SQL 2

How many types of insertion anomalies:
2
click to copy
Isolation of the transactions is ensured by
concurrency control
click to copy

DBMS → Introduction to DBMS 2

Who developed the normalization process:
e.f. codd
click to copy
Which of the following statements is/are not true for SQL profiler?
check the performance of a stored procedure
click to copy

DBMS → Database Architecture 2

E.F.Codd developed the normalization process in the which early:
1970
click to copy
Which of the following is the original purpose of SQL?
all of the mentioned
click to copy

DBMS → Data Models 2

Which is the process of breaking a relation into multiple relations:
decomposition
click to copy
SQL can be used to:
all of the mentioned
click to copy

DBMS → ER Model 2

Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:
deadlock
click to copy
A lock that allows concurrent transactions to access different rows of the same table is known as a
row-level lock
click to copy

DBMS → Relational Model 2

Which is a duplicate copy of a file program that is stored on a different storage media than the original location:
backup
click to copy
Which of the following are introduced to reduce the overheads caused by the log- based recovery?
checkpoints
click to copy

DBMS → Normalization 2

Which is the duplication of computer operations and routine backups to combat any unforeseen problems:
recovery
click to copy
Which of the following protocols ensures conflict serializability and safety from deadlocks?
time-stamp ordering protocol
click to copy

DBMS → Functional Dependency 2

Optimization basically related to the Rewrite module is termed as               
semantic query optimization
click to copy
Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other
concurrency
click to copy

DBMS → SQL Basics 2

Database security helps organizations to protect data from            
external users
click to copy
The          lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.
field-level
click to copy