{"id":1406,"date":"2021-07-05T12:54:06","date_gmt":"2021-07-05T07:24:06","guid":{"rendered":"https:\/\/cbsepython.in\/?p=1406"},"modified":"2022-02-01T22:15:42","modified_gmt":"2022-02-01T16:45:42","slug":"database-management-system-mcq-class-10","status":"publish","type":"post","link":"https:\/\/cbsepython.in\/database-management-system-mcq-class-10\/","title":{"rendered":"Database Management System MCQ Class 10"},"content":{"rendered":"

Database Management System MCQ Class 10\u00a0<\/span><\/h2>\n

 <\/p>\n

1. Which of the following is not a database programs?<\/strong><\/span><\/p>\n

a) MySQL<\/span><\/p>\n

b) Oracle<\/span><\/p>\n

c) Writer \u2713<\/strong><\/span><\/p>\n

d) OObase<\/span><\/p>\n

 <\/p>\n

2. Duplication of data is called _________.<\/strong><\/span><\/p>\n

a) Inconsistency<\/span><\/p>\n

b) Consistency<\/span><\/p>\n

c) Redundancy \u2713<\/strong><\/span><\/p>\n

d) Foreign Key<\/span><\/p>\n

 <\/p>\n

3. Which of the following is not the advantage of database?<\/strong><\/span><\/p>\n

a) Sharing of Data<\/span><\/p>\n

b) Reduce Data Redundancy<\/span><\/p>\n

c) Increase Data Inconsistency \u2713<\/strong><\/span><\/p>\n

d) Data Securit<\/span><\/p>\n

 <\/p>\n

4. Which of the following will help to maintain unique record in the table?<\/strong><\/span><\/p>\n

a) Foreign Key<\/span><\/p>\n

b) Primary Key \u2713<\/strong><\/span><\/p>\n

c) Composite Key<\/span><\/p>\n

d) Alternate Key<\/span><\/p>\n

 <\/p>\n

5. A foreign key is a reference of the ________ key in another table.<\/strong><\/span><\/p>\n

a) Alternate<\/span><\/p>\n

b) Primary \u2713<\/strong><\/span><\/p>\n

c) Candidate<\/span><\/p>\n

d) None of the above<\/span><\/p>\n

 <\/p>\n

6. SQL stands for _________________<\/strong><\/span><\/p>\n

a) Structured Queue Language<\/span><\/p>\n

b) Structured Query Language \u2713<\/strong><\/span><\/p>\n

c) Structured Query Lang<\/span><\/p>\n

d) None of the above<\/span><\/p>\n

 <\/p>\n

7. We can create query (in Open Office Base) in _______________________<\/strong><\/span><\/p>\n

a) In design view<\/span><\/p>\n

b) Using wizard<\/span><\/p>\n

c) Both of the above \u2713<\/strong><\/span><\/p>\n

d) None of the above<\/span><\/p>\n

 <\/p>\n

8. Which of the following will occupy more space in computer memory?<\/strong><\/span><\/p>\n

a) Bigint \u2713<\/strong><\/span><\/p>\n

b) Integer<\/span><\/p>\n

c) Smallint<\/span><\/p>\n

d) Boolean<\/span><\/p>\n

 <\/p>\n

9. ____________ is the most common DML command.<\/strong><\/span><\/p>\n

a) Delete<\/span><\/p>\n

b) Update<\/span><\/p>\n

c) Select \u2713<\/strong><\/span><\/p>\n

d) All of the above<\/span><\/p>\n

 <\/p>\n

10. Command to increase the salary of all employees by 15000.(table name emp and column name sal)<\/strong><\/span><\/p>\n

a) update emp set sal = sal + 15000; \u2713<\/strong><\/span><\/p>\n

b) update emp set sal = 15000;<\/span><\/p>\n

c) update set sal = sal + 15000;<\/span><\/p>\n

d) None of the above<\/span><\/p>\n

 <\/p>\n

 <\/p>\n

11. A software package that can be used for creating and managing databases.<\/strong><\/span><\/p>\n

a) MS Access<\/span><\/p>\n

b) OpenOffice Base<\/span><\/p>\n

c) LibreOffice Base<\/span><\/p>\n

d) All of these \u2713<\/strong><\/span><\/p>\n

 <\/p>\n

12. OpenOffice Base is a ________database.<\/strong><\/span><\/p>\n

a) relational \u2713<\/strong><\/span><\/p>\n

b) flat<\/span><\/p>\n

c) external<\/span><\/p>\n

d) none of these<\/span><\/p>\n

 <\/p>\n

13._____ are the building blocks of the database.<\/strong><\/span><\/p>\n

a) Reports<\/span><\/p>\n

b) Forms<\/span><\/p>\n

c) Fields<\/span><\/p>\n

d) Tables \u2713<\/strong><\/span><\/p>\n

 <\/p>\n

14.__________ are the collection of different types of information about the same subject.<\/strong><\/span><\/p>\n

a) Tables<\/span><\/p>\n

b) Records \u2713<\/strong>\u00a0<\/span><\/p>\n

c) Fields<\/span><\/p>\n

d) Reports<\/span><\/p>\n

 <\/p>\n

15.__________ key is a field that uniquely identifies each record in a table.<\/strong><\/span><\/p>\n

a) Candidate<\/span><\/p>\n

b) Primary \u2713<\/strong><\/span><\/p>\n

c) Foreign<\/span><\/p>\n

d) Composite<\/span><\/p>\n

 <\/p>\n\n\n\n\n
#<\/span>TRENDING<\/span><\/strong><\/td>\n<\/td>\n<\/tr>\n
\n

Important MCQ on Digital Documentation Class 10 IT<\/span><\/strong><\/a><\/h3>\n

Imp0rtant MCQ on Electronic Spreadsheet Class 10 IT<\/span><\/strong><\/a><\/h3>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

16.__________ indicates the type of data any field may store.<\/strong><\/span><\/p>\n

a) Data address<\/span><\/p>\n

b) Data variety<\/span><\/p>\n

c) Data types \u2713<\/strong><\/span><\/p>\n

d) Data value<\/span><\/p>\n

 <\/p>\n

17._________ DDL command is used to create a table.<\/strong><\/span><\/p>\n

a) ALTER<\/span><\/p>\n

b) CREATE \u2713<\/strong><\/span><\/p>\n

c) DESIG<\/span><\/p>\n

d) NEW<\/span><\/p>\n

 <\/p>\n

18. ________DDL command is used to change the structure of a database.<\/strong><\/span><\/p>\n

a) CHANGE<\/span><\/p>\n

b) TRUNCATE<\/span><\/p>\n

c) ALTER \u2713<\/strong><\/span><\/p>\n

d) RENAME<\/span><\/p>\n

 <\/p>\n

19. Which of these is not a valid category of SQL commands?<\/strong><\/span><\/p>\n

a) ALTER<\/span><\/p>\n

b) CREATE<\/span><\/p>\n

c) DESIGN \u2713<\/strong><\/span><\/p>\n

d) NEW<\/span><\/p>\n

 <\/p>\n

20. Table can be created using_________.<\/strong><\/span><\/p>\n

a) Table Wizard<\/span><\/p>\n

b) Table icon<\/span><\/p>\n

c) Table tool<\/span><\/p>\n

d) Table command \u2713<\/strong><\/span><\/p>\n

 <\/p>\n

21. There are _______ types of Relationships in a table.<\/strong><\/span><\/p>\n

a) one<\/span><\/p>\n

b) two<\/span><\/p>\n

d) three \u2713<\/strong><\/span><\/p>\n

c) four<\/span><\/p>\n

 <\/p>\n

22. _________ includes commands to enable users to enter and manipulate data.<\/strong><\/span><\/p>\n

a) DCL<\/span><\/p>\n

b) DDL<\/span><\/p>\n

c) DML \u2713<\/strong><\/span><\/p>\n

d) none of these<\/span><\/p>\n

 <\/p>\n

23. A popular data manipulation language is____________.<\/strong><\/span><\/p>\n

a) SQL \u2713<\/strong><\/span><\/p>\n

b) SML<\/span><\/p>\n

c) DML<\/span><\/p>\n

d) none of these<\/span><\/p>\n

 <\/p>\n

24. The file extension for databases created using OpenOffice.Org Base is<\/strong><\/span><\/p>\n

a) .db<\/span><\/p>\n

b) .dbs<\/span><\/p>\n

c) .odb \u2713<\/strong><\/span><\/p>\n

d) .oob<\/span><\/p>\n

 <\/p>\n

25. Which of the following data types supports alphanumeric characters and special symbols?<\/strong><\/span><\/p>\n

a) Text \u2713<\/strong><\/span><\/p>\n

b) Memo<\/span><\/p>\n

c) Currency<\/span><\/p>\n

d) Auto Number<\/span><\/p>\n

 <\/p>\n

26. Primary key cannot accept_______ values.<\/strong><\/span><\/p>\n

a) binary<\/span><\/p>\n

b) NULL \u2713<\/strong><\/span><\/p>\n

c) text<\/span><\/p>\n

d) numeric<\/span><\/p>\n

 <\/p>\n

27. Data_________ language allows you to alter\/update data in a database.<\/strong><\/span><\/p>\n

a) manipulation<\/span><\/p>\n

b) definition \u2713<\/strong><\/span><\/p>\n

c) truncation<\/span><\/p>\n

d) control<\/span><\/p>\n

 <\/p>\n

28. Which of the following is not a DML command?<\/strong><\/span><\/p>\n

a) Insert<\/span><\/p>\n

b) Update<\/span><\/p>\n

c) Delete<\/span><\/p>\n

d) Truncate \u2713<\/strong><\/span><\/p>\n

 <\/p>\n

29. ________ property is used to filter the data either in the ascending or descending order.<\/strong><\/span><\/p>\n

a) Sort \u2713<\/strong><\/span><\/p>\n

b) Arrange<\/span><\/p>\n

c) Query<\/span><\/p>\n

d) Criteria<\/span><\/p>\n

 <\/p>\n

30. __________ helps us to retrieve the filtered data based upon specified conditions.<\/strong><\/span><\/p>\n

a) Report<\/span><\/p>\n

b) Table<\/span><\/p>\n

c) Query \u2713<\/strong><\/span><\/p>\n

d) Form<\/span><\/p>\n

 <\/p>\n

31. The fundamental object of a database that is a collection of information stored in rows and columns format is called____________.<\/strong><\/span><\/p>\n

a) Tables \u2713<\/strong><\/span><\/p>\n

b) Form<\/span><\/p>\n

c) Query<\/span><\/p>\n

d) Report<\/span><\/p>\n

 <\/p>\n

32. ODB stands for<\/strong><\/span><\/p>\n

a) Open Office Database \u2713<\/strong><\/span><\/p>\n

b) Open Document Database<\/span><\/p>\n

c) Open Database<\/span><\/p>\n

d) Open Office Base<\/span><\/p>\n

 <\/p>\n

CASE STUDY QUESTIONS<\/span><\/h3>\n

33. Which of the following software is appropriate to store data about school students?<\/strong><\/span><\/p>\n

a) MS-Access \u2713<\/strong><\/span><\/p>\n

b) Writer<\/span><\/p>\n

c) Calc<\/span><\/p>\n

d) Impress<\/span><\/p>\n

 <\/p>\n

34. Which of the following is not the advantage of database?<\/strong><\/span><\/p>\n

a) Sharing of Data<\/span><\/p>\n

b) Reduce Data Redundancy<\/span><\/p>\n

c) Increase Data Inconsistency \u2713<\/strong><\/span><\/p>\n

d) Data Security<\/span><\/p>\n

 <\/p>\n

35. When primary key is made up of two or more columns then it is called __ primary key.<\/strong><\/span><\/p>\n

a) Mixed<\/span><\/p>\n

b) Reference<\/span><\/p>\n

c) Composite \u2713<\/strong><\/span><\/p>\n

d) Compost<\/span><\/p>\n

 <\/p>\n

36. All the values in ________ are of same type.<\/strong><\/span><\/p>\n

a) Records<\/span><\/p>\n

b) Table<\/span><\/p>\n

c) Database<\/span><\/p>\n

d) Fields \u2713<\/strong><\/span><\/p>\n

 <\/p>\n

37. _______________ are the basic building blocks of a database.<\/strong><\/span><\/p>\n

a) Tables \u2713<\/strong><\/span><\/p>\n

b) Record<\/span><\/p>\n

c) Field<\/span><\/p>\n

d) All of the above<\/span><\/p>\n

 <\/p>\n

37. Which of the following is not valid field of table \u201cStudent\u201d<\/strong><\/span><\/p>\n

a) adm. no<\/span><\/p>\n

b) name<\/span><\/p>\n

c) fees<\/span><\/p>\n

d) Salary \u2713<\/strong><\/span><\/p>\n

 <\/p>\n

38. When data is stored, maintained and retrieved from multiple tables then special database software are required called<\/strong><\/span><\/p>\n

a) DBMS<\/span><\/p>\n

b) RDBMS \u2713<\/strong><\/span><\/p>\n

c) Special DBMS<\/span><\/p>\n

d) All of the above<\/span><\/p>\n

 <\/p>\n

39. A field which is ______ for each and every record is called Primary key.<\/strong><\/span><\/p>\n

a) Common<\/span><\/p>\n

b) Same<\/span><\/p>\n

c) Unique \u2713<\/strong><\/span><\/p>\n

d) None of the above<\/span><\/p>\n

 <\/p>\n

40. It is used to establish an association between related tables.<\/strong><\/span><\/p>\n

a) Line<\/span><\/p>\n

b) Relationship \u2713<\/strong><\/span><\/p>\n

c) Primary Key<\/span><\/p>\n

d) Records<\/span><\/p>\n

 <\/p>\n

 <\/p>\n

41. A database stores and processes data in the form of.<\/span><\/strong><\/p>\n

a) Rows<\/span><\/p>\n

b) Columns<\/span><\/p>\n

c) Tables \u2713<\/strong><\/span><\/p>\n

d) All of these<\/span><\/p>\n

 <\/p>\n

42. What name do we give to the database which stores data based on their relevance?<\/span><\/strong><\/p>\n

a) Rational<\/span><\/p>\n

b) Relational \u2713<\/strong><\/span><\/p>\n

c) Ration<\/span><\/p>\n

d) Relation<\/span><\/p>\n

 <\/p>\n

43. What does this > button signify with respect to fields in the Table Wizard window?<\/span><\/strong><\/p>\n

a) Add one<\/span><\/p>\n

b) Remove one<\/span><\/p>\n

c) Remove selected<\/span><\/p>\n

d) Add selected \u2713<\/strong><\/span><\/p>\n

 <\/p>\n

44. Can we assign a composite key as the primary key of a table using the Table Wizard?<\/span><\/strong><\/p>\n

a) Yes \u2713<\/strong><\/span><\/p>\n

b) No<\/span><\/p>\n

c) May be<\/span><\/p>\n

d) None of these<\/span><\/p>\n

 <\/p>\n

45. A primary key should never contain.<\/span><\/strong><\/p>\n

a) Whole<\/span><\/p>\n

b) Composite<\/span><\/p>\n

c) Incomplete<\/span><\/p>\n

d) Null \u00a0\u2713<\/strong><\/span><\/p>\n

 <\/p>\n\n\n\n\n
#<\/span>TRENDING<\/span><\/strong><\/td>\n<\/td>\n<\/tr>\n
\n

Solved Sample Paper Class 10 IT(402) Set-1\u00a0<\/span><\/strong><\/a><\/h3>\n

Solved Sample Paper Class 10 IT(402) Set-2<\/span><\/strong><\/a><\/h3>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

46. How many default column headers are present for tables in Design View?<\/span><\/strong><\/p>\n

a) One<\/span><\/p>\n

b) Two<\/span><\/p>\n

c) Three \u2713<\/strong><\/span><\/p>\n

d) Four<\/span><\/p>\n

 <\/p>\n

47. Name the column header which tells the reader about the type of information stored in a field.<\/span><\/strong><\/p>\n

a) Field Name \u2713<\/strong><\/span><\/p>\n

b) Field Type<\/span><\/p>\n

c) Description<\/span><\/p>\n

d) All of these<\/span><\/p>\n

 <\/p>\n

48. What is the other name of Fixed Length fields?\u00a0<\/span><\/strong><\/p>\n

a) Dynamic Fields<\/span><\/p>\n

b) Fixed Fields<\/span><\/p>\n

c) Static Fields \u2713<\/strong><\/span><\/p>\n

d) None of these<\/span><\/p>\n

 <\/p>\n

49. The default Field Length of Text (fix) [CHAR] data type is..<\/span><\/strong><\/p>\n

a) 10<\/span><\/p>\n

b) 20<\/span><\/p>\n

c) 30<\/span><\/p>\n

d) 50 \u2713<\/strong><\/span><\/p>\n

 <\/p>\n

50. Which Text type data has the largest storage capacity?<\/span><\/strong><\/p>\n

a) Text [VARCHAR]<\/span><\/p>\n

b) Hyperlink<\/span><\/p>\n

c) Memo [LONGVARCHAR] \u2713<\/strong><\/span><\/p>\n

d) Number<\/span><\/p>\n

 <\/p>\n

51. Which Whole Number data type has the smallest Field Length?<\/span><\/strong><\/p>\n

a) Small Integer<\/span><\/p>\n

b) Big Integer<\/span><\/p>\n

c) Tiny Integer \u00a0\u2713<\/strong><\/span><\/p>\n

d) All of these<\/span><\/p>\n

 <\/p>\n

52. Which Field Property is used to change the date format?<\/span><\/strong><\/p>\n

a) Format example \u2713<\/strong><\/span><\/p>\n

b) Format<\/span><\/p>\n

c) Format change<\/span><\/p>\n

d) Change Format<\/span><\/p>\n

 <\/p>\n

53. Which special data type has a fixed Field Length of 1 space?<\/span><\/strong><\/p>\n

a) Binary [VAR]<\/span><\/p>\n

b) Image [LONG]<\/span><\/p>\n

c) Yes\/No [BOOLEAN] \u2713<\/strong><\/span><\/p>\n

d) None of these<\/span><\/p>\n

 <\/p>\n

54. Which column header is used to add a note\/comment about the nature of data in a field?<\/span><\/strong><\/p>\n

a) Field Name<\/span><\/p>\n

b) Field Type<\/span><\/p>\n

c) Description \u2713<\/strong><\/span><\/p>\n

d) All of these<\/span><\/p>\n

 <\/p>\n

55. Which Query is used to retrieve data from one or more tables and display the record set in a datasheet?<\/span><\/strong><\/p>\n

a) Select \u2713<\/strong><\/span><\/p>\n

b) Update<\/span><\/p>\n

c) Cross<\/span><\/p>\n

d) Drop<\/span><\/p>\n

 <\/p>\n

56. A query can be previewed by pressing.<\/span><\/strong><\/p>\n

a) F1<\/span><\/p>\n

b) F2<\/span><\/p>\n

c) F3<\/span><\/p>\n

d) F4 \u2713<\/strong><\/span><\/p>\n

 <\/p>\n

57. What does the top section of a query window display?<\/span><\/strong><\/p>\n

a) Design Grid<\/span><\/p>\n

b) Tables \u2713<\/strong><\/span><\/p>\n

c) Both<\/span><\/p>\n

d) None<\/span><\/p>\n

 <\/p>\n

58. Which key defines a relationship between two tables?<\/span><\/strong><\/p>\n

a) Foreign key \u2713<\/strong><\/span><\/p>\n

b) Primary key<\/span><\/p>\n

c) Secondary key<\/span><\/p>\n

d) Alternate Key<\/span><\/p>\n

 <\/p>\n

59. How many sections are there in a Query Design window?<\/span><\/strong><\/p>\n

a) One<\/span><\/p>\n

b) Two \u2713<\/strong><\/span><\/p>\n

c) Three<\/span><\/p>\n

d) Four<\/span><\/p>\n

 <\/p>\n

60. Which key helps to run a query?<\/span><\/strong><\/p>\n

a) F2<\/span><\/p>\n

b) F5 \u2713<\/strong><\/span><\/p>\n

c) F6<\/span><\/p>\n

d) F8<\/span><\/p>\n

 <\/p>\n

61. Which view gives more control over a query?<\/span><\/strong><\/p>\n

a) Design View \u2713<\/strong><\/span><\/p>\n

b) Wizard<\/span><\/p>\n

c) SQL View<\/span><\/p>\n

d) View<\/span><\/p>\n

 <\/p>\n

62. Which property allows the user to specify the user defined name for any column?\u00a0<\/span><\/strong><\/p>\n

a) Visible<\/span><\/p>\n

b) Alias \u2713<\/strong><\/span><\/p>\n

c) Records<\/span><\/p>\n

d) Field<\/span><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n\n\n\n\n
#<\/span>TRENDING<\/span><\/strong><\/td>\n<\/td>\n<\/tr>\n
\n

Important MCQ on Digital Documentation Class 10 IT<\/span><\/strong><\/a><\/h3>\n

Imp0rtant MCQ on Electronic Spreadsheet Class 10 IT<\/span><\/strong><\/a><\/h3>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

63. A DBMS allows different user application programs to concurrently access the <\/span>__________ .<\/span><\/strong><\/p>\n

a) same database \u2713<\/span><\/p>\n

b) different spreadsheets<\/span><\/p>\n

c) different database<\/span><\/p>\n

d) None of these<\/span><\/p>\n

 <\/p>\n

64. Databases available on the database servers are accessed through command line or <\/span>graphic user interface tools referred to as ______________.<\/span><\/strong><\/p>\n

a) back-ends<\/span><\/p>\n

b) front-ends \u2713<\/span><\/p>\n

c) intermediate<\/span><\/p>\n

d) interfaces<\/span><\/p>\n

 <\/p>\n

65. A _____________ is the actual text or numerical amount or date that you put in while <\/span>adding information to your database.<\/span><\/strong><\/p>\n

a) record<\/span><\/p>\n

b) data<\/span><\/p>\n

c) value \u2713<\/span><\/p>\n

d) entry<\/span><\/p>\n

 <\/p>\n

66. RDBMS is based on the relational model introduced by<\/span><\/strong><\/p>\n

a) Henry Ford<\/span><\/p>\n

b) E.F.Codd \u2713<\/span><\/p>\n

c) Both (a) and (b)<\/span><\/p>\n

d) None of these<\/span><\/p>\n

 <\/p>\n

67. Primary key can be of three types: ______________, single field primary key and <\/span>multi-field primary key.<\/span><\/strong><\/p>\n

a) auto number \u2713<\/span><\/p>\n

b) auto name<\/span><\/p>\n

c) auto field<\/span><\/p>\n

d) auto select<\/span><\/p>\n

 <\/p>\n

68. ________________ will restrict the amount of data that each data item or value can <\/span>hold.<\/span><\/strong><\/p>\n

a) Data type<\/span><\/p>\n

b) Data size \u2713<\/span><\/p>\n

c) Data length<\/span><\/p>\n

d) Data width<\/span><\/p>\n

 <\/p>\n

69. The _____________ data type stores serialised Java objects.<\/span><\/strong><\/p>\n

a) varbinary<\/span><\/p>\n

b) varchar<\/span><\/p>\n

c) other variable \u2713<\/span><\/p>\n

d) bigint<\/span><\/p>\n

 <\/p>\n

70. Reports are used to produce formatted summaries of the data contained from one or <\/span>more tables or queries in a ___________ format.<\/span><\/strong><\/p>\n

a) printed \u2713<\/span><\/p>\n

b) prepared<\/span><\/p>\n

c) presentation<\/span><\/p>\n

d) possible<\/span><\/p>\n

 <\/p>\n

71. The bottom half of the Table Design window displays the ______________ for the field <\/span>type you have selected.<\/span><\/strong><\/p>\n

a) field types<\/span><\/p>\n

b) field properties \u2713<\/span><\/p>\n

c) field output<\/span><\/p>\n

d) field design<\/span><\/p>\n

 <\/p>\n

72. Multiple fields can be selected by holding the ___________ key while selecting the <\/span>fields.<\/span><\/strong><\/p>\n

a) Ctrl \u2713<\/span><\/p>\n

b) Alt<\/span><\/p>\n

c) Shift<\/span><\/p>\n

d) Tab<\/span><\/p>\n

 <\/p>\n

73. A query is a statement that gives you ___________ data according to your conditions <\/span>and specification.<\/span><\/strong><\/p>\n

a) Conditioned<\/span><\/p>\n

b) Sorted<\/span><\/p>\n

c) Filtered \u2713<\/span><\/p>\n

d) Closed<\/span><\/p>\n

 <\/p>\n

74. A foreign key is linked to the primary key of the _______________.<\/span><\/strong><\/p>\n

a) same table<\/span><\/p>\n

b) different table \u2713<\/span><\/p>\n

c) Both (a) and (b)<\/span><\/p>\n

d) None of these<\/span><\/p>\n

 <\/p>\n

75. The ____________ data type stores both date and time.<\/span><\/strong><\/p>\n

a) DateTime \u2713<\/span><\/p>\n

b) Timestamp<\/span><\/p>\n

c) Datestamp<\/span><\/p>\n

d) DateAndTime<\/span><\/p>\n

 <\/p>\n

76. Sonali has created a table to store the details of the registered dealers of her company. <\/span>She has created all the fields as per the requirement. For entering phone number, she is\u00a0<\/span>not sure which data type can be used. Suggest her the best data type from the\u00a0<\/span>following options for storing phone numbers.<\/span><\/strong><\/p>\n

a) Boolean<\/span><\/p>\n

b) Varchar<\/span><\/p>\n

c) Integer \u2713<\/span><\/p>\n

d) Float<\/span><\/p>\n

 <\/p>\n

77. Ragini has created a table named Student_Details in order to store all the details of the <\/span>student of her class. She has added the following fields: Admission_No,\u00a0<\/span>Student_Name, Birth_Date, Address, Joining_Date, Mother_Name, Father_Name. Out\u00a0<\/span>of the following fields, which field can be selected as primary key as the entries in it\u00a0<\/span>will be unique?<\/span><\/strong><\/p>\n

a) Admission_No \u2713<\/span><\/p>\n

b) Birth_Date<\/span><\/p>\n

c) Student_Name<\/span><\/p>\n

d) None of these<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Database Management System MCQ Class 10\u00a0   1. Which of the following is not a database programs? a) MySQL b) Oracle c) Writer \u2713 d) OObase   2. Duplication of data is called _________. a) Inconsistency b) Consistency c) Redundancy \u2713 d) Foreign Key   3. Which of the following is not the advantage of […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[],"class_list":["post-1406","post","type-post","status-publish","format-standard","hentry","category-information-technology-for-cbse-class-10"],"_links":{"self":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/1406","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/comments?post=1406"}],"version-history":[{"count":0,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/1406\/revisions"}],"wp:attachment":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/media?parent=1406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/categories?post=1406"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/tags?post=1406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}