CUET 2024 Computer Science Unit 3 - Database Management MCQs

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

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

a.Relations

b.Queries

c.Domains

d.All of the above

2. The term "ODBC" stands for____

a.Oral database connectivity

b.Oracle database connectivity

c.Open database connectivity

d.Object database connectivity

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

a.NUMERIC

b.RAW

c.CHAR

d.VARCHAR

4. Duplication of data is called _________.

a.Consistency

b.Inconsistency

c.Foreign Key

d.Redundancy

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

a.Update

b.None of the above

c.Insert

d.Delete

6. Relationship can be created between

a.two tables only

b.none of the above

c.one table only

d.two or more tables

7. Select “salary” from emp;

a.None of the above

b.will display only particular columns of table emp;

c.will display only salary column of table emp;

d.will display all the records of table emp

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

a.It is a type of system software

b.Both A and C

c.It is a kind of application software

d.It is a kind of general software

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

a.TRUE

b.FALSE

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

a.Date

b.Datestamp

c.Time

d.Timestamp

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

a.Tables

b.Record

c.Fields

d.All of the above

12. Which of the following clause return specific rows?

a.Having

b.Specific

c.Order By

d.Where

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

a.FALSE

b.TRUE

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

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

b.give error

c.display name and three times salary

d.None of the above

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

a.All of the above

b.Alter

c.Delete

d.Create

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

a.Order By

b.Order Asc

c.Where

d.Order Inc

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

a.Reduce Data Redundancy

b.Data Security

c.Sharing of Data

d.Increase Data Inconsistency

18. The term "SQL" stands for

a.Structured query language

b.Server-side query language

c.Sequential query language

d.Standard query language

19. 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 = sal + 15000;

c.update emp set sal = 15000;

d.None of the above

20. _______ is the most common DML command.

a.All of the above

b.Update

c.Select

d.Delete

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

a.Binary Data types

b.Date Time

c.Numeric Data type

d.Alphanumeric Data types

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

a.display all the records of table.

b.display records in increasing order of roll number.

c.both of the above

d.none of the above

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

a.TRUE

b.FALSE

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

a.TRUE

b.FALSE

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

a.Same

b.Unique

c.Common

d.None of the above

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

a.more than 3

b.1

c.3

d.2

27. DBA stands for?

a.Database Administration

b.Data Administrator

c.Database Administrator

d.Data Administration

28. A database is an organized collection of _______________.

a.Record

b.None of the above

c.data

d.Attributes

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

a.FALSE

b.TRUE

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

a.Foreign Key

b.Primary Key

c.First Primary Key

d.Alternate Key

31. Pickling refers to

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

b.converting the structure to a csv filve

c.converting the structure to a file in text file

d.converting the structure to a file in unicode

32. We can ______ data in table.

a.delete

b.all of the above

c.modify

d.insert

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

a.Records

b.Table

c.Database

d.Fields

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

a.Rollno

b.Class

c.Section

d.Name

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

a.modify

b.delete

c.update

d.select

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

a.All of the above

b.Entity

c.Tuples

d.Degree

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

a.Composite Key

b.Alternate Key

c.Foreign Key

d.Primary Key

38. SQL stands for _________________

a.Structured Query Lang

b.None of the above

c.Structured Query Language

d.Structured Queue Language

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

General

Important Days

CBSE School Lessons

Popular Pages

Entrance Exams

Top Entrance Exams

Admission Information

Career and Jobs

Education India