2nd Year Computer Chapter 2 MCQs with Answers

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

Related Articles