You can get 2nd Year Computer Chapter 2 MCQs with Answers on this page. Tackle MCQs to test your core concepts from Chapter 2 (Basic Concepts and Terminology of Databases) and confidently prepare for your exams! All the correct answers have been bold.
12th Class Chapter 2 Computer Science MCQS
Here is the 12th computer science chapter 2 mcqs with answers:
1. The number of characters in the fixed-length field is:
a. Constant
b. Variable
c. 10
d. 100
2. The number of characters in the variable-length field is:
a. Constant
b. Variable
c. 10
d. 100
3. The columns of a table correspond to:
a. Table
b. Record
c. Field
d. Cell
4. A two-dimensional array of data is called:
a. Group
b. Set
c. Module
d. Relation
5. A table is a two-dimensional structure that consists of:
a. x and y coordinates
b. Matrix elements
c. Rows and columns
d. Intersection of data
6. A relation is also known as:
a. Table
b. Tuple
c. Relationship
d. Attribute
7. Attribute is also known as a:
a. Table
b. Relation
c. Row
d. Field
8. Arow of a relation is also called:
a. Attribute
b. Entity B
c. Tuple
d. a and c
9. A person, place, thing, or event about which data is kept in the database is called:
a. Attribute
b. Field
c. Record
d. Entity
10. The data or information that describes an entity is called:
a. Attribute
b. Data item
c. Record
d. Tuple
11. In a relational database, a single piece of information is called:
a. Table
b. Record
c. Entity
d. Aty
12. Which of the following is NOT a characteristic of relations?
a. Each row is unique
b. The order of columns is significant
c. The order of rows is insignificant
d. Columns are all elemental or atomic
13. The rows of a relation can be of ____order
a. Any
b. Same
c. Sorted
d. Constant
14. The columns of a relation can be of order,
a. Any
b. Same
c. Sorted
d. Constant
15. All the intersections of rows and columns must have:
a. Single value
b. Constant value
c. Multiple values
d. Numeric value
16. A virtual table that is constructed from other tables is called:
a. Table
b. View
c. Relation
d. Tuple
17. CREATE command is used to create:
a. Record
b. View
c. Report
d. Query
18. Views are also called:
a. Complex tables
b. Simple tables
c. Virtual tables
d. Actual Tables
19. The SQL statement to create a view is:
a. CREATE VIEW
b. MAKE VIEW
c. SELECT VIEW
d. INSERT VIEW
20. The views are used:
a. To hide columns
b. To hide rows
c. To hide complex SQL statements
d. All
21. An index can be used to:
a. Improve the performance of the database
b. Document the structure of the database
c. Reduce data dependency for application programs
d.All
22. Which of the following is not a type of database key?
a. Primary key
b. Foreign key
c. Secondary key
d. Public key
23. A key is:
a. A field that identifies a record
b. The most important field in a record
c. The first field of a relation
d. The last field of relation
24. A table must have:
a. Primary key
b. Secondary key
c. Composite key
d. Sort key
25. Each primary key value in a table must be:
a. Unique
b. Numeric value
c. The first field in a table
d. Alphabetic value
26. Which of the following is NOT a good primary key?
a. Social Security number
b. Order number
c. Zip code
d. Student ID number
27. How many primary keys can a table have?
a. 1
b. 1 or 2
c. 1 to 5
28. Which of the following can be a primary key?
a. Last name
b. Salary
c. Customer ID
d. Region
29. Which field is the most appropriate primary key?
a. Name
b. NIC Number
c. Birth date
d. Address
30. A primary key that consists of more than one attribute is called:
a. Foreign key
b. Composite key
c. Multivalued key
d. Candidate key
