CBSE class 10 IT 402 computer open office database base mcq bank
CBSE class 10 IT 402 computer open office database base mcq bank
Management System
Class 10 MCQ
cbseskilleducation.com/database-management-system-class-10-mcq/
Database Management System Class 10 MCQ
Session 1: Appreciate Concept of Database Management System
1. A _________ is an organized collection of data.
a. Database
b. Digital Document
c. Spreadsheet
d. None of the above
Show Answer ⟶
a. Database
2. A ________ is a software package that can be used for creating and managing
databases.
a. Database Management System
b. Basedata Management System
c. Database Manage System
d. None of the above
Show Answer ⟶
a. Database Management System
3. A_________________ database management system is referred to as a relational
model.
a. DBMS
b. RDBMS
c. DB
d. None of the above
Show Answer ⟶
b. RDBMS
4. Example of the database ________.
a. Microsoft Access
b. OpenOffice Base
c. MySQL
d. All of the above
Show Answer ⟶
2/43
d. All of the above
Database Management System Class 10 MCQ
5. The database concept has evolved since the _______.
a. 1980
b. 1960
c. 1955
d. 1950
Show Answer ⟶
b. 1960
6. DBMS Stands for __________.
a. Database Management System
b. Database Manage System
c. Data Manage System
d. None of the above
Show Answer ⟶
a. Database Management System
7. A database management system is a software package with computer programs
that controls the ___________.
a. Creation
b. Maintenance
c. Use of Database
d. All of the above
Show Answer ⟶
d. All of the above
8. A database is an integrated collection of ___________.
a. Data records
b. Files
c. Objects
d. All of the above
Show Answer ⟶
d. All of the above
9. A DBMS enables several user application programs to access the ________
database.
a. Other Database
b. Same Database
c. Both a) and b)
d. None of the above
3/43
Show Answer ⟶
b. Same Database
10. Data can be organized into __________.
a. Flat File
b. Relational
c. Both a) and b)
d. None of the above
Show Answer ⟶
c. Both a) and b)
11. Data stored in a single table is known as __________.
a. Flat File
b. Relational
c. Both a) and b)
d. None of the above
Show Answer ⟶
a. Flat File
12. Data is stored in multiple tables, which are connected together via a common field.
a. Flat File
b. Relational
c. Both a) and b)
d. None of the above
Show Answer ⟶
b. Relational
13. __________ are dedicated computers that hold the actual databases and run only
the DBMS and related software.
a. Database Server
b. Decided Server
c. Web Server
d. None of the above
Show Answer ⟶
a. Database Server
14. What are the advantages of database __________.
a. Reduces Data Redundancy
b. Sharing of Data
c. Data Integrity
d. All of the above
Show Answer ⟶
d. All of the above
4/43
Database Management System Class 10 MCQ
15. When the same piece of data is stored in two or more locations, it is called
______________.
a. Data Redundancy
b. Data Integrity
c. Data Consistency
d. None of the above
Show Answer ⟶
a. Data Redundancy
16. _________ prevents creating multiple copies in the database.
a. Data Redundancy
b. Data Integrity
c. Data Consistency
d. None of the above
Show Answer ⟶
a. Data Redundancy
17. __________ means that the data is accurate and consistent in the database.
a. Data Redundancy
b. Data Integrity
c. Data Consistency
d. None of the above
Show Answer ⟶
b. Data Integrity
18. Only authorized users should be allowed to access the database and their identity
should be authenticated using a username and password known as ________.
a. Data Redundancy
b. Data Consistency
c. Data Security
d. None of the above
Show Answer ⟶
c. Data Security
Database Management System Class 10 MCQ
19. Database Management System automatically takes care of ____________.
a. Data Redundancy
b. Backup and Recovery
c. Data Security
d. None of the above
5/43
Show Answer ⟶
b. Backup and Recovery
20. ___________ prevent multiple mismatching copies of the same data in the
database and only valid data will be added in the database.
a. Data Redundancy
b. Backup and Recovery
c. Data Consistency
d. None of the above
Show Answer ⟶
c. Data Consistency
21. __________ in a table represents a set of information with the same structure in
every row.
a. Tuples
b. Record
c. Both a) and b)
d. None of the above
Show Answer ⟶
c. Both a) and b)
22. A __________ is the actual text, number, or date that you enter when adding data
to your database.
a. Values
b. Table
c. Boolean
d. None of the above
Show Answer ⟶
a. Values
23. The unique field present in the table is called __________.
a. Primary Key
b. Candidate Key
c. Foreign Key
d. None of the above
Show Answer ⟶
a. Primary Key
24. When the primary key is applied on multiple columns is known as __________.
a. Primary Key
b. Composite Primary Key
c. Foreign Key
d. None of the above
6/43
Show Answer ⟶
b. Composite Primary Key
25. By default if the primary key is not defined that column is known as __________.
a. Primary Key
b. Candidate Key
c. Foreign Key
d. None of the above
Show Answer ⟶
c. Foreign Key
26. __________ key can store multiple same records in the table.
a. Primary Key
b. Candidate Key
c. Foreign Key
d. None of the above
Show Answer ⟶
c. Foreign Key
27. The relationship between two tables where one table has one record and another
table has many records is known as ___________.
a. One-to-Many
b. Many-to-Many
c. Many-to-One
d. None of the above
Show Answer ⟶
a. One-to-Many
Database Management System Class 10 MCQ
Session 2: Create and Edit Tables Using Wizard & SQL Commands
28. SQL stands for _____________.
a. Single Query Language
b. Structured Query Language
c. Semantic Query Language
d. None of the above
Show Answer ⟶
b. Structured Query Language
29. A ____________ is a collection of data components organized in the form of
vertical columns and horizontal rows.
a. Table
7/43
b. Fields
c. Attributes
d. None of the above
Show Answer ⟶
a. Table
30. A row also called a Record or _________ represents a single, data item in a table.
a. Column
b. Tuples
c. Fields
d. None of the above
Show Answer ⟶
b. Tuples
31. You can create tables in the database using _________.
a. Wizard
b. SQL
c. Both a) and b)
d. None of the above
Show Answer ⟶
c. Both a) and b)
32. ____________ are the basic building blocks of a database.
a. Table
b. Query
c. Database
d. None of the above
Show Answer ⟶
a. Table
33. _____________ are used to define the type of data that will be stored in the
database.
a. Data Types
b. Data field
c. Key Data
d. None of the above
Show Answer ⟶
a. Data Types
34. What are the different types of data type available in OpenOffice base?
a. Numeric Types
b. Alphanumeric Types
8/43
c. Binary Types & Date time
d. All of the above
Show Answer ⟶
d. All of the above
35. __________ types are used for describing numeric values for the field used in the
table of a database.
a. Numeric Type
b. Alphanumeric Type
c. Boolean Type
d. Date & Time
Show Answer ⟶
a. Numeric Type
36. ___________ data type can store 0 or 1 in the database.
a. Boolean
b. TinyInt
c. Smalint
d. BigInt
Show Answer ⟶
a. Boolean
Database Management System Class 10 MCQ
37. What are the different numerical data types?
a. Boolean
b. Tinyint & Smallint
c. Integer & Bigint
d. All of the above
Show Answer ⟶
d. All of the above
38. ____________ data type can store UTF 8 Characters in the database.
a. Longvarchar
b. Char
c. Both a) and b)
d. None of the above
Show Answer ⟶
c. Both a) and b)
39. __________ is case sensitive data type in the database.
a. Longvarchar
b. Varchar_Ignorecase
9/43
c. Varchar
d. All of the above
Show Answer ⟶
b. Varchar_Ignorecase
40. ___________ data types in a database can be used for storing photos, music,
video or any file format.
a. Numerical Type
b. Alphanumeric Type
c. Binary Type
d. Date & Time
Show Answer ⟶
c. Binary Type
41. Which datatype is used for storing date and time both in the database.
a. Date
b. Time
c. Timestamp
d. None of the above
Show Answer ⟶
c. Timestamp
42. A table is a collection of data elements that are organized using a vertical
__________ and horizontal ___________ model.
a. Column & Row
b. Row & Column
c. Column & Column
d. Row & Row
Show Answer ⟶
a. Column & Row
43. A ________ is a collection of data values of a specific type, one for each row of a
table.
a. Column
b. Row
c. Cell
d. None of the above
Show Answer ⟶
a. Column
44. In a table, a __________ represents a single data item.
a. Row
b. Truple
10/43
c. Both a) and b)
d. None of the above
Show Answer ⟶
c. Both a) and b)
Database Management System Class 10 MCQ
45. _____________ are used to identify which type of data we are going to store in the
database.
a. Datatype
b. DataItem
c. DataValue
d. DataCat
Show Answer ⟶
a. Datatype
46. There are ________ ways to create a table.
a. 1
b. 2
c. 3
d. 4
Show Answer ⟶
b. 2
47. Field properties can be set in both the ________ and _________ .
a. Length & Default Value
b. Length & Entry
c. Both a) and b)
d. All of the above
Show Answer ⟶
c. Both a) and b)
Session 3: Perform Operations of Table
48. By default the length of the numerical data type is _______.
a. 05
b. 10
c. 20
d. 30
Show Answer ⟶
b. 10
11/43
49. If the user does not specify a value for a field while putting values into the table, a
_____________ value can be assigned to it.
a. Default Value
b. Length
c. Format
d. None of the above
Show Answer ⟶
a. Default Value
50. ________ means to arrange the data in either ascending order or descending
order.
a. Filter
b. Sorting
c. Arrangement
d. None of the above
Show Answer ⟶
b. Sorting
51. ____________ is used to maintain accuracy and consistency of data in a
relationship.
a. Referential data
b. Referential Integrity
c. Referential Value
d. None of the above
Show Answer ⟶
b. Referential Integrity
Database Management System Class 10 MCQ
52. In base, data can be linked between two or more tables with the help of
____________.
a. Primary Key
b. Foreign Key
c. Both a) and b)
d. None of the above
Show Answer ⟶
c. Both a) and b)
53. Referential Integrity helps to avoid ____________.
a. If you want to add a record in the related table and if there is no associated record
available in the primary key table.
b. Changing values in a primary if there are any dependent records in the related table.
12/43
c. Deleting records from a primary key table if there are any matching related records
available in the associated table.
d. All of the above
Show Answer ⟶
d. All of the above
54. The connection or association between two or more table is known as
____________
a. Connection
b. Relationship
c. Connector
d. None of the above
Show Answer ⟶
b. Relationship
55. Relationships between tables help to __________.
a. Save time
b. Reduce data-entry errors
c. Summarize data from related tables
d. All of the above
Show Answer ⟶
d. All of the above
56. What are the different types of relationships which can be created in
table___________.
a. One to One
b. One to Many or Many to One
c. Many to Many
d. All of the above
Show Answer ⟶
d. All of the above
57. ___________ is the relationship, where both the tables must have primary key
columns.
a. One to One
b. One to Many or Many to One
c. Many to Many
d. All of the above
Show Answer ⟶
a. One to One
13/43
58. ____________ in this relationship, one of them must have a primary key column.
a. One to One
b. One to Many or Many to One
c. Many to Many
d. All of the above
Show Answer ⟶
b. One to Many or Many to One
59. A ____________________ is a standard for commands that define the different
structures in a database.
a. Data Manipulation Language (DML)
b. Data Definition Language (DDL)
c. Both a) and b)
d. None of the above
Show Answer ⟶
b. Data Definition Language (DDL)
60. A ______________ is a language that enables users to access and manipulate data
in a database.
a. Data Manipulation Language (DML)
b. Data Definition Language (DDL)
c. Both a) and b)
d. None of the above
Show Answer ⟶
a. Data Manipulation Language (DML)
Database Management System Class 10 MCQ
61. A ____________ is a subset of DML that just deals with information retrieval.
a. Query Language
b. Structure Language
c. Both a) and b)
d. None of the above
Show Answer ⟶
a. Query Language
62. A popular data manipulation language is _________________.
a. Structured Query Language
b. Machine Level language
c. Low level language
d. None of the above
Show Answer ⟶
14/43
a. Structured Query Language
63. There are __________ types of Relationships in a table.
a. 2
b. 3
c. 4
d. 5
Show Answer ⟶
b. 3
Session 4: Retrieve data using Query
64. _________ means that the query hides certain data and displays only what you
want to see based on the criteria you provided.
a. Filtering
b. Sort
c. Query
d. All of the above
Show Answer ⟶
a. Filtering
65. A __________ statement used to display the zero record or multiple record from
the database.
a. Select
b. Order By
c. Where
d. None of the above
Show Answer ⟶
a. Select
Database Management System Class 10 MCQ
66. To retrieve all the columns in a table the syntax is ___________.
a. Select $ from <tablename>;
b. Select * <tablename>;
c. Select * from <tablename>;
d. Select % <tablename>;
Show Answer ⟶
c.
67. To display the records containing the same type of values _________ clause can
be used with the Select SQL Command.
a. Where
15/43
b. More
c. Order
d. None of the above
Show Answer ⟶
a. Where
68. Shortcut key for executing query in OpenOffice base.
a. F2
b. F3
c. F4
d. F5
Show Answer ⟶
d. F5
69. To view records in ascending order from a database.
a. Unorder by
b. Order by
c. Acc by
d. Decc by
Show Answer ⟶
b. Order by
70. ___________ statement is used for modifying records in a database.
a. Modify
b. Update
c. Delete
d. Select
Show Answer ⟶
b. Update
71. The syntax of the update statement is _____________.
a. Update <tablename> set <columnname = value> where <condition>;
b. Update <tablename> set <condition> where <condition>;
c. Modify <tablename> set < value> where <condition>;
d. Modify <tablename> set <columnname = value> where <condition>;
Show Answer ⟶
a.
72. A _______ helps the user to systematically store information in the database.
a. Form
b. Table
c. Report
d. None of the above
16/43
Show Answer ⟶
a. Form
Database Management System Class 10 MCQ
73. A ________ enables users to view, enter, and change data directly in database
objects such as tables.
a. Table
b. Form
c. Report
d. None of the above
Show Answer ⟶
b. Form
74. _________ statement retrieves zero or more rows from one or more database
tables or database views.
a. Select
b. Update
c. Delete
d. None of the above
Show Answer ⟶
a. Select
75. By default, data is arranged in _______ order using ORDER BY clause.
a. Ascending
b. Descending
c. Both a) and b)
d. None of the above
Show Answer ⟶
a. Ascending
76. __________ statement is used for modifying records in a database.
a. Select
b. Update
c. Delete
d. None of the above
Show Answer ⟶
b. Update
77. To remove one or more records from a database, use the _________ statement.
a. Select
b. Update
c. Delete
d. None of the above
17/43
Show Answer ⟶
c. Delete
Session 5: Create Forms and Reports using Wizard
78. A __________ provides the user a systematic way of storing information into the
database.
a. Query
b. Form
c. Table
d. None of the above
Show Answer ⟶
b. Form
Database Management System Class 10 MCQ
79. __________ will help you to display summarized data from the database.
a. Report
b. Form
c. Table
d. None of the above
Show Answer ⟶
a. Report
80. To create a form you need to select the _________ option available under the
Database section.
a. Form
b. Query
c. Report
d. All of the above
Show Answer ⟶
a. Form
81. A ______ helps to collect specific information from the pool of data in the
database.
a. Form
b. Query
c. Report
d. All of the above
Show Answer ⟶
b. Query
18/43
82. ________ is used to display the summary of data.
a. Form
b. Query
c. Report
d. All of the above
Show Answer ⟶
c. Report
83. _________ are the interfaces with which the user interacts.
a. Form
b. Query
c. Report
d. All of the above
Show Answer ⟶
a. Form
84. Data from multiple tables can be stored in _______.
a. Data system
b. Database
c. Datatype
d. None of the above
Show Answer ⟶
b. Database
85. Which data type is suitable for storing values for ‘date of birth’ field?
a. Time
b. Date
c. Both of the above
d. Timestamp
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Date
Extra MCQs Questions and Answers
86. Which data type is most suitable for storing a very large amount of data?
a. LongVarchar or Memo
b. Char
c. Varchar
d. Varchar_IgnoreCase
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. LongVarchar or Memo
19/43
87. Identify the odd one out.
a. Binary Types
b. Date & Day Type
c. Numeric Types
d. Alphanumeric Types
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Date & Day Type
88. What does a single data item in a table represent?
a. Columns
b. Attribute
c. Rows
d. Field
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Rows
89. Which toolbar helps us move from one record to another in a form in a database?
a. Formatting Toolbar
b. Image Toolbar
c. Standard Toolbar
d. Form Navigation Toolbar
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. Form Navigation Toolbar
90. What is the correct query to increase the salary of all employees by Rs.10000 in a
table named Employee with a column name of Salary?
a. Update Employee set Salary = Salary + 10000;
b. Update * Employee set Salary = Salary + 10000.
c. Update table Employee set Salary = Salary + 10000;
d. Update table Employee set Salary = 10000;
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Update Employee set Salary = Salary + 10000;
91. Which query will display the details of all the students in increasing order of Roll
number?
a. Select * from student order by ‘Rollno’;
b. Select * student order by ‘Rollno’;
c. Select all from student order by ‘Rollno’;
d. Select * from student orderby ‘Rollno’;
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Select * from student order by ‘Rollno’;
20/43
92. Which clauses can be used with the SELECT statement?
a. Order by Clause
b. Where clause
c. Both a) and b)
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Both a) and b)
93. In which relationship, no table has the primary key column?
a. Many to One
b. One to One
c. Many to Many
d. One to Many
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Many to Many
94. Referential integrity refers to the _______________ between tables.
a. communication
b. consistency
c. relationship
d. joining
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. relationship
95. Which field property in Base must be set to “Yes” in order to require a value to be
entered in a field?
a. Entry Required
b. Auto Value
c. Format
d. Length
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Entry Required
96. In which view can field properties be set in Base?
a. Design View
b. Datasheet View
c. Both of the above
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Design View
21/43
97. Which of the following is a benefit of using a database management system?
a. Improved data security
b. Improved data accessibility
c. Improved data consistency
d. All of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. All of the above
98. Which of the following is NOT a type of database model?
a. Relational
b. Object-oriented
c. Hierarchical
d. Procedural
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. Procedural
99. Which of the following is an example of an open-source RDBMS?
a. Oracle
b. Microsoft Access
c. OpenOffice Base
d. Microsoft SQL Server
Show Answer ⟶
c. OpenOffice Base
100. What is the purpose of a report in a database?
a. Report is used to display information.
b. Report is systematic way of storing information into the table.
c. Both a) and b)
d. None of the above.
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Report is used to display information.
101. What is the purpose of a form in a database?
a. Form is systematic way of storing information into the table.
b. Form is used to display information.
c. Both a) and b)
d. None of the above.
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Form is systematic way of storing information into the table.
102. Which SQL command will increase the salary of all employees by 5000? (Table
name is emp and column name is salary).
a. UPDATE emp SET sal = salary + 5000;
22/43
b. UPDATE SET sal = salary + 5000;
c. UPDATE emp SET salary = 5000;
d. None of the above.
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. UPDATE emp SET sal = salary + 5000;
103. What is the purpose of the SQL query: “SELECT * FROM Stud ORDER BY Rollno
ASC;”?
a. Display all record in ascending order followed by Rollno
b. To display all the records of the table.
c. Both of the above.
d. None of the above.
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Display all record in ascending order followed by Rollno
104. What does DML stand for?
a. Database Manipulation Language
b. Data Modification Language
c. Data Manipulation Language
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Data Manipulation Language
105. What does SQL stand for?
a. Structured Query Language
b. Structured Quality Language
c. Structural Query Language
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Structured Query Language
106. Which language is used to extract/fetch data from a table?
a. HTML
b. MySQL
c. OOBase
d. Python
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. MySQL
107. In Base, how can data be linked between two or more tables?
a. Foreign key
b. Primary key
23/43
c. Both a) and b)
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Both a) and b)
108. In which view can the structure of a table be changed?
a. Design view
b. Structure view
c. Data view
d. All of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Design view
109. What data type is the Auto Value property used for?
a. Date
b. Character
c. Numeric
d. Binary
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Numeric
110. Which data type is appropriate for storing information such as salary, fees, and
price?
a. Binary data type
b. Alphanumeric data type
c. Date Time
d. Numerical data type
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. Numerical data type
111. In what ways can a table be created?
a. Using a Wizard
b. Using design view
c. Both a) and b)
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Both a) and b)
112. What kind of field is a primary key?
a. Duplicate Data
b. Unique Data
c. Any Data
d. None of the above
24/43
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Unique Data
113. Does data integrity mean that data is accurate and consistent in the database?
a. Yes
b. No
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Yes
114. Which of the following is not a database program?
a. MySQL
b. Writer
c. Oracle
d. OpenOffice base
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Writer
115. What is a database?
a. A collection of attributes
b. A collection of field
c. An organized collection of data
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. An organized collection of data
116. Which field in the “Student” table can act as the primary key?
a. Roll_No
b. Fee
c. Student_name
d. Marks
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Roll_No
117. Is Open Office base an open source software?
a. True
b. False
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. False
118. What is the default name of a table?
a. 1 Table
b. Table 1
c. Untitled 1
d. Tab 1
25/43
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Table 1
119. Which of the following data types will occupy more space in computer memory?
a. Bigint
b. Smallint
c. Tinyint
d. Integer
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Bigint
120. In which view can data be entered in a table?
a. Data view
b. Datasheet view
c. Both a) and b)
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Datasheet view
121. Can relationships be created between _________ tables in Base?
a. One table only
b. Two or more tables
c. Both a) and b)
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Two or more tables
122. Are queries commands that are used to define the structure and modify the data
in a table?
a. True
b. False
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. True
123. Which SQL query will retrieve the details of all students whose favorite color is
blue?
a. SELECT all FROM Stud WHERE fav_Color = ‘Blue’;
b. SELECT all FROM Stud WHERE fav_Color is ‘Blue’;
c. SELECT name FROM Stud WHERE fav_Color = ‘Blue’;
d. SELECT * FROM Stud WHERE fav_Color = ‘Blue’;
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. SELECT * FROM Stud WHERE fav_Color = ‘Blue’;
26/43
124. By default, data is arranged in _____ order using the ORDER BY clause.
a. Descending
b. Ascending
c. Both a) and b)
d. None of the above.
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Ascending.
126. Which of the following is NOT a SQL command?
a. DELETE
b. UPDATE
c. SELECT
d. CREATE
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. CREATE
127. What is a foreign key?
a. A key that can contain null values
b. A key that can contain Zero
c. A key that references another table’s primary key
d. A key that uniquely identifies in table
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. A key that references another table’s primary key
128. Which of the following field properties is for the Numeric data type in Base?
a. Default Value
b. AutoValue
c. Length
d. All of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. All of the above
129. What is the default length of the Integer data type in Base?
a. 20
b. 40
c. 10
d. 50
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. 10
130. We can create a relationship between any two tables by selecting which option
from the which menu?
a. Relationships
27/43
b. Filter
c. Sort
d. All of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Relationships
131. In which relationship, both the tables must have primary key columns?
a. One to Many
b. One to One
c. Many to Many
d. Many to All
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. One to One
132. What are the commands that define the data structure and manipulate the data in
a database?
a. Reports
b. Queries
c. Forms
d. Tables
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Queries
133. Which operators are used to perform simple calculations in Base?
a. Arithmetic Operators
b. Membership Operators
c. Logical Operators
d. Relational Operators
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Arithmetic Operators
134. Can ‘Where’ and ‘Order by’ clauses be used together in a single query?
a. True
b. False
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. True
135. What is the purpose of the Update command in a database?
a. It is used to modify the data of the table.
b. It is used to delete the table.
c. It is used to modify the structure of the table.
d. It is used to insert data in the table.
28/43
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. It is used to modify the data of the table.
136. Which statement is used to remove one or more records from a database?
a. Erase
b. Delete
c. Remove
d. Del
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Delete
137. Can we insert records into a table using a form in a database?
a. True
b. False
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. True
138. Which method is used to create a table step by step?
a. Use Wizard to Create Table
b. Create View
c. Create table in Design View
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Use Wizard to Create Table
140. Which of the following is not a Date Time data type?
a. Date
b. Stamptime
c. Time
d. Timestamp
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Stamptime
141. Binary data types are used for storing data in _________________ formats.
a. image
b. sound
c. boolean
d. binary
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. binary
142. Which of the following is not a category of Open Office data types?
a. Alphanumeric Types
b. Date time
29/43
c. Numeric Types
d. Bool Type
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. Bool Type
143. Which feature helps us get summarized data in a database?
a. Form
b. Query
c. Report
d. Table
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Report
144. Which database feature helps users to systematically store information in a
table?
a. Table
b. Report
c. Form
d. Query
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Form
145. Rajesh wants to display the salary of all the employees after incrementing it by
twice the amount of the present salary. Which query will help her achieve this task?
a. Select salary + 2 from employee;
b. Select salary / 2 from employee;
c. Select salary – 2 from employee;
d. Select salary * 2 from employee;
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. Select salary * 2 from employee;
146. Which feature is used to collect specific information from the pool of data?
a. Form
b. Query
c. Table
d. Report
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Query
147. Which of the following relationships cannot be created in Open Office Base?
a. One to Many
b. Many to Many
30/43
c. One to One
d. Many to All
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. Many to All
148. Which property helps to set the value that is automatically inserted in a field
when a new record is created?
a. Length
b. Entry Required
c. Format
d. Default Value
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. Default Value
149. Which field property in Base can be used to automatically increment the value of
a field?
a. Format
b. Length
c. Auto Value
d. Default Value
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Auto Value
150. In which view can data be entered in a table in Base?
a. Datasheet View
b. Design View
c. Both of the above
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Datasheet View
151. Which of the following is NOT a component of a database management system?
a. Data warehouse
b. Query language
c. Data dictionary
d. Database engine
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Data warehouse
152. Which of the following is NOT a join type in SQL?
a. Outer join
b. Full join
31/43
c. Inner join
d. Circular join
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. Circular join
153. Which element in a table contains data of the same data type?
a. Column
b. Tuple
c. Record
d. All of the above
Show Answer ⟶
a. Column
154. A table has a fixed number of ________ but can have any number of ________
a. tuple, columns
b. columns, rows
c. rows, columns
d. tuple, degree
Show Answer ⟶
b. columns, rows
155. Which of the following acts as an interface to view, enter and change data in a
database?
a. Report
b. Form
c. Table
d. Query
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Form.
156. Which SQL command is used to delete data from a table?
a. INSERT
b. REMOVE
c. SELECT
d. DELETE
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. DELETE
157. Which is the most common DML command?
a. Delete
b. Select
c. Update
d. All of the above
32/43
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Select
158. Which software is appropriate for storing data about school students?
a. Calc
b. MS-Access
c. Writer
d. Impress
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. MS-Access
159. What kind of data storage system stores data in a single table?
a. Only File
b. Relational
c. One File
d. Flat File
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. Flat File
160. What kind of computer holds the actual databases and runs only DBMS and
related software?
a. Database Server
b. Web Server
c. SMPT Server
d. POP Server
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Database Server
161. What is the role of the database server in relation to the GUI?
a. Back End
b. Front End
c. Both a) and b)
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Back End
162. What is duplication of data called?
a. Redundancy
b. Consistency
c. Foreign Key
d. Inconsistency
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Redundancy
33/43
163. Which of the following is not an advantage of a database?
a. Increasing Data Inconsistency
b. Increasing Data Redundancy
c. Data Security
d. Sharing of Data
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Increasing Data Inconsistency
164. Can a database have only one table?
a. Yes
b. No
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. No
165. Which of the following is used to maintain unique records in a table?
a. Composite Key
b. Primary Key
c. Alternate Key
d. Foreign Key
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Primary Key
166. What is a primary key made up of two or more columns called?
a. Composite Primary Key
b. Alternate Primary Key
c. Foreign Primary Key
d. Reference Primary Key
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Composite Primary Key
167. Can duplicate values be entered in a primary key?
a. Yes
b. No
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. No
168. What is a key that refers to the primary key of another table called?
a. Alternate Primary Key
b. Foreign Key
c. Primary Key
d. Alternate Key
Show Answer ⟶
34/43
⟶” swaptitle=”Hide Answer ⟵”] b. Foreign Key
169. What kind of database software is required when data is stored, maintained, and
retrieved from multiple tables?
a. SpreadSheet
b. RDBMS
c. DBMS
d. All of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. RDBMS
170. Does every row in a table have the same structure?
a. True
b. False
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. True
171. What are the basic building blocks of a database?
a. Records
b. Tables
c. Fields
d. All of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Tables
172. What is the default data type of fields?
a. Int
b. Text[Memo]
c. Memo
d. Text[Varchar]Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. Text[Varchar]
173. Does Base automatically add a column as Primary Key if none is added?
a. True
b. False
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. True
174. What is the default length of the Varchar data type?
a. 10
b. 30
c. 50
d. 20
35/43
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. 50
175. What is used to identify the type of data that will be stored in a database?
a. Field
b. Data type
c. Table
d. Record
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Data type
176. Which of the following is not a numerical data type?
a. Varchar
b. Tinyint
c. Boolean
d. Smallint
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Varchar
177. Which of the following data types cannot store decimal values?
a. Boolean
b. Decimal
c. Numeric
d. Real
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Boolean
178. Which data type is used for storing photos, music files, and other binary data?
a. Numeric
b. Varchar
c. Binary
d. Alphanumeric
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Binary
179. Is Char a fixed-length data type and Varchar a variable-length data type?
a. Yes
b. No
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Yes
180. What operations can be performed on data in a table?
a. Insert
b. Delete
36/43
c. Modify
d. All of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. All of the above
181. After inserting records in a table, can the structure of the table be modified?
a. True
b. False
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. False
182. What does sorting mean?
a. Arranging data in decreasing order
b. Arranging data in increasing order
c. Both a) and b)
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Both a) and b)
183. Is Referential Integrity used to maintain accuracy and consistency of data in a
relationship?
a. True
b. False
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. True
184. From which menu a relationship can be created in Base?
a. View
b. Tools
c. Insert
d. Windows
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Tools
185. How many types of relationships can be created between tables in Base?
a. Four
b. Five
c. Three
d. Two
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Three
37/43
186. In Open Office Base, in which view can a query be created?
a. Using wizard
b. Design view
c. Both a) and b)
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Both of the above
187. Can data be deleted using queries in Base?
a. True
b. False
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. False
188. Which statement is used to retrieve data from a table?
a. Print
b. Select
c. Delete
d. Update
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Select
189. What is the purpose of the SQL query: “SELECT empname, salary * 3 FROM
emp;”?
a. Display only name and salary
b. It will give an error.
c. Display empname and three times of the salary of all employees.
d. None of the above.
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Display empname and three times of the salary of all
employees.
190. Which SQL command is used to modify data in a table?
a. SELECT
b. MODIFY
c. DELETE
d. UPDATE
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. UPDATE
191. Which of the following SQL commands are considered as DML commands?
a. UPDATE
b. DELETE
38/43
c. INSERT
d. All of the above.
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. All of the above.
192. What is another name for a tuple in a table?
a. Record
b. Column
c. Both of the above
d. Attribute
Show Answer ⟶
a. Record
193. Which element in a table represents a single data item?
a. Rows
b. Attribute
c. Columns
d. Field
Show Answer ⟶
c. Columns
194. Which of the following is NOT a standard SQL data type?
a. Float
b. Boolean
c. Integer
d. String
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Boolean
195. Which of the following is NOT a function of a database management system?
a. Data retrieval
b. Data manipulation
c. Data storage
d. Data transmission
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. Data transmission
196. Which of the following is NOT a type of data manipulation language (DML)?
a. SELECT
b. UPDATE
c. INSERT
d. DELETE
39/43
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. SELECT
197. What can you do with data in a table created in Base?
a. Modify it
b. Insert it
c. Delete it
d. All of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. All of the above
198. In which view can the structure of a table be changed in Base?
a. Design View
b. Datasheet View
c. Both of the above
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Design View
199. Which field property in Base can be used to store data in a specific format, such
as a phone number?
a. Auto Value
b. Length
c. Default Value
d. Format
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. Format
200. What is the default value of the field property ‘Entry Required’ in Base?
a. Yes
b. No
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. No
201. To arrange the data in ascending or descending order, first select the column(s)
and then click on which button?
a. View
b. Save
c. Arrange
d. Sort
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. Sort
40/43
202. When a primary key from one table appears in another table, it is called a
________.
a. Composite Primary Key
b. Secondary Key
c. Foreign Key
d. Main Key
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Foreign Key
203. In which relationship, one of the table must have primary key column?
a. One to Many
b. One to One
c. Many to Many
d. Many to All
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. One to Many
204. Once the relationships applied on the tables cannot be removed.
a. True
b. False
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. False
205. To remove the relationship between tables, right-click on the relationship thread
and select which option?
a. Delete
b. Remove
c. Edit
d. Clear
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Delete
206. Which language is used to write a query in Open Office Base?
a. VB
b. SQL
c. C
d. Python
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. SQL
207. Which command is used to retrieve data from a table?
a. Delete
b. Create
41/43
c. Select
d. Insert
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Select
208. Can SELECT statement retrieve data from multiple tables?
a. True
b. False
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. True
209. Rajesh wants to display all the records from the table ‘student’.
a. Select * student;
b. Select # from student;
c. Select from student;
d. Select * from student;
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. Select * from student;
210. Which clause can be used with the SELECT SQL command to display records
containing the same type of values?
a. Order By
b. Where
c. Both a and b
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Where
211. Which commands are used to add, modify, and delete records in a database
table?
a. Insert, Update, and Remove
b. Insert, Update, and Delete
c. Insert, Modify, and Delete
d. Add, Update, and Delete
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Insert, Update, and Delete
212. By default, in which order is data arranged using the ORDER BY clause in a
database?
a. Decreasing
b. Alphabetical
c. Increasing
d. Descending
42/43
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Increasing
213. Which clause of the SELECT statement helps to display specific data in a
database?
a. Where
b. Between
c. Order By
d. None of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Where
214. What is the name of the interface in a user-specified layout that lets users view,
enter, and change data directly in database objects such as tables?
a. Query
b. Form
c. Report
d. Table
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Form
215. Aman created an object ‘X’ in Base to store the value in the form of rows and
columns. What is ‘X’?
a. Table
b. Row
c. Column
d. Database
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] a. Table
216. Which of the following contains data of the same data type?
a. Record
b. Tuple
c. Column
d. All of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. Column
217. Give an example of an open-source RDBMS.
a. Microsoft SQL Server
b. Microsoft Access
c. Oracle
d. OpenOffice Base
43/43
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. OpenOffice Base
218. What is the default length of the TINYINT data type?
a. 1
b. 2
c. 3
d. 4
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] c. 3
219. Which data type can store character/data up to the length specified by the user?
a. Varchar
b. Char
c. Varchar_IgnoreCase
d. All of the above
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] d. All of the above
220. Dhriti wants to store the details of students as well as their pictures in a table
named “school”. Which data type is suitable for storing pictures?
a. Boolean
b. Binary
c. Memo
d. Varchar
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Binary
221. Which data type stores hours, minutes, and second information?
a. Date
b. Time
c. Stamptime
d. Timer
Show Answer ⟶
⟶” swaptitle=”Hide Answer ⟵”] b. Time
Comments
Post a Comment