McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: MCQ on Computer Softwares , Common Topics in Competitive and Entrance exams , Microsoft Office .
| 401. |
Which is not an option for Filter on a text field? |
| A. | Begins With |
| B. | Between |
| C. | Contains |
| D. | End With |
| Answer» B. Between | |
| 402. |
The Search tool is best used when searching for ______ data. |
| A. | simple |
| B. | multiple |
| C. | unique |
| D. | formatted |
| Answer» A. simple | |
| 403. |
Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry? |
| A. | Match Case |
| B. | Match: Whole Field |
| C. | Match: Start of Field |
| D. | Match: Any Part of Field |
| Answer» C. Match: Start of Field | |
| 404. |
Which of the following functions CANNOT be used in the Totals row? |
| A. | Average |
| B. | Count |
| C. | Maximum |
| D. | Round |
| Answer» D. Round | |
| 405. |
Before printing a datasheet, you can use ____ to determine whether to change the page orientation from portrait to vertical orientation. |
| A. | Design View |
| B. | Datasheet View |
| C. | Office View |
| D. | Print Preview |
| Answer» D. Print Preview | |
| 406. |
What is the keyboard shortcut to move to the last records in a table? |
| A. | [Tab] |
| B. | [Shift]+[Tab] |
| C. | [Ctrl]+Home] |
| D. | [Ctrl]+[End] |
| Answer» D. [Ctrl]+[End] | |
| 407. |
A ____ is a major database object used to display information in an attractive, easy-to-read screen format. |
| A. | form |
| B. | query |
| C. | report |
| D. | table |
| Answer» A. form | |
| 408. |
Print options can be changed in the Print ____. |
| A. | tab |
| B. | layout mode |
| C. | setup routine |
| D. | dialog box |
| Answer» D. dialog box | |
| 409. |
Which major database object stores all data? |
| A. | Field |
| B. | Query |
| C. | Record |
| D. | Table |
| Answer» D. Table | |
| 410. |
The insertion point looks like a(n) ____. |
| A. | H-pointer |
| B. | I-pointer |
| C. | H-beam |
| D. | I-beam |
| Answer» D. I-beam | |
| 411. |
Access file operations can be found by clicking the ____. |
| A. | Access Button |
| B. | Database Button |
| C. | Office Button |
| D. | Window Button |
| Answer» C. Office Button | |
| 412. |
A ____ is a major database object used to display information in a printable page format. |
| A. | form |
| B. | query |
| C. | report |
| D. | table |
| Answer» C. report | |
| 413. |
In Datasheet View, new records are added to a table ____. |
| A. | in alphabetical order |
| B. | at the end of the table |
| C. | at the beginning of the table |
| D. | in numerical order |
| Answer» B. at the end of the table | |
| 414. |
What happens when a user selects a record in a form and presses [Delete]? |
| A. | The record is deleted in the form and from its source table. |
| B. | The record is deleted in the form, but not from its source table. |
| C. | The record is neither deleted in the form, nor from its source table. |
| D. | The record is not deleted in the form, but is deleted from its source table. |
| Answer» A. The record is deleted in the form and from its source table. | |
| 415. |
Which of the following CANNOT be done to data using a Form? |
| A. | Store |
| B. | Sort |
| C. | Edit |
| D. | |
| Answer» A. Store | |
| 416. |
What is one of the advantages for using a form over other Access objects? |
| A. | Utilizes field placement to improve the efficiency of data entry. |
| B. | Forms store information more efficiently. |
| C. | Forms show the summary of all the records. |
| D. | Forms cannot be edited. |
| Answer» A. Utilizes field placement to improve the efficiency of data entry. | |
| 417. |
Which of the following methods CANNOT be used to copy a block of text from one part of a table to another? |
| A. | Press [Ctrl]+[C] and [Ctrl]+[V]. |
| B. | Right-click, choose from the shortcut menu Copy and Paste. |
| C. | Press [Ctrl]+[+] and [Ctrl]+[-]. |
| D. | From the ribbon, select Copy and Paste. |
| Answer» C. Press [Ctrl]+[+] and [Ctrl]+[-]. | |
| 418. |
A(n) ____ in the Record Selector indicates a new record. |
| A. | check mark |
| B. | pencil |
| C. | asterisk |
| D. | arrow |
| Answer» C. asterisk | |
| 419. |
All attachment fields display as a(n) ____ in Datasheet View. |
| A. | icon |
| B. | button |
| C. | thumb tack |
| D. | paperclip |
| Answer» D. paperclip | |
| 420. |
Which of the following methods CANNOT be used to delete records from a table? |
| A. | Selecting records and pressing [Delete] |
| B. | Pressing [Ctrl]+[\'] |
| C. | Clicking the Delete Record button |
| D. | From the ribbon, selecting Delete Record |
| Answer» B. Pressing [Ctrl]+[\'] | |
| 421. |
Where can you find the undo command in Access? |
| A. | Office button |
| B. | Home command tab |
| C. | Status bar |
| D. | Quick Access toolbar |
| Answer» D. Quick Access toolbar | |
| 422. |
An application that executes on separate PCs like this is called a(n) __________ application. |
| A. | enterprise |
| B. | distributed |
| C. | tier |
| D. | global |
| Answer» B. distributed | |
| 423. |
The most popular commercial DBMS. |
| A. | Microsoft SQL Server |
| B. | Microsoft Access |
| C. | MySQL |
| D. | Oracle |
| Answer» D. Oracle | |
| 424. |
The ability of a database to grow as the data tracking needs grow is its __________. |
| A. | scalability |
| B. | expandability |
| C. | maintainability |
| D. | platform-independence |
| Answer» A. scalability | |
| 425. |
The most open source DBMS. |
| A. | Microsoft SQL Server |
| B. | Microsoft Access |
| C. | MySQL |
| D. | Oracle |
| Answer» C. MySQL | |
| 426. |
A DBMS that runs on many different operating systems is said to be __________. |
| A. | scalable |
| B. | robust |
| C. | platform independent |
| D. | distributed |
| Answer» C. platform independent | |
| 427. |
Search engines use a(n) __________ to automatically index sites. |
| A. | crawler |
| B. | query |
| C. | enterprise |
| D. | sitebuilder |
| Answer» A. crawler | |
| 428. |
The __________ performs document tracking. |
| A. | distributed application |
| B. | enterprise software |
| C. | Oracle software |
| D. | EDM software |
| Answer» D. EDM software | |
| 429. |
An enterprise solution with data storage, a client interface and a security system is a(n) __________ system. |
| A. | 2-tier |
| B. | 3-tier |
| C. | 4-tier |
| D. | n-tier |
| Answer» B. 3-tier | |
| 430. |
__________ will answer questions you did not think to ask of your data. |
| A. | data mining |
| B. | data extrapolation |
| C. | knowledge discovery |
| D. | data enlightenment |
| Answer» C. knowledge discovery | |
| 431. |
__________ is the clear leader for personal databases. |
| A. | Microsoft Access |
| B. | Microsoft FoxPro |
| C. | Borland dBase |
| D. | MySQL |
| Answer» A. Microsoft Access | |
| 432. |
The __________ is the software tool to store or access data. |
| A. | table |
| B. | DBMS |
| C. | query |
| D. | report |
| Answer» B. DBMS | |
| 433. |
__________ are documents that when filled in create records. |
| A. | Forms |
| B. | Reports |
| C. | Tables |
| D. | Queries |
| Answer» A. Forms | |
| 434. |
This database has only one table. |
| A. | relational |
| B. | large |
| C. | flat-file |
| D. | DBMS |
| Answer» C. flat-file | |
| 435. |
The __________ field is used to hold a yes or no answer. |
| A. | object |
| B. | number |
| C. | text |
| D. | logical |
| Answer» D. logical | |
| 436. |
To delete records or perform calculations on a table, the best tool to use is a __________. |
| A. | query |
| B. | filter |
| C. | form |
| D. | report |
| Answer» A. query | |
| 437. |
__________ is used to build ‘intuitive’ queries. |
| A. | SQL |
| B. | Xbase |
| C. | QBE |
| D. | XML |
| Answer» C. QBE | |
| 438. |
To print information from a table, the __________ tool is the best choice. |
| A. | form |
| B. | report |
| C. | query |
| D. | macro |
| Answer» B. report | |
| 439. |
To store your picture in a database requires a(n) __________ field. |
| A. | BLOB |
| B. | text |
| C. | image |
| D. | logical |
| Answer» A. BLOB | |
| 440. |
The __________ is used to access one record at a time. |
| A. | query |
| B. | filter |
| C. | form |
| D. | report |
| Answer» C. form | |
| 441. |
SQL stands for __________. |
| A. | Standard Query Language |
| B. | Structured Query Language |
| C. | Simplified Query Language |
| D. | Static Query Language |
| Answer» B. Structured Query Language | |
| 442. |
What are the different views to display a table |
| A. | Datasheet view |
| B. | Design view |
| C. | Pivote table & pivot chart view |
| D. | All of above |
| Answer» D. All of above | |
| 443. |
Which of the following creates a drop down list of values to choose from? |
| A. | Ole object |
| B. | Hyperlink |
| C. | Memo |
| D. | Lookup wizard |
| Answer» D. Lookup wizard | |
| 444. |
The command center of access file that appears when you create or open the MS Access database file. |
| A. | Database window |
| B. | Query window |
| C. | Design view window |
| D. | Switchboard |
| Answer» A. Database window | |
| 445. |
In a database table, the category of information is called __________ |
| A. | Tuple |
| B. | Field |
| C. | Record |
| D. | All of above |
| Answer» B. Field | |
| 446. |
It is an association established between common |
| A. | Line |
| B. | Relationship |
| C. | Primary key |
| D. | Records |
| Answer» B. Relationship | |
| 447. |
This is the stage in database design where one gathers and list all the necessary fields for the database project. |
| A. | Data definition |
| B. | Data refinement |
| C. | Establishing relationship |
| D. | None of the above |
| Answer» A. Data definition | |
| 448. |
Which of the following statement is true? |
| A. | Foreign key fields don\'t allow duplicate values |
| B. | In primary key field you can enter duplicate value |
| C. | In an indexed field you may or may not enter duplicate value depending upon setting |
| D. | All statements are true |
| Answer» C. In an indexed field you may or may not enter duplicate value depending upon setting | |
| 449. |
The database language that allows you to access or maintain data in a database |
| A. | Dcl |
| B. | Dml |
| C. | Ddl |
| D. | None of above |
| Answer» A. Dcl | |
| 450. |
What is the difference between ‘open’ and ‘open exclusively’ |
| A. | Open statement opens access database files and open exclusively opens database files of other program like oracle |
| B. | Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed |
| C. | Both open and open exclusively are same |
| D. | Open exclusive command does not exist in MS Access |
| Answer» B. Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.