| 1. | The following term applies to a collection of related records in a database |
| A. | File |
| B. | Layout |
| C. | File |
| D. | Field |
| Answer» A. File | |
| 2. | This set of related data items is known as a |
| A. | File |
| B. | Record |
| C. | Table |
| D. | None of the above |
| Answer» B. Record | |
| 3. | The framework for storing records in database is a |
| A. | Form |
| B. | Report |
| C. | Query |
| D. | Table |
| Answer» C. Query | |
| 4. | The following command is used to search the record that satisfies the specified criteria |
| A. | FOUND |
| B. | SEARCH |
| C. | GET |
| D. | LOCATE |
| Answer» A. FOUND | |
| 5. | The data in a record is of the following types |
| A. | four text fields and three numeric fields |
| B. | two integer fields and five text fields |
| C. | three text fields and four numeric fields |
| D. | none of the above |
| Answer» B. two integer fields and five text fields | |
| 6. | A treelike structure of records in a database. Select the best fit for answer |
| A. | Hierarchical database structure |
| B. | Relational database structure |
| C. | Multidimensional database structure |
| D. | Sequential database access |
| Answer» A. Hierarchical database structure | |
| 7. | The following language used by most of the DBMSs for helping their users to access data |
| A. | High level language |
| B. | Query language |
| C. | SQL |
| D. | 4GL |
| Answer» A. High level language | |
| 8. | What is a largest collection of data stored in a computer? You might use this type of program to keep a record of all the friends in your address book. |
| A. | Information Processing |
| B. | Spreadsheet |
| C. | Operating system |
| D. | Database |
| Answer» D. Database | |
| 9. | Which command is used to replace ? |
| A. | REPLACE |
| B. | REPLACE ALL |
| C. | Add record from edit menu |
| D. | All of above |
| Answer» C. Add record from edit menu | |
| 10. | The following part of a database that holds only one type of information |
| A. | Report |
| B. | Query |
| C. | Record |
| D. | Field |
| Answer» D. Field | |
| 11. | All of the following terms are related to computerized databases except which one? |
| A. | Search |
| B. | Sort |
| C. | Field names |
| D. | Record grab |
| Answer» A. Search | |
| 12. | Need to see all the information from two tables on one form. Insert |
| A. | A page break |
| B. | A subform |
| C. | A linked command button |
| D. | None of the above |
| Answer» B. A subform | |
| 13. | What is the primary difference between a pivot table report and a cross tab query? |
| A. | A pivot table report can contain sums, counts, and averages while a cross tab query cannot. |
| B. | You can’t pivot a cross tab query |
| C. | A cross tab query lets you group similar items. A pitot table report does not |
| D. | None of above |
| Answer» B. You can’t pivot a cross tab query | |
| 14. | The largest unit of a database is |
| A. | A record |
| B. | A field |
| C. | A subfield |
| D. | None of above |
| Answer» B. A field | |
| 15. | What’s the best Access object for an invoice you’ll mail to customers? |
| A. | A report |
| B. | A form |
| C. | A table |
| D. | All of the above |
| Answer» A. A report | |
| 16. | What is a Grouped Report? |
| A. | A type of report that can be generated by the Report Wizard |
| B. | A report that displays data that has been sorted in ascending or descending order |
| C. | A report that displays data grouped by fields you specify |
| D. | None |
| Answer» C. A report that displays data grouped by fields you specify | |
| 17. | Which field allow to select items from drop down list? |
| A. | An OLE field |
| B. | A Memo Field |
| C. | A lookup Field |
| D. | A hyperlink field |
| Answer» C. A lookup Field | |
| 18. | What did the first Table Analyzer do? |
| A. | Analyze the data in a set of flat files and automatically create a relational database system from that information |
| B. | Provide a graphic way to design relational databases |
| C. | Automate process of connecting tables to SQL Server |
| D. | None |
| Answer» A. Analyze the data in a set of flat files and automatically create a relational database system from that information | |
| 19. | Pivot Table reports are good for |
| A. | Analyzing large amounts of data |
| B. | Turning tables upside down |
| C. | Breaking spreadsheet data into multiple worksheet |
| D. | None of above |
| Answer» A. Analyzing large amounts of data | |
| 20. | Which of the following are common ways to enforce data validation when entering data into an Access form? |
| A. | Create an input mask to restrict the kind of value that can be entered in positions across the field. |
| B. | Define a validation rule for that field |
| C. | A and B |
| D. | none of the above |
| Answer» C. A and B | |
| 21. | The purpose of the Add-in Manager is to |
| A. | Create macros and automate data processing |
| B. | Add or remove data in an existing database |
| C. | Add or remove templates, macros, and wizards |
| D. | All of above |
| Answer» C. Add or remove templates, macros, and wizards | |
| 22. | Sub-schema can be used to |
| A. | Create very different, personalized views of the same data |
| B. | Present information in different formats |
| C. | Hide sensitive information by omitting fields from the subschema’s description |
| D. | All of the above |
| Answer» D. All of the above | |
| 23. | If you are entering data in a form, a quick way to cpy a value from the previous record is to press |
| A. | Ctrl+’ |
| B. | F6 |
| C. | Ctrl+D |
| D. | None of the above |
| Answer» A. Ctrl+’ | |
| 24. | DBMS is |
| A. | Collection of data |
| B. | Set of programs to access those data |
| C. | Set of programs to update those data |
| D. | All of the above |
| Answer» D. All of the above | |
| 26. | COUNT command is used to | |
| A. | Count the number of data fields in an active database file | |
| B. | Count the number of data files which are active | |
| C. | Count the records which are updated | |
| D. | Count the number of records in an active database file | |
| Answer» D. Count the number of records in an active database file | ||
| 27. | What is the term to ask the computer to pt information in order numerically or alphabetically ? |
| A. | Crop |
| B. | Report |
| C. | Sort |
| D. | Organize |
| Answer» C. Sort | |
| 28. | The raw facts are called |
| A. | Data |
| B. | Programs |
| C. | Commands |
| D. | Responses |
| Answer» A. Data | |
| 29. | The term refers to a collection of related information |
| A. | Database |
| B. | List |
| C. | Outline |
| D. | Record |
| Answer» C. Outline | |
| 30. | A form that is used to collect data in a structured manner for entry to a database is called a |
| A. | Database deign form |
| B. | Systems flowchart |
| C. | Data capture form |
| D. | None of above |
| Answer» C. Data capture form | |
| 31. | The following command is used for inserting records |
| A. | INSERT |
| B. | ADD |
| C. | Both of the above |
| D. | None of the above |
| Answer» A. INSERT | |
| 32. | The Query is a statement requesting for |
| A. | Insertion of information |
| B. | Deletion of information |
| C. | Update of information |
| D. | Retrieval of information |
| Answer» D. Retrieval of information | |
| 33. | The activity of a file |
| A. | Is a low percentages of number of records added or deleted from a file |
| B. | If high, reduces processing efficiency for sequential and non sequential files |
| C. | Is a measure of the percentage of existing records updated during a run |
| D. | Refers to how closely the files fit into the allocated |
| Answer» A. Is a low percentages of number of records added or deleted from a file | |
| 34. | The following statement is not valid about indexing |
| A. | it stores the index fields |
| B. | it stores the corresponding record number |
| C. | it maintains the alphabetically order |
| D. | it duplicate the database file |
| Answer» D. it duplicate the database file | |
| 35. | The following devices can be used to input data into a database |
| A. | Keyboard, fax roller ball |
| B. | Mouse, keyboard, monitor |
| C. | Mouse, keyboard, touch screen |
| D. | None of the above |
| Answer» C. Mouse, keyboard, touch screen | |
| 36. | The following command is used for sorting |
| A. | list |
| B. | browse |
| C. | index |
| D. | sort |
| Answer» C. index | |
| 37. | List command is used to get |
| A. | List of database contents |
| B. | List of database contents |
| C. | List of variables used in database file |
| D. | None of the above |
| Answer» A. List of database contents | |
| 38. | A field that uniquely identifies a record is called a |
| A. | Main field |
| B. | Header |
| C. | Key field |
| D. | None of above |
| Answer» C. Key field | |
| 39. | Corrupted index file is corrected using |
| A. | Modifyindex |
| B. | Recreateindex |
| C. | Reindex |
| D. | None of the above |
| Answer» C. Reindex | |
| 40. | The navigation buttons enable you to |
| A. | move from record to record in a table or form |
| B. | move from page to page in report |
| C. | (A) and (B) both |
| D. | None of the above |
| Answer» C. (A) and (B) both | |
| 41. | Different levels of access are assigned to personnel records in the health and fitness gym. Only the system manager is able to create delete or edit records. Certain other personnel are allowed to view all the records, whereas others are not permitted to view complete records. The levels of access are controlled by |
| A. | Password |
| B. | User id’s |
| C. | Status |
| D. | None of the above |
| Answer» A. Password | |
| 42. | You can switch back and forth between design and datasheet view by clicking the |
| A. | queries object tab |
| B. | switch command on the view menu |
| C. | view button |
| D. | select query title bar |
| Answer» C. view button | |
| 43. | The table wizard |
| A. | Quickly creates a default report |
| B. | Displays a subset of the data in a database |
| C. | Contains sample tables and fields you can use to create a table |
| D. | Automatically edits your data as you enter it |
| Answer» D. Automatically edits your data as you enter it | |
| 44. | The names, address, and account balance of all of your customers, select the best fit for answer |
| A. | record |
| B. | file |
| C. | database |
| D. | key field |
| Answer» D. key field | |
| 45. | An integrated collection of all of the data about your customers. Select the best fit for answer |
| A. | Record |
| B. | File |
| C. | Database |
| D. | Key field |
| Answer» B. File | |
| 46. | An identification field in a record. Select the best fit for answer |
| A. | Record |
| B. | File |
| C. | Database |
| D. | Key field |
| Answer» D. Key field | |
| 47. | What is part of database that holds all of the information about one item or subject? |
| A. | Record |
| B. | File |
| C. | Query |
| D. | Chart |
| Answer» A. Record | |
| 48. | What is a stored question about information in a database? |
| A. | Record |
| B. | Field |
| C. | Report |
| D. | Query |
| Answer» D. Query | |
| 49. | RDBMS stands for |
| A. | Relational Database Management System |
| B. | Relation Data Module System |
| C. | Right Data Base Management System |
| D. | None of the above |
| Answer» A. Relational Database Management System | |
| 51. | Modules are | |
| A. | selection of commands used to automate repetitive tasks | |
| B. | programs written in Visual C++ | |
| C. | Object tabs | |
| D. | Group of records | |
| Answer» A. selection of commands used to automate repetitive tasks | ||
| 52. | APPEND command is used to |
| A. | Add record to the end of active database file and starts full screen data entry |
| B. | Add Record to the start of active database file |
| C. | Add record to the start of active database file and starts full screen data entry |
| D. | Add record to the end of database file |
| Answer» A. Add record to the end of active database file and starts full screen data entry | |
| 53. | Append from command is used to |
| A. | Add records from information in an array |
| B. | Adds records from a file |
| C. | Add records from a variable |
| D. | Add records from stock |
| Answer» A. Add records from information in an array | |
| 54. | Examples of centralized multi-user databases are |
| A. | Barclays’ Bank customer accounts |
| B. | Supermarket stock control, organ donor database, client database |
| C. | Airline reservations and other national global booking systems |
| D. | None of above |
| Answer» C. Airline reservations and other national global booking systems | |
| 55. | New record is added using |
| A. | Append record from browse menu |
| B. | Append record into from browse menu |
| C. | Add record from edit menu |
| D. | All of above |
| Answer» A. Append record from browse menu | |
| 56. | When a customer makes an online hotel booking, the database is updated in |
| A. | Batch mode |
| B. | Pseudo real-time |
| C. | One month |
| D. | All of above |
| Answer» B. Pseudo real-time | |
| 57. | A database that contains tables linked by common fields is called a |
| A. | Centralized database |
| B. | Flat file database |
| C. | Relational database |
| D. | None of above |
| Answer» C. Relational database | |
| 58. | The use of integrated collections of database records and files for data storage and processing. The best fit for answer: |
| A. | Database management approach |
| B. | DBMS uses |
| C. | Database administrator |
| D. | Query language |
| Answer» D. Query language | |
| 59. | DBMS allows you to create, interrogate, and maintain a database, create reports, and develop application programs, select the best fit answer |
| A. | Database management approach |
| B. | DBBMS uses |
| C. | Database administrator |
| D. | Query language |
| Answer» D. Query language | |
| 60. | A specialist in charge of the database of an organization select the best fit for answer |
| A. | Database management approach |
| B. | DBMS uses |
| C. | Database administrator |
| D. | Query language |
| Answer» B. DBMS uses | |
| 61. | This DBMS feature allows users to easily interrogate a database. Select the best fit for answer |
| A. | Database management approach |
| B. | DBMS uses |
| C. | Database administrator |
| D. | Query language |
| Answer» C. Database administrator | |
| 62. | The ….. presents data in a way similar to an excel spreadsheet |
| A. | Datasheet view |
| B. | Design view |
| C. | Print preview |
| D. | Layout preview |
| Answer» C. Print preview | |
| 63. | It Is used to build and modify database objects and also to create new queries |
| A. | Datasheet view |
| B. | Design view |
| C. | Print preview |
| D. | Layout preview |
| Answer» C. Print preview | |
| 64. | It shows the appearance and layout of a report, table or form in order to confirm what will be printed. |
| A. | Datasheet view |
| B. | Design view |
| C. | Print preview |
| D. | Layout preview |
| Answer» B. Design view | |
| 65. | It examines a small portion or sample of your data in a report before printing it. |
| A. | Datasheet view |
| B. | Design view |
| C. | Print preview |
| D. | Layout preview |
| Answer» D. Layout preview | |
| 66. | A report form |
| A. | Appears on the computer monitor during data entry |
| B. | Is used during report generation to format data |
| C. | Both (A) and (B) |
| D. | All of above |
| Answer» B. Is used during report generation to format data | |
| 67. | Which of the following columns can not be found in the macro design window? |
| A. | Arguments column |
| B. | Comment column |
| C. | Conditions column |
| D. | Actions column |
| Answer» B. Comment column | |
| 68. | The ascending order of a data hierarchy ios: |
| A. | Bit, byte, field, record, file, database |
| B. | Bit, byte, record, field, file, database |
| C. | Byte, bit, field, record, file, database |
| D. | Byte, bit, record, field, file, database |
| Answer» D. Byte, bit, record, field, file, database | |
| 69. | A good query system |
| A. | Can accept English language commands |
| B. | Allows non-programmers to access information stored in a database |
| C. | Can be accessed only by data prssing professionals |
| D. | Both (A) and (B) |
| Answer» B. Allows non-programmers to access information stored in a database | |
| 70. | How do you freeze a field a column or field in Microsoft Access? |
| A. | Click anywhere in the column and select Edit>Freeze Column form the menu |
| B. | Place an ice cube in the column |
| C. | Click anywhere in the column and click the freeze button on the toolbar |
| D. | Right click the column and select freeze columns from the shortcut menu |
| Answer» D. Right click the column and select freeze columns from the shortcut menu | |
| 71. | Within Table Datasheet view, how can you display associated records from another table? |
| A. | Click the expand indicator (+) next to a record |
| B. | Double click the record. |
| C. | Apply the filter by form command |
| D. | None of the above |
| Answer» A. Click the expand indicator (+) next to a record | |
| 72. | Which of the following is not a command to find specific word or phrases in a database? |
| A. | Click the find button on the toolbar |
| B. | Click the find button on the record navigation button area |
| C. | Press Ctrl+F |
| D. | Select Edit>Find from the menu. |
| Answer» B. Click the find button on the record navigation button area | |
| 73. | One of the type libraries that you can use to programmatically connect to Microsoft Access data is |
| A. | Collaborative Data Objects |
| B. | ActiveX Data Objects |
| C. | Dynamic Data Interfaces |
| D. | None of the above |
| Answer» B. ActiveX Data Objects | |
| 74. | The data in a Pivot Table report is categorized using |
| A. | Column headings |
| B. | Items from the Pivot Table field list |
| C. | Header rows |
| D. | All of above |
| Answer» B. Items from the Pivot Table field list | |
| 76. | You can enter data in a table in | |
| A. | design view | |
| B. | datasheet view | |
| C. | format view | |
| D. | None of the above | |
| Answer» C. format view | ||
| 77. | Creating a data file means |
| A. | Designing base and defining the structure of the database |
| B. | Getting the information about database |
| C. | Selecting data from database |
| D. | Deleting data from database |
| Answer» A. Designing base and defining the structure of the database | |
| 78. | In a large DBMS |
| A. | each user can “see” only a small part of the entire database |
| B. | each user can access every subschema |
| C. | each subschema contains every field in the logical schema |
| D. | none of the above is true |
| Answer» A. each user can “see” only a small part of the entire database | |
| 79. | You want to keep track of addresses, phone numbers, parent/guardian names as well as class attendance, average and grades. Every so often you want to send reports home that select failing grades and excessive absences. The following of the Microsoft Office suit used in this course is best suited for this kind of information |
| A. | Excel |
| B. | PowerPoint |
| C. | Access |
| D. | Word |
| Answer» C. Access | |
| 80. | Each individual data items of record is called a |
| A. | Field |
| B. | Data type |
| C. | Comment |
| D. | All of the above |
| Answer» B. Data type | |
| 81. | A large collections of files are called |
| A. | Fields |
| B. | Records |
| C. | Databases |
| D. | File system |
| Answer» B. Records | |
| 82. | Memo field in database file is used to |
| A. | Store lengthy number |
| B. | Store images |
| C. | Store audio files |
| D. | Store long textual information |
| Answer» D. Store long textual information | |
| 83. | Applications that rely on databases are |
| A. | Supermarket stock control, theater bookings and payroll |
| B. | Accounts, online banking, PowerPoint presentations |
| C. | Internet shopping, robotics, computer games |
| D. | None of above |
| Answer» A. Supermarket stock control, theater bookings and payroll | |
| 84. | Which of the following is not a Access database object ? |
| A. | table |
| B. | form |
| C. | query |
| D. | datasheet |
| Answer» D. datasheet | |
| 85. | Data owners must protect their data against corruption or loss. One sensible method to achieving this is to |
| A. | Take regular backups |
| B. | Keep a hardcopy printout of all data |
| C. | Keep fingers crossed at all times |
| D. | None of above |
| Answer» A. Take regular backups | |
| 86. | Facilities offered by databases are |
| A. | The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports |
| B. | Easy editing, spell check, perform calculations, library of mathematical functions, replication |
| C. | The ability to rotate images, copy and paste, fill scale |
| D. | None of above |
| Answer» A. The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports | |
| 87. | Users who store data about real people for marketing purposes must register the data and its potential use with |
| A. | The computer misuse controller |
| B. | The data protection controller |
| C. | HM customs and excise |
| D. | None of above |
| Answer» B. The data protection controller | |
| 88. | When you double click a query object, you open |
| A. | The object in design view |
| B. | The object in print preview |
| C. | The result of the query |
| D. | The underlying table on which the query is based |
| Answer» B. The object in print preview | |
| 89. | Checks that are added to databases to detect unsuitable data on inpt are called |
| A. | validation |
| B. | verification |
| C. | vegetation |
| D. | none of above |
| Answer» A. validation | |
| 90. | Auto Report allows you to |
| A. | View a subset of your data |
| B. | Create a simple report |
| C. | Create a data entry form |
| D. | Enter records |
| Answer» B. Create a simple report | |
| 91. | Auto Form allows you to |
| A. | View a subset of your data |
| B. | Create a simple report |
| C. | Create a data entry form |
| D. | Enter records |
| Answer» B. Create a simple report | |
| 92. | The asterisk (*) is sometimes used in database queries. This character is then called a |
| A. | Wildcard |
| B. | Dummy |
| C. | Ditto |
| D. | All of the above |
| Answer» A. Wildcard | |
| 93. | When performing a look-up operation using a form |
| A. | You enter the search value into the form |
| B. | You look at each form sequentially until you see the one you want |
| C. | You type the key in an entry line, and the correct form is displayed |
| D. | All of the above |
| Answer» D. All of the above | |
| 94. | Which custom date format displays the numeric day of the year when a date is entered? |
| A. | YY |
| B. | YYYY |
| C. | Y |
| D. | All of above |
| Answer» C. Y | |
| 95. | When you save an Access project, what file format do you use? |
| A. | .adp |
| B. | .xm. |
| C. | .mdb |
| D. | All of above |
| Answer» A. .adp | |
| 96. | Which of the following criterion would find records whose personality field does not equal “Nice”? |
| A. | <>Nice |
| B. | NOT Nice |
| C. | <>”Nice” |
| D. | IS NOT Nice |
| Answer» C. <>”Nice” | |
| 97. | What is the maximum character field size you can set for a field that has a text data type? |
| A. | 64 |
| B. | 255 |
| C. | 512 |
| D. | All of above |
| Answer» B. 255 | |
| 98. | Which of the following fields would not make a suitable primary key ? |
| A. | A date field |
| B. | An invoice number |
| C. | An autoNumber field |
| D. | A customer’s social security number |
| Answer» A. A date field | |
| 99. | Auto reports can contain each of the following elements except |
| A. | A detail section |
| B. | A page footer |
| C. | A group header |
| D. | All of the above |
| Answer» D. All of the above | |
| 101. | A repository for data, usually covering some specific topic is called |
| A. | Data acquisition |
| B. | Data bank |
| C. | Real time |
| D. | Database |
| Answer» B. Data bank | |
| 102. | A notation for defining the form and structure of data is known as |
| A. | Data description language |
| B. | Binary language |
| C. | Data channels |
| D. | Data definition language |
| Answer» D. Data definition language | |
| 103. | A data item, which is not broken down into smaller units, is |
| A. | Data element |
| B. | Elementary data item |
| C. | Data entry |
| D. | Database management |
| Answer» B. Elementary data item | |
| 104. | Which of the following terms refers to the degree to which data in database system are accurate and correct? |
| A. | Data security |
| B. | Data validaity |
| C. | Data independence |
| D. | Data integrity |
| Answer» D. Data integrity | |
| 105. | A repository for data, usually covering specific topic is |
| A. | Database |
| B. | Data requisition |
| C. | Data bank |
| D. | Data collection |
| Answer» C. Data bank | |
| 106. | A set of programs that handle firm’s data base responsibilities is called a |
| A. | Database Management System (DBMS) |
| B. | Database Processing System (DBPS) |
| C. | Data Management System (DMS) |
| D. | All of above |
| Answer» D. All of above | |
| 107. | Which of the following is not a relational database? |
| A. | dBase IV |
| B. | 4th Dimension |
| C. | FoxPro |
| D. | Reflex |
| Answer» D. Reflex | |
| 108. | Which is used to provide the sight information to the right person at the right time for proper decision making ? |
| A. | DBMS |
| B. | MIS |
| C. | ISO |
| D. | PSO |
| Answer» B. MIS | |
| 109. | Dbase-III was developed by |
| A. | Dec |
| B. | IBM |
| C. | Ashton-tate |
| D. | All of the above |
| Answer» C. Ashton-tate | |
| 110. | Which of the following database objects asks a question of information in a database and then displays the result? |
| A. | Tables |
| B. | Reports |
| C. | Queries |
| D. | Forms |
| Answer» C. Queries | |
| 111. | What data type should you choose for a zip code field in a table? |
| A. | Text |
| B. | Number |
| C. | Memo |
| D. | All of above |
| Answer» A. Text | |
| 112. | A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be |
| A. | The pin code |
| B. | The last name |
| C. | A compound key consisting of the first name and the last name |
| D. | All of the above |
| Answer» C. A compound key consisting of the first name and the last name | |
| 113. | What happens when you add the asterisk (() from any field list ot a query? |
| A. | The table will not include any fields from the table |
| B. | The query sorts the table’s record in the order you specify |
| C. | The query will include every field from the table* |
| D. | The query uses the records from the table without displaying them |
| Answer» C. The query will include every field from the table* | |
| 114. | The modify operation is likely to be done after |
| A. | delete |
| B. | look up |
| C. | insert |
| D. | all of above |
| Answer» B. look up | |
| 115. | The criteria BETWEEN 1/1/99 and 12/31/99 would which is proper |
| A. | Display records between the dates 1/2/ 99 and 1/1/00 |
| B. | Display records between the dates 1/1/ 99 and 12/31/99 |
| C. | Display records whose dates equaled 1/1/99 or 12/31/99 |
| D. | All of the above |
| Answer» B. Display records between the dates 1/1/ 99 and 12/31/99 | |
| 116. | DDP stands for |
| A. | Distributed Double Processing |
| B. | Double Decimal Processing |
| C. | Distributed Data Programming |
| D. | Distributed Data Processing |
| Answer» D. Distributed Data Processing | |
| 117. | To see sales amount figures totaled, into which drop area would you drag that field? |
| A. | Drop column fields here |
| B. | Drop row fields here |
| C. | Drop data items here |
| D. | None of the above |
| Answer» C. Drop data items here | |
| 118. | Which access feature do you use to develop applications that host access data on the web? |
| A. | Dynamic web data |
| B. | Data access pates |
| C. | Html data pages |
| D. | None of the above |
| Answer» B. Data access pates | |
| 119. | What is the common name for a column of data within an Access table? |
| A. | Field |
| B. | Record |
| C. | Row |
| D. | None of the above |
| Answer» A. Field | |
| 120. | A data structure consisting of several fields, some or all of which are instances of the same data structure, is called |
| A. | Field |
| B. | Bead |
| C. | Database |
| D. | Data collection |
| Answer» B. Bead | |
| 121. | A group of characters used to identiry a given low level instruction is |
| A. | File |
| B. | Record |
| C. | Key field |
| D. | Label |
| Answer» D. Label | |
| 122. | One or more characters used to identify a data field in a computer program is |
| A. | File name |
| B. | Database |
| C. | Label |
| D. | Group |
| Answer» C. Label | |
| 123. | In Form view, which command displays records alphabetically? |
| A. | Find |
| B. | Advanced Filter/Sort |
| C. | Sort |
| D. | All of the above |
| Answer» C. Sort | |
| 124. | Where do report and forms get their information form? |
| A. | Forms |
| B. | Modules |
| C. | Tables |
| D. | Queries |
| Answer» C. Tables | |
| 126. | A top to bottom relationship among the items in a database is established by a | |
| A. | Hierarchical schema | |
| B. | Network Schema | |
| C. | Relational schema | |
| D. | All of the above | |
| Answer» A. Hierarchical schema | ||
| 127. | A command that lets you cange one or more fields in a record is |
| A. | Insert |
| B. | Modify |
| C. | Look up |
| D. | All of the above |
| Answer» B. Modify | |
| 128. | A logical schema |
| A. | Is the entire database |
| B. | Is a standard way of organizing information into accessible parts |
| C. | Describes how data is actually stored on disk |
| D. | All of the above |
| Answer» B. Is a standard way of organizing information into accessible parts | |
| 129. | What is the purpose of the page field on a pivot table report? |
| A. | It creates a new page for each type of data |
| B. | It allows the data within the the Pivot Table report to be filtered |
| C. | It displays a title for the Pivot Table report |
| D. | None of the above |
| Answer» B. It allows the data within the the Pivot Table report to be filtered | |
| 130. | What does the Special Effect button on the formatting toolbar do? |
| A. | It lets you add animation to your forms and reports to make them more entertaining and amusing |
| B. | It lets you select a transitional effect for how a form opens and closes. |
| C. | It applies a 30d effect to a selected control |
| D. | None of these |
| Answer» C. It applies a 30d effect to a selected control | |
| 131. | Pivot Table report data must meet which of the following criteria? |
| A. | It must be in tabular form, have unique column labels, and each row must represent a unique piece of data |
| B. | Any dates should be formatted with the data format and blank rows or columns should be removed |
| C. | It must be in tabular form, have unique column lagels, and all rows must be sorted |
| D. | Both (A) and (B) |
| Answer» D. Both (A) and (B) | |
| 132. | Customers, Orders. What’s their best relationship? |
| A. | Many-to-many |
| B. | One-to-one |
| C. | One-to-many |
| D. | All of the above |
| Answer» C. One-to-many | |
| 133. | Which control does access use to link data access page components to access data? |
| A. | Microsoft Dynamic Data Control |
| B. | Microsoft Data Connection Control |
| C. | Microsoft Office Data Source Control |
| D. | None of the above |
| Answer» C. Microsoft Office Data Source Control | |
| 134. | Which program do you use to edit code for data access pages? |
| A. | Microsoft script editor |
| B. | Microsoft code editor |
| C. | Microsoft data access pages editor |
| D. | None of above |
| Answer» A. Microsoft script editor | |
| 135. | The way a particular application views the data from the database that the applicaton uses is a |
| A. | Module |
| B. | Relational model |
| C. | Schema |
| D. | Sub-schema |
| Answer» D. Sub-schema | |
| 136. | Which of the following is a database management system? |
| A. | Ms-Word |
| B. | Lotus 1-2-3 |
| C. | Oracle |
| D. | None of above |
| Answer» C. Oracle | |
| 137. | What is the corresponding text for the <#1/1/ 95# validation rule setting? |
| A. | Neter a value less or more than 1,195 |
| B. | Value must be less than 95 characters |
| C. | Enter a date before 1995 |
| D. | All of above |
| Answer» A. Neter a value less or more than 1,195 | |
| 138. | What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type library’s available objects and members? |
| A. | Object Viewer |
| B. | Object Browser |
| C. | Type Library Spy |
| D. | None of above |
| Answer» B. Object Browser | |
| 139. | A computer language for informing the DBMS regarding the data structure used is |
| A. | PASCAL |
| B. | DDL |
| C. | PROLOG |
| D. | FORTRAN |
| Answer» B. DDL | |
| 140. | Which of the following is not a data type ? |
| A. | Picture/graphic |
| B. | Data/time |
| C. | Texst |
| D. | Number |
| Answer» A. Picture/graphic | |
| 141. | The executive responsible for the data processing function in an organization is |
| A. | PM |
| B. | DBMS |
| C. | DP |
| D. | DPM |
| Answer» B. DBMS | |
| 142. | Which of the following is NOT a type of Microsoft Access database object? |
| A. | Queries |
| B. | Workbooks |
| C. | Forms |
| D. | Tables |
| Answer» B. Workbooks | |
| 143. | A file containing relatively permanent data is |
| A. | Random file |
| B. | Transaction file |
| C. | Master file |
| D. | Sequential file |
| Answer» C. Master file | |
| 144. | The complete picture of data stored in database is known as |
| A. | Record |
| B. | Scheme |
| C. | System flowchart |
| D. | DBMS |
| Answer» B. Scheme | |
| 145. | A subset of characters within a data field is known as |
| A. | Record |
| B. | File |
| C. | Data string |
| D. | Byte |
| Answer» C. Data string | |
| 146. | Data items groped together for storage purposes are called a |
| A. | Record |
| B. | Title |
| C. | List |
| D. | string |
| Answer» A. Record | |
| 147. | Which of the following terms does not describe a database structure used by a DBMS to link data from several files? |
| A. | Relational |
| B. | Structural |
| C. | Network |
| D. | All of the above |
| Answer» B. Structural | |
| 148. | In a relational schema, each tuple is divided into fields called |
| A. | Relations |
| B. | Domains |
| C. | Queries |
| D. | All of the above |
| Answer» B. Domains | |
| 149. | How do you filter by selection? |
| A. | Right click the field value and select filter by selection from the shortcut menu |
| B. | Find and double click the value on which you want to base the filter |
| C. | Find and select the value on which you want to base the filter and select tools>filter by selection from the menu |
| D. | None of the above |
| Answer» A. Right click the field value and select filter by selection from the shortcut menu | |
| 151. | What are the columns in a Microsoft Access table called? |
| A. | Rows |
| B. | Fields |
| C. | Cells |
| D. | Records |
| Answer» B. Fields | |
| 152. | How do you update Pivot Table report data after changes are made to the source data? |
| A. | Save your changes, close the workbook, and then reopen it. |
| B. | Select the Pivot Table worksheet and press F9 on the keyboard |
| C. | Click the report, and on the Pivot Table toolbar, click the refresh data button |
| D. | All of the above |
| Answer» C. Click the report, and on the Pivot Table toolbar, click the refresh data button | |
| 153. | In access, the best types of queries to use for data analysis are: |
| A. | Select querie |
| B. | Parameter queries |
| C. | Action queries |
| D. | All of the above |
| Answer» A. Select querie | |
| 154. | How can you add a table to the relationship window? |
| A. | Select Tools>Add table from the menu |
| B. | Select the table from the table list on the toolbar |
| C. | Click the show table button on the toolbar |
| D. | Select Edit>Add table from the menu |
| Answer» B. Select the table from the table list on the toolbar | |
| 155. | What is the first step in creating a form or report with the form wizard or report wizard? |
| A. | Selecting the fields that you want to appear in the form or report |
| B. | Selecting the underlying table or query on which you want to base the form or report |
| C. | Reading several screens of mostly useless information and clicking next |
| D. | Selecting how the form or report should be formatted |
| Answer» B. Selecting the underlying table or query on which you want to base the form or report | |
| 156. | Which action will optimize your database performance? |
| A. | Set the record set type to Snapshot |
| B. | Use the compact and repair database tool |
| C. | Create a replica of the database |
| D. | All of the above |
| Answer» B. Use the compact and repair database tool | |
| 157. | The arranging of data in a logical sequence is called |
| A. | Sorting |
| B. | Classifying |
| C. | Reproducing |
| D. | Summarizing |
| Answer» A. Sorting | |
| 158. | If a piece of data is stored in two places in the database, then a |
| A. | Storage space is wasted |
| B. | Changing the data is one spot will cause data inconsistency |
| C. | It can be more easily accessed |
| D. | Both (A) and (B) |
| Answer» D. Both (A) and (B) | |
| 159. | A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file? As |
| A. | Tables |
| B. | Relations |
| C. | Tuple |
| D. | Both (A) and (B) |
| Answer» D. Both (A) and (B) | |
Tags
Question and answers in Basics of Database Management System (DBMS),Basics of Database Management System (DBMS) multiple choice questions and answers,Basics of Database Management System (DBMS) Important MCQs,Solved MCQs for Basics of Database Management System (DBMS),Basics of Database Management System (DBMS) MCQs with answers PDF download