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

Which command enables alteration the data stored in existing records:
Update command
click to copy
A DBMS uses a transaction ____ to keep track of all transactions that update the database
log
click to copy
................. requires that data should be made available to only authorized users.
Security
click to copy

DBMS → Views 3

Which are the dependencies types:
All of these
click to copy
When a program is abnormally terminated, the equivalent of a ____ command occurs.
COMMIT
click to copy
.............. is a combination of two of more attributes used as a primary key
Composite Key
click to copy

DBMS → Indexes 3

FDs are the types of constraints that are based on______:
Key
click to copy
In a(n) ____ backup of the database, only the last modifications to the database are copied.
differential
click to copy
To delete a database ................... command is used
drop database database_name
click to copy

DBMS → Transactions 3

In decomposition technique of splitting a relation into_____ relation:
TWO or MORE
click to copy
Although the ____ locking approach improves the availability of data, its management requires high overhead.
row-level
click to copy
Some of the utilities of DBMS are ............. i) Transaction ii) Backup iii) File organization iv) Process Organization
ii, iii and iv only
click to copy

DBMS → Concurrency Control 2

Consequently R.Boyce-Codd jointly launched powerful definition for the third normal form called______:
Boyce-Codd normal form
click to copy
A(n) ____ lock exists when concurrent transactions are granted Read access on the basis of a common lock.
shared
click to copy

DBMS → Deadlock 2

BCNF stands for:
Boyce-Codd normal form
click to copy
A ____ database state is one in which all data integrity constraints are satisfied.
consistent
click to copy

DBMS → Database Security 2

Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:
1NF
click to copy
The ____ statement is used to end a successful transaction.
COMMIT
click to copy

DBMS → PL/SQL 2

Which forms every non-prime attribute is fully dependent functionally on the candidate key of a relational schema:
2NF
click to copy
____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
Isolation
click to copy

DBMS → Introduction to DBMS 2

PJNF stands form:
Project –join normal form
click to copy
The three basic techniques to control deadlocks are: deadlock ____, deadlock detection, and deadlock avoidance.
prevention
click to copy

DBMS → Database Architecture 2

Which forms are based on the concept of functional dependency
3NF
click to copy
All transactions are controlled and executed by the DBMS (subject to some limitations) to guarantee database ____.
integrity
click to copy

DBMS → Data Models 2

The DBMS utility, ____________ allows to reconstruct the correct state of database from the backup and history of transactions.
Recovery
click to copy
In a ____ lock, the DBMS will lock an entire disk page.
page-level
click to copy

DBMS → ER Model 2

In the ........... normal form, a composite attribute is converted to individual attributes.
First
click to copy
According to the ANSI SQL standard, when does a transaction begin?
when the first SQL statement is encountered
click to copy

DBMS → Relational Model 2

In RDBMS, Data is presented as a collection of ............
Relations
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

DBMS → Normalization 2

A .................. normal form, normalization will be needed where all attributes in a relation are not functionally dependent only on the key attribute.
Third
click to copy
What is ACID properties
All of the above
click to copy

DBMS → Functional Dependency 2

To select all column from the table the syntax is:
Select * from table_name
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

____ ensures that once transaction changes are done, they cannot be undone or lost, even in the event of a system failure.
Durability
click to copy
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

DBMS → DDL Commands 2

Deadlocks are possible only when one of the transactions wants to obtain a(n) ____ lock on a data item.
exclusive
click to copy
............... joins are SQL server default
Inner
click to copy

DBMS → DML Commands 2

If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.
isolation
click to copy
The ..................... is essentially used to search for patterns in target string.
Like Predicate
click to copy