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 → Indexes 3

Entity is a                    
thing in real world
click to copy
We indicate roles in E-R diagrams by labeling the lines that connect                         to                      
diamond, rectangle
click to copy
Key to represent relationship between tables is called
foreign key
click to copy

DBMS → Transactions 3

The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
composite attribute
click to copy
An entity set that does not have sufficient attributes to form a primary key is termed a
weak entity set
click to copy
A window into a portion of a database is
view
click to copy

DBMS → Concurrency Control 3

The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is
derived
click to copy
Weak entity set is represented as
double diamond
click to copy
A primary key is combined with a foreign key creates
parent-child relation ship between the tables that connect them
click to copy

DBMS → Deadlock 3

Not applicable condition can be represented in relation entry as
null
click to copy
If you were collecting and storing information about your music collection, an album would be considered a(n)            
entity
click to copy
The entity set person is classified as student and employee. This process is called
specialization
click to copy

DBMS → Database Security 2

Which of the following can be a multivalued attribute?
phone_number
click to copy
What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?
instance
click to copy

DBMS → PL/SQL 2

Which of the following is a single valued attribute
register_number
click to copy
Which one of the following can be treated as a primary key in teaches relation?
id
click to copy

DBMS → Introduction to DBMS 2

In a relation between the entities the type and condition of the relation should be specified. That is called as            attribute.
desciptive
click to copy
The primary key in the section relation is
both course_id and sec_id
click to copy

DBMS → Database Architecture 2

                           express the number of entities to which another entity can be associated via a relationship set.
mapping cardinality
click to copy
The relation with primary key can be created using
create table instructor (id, name, primary key (id))
click to copy

DBMS → Data Models 2

An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as
one-to-one
click to copy
How can the values in the relation teaches be deleted?
delete from teaches;
click to copy

DBMS → ER Model 2

An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A.
many-to-one
click to copy
In the above teaches relation ” Select * from teaches where Year = ‘2010’” displays how many rows?
2
click to copy

DBMS → Relational Model 2

Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of:
data integrity constraints
click to copy
The relation changes can be got back using                  command
flashback
click to copy

DBMS → Normalization 2

Which of the following can be addressed by enforcing a referential integrity constraint?
information on the customer must be known before anything can be sold to that customer
click to copy
Let us consider phone_number ,which can take single or several values . Treating phone_numberas an                    permits instructors to have several phone numbers (including zero) associated with them.
entity
click to copy

DBMS → Functional Dependency 2

             is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
referential integrity constraints
click to copy
The total participation by entities is represented in E-R diagram as
double line
click to copy

DBMS → SQL Basics 2

Which one of the following uniquely identifies the elements in the relation?
primary key
click to copy
Given the basic ER and relational models, which of the following is INCORRECT?
in a row of a relational table, an attribute can have more than one value
click to copy

DBMS → DDL Commands 2

Drop Table cannot be used to drop a table referenced by a                    constraint.
foreign key
click to copy
Which of the following indicates the maximum number of entities that can be involved in a relationship?
maximum cardinality
click to copy

DBMS → DML Commands 2

                         is preferred method for enforcing data integrity
constraints
click to copy
In E-R diagram generalization is represented by
triangle
click to copy

DBMS → Joins 2

The entity relationship set is represented in E-R diagram as
diamond
click to copy
What is a relationship called when it is maintained between two entities?
binary
click to copy

DBMS → Views 2

The Rectangles divided into two parts represents
entity set
click to copy
Which of the following is a low level operator?
directory
click to copy