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 → Introduction to DBMS 3

Which of the following is a Data Model?
all of the above
click to copy
The descriptive property possessed by each entity set is _________
Attribute
click to copy
Entity Relationship model consists of collection of basic objects called _________ and relationship among these objects.
entities
click to copy

DBMS → Database Architecture 3

A collection of related data.
Database
click to copy
The function that an entity plays in a relationship is called that entity’s _____________
Role
click to copy
Which of the following gives a logical structure of the database graphically?
Entity-relationship diagram
click to copy

DBMS → Data Models 3

DBMS is software.
TRUE
click to copy
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
Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality
One to one
click to copy

DBMS → ER Model 3

DBMS manages the interaction between __________ and database.
End Users
click to copy
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
We indicate roles in E-R diagrams by labeling the lines that connect ___________ to __________
Diamond, rectangle
click to copy

DBMS → Relational Model 2

Which of the following is not involved in DBMS?
HTML
click to copy
_____________ can help us detect poor E-R design.
Functional dependencies
click to copy

DBMS → Normalization 2

Database is generally __________
User-centered
click to copy
If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.
Both A many-to-many relationship set and A multivalued attribute of an entity set
click to copy

DBMS → Functional Dependency 2

A characteristic of an entity.
Attribute
click to copy
Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
A many-to-many relationship set
click to copy

DBMS → SQL Basics 2

The restrictions placed on the data.
Constraint
click to copy
In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
A multivalued attribute of an entity set
click to copy

DBMS → DDL Commands 2

IMS stands for?
Information Management System
click to copy
Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by
Unique-role assumption
click to copy

DBMS → DML Commands 2

A model developed by Hammer and Mc Leod in 1981.
SDM
click to copy
Designers use which of the following to tune the performance of systems to support timecritical operations?
Denormalization
click to copy

DBMS → Joins 2

Object=_________+relationships.
entity
click to copy
In the schema (dept name, size) we have relations total inst 2007, total inst 200Q:8) Which dependency have lead to this relation ?
Dept name, year->size
click to copy

DBMS → Views 2

Duplication of data at several places is called as _______________.
Data Redundance
click to copy
Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
BCNF
click to copy

DBMS → Indexes 2

Data Redundancy increases the cost of storing and retrieving data.
TRUE
click to copy
Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
Snapshot
click to copy

DBMS → Transactions 2

Which of the information is not redundant.
account-no
click to copy
Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.
Cross-tabs
click to copy

DBMS → Concurrency Control 2

If in redundant file common fields are not matching then it results in _____________.
Data Inconsistency
click to copy
Data Model is collection of conceptual tools for describing -
All of these
click to copy

DBMS → Deadlock 2

It is difficult to access conventional file system than Database System.
TRUE
click to copy
Data Models in DBMS are classified into ______ categories.
5
click to copy

DBMS → Database Security 2

An ________ is a set of entities of the same type that share the same properties, or attributes.
Entity set
click to copy
Object based logical model(s) are used to describe data at - [Select Appropriate Option(s)]
Physical Level
click to copy

DBMS → PL/SQL 2

Entity is a _________
Thing in real world
click to copy
Which of the following is example of Object based logical model ?
Entity Relationship Model
click to copy