Basic Concepts and Terminology of Database | MCQs - Quiz

Basic Concepts and Terminology of Database | MCQs - Quiz. Find the most important and more conceptual multiple-choice questions (MCQs) with answers of Computer, ICS Part-II on the database management system (DBMS) for the interview and final examinations of intermediate for all boards of Pakistan and entry test for admission in universities i.e., ECAT.

 

We tried our best to provide the most important and best multiple-choice questions (MCQs) from this chapter named Basic Concepts and Terminology of Database. This post covers the topics i.e., database, field, record, file, data handling in file management systems, attributes, rows, tables, data element, tuples, relations, entity, properties of relation, views, indexes, keys (i.e., primary key, secondary key, candidate key / alternate key, composite key, concatenate key, sort/control key, and foreign key), the end user, the data administrator, and the database administrator.

➤ Basic Concepts & Terminology of Databases - Short Questions
➤ Data Basics - MCQs
➤ Data Basics - Short Questions
➤ Getting Started with C - MCQs
➤ Getting Started with C - Short Questions
➤ Elements of C - MCQs
➤ Elements of C - Short Questions
➤ Input/Output - MCQs
➤ Input/Output - Short Questions
➤ Input/Output - Exercise Programs
➤ Decision Constructs - MCQs
➤ Decision Constructs - Short Questions
➤ Decision Constructs - Exercise Programs
➤ Loop Constructs - MCQs
➤ Loop Constructs - Exercise Solution
➤ Loop Constructs - Short Questions
➤ Functions in C - MCQs
➤ Functions in C - Short Questions
➤ Functions in C - Exercise Programs
➤ File Handling - Short Questions
➤ File Handling - Short Questions

Chapter No.2: 

Basic Concepts & Terminology of Database

Database MCQs | Online Quiz

 

1. By default which of the followings value is stored in a cell?
   1.   random
   2.   null
   3.   zero
   4.   no value is entered
2. Followings is true about a relation except?
   1.   all records must be unique
   2.   the order of rows must be insignificant
   3.   each cell must contain atomic value
   4.   the order of columns must be significant
3. Followings is true about primary key except?
   1.   it can have identical values
   2.   these uniquely identify the records of database
   3.   these must be unique
   4.   it must be one in a table
4. In database, teacher is an example of?
   1.   record
   2.   primary key
   3.   object
   4.   entity
5. On hard disk, data is stored in the form of?
   1.   high level language
   2.   machine language
   3.   assembly language
   4.   structured query language
6. Storage of same data at more than one places results in?
   1.   data integrity
   2.   data integration
   3.   data redundancy
   4.   all of these
7. The ascending order of data hierarchy in a database is?
   1.   bit-byte-field-record-file-database
   2.   byte-bit-field-record-file-database
   3.   bit-byte-record-field-file-database
   4.   bit-byte-field-record-database-file
8. The collection of one or more __ results in a record?
   1.   characters
   2.   fields
   3.   files
   4.   none of these
9. The concatenate key is also called?
   1.   primary key
   2.   composite key
   3.   candidate key
   4.   foreign key
10. The control key is used to?
    1.   sort data
    2.   store data
    3.   define data
    4.   all of these
11. The fields of a relation are stored in?
    1.   rows
    2.   columns
    3.   records
    4.   none of these
12. The INSERT command is used to insert?
    1.   new table
    2.   view
    3.   new record
    4.   none of these
13. The key create links between?
    1.   reports
    2.   records
    3.   relations
    4.   none of these
14. The key which can represent uniqueness of a row but is not acting as primary key?
    1.   secondary key
    2.   rare key
    3.   candidate key
    4.   none of these
15. The person who shares development of logical design and establishes data standards?
    1.   end user
    2.   database admin
    3.   data admin
    4.   none of these
16. The SELECT command is used to select?
    1.   record from a table
    2.   report from a table
    3.   field from table
    4.   none of these
17. The table containing the foreign key refers to?
    1.   parent table
    2.   primary table
    3.   dependant table
    4.   none of these
18. The table pointing to foreign key is called?
    1.   parent table
    2.   grand table
    3.   child table
    4.   none of these
19. The value of foreign key must match with ___ value?
    1.   primary key
    2.   candidate key
    3.   composite key
    4.   none of these
20. Which of the followings can be used to create a view?
    1.   report generator
    2.   DBMS
    3.   SQL
    4.   none of these
21. Which of the followings can be used to improve data retrieval operations?
    1.   query
    2.   index
    3.   view
    4.   none of these
22. Which of the followings can be used to secure data from unauthorized access?
    1.   query
    2.   view
    3.   DBMS
    4.   none of these
23. Which of the followings is an advantage of variable length field?
    1.   fast access
    2.   good response time
    3.   no memory wastage
    4.   all of these
24. Which of the followings is most appropriate for primary key?
    1.   teacher name
    2.   physician address
    3.   student id
    4.   none of these
25. Which of the followings person must be technically expert in DBMS?
    1.   data admin
    2.   end user
    3.   database admin
    4.   all of these