DATABASE MANAGEMENT SYSTEM
SESSION 8-12 BOOK BACK MCQ’S
SESSION 8: INTRODUCTION TO DATABASE MANAGEMENT
SYSTEM
OBJECTIVE TYPE QUESTIONS:
[Link] Organized collection of data is known as _____________
(A) Knowledge
(B) Record
(C) Database
(D) Information
2. Databases can be created and managed using ___________
(A) Database Management System
(B) Database Record System
(C) Database Backup
(D) All the Above
3. A database based on relational model is known as _____________
(A) Relativity of Base
(B) Database Relationship System
(C) Relational Database Management System
(D) Flat file
4. Which of the following is not an example of Flat file?
(A) Word
(B) Excel
(C) CSV
(D) Google Spreadsheet
5. Which of the following is a popular Database Management System Software?
(A) Java
(B) Python
(C) Lotus
(D) Oracle
6. How are Attributes represented in Database?
(A) As records
(B) As tables
(C) As columns
(D) As rows
SESSION 9: STARTING WITH LIBRE OFFICE BASE
OBJECTIVE TYPE QUESTIONS:
1.___________ is the simplest example of data stored in RDBMS
(A) Row
(B) Column
(C) Shape
(D) Table
2. Which of the keys uniquely identifies each record?
(A) Primary
(B) Foreign
(C) Candidate
(D) Alternate
3. A table can have ____________ number of columns but ____________
number of rows.
(A) Definite, Any
(B) Any, Definite
(C) Five, Seven
(D) Six, Ten
4. Which data type is used to store match time?
(A) Decimal
(B) Float
(C) Time
(D) Binary
5. How many ways does LibreOffice Base offer for creating a table?
(A) 2
(B) 3
(C) 4
(D) 5
SESSION 10: WORKING WITH MULTIPLE TABLES
1. Which keys help in linking two or more tables?
(A) Primary key
(B) Foreign key
(C) Both (A) and (B)
(D) None of the above
2. Relationship between tables help to ________
(A) Save Time
(B) Reduce data-entry errors
(C) Summarize data from related tables
(D) All of the above
3. When one record in one table has corresponding one record in the other table.
It is known as _________________
(A) One-to-One relationship
(B) One-to-Many relationship
(C) Many-to-Many relationship
(D) None of the above
4. When one record in a table has multiple records in the other table. It is a case
of ___________
(A) One-to-One relationship
(B) One-to-Many relationship
(C) Many-to-Many relationship
(D) None of the above
5. The benefits of which feature of RDBMS are the following:
● Increases productivity
● Allows programmer to complete the task in fewer programs
● There is reduction in data errors
(A) Data Types
(B) Primary Keys
(C) Referential Integrity
(D) None of the these
6. Among the Update options available in Relations dialog, which option
corresponds to the description that: “Specifies that any change made to a
primary key does not affect other external key fields.”
(A) No Action
(B) Updating Cascade
(C) Set Null
(D) Set Default
7. Which of the following is not an advantage of relating tables?
(A) Prevents Data Redundancy
(B) Ensure Data Inconsistency
(C) Validates Data Entry
(D) Automatic Updates
8. From the Delete options available under Relations dialog, which options can
be described as: “If you delete the corresponding primary key, a set value will
be set to all external key fields.”
(A) No Action
(B) Delete Cascade
(C) Set Null
(D) Set Default
9. Which of the following is NOT a type of relation between tables?
(A) One-to-One
(B) One-to-Many
(C) Many-to-Many
(D) Many-to-One
SESSION 11: QUERIES IN BASE
OBJECTIVE TYPE QUESTIONS:
1. Which of the following is used to organize and store data in a structured
format?
(A) Query
(B) Report
(C) Table
(D) Database
2. Which of the following methods can be used to create a query?
(A) Wizard
(B) Design View
(C) SQL
(D) All of the Above
3. Which of the following is used to run the query?
(A) F3
(B) F4
(C) F5
(D) F6
4. Which of the following relational operators can be used to set criteria when
designing a query in LibreOffice Base?
(A) >
(B) =
(C) !=
(D) All of these
5. What type of operations can be performed when creating queries in a
database?
(A) Data entry only
(B) Numerical
(C) Only Text formatting
(D) Both (B) and (C)
6. Which clause is used to filter records based on a condition?
(A) where
(B) Order By
(C) Select
(D) Having
7. What is the significance of the ASC in the below SQL command?
Select * From GroceryItems Order By Cost ASC;
(A) For ASCII Code
(B) For taking input
(C) Ascending order
(D) None of these
8. What DBMS entity follows the FROM keyword in a SQL query?
(A) Forms
(B) Reports
(C) Tables
(D) Query names
9. Which of the following keywords specified in an SQL query is optional?
(A) WHERE
(B) FROM
(C) Both (A) and (B)
(D) None of these
SESSION 12: FORMS AND REPORTS
1. What is the primary function of a form in a database?
(A) To store data
(B) To manage queries
(C ) To provide user-friendly interface for data entry and viewing
(D) To create reports
2. Which tool should you use to change the background color of a form in
LibreOffice Base?
(A) Font Style tool
(B) Page Style Option
(C) Control Properties
(D) Label Field dialog box
3. How do you edit the label of a control in a form?
(A) Right-click the label and choose “Edit Label”
(B) Use the Font tool to change and change the label text
(C) Right-click the label and select “Control Properties” to
update it
(D) Select the label and press the Delete key
4. Which key do you need to press while clicking a control to select it for
resizing?
(A) Alt
(B) Shift
(C) Ctrl
(D) Tab
5. What is a tool tip in LibreOffice Base?
(A) A Label for a control
(B) A message displayed when the mouse hovers over a control
(C) A property that changes the size of a textbox
(D) A part of the database that stores the data
6. How do you enable the calendar feature in the date field of a form?
(A) Change the Data Format property to Standard (Short)
(B) Set the Drop-Down property to Yes
(C) Change the Label Field property
(D) Use the Font tool to adda calendar.
7. In the Form Controls toolbar, which tool is used to create headings or
subheadings in a form?
(A) Calendar tool
(B) Label tool
(C) Textbox tool
(D) Date Field tool
8. What is the purpose of the “New Record” button in the Records toolbar?
(A) To save the current record
(B) To create a new table
(C) To insert a new record into the database
(D) To delete an existing record
9. What type of object allows you to present data from a query in a visually
appealing format?
(A) Form
(B) Report
(C) Table
(D) Query
10. How can you insert the current date and time into a report?
(A) Right-click the report and select “Insert Date and Time”
(B) Go to Insert -> Date and Time in the Page Header area
(C) Open the Control Properties and change the Date Format
(D) Use the Label tool in the Forms Control toolbar
11. Using Form Wizard, in which step number does the Set Name title of the
step come?
(A) 5
(B) 6
(C) 7
(D) 8
12. Using the Form Wizard, in which step number does the Arrange Controls
title come up?
(A) 4
(B) 5
(C) 6
(D) 7
13. In the Form wizard, step 7, Apply Styles, for what text chosen for Field
Border does the field borders of the form have a 3-D look?
(A) No Border
(B) 3-D look
(C) Flat
(D) 2-D look
14. If you use wizard to create a report, what is the step name for the first step?
(A) Labelling field
(B) Grouping
(C) Field Selection
(D) Choose layout
DATABASE MANAGEMENT SYSTEM
SESSION 8-12 BOOK BACK FILL IN THE BLANKS:
[Link] key in a database table that distinctly identifies each record is known as
PRIMARY KEY.
2.A DATABASE MANAGEMENT SYSTEM provides a computerized data
storing mechanism.
3. A Database management system can be categorized as FLAT FILE or
RELATIONAL FILE.
4. Tables are created in such a manner that each ROW consists of one type of
record.
5. The possibility of duplicate or redundant data is greatly REDUCED in a
database.
[Link] most common example for a FLAT FILE is the CSV file or an excel
sheet.
7.A database SERVER is a machine that is solely dedicated to providing a
database related service. It is a crucial element of any background related
application.
[Link] attributes(columns) of a relation are DISTINCT which means that each
cell of a relation contains exactly one value.
[Link] are identified by the content and not by ORDER hence records are
never stored in any particular order.
[Link] TINY INT datatype stores integers in the range 0 to 255.
[Link] BOOLEAN data types stores of 0 OR 1 only.
[Link] TIME STAMP data types stores information of timestamp which
includes data and time details.
[Link] edit the fields of a table, you can right-click on a table and click on EDIT
button.
[Link] of a column can be SORTED by selecting the column and clicking any
one of the sorting buttons.
[Link] in database design are described with the help of
REFEENTIAL INTEGRITY
[Link] TO MANY relationships is when one record in one table has
corresponding one record in the other table.
[Link] create a relationship between tables, select a table and click on TOOLS-
>RELATIONSHIPS.
[Link] ADD TABLES window allows you to select and add tables for creating
relationships
[Link] a primary key is modified, the set NULL option assigns the value NULL
to all external key fields.
[Link] Delete Cascade options specifies that when a primary key is deleted, all
related EXTERNAL KEYS are also deleted.
[Link] a ONE-TO-ONE relationship, one record in one table corresponds to one
record in another table,
[Link] of the benefits of referential integrity is that it helps prevent
INCORRECT data entry.
23.A DATABASE serves to store data in a structured way.
[Link] simplify the tasks by allowing us to quickly extract specific data
without manually going through each record.
25. In the 1960S, THE FIRST DBMS systems were created to handle complex
data for businesses.
26.A Query can be created in 2 ways.
27. The result of the query can be displayed in ASCENDING OR
DESCENDING order of any particular field of the table
[Link] Office BASE is a DBMS.
[Link] rules of NORMALIZATION were first formulated by E,[Link] in
IBM
[Link] Report Wizard, the step number 5 is the Sort options for displaying data.
[Link] option will save the report as a template. When you open a DYNAMIC
report, it will display with the current data contents.
[Link] FLAT as the Field Border from Form Wizard dialog box specifies
that the field borders look flat.