CUET 2024 Computer Science Unit 3 - Database Management MCQs

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

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

a.Fields

b.All of the above

c.Record

d.Tables

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

a.FALSE

b.TRUE

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

a.both of the above

b.none of the above

c.display all the records of table.

d.display records in increasing order of roll number.

4. Select “salary” from emp;

a.will display all the records of table emp

b.will display only particular columns of table emp;

c.None of the above

d.will display only salary column of table emp;

5. 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.None of the above

d.update emp set sal = sal + 15000;

6. The term "SQL" stands for

a.Sequential query language

b.Server-side query language

c.Structured query language

d.Standard query language

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

a.Rollno

b.Name

c.Class

d.Section

8. Duplication of data is called _________.

a.Redundancy

b.Foreign Key

c.Consistency

d.Inconsistency

9. _______ is the most common DML command.

a.All of the above

b.Delete

c.Update

d.Select

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

a.Tuples

b.Degree

c.All of the above

d.Entity

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

a.Alphanumeric Data types

b.Binary Data types

c.Numeric Data type

d.Date Time

12. The term "ODBC" stands for____

a.Open database connectivity

b.Oracle database connectivity

c.Oral database connectivity

d.Object database connectivity

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

a.FALSE

b.TRUE

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

a.Datestamp

b.Date

c.Time

d.Timestamp

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

a.display name and three times salary

b.None of the above

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

d.give error

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

a.Foreign Key

b.Alternate Key

c.First Primary Key

d.Primary Key

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

a.2

b.3

c.1

d.more than 3

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

a.TRUE

b.FALSE

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

a.It is a kind of application software

b.It is a type of system software

c.It is a kind of general software

d.Both A and C

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

a.modify

b.delete

c.update

d.select

21. SQL stands for _________________

a.Structured Query Language

b.Structured Query Lang

c.Structured Queue Language

d.None of the above

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

a.Reduce Data Redundancy

b.Data Security

c.Increase Data Inconsistency

d.Sharing of Data

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

a.FALSE

b.TRUE

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

a.Common

b.Same

c.Unique

d.None of the above

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

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

a.TRUE

b.FALSE

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

a.All of the above

b.Alter

c.Delete

d.Create

28. A database is an organized collection of _______________.

a.None of the above

b.data

c.Record

d.Attributes

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

a.RAW

b.VARCHAR

c.CHAR

d.NUMERIC

30. Relationship can be created between

a.none of the above

b.two tables only

c.two or more tables

d.one table only

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

a.Order By

b.Where

c.Order Asc

d.Order Inc

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

a.Queries

b.All of the above

c.Domains

d.Relations

33. Pickling refers to

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

b.converting the structure to a file in text file

c.converting the structure to a file in unicode

d.converting the structure to a csv filve

34. DBA stands for?

a.Database Administrator

b.Data Administrator

c.Database Administration

d.Data Administration

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

36. Which of the following clause return specific rows?

a.Having

b.Order By

c.Where

d.Specific

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

a.Fields

b.Database

c.Records

d.Table

38. We can ______ data in table.

a.delete

b.insert

c.modify

d.all of the above

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