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 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
Which rules are defined in relational models they from as an essential part of any relation database:
Integrity rules
click to copy

DBMS → SQL Basics 3

A data dictionary is a repository that manages _____:
Metadata
click to copy
The primary key is selected from the:
Candidate keys
click to copy
Which are the types of integrity rule:
Referential integrity
click to copy

DBMS → DDL Commands 3

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
______states that primary keys should not be null:
Entity integrity
click to copy

DBMS → DML Commands 3

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

DBMS → Joins 2

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 2

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 2

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 2

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

The SQL command to creating a table is:
Create table
click to copy
Which of the following is not a restriction for a table to be a relation?
The columns must be ordered.
click to copy

DBMS → Deadlock 2

----------- is a virtual table
View
click to copy
For some relations, changing the data can have undesirable consequences called:
Modification anomalies.
click to copy

DBMS → Database Security 2

The DROP TABLE statement:
Deletes the table structure along with the table data
click to copy
If attributes A and B determine attribute C, then it is also true that:
(A, B) is a composite determinant.
click to copy

DBMS → PL/SQL 2

The SQL statement to create a view is:
CREATE VIEW
click to copy
If attribute A determines both attributes B and C, then it is also true that:
A → B
click to copy

DBMS → Introduction to DBMS 2

Which of the following is NOT a type of SQL constraint?
ALTERNATE KEY
click to copy
One solution to the multivalued dependency constraint problem is to:
split the relation into two relations, each with a single theme
click to copy

DBMS → Database Architecture 2

The following are functions of a DBMS except ________
creating and processing forms
click to copy
FD stands for:
Functional dependency
click to copy

DBMS → Data Models 2

What SQL structure is used to limit column values of a table?
The CHECK constraint
click to copy
In which model of database data is stored in tables:
Relational model
click to copy

DBMS → ER Model 2

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
How many types of keys in relation database design:
All of these
click to copy

DBMS → Relational Model 2

The different classes of relations created by the technique for preventing modification anomalies are called:
Normal forms.
click to copy
Which key is referencing a primary key in a table:
Foreign key
click to copy

DBMS → Normalization 2

A relation is in this form if it is in BCNF and has no multivalued dependencies:
Fourth normal form.
click to copy
In which ways two tables may be related:
All of these
click to copy