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 → Concurrency Control 3

Which of the following is not a restriction for a table to be a relation?
The columns must be ordered.
click to copy
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 3

For some relations, changing the data can have undesirable consequences called:
Modification anomalies.
click to copy
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 3

If attributes A and B determine attribute C, then it is also true that:
(A, B) is a composite determinant.
click to copy
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 3

If attribute A determines both attributes B and C, then it is also true that:
A → B
click to copy
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

One solution to the multivalued dependency constraint problem is to:
split the relation into two relations, each with a single theme
click to copy
PJNF stands form:
Project –join normal form
click to copy

DBMS → Database Architecture 2

FD stands for:
Functional dependency
click to copy
Which forms are based on the concept of functional dependency
3NF
click to copy

DBMS → Data Models 2

In which model of database data is stored in tables:
Relational model
click to copy
The DBMS utility, ____________ allows to reconstruct the correct state of database from the backup and history of transactions.
Recovery
click to copy

DBMS → ER Model 2

How many types of keys in relation database design:
All of these
click to copy
In the ........... normal form, a composite attribute is converted to individual attributes.
First
click to copy

DBMS → Relational Model 2

Which key is referencing a primary key in a table:
Foreign key
click to copy
In RDBMS, Data is presented as a collection of ............
Relations
click to copy

DBMS → Normalization 2

In which ways two tables may be related:
All of these
click to copy
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

DBMS → Functional Dependency 2

Which rules are defined in relational models they from as an essential part of any relation database:
Integrity rules
click to copy
To select all column from the table the syntax is:
Select * from table_name
click to copy

DBMS → SQL Basics 2

Which are the types of integrity rule:
Referential integrity
click to copy
____ 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

DBMS → DDL Commands 2

______states that primary keys should not be null:
Entity integrity
click to copy
Deadlocks are possible only when one of the transactions wants to obtain a(n) ____ lock on a data item.
exclusive
click to copy

DBMS → DML Commands 2

Which command creates database objects like tables, views and indexes:
Create command
click to copy
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

DBMS → Joins 2

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

DBMS → Views 2

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

DBMS → Indexes 2

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

DBMS → Transactions 2

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