Q31. What is the main purpose of creating a form in a database?
a) To view and modify data easily
b) To print tables
c) To create new tables
d) To design queries
Show Answer
Correct Answer: a) To view and modify data easily
Explanation: Forms provide a user-friendly interface for entering, viewing, and modifying data.
Q32. Which of the following is NOT a typical field type?
a) Date/Time
b) Currency
c) Hyperlink
d) Chart
Show Answer
Correct Answer: d) Chart
Explanation: Chart is not a field type but rather a way to visualize data. Field types include Date/Time, Currency, and Hyperlink.
Q33. What is the function of the ‘Save’ option when working with a table?
a) To preserve changes made to the table
b) To print the table
c) To close the table
d) To open a new table
Show Answer
Correct Answer: a) To preserve changes made to the table
Explanation: The Save option ensures that any changes made to the table are preserved.
Q34. Which tool is used to enter data into a table?
a) Data Entry Form
b) Report Wizard
c) Query Wizard
d) Table Design View
Show Answer
Correct Answer: a) Data Entry Form
Explanation: A Data Entry Form is specifically designed to input data into a table.
Q35. How can you sort data in ascending order in most DBMS?
a) Use the SORT ASCENDING command
b) Use the ORDER BY clause with ASC
c) Use the FILTER option
d) Use the FIND command
Show Answer
Correct Answer: b) Use the ORDER BY clause with ASC
Explanation: The ORDER BY clause with ASC (ascending) is used to sort data in ascending order.
Q36. What should you do to ensure data integrity in a table?
a) Define appropriate field types and constraints
b) Regularly delete old records
c) Frequently print the table
d) Create multiple copies of the table
Show Answer
Correct Answer: a) Define appropriate field types and constraints
Explanation: Data integrity is maintained by defining correct field types and applying constraints to ensure data accuracy and consistency.
Q37. When using a form, which of the following actions can you perform?
a) Enter new data into the database
b) Modify table structures
c) Run complex queries
d) Print database reports
Show Answer
Correct Answer: a) Enter new data into the database
Explanation: Forms are designed to simplify the process of entering new data into the database.
Q38. What is the primary benefit of using a database ‘report’?
a) To analyze and present data in a structured format
b) To enter new records
c) To modify table schemas
d) To execute queries
Show Answer
Correct Answer: a) To analyze and present data in a structured format
Explanation: Reports are used to analyze and present data in a clear and organized manner, often for review or printing.
Q39. To view the structure of a table, which view should you use?
a) Design View
b) Data View
c) Print View
d) Layout View
Show Answer
Correct Answer: a) Design View
Explanation: Design View shows the structure of a table, including field names, types, and properties.
Q40. What is the purpose of the ‘Query Wizard’ in a database?
a) To simplify the creation of queries
b) To format reports
c) To design tables
d) To enter data
Show Answer
Correct Answer: a) To simplify the creation of queries
Explanation: The Query Wizard helps users create and execute queries by guiding them through a series of steps.