1. An organized collection of logically related data is known as
2. In databases, Locking level is also called as
3. Which of the following is not a database application?
4. HSAM stands for ________ .
5. Which of the following is not a logical database structure?
6. In a datasheet, what does each column represent?
7. In a datasheet, what does each row represent?
8. A ________ is a unit of information in a ________.
9. What do you call a primary key field included in another table?
10. Which type of field is incremented automatically?
11. Which object is used to create a form?
12. What determines a table's sort order?
13. What is an intersection of a row and a column?
14. Which tool do you use to create a query object?
15. Which of the following is not a view for interacting with a form object?
16. What is the purpose of indexing?
17. Which is the valid data type in Access?
18. How many relations may exist between tables in databases?
19. What is the full form of SQL?
20. Which data type is better to use for storing phone number in the following format “977-1-1234567”?
21. What do you call a collection of records matching parameters of a query?
22. Which query do you use to answer the question “Which employees earn more than $5000 a month”?
23. In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
24. What does the expression [detail] ! [product] * 1.30 do?
25. Which criteria return only those addresses beginning with the letter “K”?
26. Which criteria do not return the position “Officer” as a match?
27. Which query do you use to answer the question “What is the average salary of the employees”?
28. What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
29. How to make a date field DOB store the dates like “2002/10/17” ?
30. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
31. In an application created using the database wizard, the main menu is presented as a:
32. Which leads you through the process of creating a table?
33. Which data type is better to use for storing the price of an item?
34. Which do you click to display the table’s primary key and indexes in a separate window?
35. After right click the field selector button, which do you choose to delete a field in design view?
36. Which tool is used to generate printout of a table’s structure?
37. Which of the following is not a legitimate section for form objects?
38. The basic elements of a form or a report are called:
39. Which control types is most often associated with a bound control?
40. Which control type do you use to create a calculated control?
41. Which is not a view for displaying a report object?
42. The report footer section is most useful for displaying:
43. Which function can not be used for calculated controls in a report?
44. Which setting you must modify to print a report using letterhead?
45. In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?
46. Which is not an option for customizing a datasheet window?
47. Which is not a command that is selectable from right click menu of a field column?
48. What do you call the process of restricting the display of records in a table to those matching a particular criterion?
49. In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?
50. Which of the following is not an action query?
51. In MS Access, Text Data type may contain maximum character of
52. Which of the following is not a valid Data Type in MS Access?
53. In MS Access "Hyperlink" Data Type can store
54. Which of the following data type is used to store logical value in MS Access?
55. The appropriate Data Type to store Time in MS Access?
56. In MS Access "Lookup Wizard" is used to
57. Which of the following Data Type is used to store picture in MS Access
58. in MS Access, which data type is appropriate to store large text and numbers?
59. in MS Access, OLE Object Data type can store
60. in MS Access, AutoNumber Data Type
61. Which of the following is use to get data from user?
62. Which of the following is invalid field name?
63. Primary key is _____.
64. To create a table in Access
65. Which of the following is use to view or print the data in organized manner?
66. In a table to insert User's Voice, Data field should be
67. In a table Multiple Primary Keys can be set
68. After creating the table which of the following is correct?
69. Validation Rule in a field will ______.
70. Query can be use to select data from
71. Data can be import into Access Database from
72. What is the use of Referential Integrity in MS Access?
73. In MS Access, Field Value may contain
74. Which of the following is the DBMS type
75. Which of the following relationship is not valid in MS Access ?
76. A collection of related tables is called
77. Which of the following Format supports for Data Type Yes/No?
78. Queries can be created in Access by
79. Relationship can be establish between two tables by
80. What is the use of Cascade Delete Option in MS Access?
2. In databases, Locking level is also called as
3. Which of the following is not a database application?
4. HSAM stands for ________ .
5. Which of the following is not a logical database structure?
6. In a datasheet, what does each column represent?
7. In a datasheet, what does each row represent?
8. A ________ is a unit of information in a ________.
9. What do you call a primary key field included in another table?
10. Which type of field is incremented automatically?
11. Which object is used to create a form?
12. What determines a table's sort order?
13. What is an intersection of a row and a column?
14. Which tool do you use to create a query object?
15. Which of the following is not a view for interacting with a form object?
16. What is the purpose of indexing?
17. Which is the valid data type in Access?
18. How many relations may exist between tables in databases?
19. What is the full form of SQL?
20. Which data type is better to use for storing phone number in the following format “977-1-1234567”?
21. What do you call a collection of records matching parameters of a query?
22. Which query do you use to answer the question “Which employees earn more than $5000 a month”?
23. In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
24. What does the expression [detail] ! [product] * 1.30 do?
25. Which criteria return only those addresses beginning with the letter “K”?
26. Which criteria do not return the position “Officer” as a match?
27. Which query do you use to answer the question “What is the average salary of the employees”?
28. What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
29. How to make a date field DOB store the dates like “2002/10/17” ?
30. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
31. In an application created using the database wizard, the main menu is presented as a:
32. Which leads you through the process of creating a table?
33. Which data type is better to use for storing the price of an item?
34. Which do you click to display the table’s primary key and indexes in a separate window?
35. After right click the field selector button, which do you choose to delete a field in design view?
36. Which tool is used to generate printout of a table’s structure?
37. Which of the following is not a legitimate section for form objects?
38. The basic elements of a form or a report are called:
39. Which control types is most often associated with a bound control?
40. Which control type do you use to create a calculated control?
41. Which is not a view for displaying a report object?
42. The report footer section is most useful for displaying:
43. Which function can not be used for calculated controls in a report?
44. Which setting you must modify to print a report using letterhead?
45. In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?
46. Which is not an option for customizing a datasheet window?
47. Which is not a command that is selectable from right click menu of a field column?
48. What do you call the process of restricting the display of records in a table to those matching a particular criterion?
49. In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?
50. Which of the following is not an action query?
51. In MS Access, Text Data type may contain maximum character of
52. Which of the following is not a valid Data Type in MS Access?
53. In MS Access "Hyperlink" Data Type can store
54. Which of the following data type is used to store logical value in MS Access?
55. The appropriate Data Type to store Time in MS Access?
56. In MS Access "Lookup Wizard" is used to
57. Which of the following Data Type is used to store picture in MS Access
58. in MS Access, which data type is appropriate to store large text and numbers?
59. in MS Access, OLE Object Data type can store
60. in MS Access, AutoNumber Data Type
61. Which of the following is use to get data from user?
62. Which of the following is invalid field name?
63. Primary key is _____.
64. To create a table in Access
65. Which of the following is use to view or print the data in organized manner?
66. In a table to insert User's Voice, Data field should be
67. In a table Multiple Primary Keys can be set
68. After creating the table which of the following is correct?
69. Validation Rule in a field will ______.
70. Query can be use to select data from
71. Data can be import into Access Database from
72. What is the use of Referential Integrity in MS Access?
73. In MS Access, Field Value may contain
74. Which of the following is the DBMS type
75. Which of the following relationship is not valid in MS Access ?
76. A collection of related tables is called
77. Which of the following Format supports for Data Type Yes/No?
78. Queries can be created in Access by
79. Relationship can be establish between two tables by
80. What is the use of Cascade Delete Option in MS Access?
