Database Management System (KMBIT04) MCQ

 

DBMS  KMBIT04

Q1. A database is an organized collection of _______________.

a. data

b. Attributes

c. Record

d. None of the above

 

Ans. a (data)

Q2. Which of the following software is appropriate to store data about school students?

a. MS-Access

b. Writer

c. Calc

d. Impress

 

Ans. a. MS-Access

Q3. Which of the following is not a database programs?

a. MySQL

b. Oracle

c. Writer

d. OObase

 

Ans. c. Writer

Q4. __________ store data in Single table.

a. Flat File

b. Relational

c. Single File

d. One File

 

Ans. a. Flat File

Q5. ___________ are dedicated computers that hold the actual databases and run only DBMS and related Software.

a. Main Server

b. Web Server

c. Database Server

d. Non Database Server

 

Ans. c. Database Server

Q6. GUI act as front end and database server act as _____

a. Container

b. Back End

c. End

d. None of the above

 

Ans. b. Back End

Q7. Duplication of data is called _________.

a. Inconsistency

b. Consistency

c. Redundancy

d. Foreign Key

 

Ans. c. Redundancy

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

a. Sharing of Data

b. Reduce Data Redundancy

c. Increase Data Inconsistency

d. Data Security

 

Ans. c. Increase Data Inconsistency

Q9. Data Integrity means that data is accurate and consistent in the database.(T/F)

a. True

b. False

 

Ans. a. True

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

a. True

b. False

 

Ans. b. False

 

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

a. Foreign Key

b. Primary Key

c. Composite Key

d. Alternate Key

 

Ans. b. Primary Key

Q12. Which of the following field of table “Book” can act as primary key?

a. Book_number

b. Subject

c. price

d. Author_name

 

Ans. a. Book_number

Q13. When primary key is made up of two or more columns then it is called __ primary key.

a. Mixed

b. Reference

c. Composite

d. Compost

 

Ans. c. Composite

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

a. True

b. False

 

Ans. False

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

a. Alternate Key

b. Primary Key

c. First Primary Key

d. Foreign Key

 

Ans. d. Foreign Key

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

a. Common

b. Same

c. Unique

d. None of the above

 

Ans. c. Unique

Q17. When data is stored, maintained and retrieved from multiple tables then special database software are required called ______

a. DBMS

b. RDBMS

c. Special DBMS

d. All of the above

 

Ans. b. RDBMS

Q18. Identify the Foreign Key from table “Sales”

Table Client:
ClientID (primary Key)
clientname
clientphone

Table : Sales
SalesID (Primary Key)
ClientID
Profit

a. SalesID

b. Profit

c. Clientphone

d. ClientID

 

Ans. d. ClientID

Q19. Which of the following is not valid field of table “Student”

a. admno

b.name

c. fees

d. salary

 

Ans. d. salary

Q20. There can be multiple primary key in a table.(T/F)

a. True

b. False

 

Ans. False

Q21. In RDBMS, data is organized in the form of __________________

a. Table

b. Record

c. Field

d. None of the above

 

Ans. a. Table

Q22. SQL stands for _________________

a. Structured Queue Language

b. Structured Query Language

c. Structured Query Lang

d. None of the above

 

Ans. b. Structured Query Language

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

a. Records

b. Table

c. Database

d. Fields

 

Ans. d. Fields

Q24. ___________ represent a single data item in a table.

a. Tuples

b. Attributes

c. Relation

d. All of the above

 

Ans. a. Tuples

Q25. In tables, data is organized in the form of rows and columns.(T/F)

a. True

b. False

 

Ans. True

Q26. Every row in a table has the same structure.(T/F)

a. True

b. False

 

Ans. True

Q27. Open Office base is not an open source software.(T/F)

a. True

b. False

 

Ans. False

Q28. _______________ are the basic building blocks of a database.

a. Tables

b. Record

c. Fields

d. All of the above

 

Ans. a. Tables

Q29. We can create table :

a. in design view

b. use Wizard

c. Both of the above

d. None of the above

 

Ans. c. Both of the above

Q30. By default data type of fields is.

a. Text[Varchar]

b. Text[Char]

c. Int

d. Long

 

Ans. a. Text[Varchar]

Q31. Base automatically adds the column as Primary Key if we don’t add.(T/F)

a. True

b. False

 

Ans. True

Q32. By default the length of Varchar data type is __

a. 20

b. 30

c. 40

d. 50

 

Ans d. 50

Q33. By default the name of the table is ______

a. Tab 1

b. Table 1

c. First Table

d. Untitled 1

 

Ans b. Table 1

Q34. __________ are used to identify which type of data we are going to store in the database.

a. Datatype

b. Record

c. Table

d. Attributes

 

Ans. a. Datatype

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

b. Alphanumeric Data types

a. Numeric Data type

c. Binary Data types

d. Date Time

 

Ans a. Numeric Data type

Q36. Which of the following is not a numeric data type?

a. Tinyint

b. Smallint

c. Boolean

d. Date

 

Ans d. Date

Q37. Which of the following data types can not store decimal values?

a. Decimal

b. Real

c. Numeric

d. Boolean

 

Ans d. Boolean

Q38. Which of the following will occupy more space in computer memory?

a. Bigint

b. Integer

c. Smallint

d. Boolean

 

Ans a. Bigint

Q39. _______ data types are used for storing photos, music files etc

a. Binary

b. Alphanumeric

c. Numeric

d. Special

 

Ans a. Binary

Q40. Char is a ______ length data type and varchar is a ______ length data type.

a. Fixed, Variable

b. Variable, Fixed

c. Variable, Variable

d. Fixed, Fixed

 

Ans. a. Fixed, Variable

Q41. Which field is suitable for storing records of employees?

a. EmpNo

b. Empname

c. Salary

d. All of the above

 

Ans. d. All of the above

Q42. Auto Value is a property of __ data type .

a. Numeric

b. Character

c. Binary

d. Date

 

Ans. a. Numeric

Q43. Which of the following property help to set the number of characters in Varchar type.

a. Auto value

b. Required

c. Default Value

d. Length

 

Ans. d. Length

Q44. Which property ensures that field can not be left blank?

a. Entry required

b. Format

c. Required Entry

d. Required

 

Ans. a. Entry required

Q45. By default the length of the Integer data type is ______________

a. 10

b. 15

c. 20

d. 25

 

Ans. a. 10

Q46. Which of the following property to be turned “yes” so that value will be auto incremented?

a. Default

b. Format

c. Auto value

d. Length

 

Ans. c. Auto value

Q47. Which of the following is not the binary data types?

a. Longvarbinary

b. Varbinary

c. Binary

d. Charbinary

 

Ans. d. Charbinary

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

a. Date

b. Time

c. Datestamp

d. Timestamp

 

Ans. c. Datestamp

Q49. Which data type is used to store value of fields like “Date of Birth”?

a. Date Time

b. Varchar

c. Integer

d. Other

 

Ans. a. Date Time

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

a. True

b. False

 

Ans. b. False

Q51. We can ____________________ data in table.

a. modify

b. insert

c. delete

d. all of the above

 

Ans. d. all of the above

Q52. In which view data can be entered in table?

a. Datasheet view

b. Design view

c. Both of the above

d. None of the above

 

Ans. a. Datasheet view

Q53. In which mode we can change the structure of table?

a. Datasheet view

b. Design view

c. Structure view

d. All of the above

 

Ans. b. Design view

Q54. After inserting records in table, we can not modify the structure of table.(T/F)

a. True

b. False

 

Ans. b. False

Q55. Sorting means to arrange data in _______________ order.

a. increasing

b. decreasing

c. increasing or decreasing

d. None of the above

 

Ans. c. increasing or decreasing

Q56. Referential Integrity is used to maintain accuracy and consistency of data in a relationship.(T/F)

a. True

b. False

 

Ans. a. True

Q57. In Base data can be linked between two or more tables with the help of _________________

a. primary key

b. foreign key

c. primary and foreign key

d. None of the above

 

Ans. c. primary and foreign key

Q58. Relationship can be created between

a. two tables only

b. one table only

c. two or more tables

d. none of the above

 

Ans. c. two or more tables

Q59. Relationship between tables can be created from _____________________ menu.

a. View

b. Insert

c. Windows

d. Tools

 

Ans. d. Tools

Q60. There are __________________ types of relationship which can be created between tables.

a. three

b. two

c. four

d. infinite

 

Ans. a. three

Q61. Which language help to extract/fetch data from table?

a. MySQL

b. Python

c. OOBase

d. HTML

 

Ans. a. MySQL

Q62. We can create query (in Open Office Base) in _______________________

a. In design view

b. Using wizard

c. Both of the above

d. None of the above

 

Ans. c. Both of the above

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

a. True

b. False

 

Ans. a. True

Q64. We can not delete the data using queries.(T/F)

a. True

b. False

 

Ans. b. False

Q65. SQL stands for __________________

a. Structural Query Language

b. Structured Query Language

c. Skeletal Query Language

d. None of the above

 

Ans. a. Structural Query Language

Q66. ___________ statement is used to retrieve data from table.

a. Delete

b. Update

c. Print

d. Select

 

Ans. d. Select

Q67. ____________ is the most common DML command.

a. Delete

b. Update

c. Select

d. All of the above

 

Ans. c. Select

Q68. DML stands for ____________

a. Data Manipulation Language

b. Database Manipulation Language

c. Data Modify Language

d. None of the above

 

Ans. a. Data Manipulation Language

Q69. Which of the following clause return specific rows?

a. Order By

b. Where

c. Having

d. Specific

 

Ans. b. Where

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

a. Order By

b. Where

c. Order Asc

d. Order Inc

 

Ans. a. Order By

Q71. Command to display all the data in the table “emp” is.

a. Select * from emp

b. Select * from emp;

c. Select all from emp

d. Select all from emp;

 

Ans. b. Select * from emp;

Q72. Which command is used to create table?

a. Select

b. Create

c. Open

d. New

 

Ans. b. Create

Q73. Shortcut to execute query in Create Query in SQL View is __

a. F7 Key

b. F5 Key

c. F8 Key

d. F6 Key

 

Ans. b. F5 Key

Q74. Which command is used to display the salary of all the employees after incrementing by 1000.

a. Select

b. Update

c. Modify

d. Change

 

Ans. a. Select

Q75. Select “salary” from emp;

a. will display all the records of table emp

b. will display only particular columns of table emp;

c. will display only salary column of table emp;

d. None of the above

 

Ans. c. will display only salary column of table emp;

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

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

b. display name and three times salary

c. give error

d. None of the above

 

Ans. b. display name and three times salary

Q77. To get details about the list of students whose favorite color is blue. Query for this is :

a. select all from Stud where fav_Color=’Blue’;

b. select name from Stud where fav_Color=’Blue’;

c. select * from Stud where fav_Color=’Blue’;

d. select all from Stud where fav_Color is ’Blue’;

 

Ans. c. select * from Stud where fav_Color=’Blue’;

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

 

Ans. b. display records in increasing order of roll number.

Q79. Which command is used to modify data in table?

a. delete

b. select

c. modify

d. update

 

Ans. d. update

Q80. Which command is used to delete data from table?

a. select

b. delete

c. insert

d. remove

 

Ans. b. delete

Q81. Update statement is used to modify data in a table.(T/F)

a. True

b. False

 

Ans. a. True

Q82. 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. update emp set sal = 15000;

c. update set sal = sal + 15000;

d. None of the above

 

Ans. a. update emp set sal = sal + 15000;

Q83. By default data is arranged in _____ order using order by clause.

a. Ascending

b. Descending

c. Primary Key

d. None of the above

 

Ans. a. Ascending

Q84. Which of the following is DML commands?

a. Insert

b. Update

c. Delete

d. All of the above

 

Ans. d. All of the above

Q85. A ________ provides a systematic way of storing information into the database.

a. Report

b. Query

c. Form

d. None of the above

 

Ans. c. Form

Q86. Which of the following act as an interface to view, enter and change data in database?

a. Report

b. Table

c. Query

d. Form

 

Ans. d. Form

Q87. A _____________ helps to display the data in a summarized data.

a. Report

b. Form

c. Query

d. None of the above

 

Ans. a. Report

Q88. A _______ helps to collect specific information from the pool of data.

a. Query

b. Report

c. Form

d. None of the above

 

Ans. a. Query

Q89. Which of the following is to be created first?

a. Report

b. Query

c. Form

d. Table

 

Ans. Table

Q90. Which of the following field is invalid for storing information of “Library” Table?

a. Cost

b. Booknumber

c. Authorname

d. Dateofbirth

 

Ans. d. Dateofbirth

 

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

a. Rollno

b. Name

c. Class

d. Section

 

Ans. a. Rollno

Q92. A foreign key is a reference of the ________ key in another table.

a. Alternate

b. Primary

c. Candidate

d. None of the above

 

Ans. b. Primary

Q93. A table is a collection of logically related data.(T/F)

a. True

b. False

 

Ans. a. True

Q94. _______ tables can be created in a database.

a. 1

b. 2

c. 3

d. More than 3

 

Ans. d. More than 3

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

a. True

b. False

 

Ans. b. False

Q96. Only numeric fields can act as a primary key in a table.(T/F)

a. True

b. False

 

Ans. b. False

Q97. Primary key increases data redundancy.(T/F)

a. True

b. False

 

Ans. b. False

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

a. 1

b. 2

c. 3

d. more than 3

 

Ans. a. 1

Q99. A foreign key is a primary key in other table.(T/F)

a. True

b. False

Ans. a. True

Q100. Duplicate values can be entered in Foreign key.(T/F)

a. True

b. False

 

Ans. a. True