Page 1 :
Part B Unit-3 MCQs, 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
Page 2 :
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
Page 3 :
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”
Page 4 :
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
Page 5 :
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 ______
Page 6 :
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
Page 7 :
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
Page 8 :
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?
Page 9 :
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
Page 10 :
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
Page 11 :
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;
Page 12 :
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’;
Page 13 :
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
Page 14 :
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
Page 15 :
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
Page 16 :
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