CUET 2024 Computer Science Unit 3 - Database Management MCQs

Computer Science Unit 3 – Database Management MCQ Question Answers for CUET 2024

1. The term "SQL" stands for

a.Sequential query language

b.Structured query language

c.Server-side query language

d.Standard query language

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

a.Order By

b.Where

c.Order Asc

d.Order Inc

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

a.modify

b.select

c.delete

d.update

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

a.Record

b.Fields

c.Tables

d.All of the above

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

a.Datestamp

b.Time

c.Date

d.Timestamp

6. Select “salary” from emp;

a.will display only particular columns of table emp;

b.will display all the records of table emp

c.will display only salary column of table emp;

d.None of the above

7. We can ______ data in table.

a.insert

b.all of the above

c.delete

d.modify

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

a.FALSE

b.TRUE

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

a.Primary Key

b.Alternate Key

c.Foreign Key

d.Composite Key

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

a.Alternate Key

b.First Primary Key

c.Foreign Key

d.Primary Key

11. Relationship can be created between

a.two tables only

b.two or more tables

c.none of the above

d.one table only

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

a.Delete

b.Create

c.All of the above

d.Alter

13. Which of the following clause return specific rows?

a.Where

b.Order By

c.Specific

d.Having

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

a.TRUE

b.FALSE

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

a.None of the above

b.display name and three times salary

c.give error

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

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

a.Class

b.Name

c.Rollno

d.Section

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

a.Domains

b.Queries

c.Relations

d.All of the above

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

a.display records in increasing order of roll number.

b.none of the above

c.display all the records of table.

d.both of the above

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

a.Delete

b.Update

c.Insert

d.None of the above

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

a.TRUE

b.FALSE

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

a.more than 3

b.1

c.2

d.3

22. Duplication of data is called _________.

a.Inconsistency

b.Foreign Key

c.Redundancy

d.Consistency

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

a.NUMERIC

b.CHAR

c.VARCHAR

d.RAW

24. _______ is the most common DML command.

a.Select

b.All of the above

c.Update

d.Delete

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

a.Database

b.Fields

c.Table

d.Records

26. The term "ODBC" stands for____

a.Oracle database connectivity

b.Object database connectivity

c.Oral database connectivity

d.Open database connectivity

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

a.Tuples

b.All of the above

c.Degree

d.Entity

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

a.FALSE

b.TRUE

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

a.Reduce Data Redundancy

b.Increase Data Inconsistency

c.Sharing of Data

d.Data Security

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

a.Alphanumeric Data types

b.Date Time

c.Numeric Data type

d.Binary Data types

31. Pickling refers to

a.converting the structure to a file in unicode

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

c.converting the structure to a file in text file

d.converting the structure to a csv filve

32. A database is an organized collection of _______________.

a.Record

b.Attributes

c.data

d.None of the above

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

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

a.Unique

b.Same

c.None of the above

d.Common

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

a.FALSE

b.TRUE

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

a.update emp set sal = 15000;

b.update emp set sal = sal + 15000;

c.None of the above

d.update set sal = sal + 15000;

37. SQL stands for _________________

a.Structured Query Lang

b.Structured Query Language

c.None of the above

d.Structured Queue Language

38. DBA stands for?

a.Database Administrator

b.Database Administration

c.Data Administration

d.Data Administrator

Also Check out Related CUET Computer Science MCQs Links
Computer Science UNIT 1 – Computational Thinking and Programming – 2 MCQs

Computer Science Unit 2 – Computer Networks MCQs

CUET 2024 Computer Science Unit 3 – Database Management MCQ Question Answers – MCQs for Practice

Computer Science Unit 3 – Database Management MCQ Question Answers for CUET 2024

Submit a Comment Cancel reply

Latest Posts

CBSE School Lessons

Popular Pages

Entrance Exams

Top Entrance Exams

Admission Information

Career and Jobs

Education India