MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 31 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The database server is responsible for database storage, access, and processing.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 2. |
ODBC requires the specific driver.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
The Windows operating system and Windows applications are event driven.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
Client/server environments use a local area network (LAN) to support a network of personal computers, each with its own storage, that are also able to share common devices and software attached to the LAN.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 5. |
Data processing logic includes such activities as data validation and identification of processing errors.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 6. |
Massively parallel processing (MPP) systems require a complete copy of the operating system to be resident in each dedicated memory.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 7. |
A fat client is a PC configured for handling user interfaces and some application processing, usually with no or limited local data storage.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 8. |
Writing stored procedures takes less time than using Visual Basic or PowerBuilder to create an application.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 9. |
Symmetric multiprocessing (SMP) architectures are useful for situations where data must remain in memory during processing to achieve the desired performance level.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
Query-by-Example (QBE) is the most widely available direct-manipulation database query language.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 11. |
Centralized systems are more susceptible to security threats than client/server architectures.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 12. |
The presentation logic component is responsible for formatting and presenting data on the user's screen or other output device, and for managing user input from a keyboard or other input device.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 13. |
With an asynchronous system, the requesting system waits for a response in real time.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 14. |
The first client/server architectures developed were file servers.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 15. |
Activities of a DBMS occur in the processing component logic.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 16. |
A characteristic of a file server is which of the following?%! |
| A. | Manages file operations and is shared on a network. |
| B. | Manages file operations and is limited to one PC. |
| C. | Acts as a fat client and is shared on a network. |
| D. | Acts as a fat client and is limited to one PC. |
| Answer» B. Manages file operations and is limited to one PC. | |
| 17. |
*$_A characteristic of a file server is which of the following?? |
| A. | Manages file operations and is shared on a network. |
| B. | Manages file operations and is limited to one PC. |
| C. | Acts as a fat client and is shared on a network. |
| D. | Acts as a fat client and is limited to one PC. |
| Answer» B. Manages file operations and is limited to one PC. | |
| 18. |
*/*_A database server is responsible for which of the following?? |
| A. | Database storage |
| B. | Data processing logic |
| C. | Data presentation logic |
| D. | All of the above |
| Answer» B. Data processing logic | |
| 19. |
*/*_An application program interface (API) is which of the following?? |
| A. | The same thing as ODBC. |
| B. | Middleware that does not provide access to a database. |
| C. | Middleware that provides access to a database. |
| D. | The same thing as JDBC. |
| Answer» D. The same thing as JDBC. | |
| 20. |
%_Which of the following statements is true concerning JDBC?_% |
| A. | It is language independent. |
| B. | It is similar in concept to ODBC. |
| C. | It is useful for all object-oriented languages. |
| D. | It consists of three main layers. |
| Answer» C. It is useful for all object-oriented languages. | |
| 21. |
_ The three different application logic components are which of the following?$? |
| A. | Presentation, Client, and Storage |
| B. | Presentation, Client, and Processing |
| C. | Presentation, Processing, and Storage |
| D. | Presentation, Processing, and Network |
| Answer» D. Presentation, Processing, and Network | |
| 22. |
_ Client/server security includes which of the following?$? |
| A. | Physical security |
| B. | Change control security |
| C. | Measures taken to secure all systems |
| D. | All of the above |
| Answer» E. | |
| 23. |
__A benefit of the three-tier architecture is which of the following?__ |
| A. | New modules can be built to support specific business needs |
| B. | Performance improves for compiled SQL statements |
| C. | Results in a thinner client and database server |
| D. | All of the above. |
| Answer» B. Performance improves for compiled SQL statements | |
| 24. |
_A server cannot serve on which of the following levels?$? |
| A. | Client Layer |
| B. | Business Layer |
| C. | Database Layer |
| D. | All of the above |
| Answer» B. Business Layer | |
| 25. |
_Which of the following is true concerning QBE?$? |
| A. | An official standard has been defined for QBE. |
| B. | QBE cannot be used for client/server systems. |
| C. | QBE does not give the programmer a visual programming environment. |
| D. | Complete applications can be written using QBE. |
| Answer» E. | |
| 26. |
Which of the following items are not necessary for client/server?$? |
| A. | Assure that tools will connect with middleware. |
| B. | Understand the requirements. |
| C. | Determine network bandwidth capabilities. |
| D. | Include the use of a file server. |
| Answer» E. | |
| 27. |
Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?$? |
| A. | Each vendor desiring to be ODBC-complaint provides an ODBC driver. |
| B. | Requires certain criteria to be met in order to establish an ODBC connection. |
| C. | Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed. |
| D. | All of the above. |
| Answer» E. | |
| 28. |
Which of the following is true concerning the mainframe?$? |
| A. | It is the same thing as client/server. |
| B. | Requires someone to decide which code should be on the workstation or the server. |
| C. | Mission-critical systems have tended to remain there. |
| D. | All of the above. |
| Answer» D. All of the above. | |
| 29. |
Which of the following items are not necessary for client/server?? |
| A. | Assure that tools will connect with middleware. |
| B. | Understand the requirements. |
| C. | Determine network bandwidth capabilities. |
| D. | Include the use of a file server. |
| Answer» E. | |
| 30. |
Which of the following is true concerning the mainframe?? |
| A. | It is the same thing as client/server. |
| B. | Requires someone to decide which code should be on the workstation or the server. |
| C. | Mission-critical systems have tended to remain there. |
| D. | All of the above. |
| Answer» D. All of the above. | |
| 31. |
Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?? |
| A. | Each vendor desiring to be ODBC-complaint provides an ODBC driver. |
| B. | Requires certain criteria to be met in order to establish an ODBC connection. |
| C. | Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed. |
| D. | All of the above. |
| Answer» E. | |