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

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

To score full marks in the CUET 2025 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. ________ are the basic building blocks of a database.

a.All of the above

b.Record

c.Tables

d.Fields

 Loading...

2. Duplication of data is called _________.

a.Consistency

b.Foreign Key

c.Redundancy

d.Inconsistency

 Loading...

3. Select “salary” from emp;

a.will display all the records of table emp

b.will display only salary column of table emp;

c.will display only particular columns of table emp;

d.None of the above

 Loading...

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

a.Order Asc

b.Where

c.Order Inc

d.Order By

 Loading...

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

a.FALSE

b.TRUE

 Loading...

6. Which of the following clause return specific rows?

a.Having

b.Order By

c.Where

d.Specific

 Loading...

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

a.both of the above

b.display all the records of table.

c.display records in increasing order of roll number.

d.none of the above

 Loading...

8. DBA stands for?

a.Data Administrator

b.Database Administrator

c.Database Administration

d.Data Administration

 Loading...

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

a.Fields

b.Table

c.Database

d.Records

 Loading...

10. _______ is the most common DML command.

a.Select

b.All of the above

c.Update

d.Delete

 Loading...

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

a.FALSE

b.TRUE

 Loading...

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

a.Data Security

b.Sharing of Data

c.Increase Data Inconsistency

d.Reduce Data Redundancy

 Loading...

13. SQL stands for _________________

a.Structured Queue Language

b.Structured Query Language

c.None of the above

d.Structured Query Lang

 Loading...

14. A database is an organized collection of _______________.

a.Record

b.data

c.Attributes

d.None of the above

 Loading...

15. The term "ODBC" stands for____

a.Object database connectivity

b.Open database connectivity

c.Oral database connectivity

d.Oracle database connectivity

 Loading...

16. Relationship can be created between

a.one table only

b.two or more tables

c.none of the above

d.two tables only

 Loading...

17. 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...

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

a.Datestamp

b.Time

c.Date

d.Timestamp

 Loading...

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

a.All of the above

b.Degree

c.Entity

d.Tuples

 Loading...

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

a.Insert

b.None of the above

c.Update

d.Delete

 Loading...

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

a.None of the above

b.give error

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

d.display name and three times salary

 Loading...

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

a.Numeric Data type

b.Binary Data types

c.Date Time

d.Alphanumeric Data types

 Loading...

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

a.Both A and C

b.It is a kind of application software

c.It is a type of system software

d.It is a kind of general software

 Loading...

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

a.Common

b.None of the above

c.Unique

d.Same

 Loading...

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

a.3

b.1

c.more than 3

d.2

 Loading...

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

a.All of the above

b.Relations

c.Queries

d.Domains

 Loading...

27. Pickling refers to

a.converting the structure to a file in text file

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

c.converting the structure to a file in unicode

d.converting the structure to a csv filve

 Loading...

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

a.select

b.delete

c.update

d.modify

 Loading...

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

a.update set sal = sal + 15000;

b.update emp set sal = 15000;

c.update emp set sal = sal + 15000;

d.None of the above

 Loading...

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

a.TRUE

b.FALSE

 Loading...

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

a.Class

b.Rollno

c.Name

d.Section

 Loading...

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

a.TRUE

b.FALSE

 Loading...

33. The term "SQL" stands for

a.Sequential query language

b.Standard query language

c.Server-side query language

d.Structured query language

 Loading...

34. We can ______ data in table.

a.delete

b.modify

c.all of the above

d.insert

 Loading...

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

a.Alter

b.Delete

c.All of the above

d.Create

 Loading...

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

a.FALSE

b.TRUE

 Loading...

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

a.NUMERIC

b.CHAR

c.VARCHAR

d.RAW

 Loading...

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

a.Foreign Key

b.Composite Key

c.Primary Key

d.Alternate Key

 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 2025 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 2025 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