DBMS Basics Mcqs

Our collections of Multiple choice questions and answers focuses on study of DBMS Basics. These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate DBMS Basics comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. DBMS Basics Mcqs

Computer MCQS

Sciences MCQS

1.
Package of software that facilitate modeling of database and improved performance of database system is classified as

Tools

Tool developers

Programmers

System tools

Answer Discus (0)

2.
Parts of an operation or function must includes

Storage capacity

Implementation

Interface

Both a and b

Answer Discus (0)

3.
Name of operation and type of data of parameters must be included in

Interface or signature

User friendly signature

Conceptual signature

Logical signature

Answer Discus (0)

4.
Function which causes retrieval of any kind of data from database is considered as

Key

Query

Structure

Storing cycle

Answer Discus (0)

5.
Type data abstraction which allows conceptual representation of data in database management system is considered as

Logical design model

Data model

Interface model

User friendly model

Answer Discus (0)

6.
Implications of database management approaches includes

Flexibility

Economies of scale

Reduced development time

All of theses

Answer Discus (0)

7.
Standardized types of database queries and methods of updating database are called

Canned transactions

Occasional transactions

Conceptual transactions

Answer Discus (0)

8.
Type of constraints that specifies uniqueness of data stored in database are considered as

Semantics

Business rules

Controlled rules

Structural rules

Answer Discus (0)

9.
Collection of known and useful raw facts that has some meaning and can be processed in useful way is classified as

Management oriented facts

Updated facts

Data

Recorded facts

Answer Discus (0)

10.
Usage of operations with help of arguments without considering structure of operation implementation is classified as

Program operation independence

Program operation dependence

Interface implementation independence

Program structural independence

Answer Discus (0)

11.
Type of application program which controls all task from order processing to customer support functions is classified as

Enterprise record management

Customer services application

Customer relationship management

Customer information management

Answer Discus (0)

12.
Users who access database occasionally but need different information every time are classified as

Isolated users

Occasional users

Logical users

Casual end users

Answer Discus (0)

13.
Files used for speedy disk search by providing specialized structures of data are classified as

Indexes

Glossaries

Content specification

Listing documents

Answer Discus (0)

14.
Type of function which allows performing additional operations and sending messages to other tables in database program is considered as

Trigger

Semantics

Index

Structure

Answer Discus (0)

15.
Characteristic of database management system which allows program operation independence and program data independence is classified as

Conceptual abstraction

Implementation abstraction

Data abstraction

Interface abstraction

Answer Discus (0)

Engineering MCQS

General Subjects MCQS

0Shares
0
Scroll to Top