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

The data in the database at a particular moment in time is called a ________________
Database state
click to copy
The method of access which uses key transformation is known as
Hashing
click to copy
A relation is considered a:
Two dimensional table
click to copy

DBMS → Views 3

Which is a DBMS keeps back-up copies of the database:
Backup
click to copy
The statement in SQL which allows to change the definition of a table is
Alter
click to copy
In the relational model, relationships between relations or tables are created by using:
Foreign keys
click to copy

DBMS → Indexes 3

In which the database can be restored up to the last consistent state after the system failure:
Recovery
click to copy
This is not a date type in SQL Server 2000
String
click to copy
A functional dependency is a relationship between or among:
Attributes
click to copy

DBMS → Transactions 3

How many levels of abstraction in DBMS:
3
click to copy
Which of the following is NOT a basic element of all versions of the E-R model?
Primary key
click to copy
Table is synonymous with the term:
Relation
click to copy

DBMS → Concurrency Control 2

Which are the three levels of abstraction:
All of these
click to copy
The SQL command to creating a table is:
Create table
click to copy

DBMS → Deadlock 2

How many types of data independence:
2
click to copy
----------- is a virtual table
View
click to copy

DBMS → Database Security 2

Which are the types of data independence:
Both
click to copy
The DROP TABLE statement:
Deletes the table structure along with the table data
click to copy

DBMS → PL/SQL 2

Which is the transformation of requests and results between different levels of abstraction:
Mapping
click to copy
The SQL statement to create a view is:
CREATE VIEW
click to copy

DBMS → Introduction to DBMS 2

Which mapping exists between the conceptual and internal levels:
Both
click to copy
Which of the following is NOT a type of SQL constraint?
ALTERNATE KEY
click to copy

DBMS → Database Architecture 2

Which mapping exists between the external and conceptual levels:
Both
click to copy
The following are functions of a DBMS except ________
creating and processing forms
click to copy

DBMS → Data Models 2

The related and interconnected software components of a DBMS are described by the _______:
Both
click to copy
What SQL structure is used to limit column values of a table?
The CHECK constraint
click to copy

DBMS → ER Model 2

Which are the types of physical DBMS architecture can be split :
Both
click to copy
Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
A → B
click to copy

DBMS → Relational Model 2

The DML is called:
Sublanguages
click to copy
The different classes of relations created by the technique for preventing modification anomalies are called:
Normal forms.
click to copy

DBMS → Normalization 2

The overall description of a database is called______:
Database schema
click to copy
A relation is in this form if it is in BCNF and has no multivalued dependencies:
Fourth normal form.
click to copy

DBMS → Functional Dependency 2

Which is proper subset designed to support ‘views’ belonging to different classes of users in order to hid or protect information:
Subschema
click to copy
Row is synonymous with the term:
Record
click to copy

DBMS → SQL Basics 2

A data dictionary is a repository that manages _____:
Metadata
click to copy
The primary key is selected from the:
Candidate keys
click to copy

DBMS → DDL Commands 2

A tuple is a(n):
row of a table
click to copy
Which of the following is a group of one or more attributes that uniquely identifies a row?
Key
click to copy

DBMS → DML Commands 2

An attribute is a(n):
column of a table
click to copy
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Referential integrity constraint.
click to copy