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 → Relational Model 3

The name of the system database that contains descriptions of data in the database is
Metadata
click to copy
The following are components of a database except ________
Reports
click to copy
The database schema is written in
DDL
click to copy

DBMS → Normalization 3

System catalog is a system-created database that describes:
All of these
click to copy
An application where only one user accesses the database at a given time is an example of a(n) ________ .
single-user database application
click to copy
Who developed SEQUEL?
Chamberlain
click to copy

DBMS → Functional Dependency 3

Following is the type of metadata:
All of these
click to copy
An on-line commercial site such as Amazon.com is an example of a(n) ________ .
e-commerce database application
click to copy
Which of the following is used to get all the columns of a table?
*
click to copy

DBMS → SQL Basics 3

What is refined data?
Information
click to copy
SQL stands for ________ .
Structured Query Language
click to copy
The first commercial RDBMS is:
INGRESS
click to copy

DBMS → DDL Commands 2

Which of the following is a database element?
All of the above
click to copy
Because it contains a description of its own structure, a database is considered to be ________
self-describing
click to copy

DBMS → DML Commands 2

What defines how and where data are organized in physical data storage?
Internal schema
click to copy
The following are functions of a DBMS except ________ .
creating and processing forms
click to copy

DBMS → Joins 2

What defines a view or views of the database for particular users?
External schema
click to copy
Helping people keep track of things is the purpose of a(n) ________ .
Database
click to copy

DBMS → Views 2

To access information from a database, you need a ___________
DBMS
click to copy
A DBMS that combines a DBMS and an application generator is ________ .
Microsoft's Access
click to copy

DBMS → Indexes 2

Which of the following is an advantage of a database?
All of the above
click to copy
Let us consider phone_number ,which can take single or several values . Treating phone_numberasan _________ permits instructors to have several phone numbers (including zero) associated with them.
Relation
click to copy

DBMS → Transactions 2

Which of the following is an example of a database application?
All of the above
click to copy
In an object-oriented model, one object can access data of another object by passing:
Message
click to copy

DBMS → Concurrency Control 2

DBMS stands for________________?
Database Management Systems
click to copy
A view of database that appears to an application program is known as:
Subschema
click to copy

DBMS → Deadlock 2

What is the name of the system database that contains descriptions of the data in the database?
Data dictionary
click to copy
An abstraction concept for building composite object from their component object is called:
Aggregation
click to copy

DBMS → Database Security 2

IMS stands for ___________
Information Management System
click to copy
A set of objects that share a common structure and a common behavior is called:
Class
click to copy

DBMS → PL/SQL 2

Which category of users need not be aware of the presence of the database system?
Naive
click to copy
Every weak entity set can be converted into a strong entity set by:
adding appropriate attributes
click to copy

DBMS → Introduction to DBMS 2

Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
Schema, Instance
click to copy
The number of entities to which another entity can be associated via a relationship set is expressed as:
Cardinality
click to copy

DBMS → Database Architecture 2

Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________ .
Attributes, Relation
click to copy
The view of total database content is
Conceptual view.
click to copy

DBMS → Data Models 2

Department (dept name, building, budget) and Employee (employee_id , name, deptname,salary) Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.
Tuple of distinct
click to copy
The file organization that provides very fast access to any arbitrary record of a file is:
Hashed file
click to copy

DBMS → ER Model 2

Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
DB2
click to copy
What is not true about a view?
It is always updatable like any other table
click to copy