12th class (Fsc) computer unit 2 MCQs
chapter 2 MCQs 12th Class computer
Basics Concepts and Terminology of Databases:
1. Insert command is used to insert:
a. A view
b. A new table
c. Dependencies
d. A new record
2. CREATE command is used to create a:
a. Report
b. Table
c. Query
d. View
3. A logical grouping of characters is a:
a. File
b. Filed
c. Record
d. All
4. In relational database, a single piece of information is called:
a. Entity
b. Field
c. Attribute
d. Record
5. Insert command is used to insert:
a. A view
b. A new record
c. A new table
d. A new column
6. Which of the following is used to describe the characteristics of an object?
a. Cardinality
b. Modality
c. Entity
d. Attribute
7. Which of the following is correct association?
a. Field = row
b. File = column
c. Record = table
d. Record = row
8. An attribute is also known as a:
a. Row
b. Table
c. Field
d. Relation
9. A category of data or information that describes an entity is called a(n):
a. Record
b. Attribute
c. Tuple
d. Data item
10. A table is perceived as two-dimensional structure composed of:
a. Rows and columns
b. X and Y coordinates
c. Intersection of data
d. Matrix elements
11. A row of a relation is called a(n):
a. Attribute
b. Entity
c. Tuple
d. Both A & C
12. A data or information that describes an entity is called:
a. Record
b. Attribute
c. Tuple
d. Data item
13. Every relation should have:
a. Secondary key
b. Primary key
c. Mutually key
d. Candidate key
14. The row of relation can be of ……… order.
a. Sorted
b. Any
c. Constant
d. Same
15. A relation is analogous to a:
a. Record
b. Table
c. Row
d. Field
16. Which of the following is degree of a table?
a. Total number of cells
b. Total number of rows
c. Total number of foreign keys
d. Total number of columns
17. The row of table is also called:
a. Cell
b. Entity
c. Record
d. Attributes
18. A relation is also known as:
a. Relationship
b. Table
c. Attribute
d. Tuple
19. The columns of a table correspond to:
a. Field
b. Table
c. Cell
d. Record
20. Which of the following is not included in the definition of entity?
a. Concept
b. Person
c. Action
d. Object
21. Which of the following is used to associate entities with one another?
a. Identifier
b. Entity
c. Relationship
d. Attribute
22. In MS Access, table contains:
a. Character
b. Fields
c. File
d. Record
23. A person, place, thing, event or condition about which data is kept in the database is called:
a. Record
b. Attribute
c. Entity
d. Field
24. Which of the following is not a general characteristic of relations?
a. The order of rows is insignificant
b. Each row is unique
c. Columns are all elemental or atomic
d. The order of columns is significant
25. A two-dimensional table of data is called a:
a. Declaration
b. Group
c. Relation
d. Set