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 → Concurrency Control 3

There are _________ number of Normal forms that has been defined
6
click to copy
What scheme defines how and where the data are organized in a physical data storage?
External
click to copy
DBMS stands for________________?
Database Management Systems
click to copy

DBMS → Deadlock 3

Which is relation calculus:
Both
click to copy
Which of the following schemas defines the stored data structures in terms of the database model used?
Conceptual
click to copy
What is the name of the system database that contains descriptions of the data in the database?
Data dictionary
click to copy

DBMS → Database Security 3

Which calculus is based on specifying a number of tuple variables:
Tuple relation calculus
click to copy
Which of the following schemas defines a view or views of the database for particular users?
Conceptual
click to copy
IMS stands for ___________
Information Management System
click to copy

DBMS → PL/SQL 3

SQL outputs a single table known as the ______:
Result set
click to copy
A collection of data designed to be used by different people is called.
Database
click to copy
Which category of users need not be aware of the presence of the database system?
Naive
click to copy

DBMS → Introduction to DBMS 2

Which of the following is related to information?
Data
click to copy
Which of the following is an object-oriented feature?
Abstraction
click to copy

DBMS → Database Architecture 2

Data is:
A piece of fact
click to copy
A physical data models are used to
All of these
click to copy

DBMS → Data Models 2

Which of the following is element of the database?
All of these.
click to copy
Which data model organizes the data in the form of tables and relations?
Relational Model
click to copy

DBMS → ER Model 2

What represent a correspondence between the various data elements?
Relationships
click to copy
Which company has developed the hierarchical model?
IBM
click to copy

DBMS → Relational Model 2

Which of the following is an advantage of using database system?
All of these.
click to copy
The name of the system database that contains descriptions of data in the database is
Metadata
click to copy

DBMS → Normalization 2

Which of the following is characteristic of the data in a database?
All of these.
click to copy
System catalog is a system-created database that describes:
All of these
click to copy

DBMS → Functional Dependency 2

Relationships could be of the following type:
All of these.
click to copy
Following is the type of metadata:
All of these
click to copy

DBMS → SQL Basics 2

In a file-oriented system there is:
Al of these.
click to copy
What is refined data?
Information
click to copy

DBMS → DDL Commands 2

In a database system there is:
All of these.
click to copy
Which of the following is a database element?
All of the above
click to copy

DBMS → DML Commands 2

VDL is used to specify:
None of these.
click to copy
What defines how and where data are organized in physical data storage?
Internal schema
click to copy

DBMS → Joins 2

The DML provides following functional access to the database:
Add (or insert) records
click to copy
What defines a view or views of the database for particular users?
External schema
click to copy

DBMS → Views 2

4GL has the following components inbuilt in it:
All of these.
click to copy
To access information from a database, you need a ___________
DBMS
click to copy

DBMS → Indexes 2

Which of the following is database element?
All of these.
click to copy
Which of the following is an advantage of a database?
All of the above
click to copy

DBMS → Transactions 2

What separates the physical aspects of data storage from the logical aspects of data representation?
Relationships
click to copy
Which of the following is an example of a database application?
All of the above
click to copy