Computer Science Unit 3 - Database Management MCQs

Computer Science Unit 3 – Database Management MCQ Question Answers for Various Entrance Exams

1. DBA stands for?

a.Database Administration

b.Data Administrator

c.Database Administrator

d.Data Administration

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

a.3

b.2

c.more than 3

d.1

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

a.FALSE

b.TRUE

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

a.Order Inc

b.Order By

c.Order Asc

d.Where

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

a.Time

b.Timestamp

c.Datestamp

d.Date

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

a.Fields

b.All of the above

c.Tables

d.Record

7. We can ______ data in table.

a.modify

b.all of the above

c.delete

d.insert

8. Relationship can be created between

a.none of the above

b.two or more tables

c.one table only

d.two tables only

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

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

a.TRUE

b.FALSE

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

a.NUMERIC

b.CHAR

c.VARCHAR

d.RAW

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

a.modify

b.select

c.delete

d.update

13. Duplication of data is called _________.

a.Redundancy

b.Inconsistency

c.Consistency

d.Foreign Key

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

a.FALSE

b.TRUE

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

a.Unique

b.Common

c.Same

d.None of the above

16. A database is an organized collection of _______________.

a.data

b.Attributes

c.None of the above

d.Record

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

a.Primary Key

b.Composite Key

c.Alternate Key

d.Foreign Key

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

a.Sharing of Data

b.Increase Data Inconsistency

c.Reduce Data Redundancy

d.Data Security

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

a.TRUE

b.FALSE

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

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

a.It is a kind of application software

b.It is a kind of general software

c.Both A and C

d.It is a type of system software

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

23. The term "SQL" stands for

a.Server-side query language

b.Sequential query language

c.Standard query language

d.Structured query language

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

a.TRUE

b.FALSE

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

a.Delete

b.All of the above

c.Create

d.Alter

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

a.Records

b.Table

c.Fields

d.Database

27. SQL stands for _________________

a.Structured Query Language

b.None of the above

c.Structured Query Lang

d.Structured Queue Language

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

a.Numeric Data type

b.Date Time

c.Alphanumeric Data types

d.Binary Data types

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

a.None of the above

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

c.display name and three times salary

d.give error

30. Which of the following clause return specific rows?

a.Specific

b.Where

c.Having

d.Order By

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

a.None of the above

b.Update

c.Delete

d.Insert

32. 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;

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

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

a.All of the above

b.Domains

c.Queries

d.Relations

35. _______ is the most common DML command.

a.Select

b.Update

c.Delete

d.All of the above

36. The term "ODBC" stands for____

a.Open database connectivity

b.Oral database connectivity

c.Object database connectivity

d.Oracle database connectivity

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

a.Entity

b.Tuples

c.All of the above

d.Degree

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

a.Name

b.Rollno

c.Section

d.Class

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

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

Computer Science Unit 3 – Database Management MCQ Question Answers for Various Entrance Exams

Submit a Comment Cancel reply

Latest Posts

Other Exams

CBSE School Lessons

Entrance Exams

Top Entrance Exams

Admission Information

Career and Jobs

Education India

Popular Pages