Information Technology
Class-10
Unit- 3(B) Database Management System (Advanced) PART-I
A. Multiple Choice Questions:
1. What identifies the content of a field?
a. Data b. Field value c. Field name d. Table name
Answer: Field Name
2. Which of the following is not a field type in MS Access?
a. Hyperlink b. Number c. Currency d. True/False
Answer: True/False
3. Field validation is set in fields:
a. Input Mask property b. Validation rule property c. Default value property d. Validation act property
Answer: Validation Rule property
4. Which of the following wizard is used to create lookup fields?
a. Table wizard b. Form wizard c. Field wizard d. Lookup wizard
Answer: Lookup Wizard
5. Text datatype in MS Access stores:
a. Upto 64000 characters b. Upto 255 character c. Upto 1024 character d. Upto 13064 characters
Answer: Upto 64000 characters
6. Which of the following is not a Microsoft Access database object?
a. Queries b. Tables c. Forms d. SQL
Answer: SQL
7. What is the full form of SQL?
a. Sequence query language b. Structured Query language c. Structured Query layout d. Sequential Query language
Answer: Structured Query Language
8. Which of the following is a basic object of a database?
a. form b. query c. table d. report
Answer: Table
9. A form can be prepared for:
a. Automating the task b. Accepting input c. Printing labels d. None of these
Answer: Accepting input
10. Which of the following is not an aggregate function in SQL?
a. SUM() b. MAX() c. AVG() d. CONCAT()
Answer: CONCAT()
11. ________ DDL command is used to create a table.
a. ALTER b. CREATE c. DESIG d. NEW
Answer: CREATE
12. ________ DDL command is used to change the structure of a database.
a. CHANGE b. TRUNCATE c. ALTER d. MODIFY
Answer: Alter
13. ________ property is used to filter the data either in the ascending or descending order.
a. Sort b. Arrange c. Query d. Criteria
Answer: Sort
14. ___________ helps us to retrieve the filtered data based upon specified conditions.
a. Report b. Table c. Query d. Form
Answer: Query
15. Which of the following is not a logical operator?
a. NOT b. DOT c. AND d. OR
Answer: DOT
16. In database_________ helps us to retrieve the filtered data based upon some conditions.
a. Forms b. Reports c. Queries d. Table
Answer: Queries
17. Aadya wants to create a connection between two or more tables. Suggest her the option to accomplish the task.
a. Table b. Form c. Relationships d. Sorting
Answer: Relationships
18. _______ data type takes the values in the form of 0 and 1 in the database.
a. Integer b. Text c. Boolean d. Memo
Answer: Boolean
B. State T for true F for false:
1. Maximum size of text field is 256 characters.
Answer: F
2. An error message appears when an incorrect or restricted value is entered in a field with a validation rule.
Answer: T
3. There can be multiple primary keys in a table.
Answer: F
4. Validation rule box is used to specify the requirements for data entered into the field.
Answer: T
5. A query is an object of MS Access.
Answer: T
6. A query produces the output result like a table.
Answer: T
7. Without a table, report can be generated.
Answer: F
8. The UPDATE command is used for producing the query result.
Answer: F
9. AND is an arithmetic operator.
Answer: F
10. SUM() is an aggregate function in SQL.
Answer: T
11. A form can be used to accept input from the users.
Answer: T
12. Data entered in a form can update a table directly.
Answer: T
13. A form can be modified in Design view.
Answer: T
C. Fill in the blanks:
1. ___________ view provides the tool for creating field in a table/report.
Answer: Design
2. _____________ is a field which when used as a primary key numbers each record sequentially.
Answer: AutoNumber
3. Primary key is used to ____________ identify records in a table.
Answer: Uniquely
4. A number field can store up________ bytes.
Answer: 16
5. A _________ is a collection of records where each and every record contains similar kind of information.
Answer: Database
Some other links:
.jpg)
No comments:
Post a Comment