Q1. What is the primary purpose of a database management system (DBMS)?
a) To manage spreadsheets
b) To store and manage data efficiently
c) To create documents
d) To generate presentations
Show Answer
Correct Answer: b) To store and manage data efficiently
Explanation: A DBMS is designed to handle large amounts of data efficiently, ensuring that data is stored, managed, and retrieved effectively.
Q2. When creating a database, which of the following is NOT typically a step?
a) Defining tables
b) Setting field types
c) Printing the database
d) Entering initial data
Show Answer
Correct Answer: c) Printing the database
Explanation: Printing the database is not a typical step in database creation. The usual steps involve defining tables, setting field types, and entering data.
Q3. In database terminology, what is a ‘field’?
a) A section of a table that holds data
b) A set of rows in a table
c) A type of database
d) A command to sort data
Show Answer
Correct Answer: a) A section of a table that holds data
Explanation: A field in a database is a specific area within a table where individual data values are stored. Each field holds data of a particular type.
Q4. What does the term ‘field type’ refer to?
a) The color of the field
b) The data format for the field
c) The size of the field
d) The name of the field
Show Answer
Correct Answer: b) The data format for the field
Explanation: Field type refers to the data format or datatype that the field will hold, such as text, number, date, etc.
Q5. Which command would you use to sort data in a table?
a) ORDER BY
b) GROUP BY
c) SELECT
d) JOIN
Show Answer
Correct Answer: a) ORDER BY
Explanation: The ORDER BY command is used in SQL to sort the result set of a query by one or more columns.
Q6. How can you find and replace text in a table?
a) Use the FIND and REPLACE features
b) Use the PRINT command
c) Use the SAVE AS option
d) Use the DELETE command
Show Answer
Correct Answer: a) Use the FIND and REPLACE features
Explanation: Most DBMS software provides FIND and REPLACE functions to locate specific text and replace it with new text.
Q7. What does the ‘Queries Wizard’ allow you to do?
a) Design the database schema
b) Create and run queries
c) Modify table structures
d) Print tables
Show Answer
Correct Answer: b) Create and run queries
Explanation: The Queries Wizard helps in designing and running queries to extract or manipulate data from the database.
Q8. Which of the following is NOT typically a feature of a report created using a report wizard?
a) Formatting of data
b) Sorting data
c) Creating tables
d) Aggregating data
Show Answer
Correct Answer: c) Creating tables
Explanation: A report wizard focuses on formatting, sorting, and aggregating data, but not on creating tables.
Q9. To modify an existing report, which of the following should you use?
a) Report Wizard
b) Query Wizard
c) Table Design View
d) Form Wizard
Show Answer
Correct Answer: a) Report Wizard
Explanation: The Report Wizard allows you to modify the design and layout of an existing report.
Q10. How can you print a table in most DBMS software?
a) Use the PRINT command
b) Use the EXPORT option
c) Use the REPORT function
d) Use the SAVE AS option
Show Answer
Correct Answer: a) Use the PRINT command
Explanation: The PRINT command or option is typically used to print the contents of a table directly.