Database Management MCQ Class 12 Computer Science Unit 3 MCQs Question and Answers

Database Management MCQ Question Answers suitable for CUET 2026 from Class 12 Computer Science Unit 3

To score full marks in the CUET 2026 Computer Science exam, Practice Class 12 Computer Science Unit 3 Database Management MCQ Test any number of times free on our website. These questions have been created by our experts from the latest Class 12 Computer Science Syllabus and as per latest exam pattern. Multiple Choice Questions (MCQs) are a type of objective assessment in which a person is asked to choose one or more correct answers from a list of available options. An MCQ presents a question along with several possible answers. Most of the exams in India including the CUET exam conduct an online test to check your knowledge.

Class 12 Computer Science Unit 3 MCQs

Please wait...

1. Which of the following is not the date time data types?

a.Time

b.Datestamp

c.Date

d.Timestamp

 Loading...

2. Which data type will be appropriate to store information as Salary, Fees, Price etc

a.Date Time

b.Alphanumeric Data types

c.Binary Data types

d.Numeric Data type

 Loading...

3. _______ is the most common DML command.

a.Select

b.Update

c.Delete

d.All of the above

 Loading...

4. Select “salary” from emp;

a.None of the above

b.will display all the records of table emp

c.will display only salary column of table emp;

d.will display only particular columns of table emp;

 Loading...

5. A Database Management System is a type of _________software.

a.It is a kind of general software

b.It is a type of system software

c.It is a kind of application software

d.Both A and C

 Loading...

6. Which of the following will help to maintain unique record in the table?

a.Alternate Key

b.Primary Key

c.Composite Key

d.Foreign Key

 Loading...

7. SQL stands for _________________

a.Structured Query Lang

b.None of the above

c.Structured Queue Language

d.Structured Query Language

 Loading...

8. The term "ODBC" stands for____

a.Oracle database connectivity

b.Object database connectivity

c.Oral database connectivity

d.Open database connectivity

 Loading...

9. Pickling refers to

a.converting the structure to a byte stream before working to the file

b.converting the structure to a file in unicode

c.converting the structure to a file in text file

d.converting the structure to a csv filve

 Loading...

10. Which of the following is not the advantage of database?

a.Data Security

b.Increase Data Inconsistency

c.Reduce Data Redundancy

d.Sharing of Data

 Loading...

11. In primary key we can enter NULL values.(T/F)

a.TRUE

b.FALSE

 Loading...

12. select * from Stud order by “Rollno” ASC;

a.both of the above

b.display records in increasing order of roll number.

c.display all the records of table.

d.none of the above

 Loading...

13. Command to increase the salary of all employees by 15000.(table name emp and column name sal)

a.update emp set sal = sal + 15000;

b.None of the above

c.update set sal = sal + 15000;

d.update emp set sal = 15000;

 Loading...

14. ________ are the basic building blocks of a database.

a.All of the above

b.Fields

c.Tables

d.Record

 Loading...

15. Which of the following clause return records in ascending order?

a.Where

b.Order By

c.Order Asc

d.Order Inc

 Loading...

16. A database can have only one table.(T/F)

a.TRUE

b.FALSE

 Loading...

17. Which one of the following commands is used to delete the existing row in a table?

a.Delete

b.None of the above

c.Insert

d.Update

 Loading...

18. A field which is ______ for each and every record is called Primary key.

a.Common

b.Same

c.None of the above

d.Unique

 Loading...

19. Duplicate values can be entered in primary key.(T/F)

a.FALSE

b.TRUE

 Loading...

20. Which one of the following is a type of Data Manipulation Command?

a.Create

b.All of the above

c.Delete

d.Alter

 Loading...

21. Which datatype can store unstructured data in a column?

a.CHAR

b.RAW

c.VARCHAR

d.NUMERIC

 Loading...

22. A database is an organized collection of _______________.

a.Record

b.data

c.Attributes

d.None of the above

 Loading...

23. In a table we can have only ______ primary key.

a.1

b.3

c.2

d.more than 3

 Loading...

24. All the values in ________ are of same type.

a.Records

b.Database

c.Table

d.Fields

 Loading...

25. DBA stands for?

a.Data Administrator

b.Database Administrator

c.Database Administration

d.Data Administration

 Loading...

26. Which of the following is suitable to act as a primary key in table student?

a.Class

b.Name

c.Rollno

d.Section

 Loading...

27. The term "SQL" stands for

a.Server-side query language

b.Standard query language

c.Sequential query language

d.Structured query language

 Loading...

28. In a relation database, every tuple divided into the fields are known as the______.

a.Domains

b.All of the above

c.Queries

d.Relations

 Loading...

29. Queries are commands that are used to define the structure and modify the data in a table.(T/F)

a.TRUE

b.FALSE

 Loading...

30. Which command is used to modify data in a table?

a.modify

b.select

c.update

d.delete

 Loading...

31. Select “empname”, “salary” * 3 from emp;

a.give error

b.None of the above

c.display name and three times salary

d.will increase the salary three times of all employees in table

 Loading...

32. Rows of a relation are known as the _______.

a.Degree

b.All of the above

c.Entity

d.Tuples

 Loading...

33. Which of the following clause return specific rows?

a.Where

b.Having

c.Order By

d.Specific

 Loading...

34. Relationship can be created between

a.one table only

b.none of the above

c.two tables only

d.two or more tables

 Loading...

35. A key which is referring to the primary key of another table is called _______

a.Primary Key

b.First Primary Key

c.Foreign Key

d.Alternate Key

 Loading...

36. Duplication of data is called _________.

a.Foreign Key

b.Consistency

c.Inconsistency

d.Redundancy

 Loading...

37. We can ______ data in table.

a.modify

b.delete

c.insert

d.all of the above

 Loading...

38. A record in table is also known as Attribute.(T/F)

a.FALSE

b.TRUE

 Loading...

 Loading...

 

To summarize, revising for free using our MCQs on Class 12 Computer Science Unit 3 Database Management is highly beneficial for scoring full marks on the CUET 2026 Computer Science exam. We provide a sophisticated online test platform tailored for unlimited practice through proficiently crafted questions built on the most recent syllabus and exam pattern. Practicing MCQs regularly will boost conceptual understanding as they are significant for objective assessments. Start practicing now to succeed in your CUET 2026 Computer Science exam!

Also Check out Related CUET Computer Science MCQs Links

• Computational Thinking and Programming MCQ Class 12 Computer Science Unit 1
• Computer Networks MCQ Class 12 Computer Science Unit 2