MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 30 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Writing stored procedures takes less time than using Visual Basic or PowerBuilder to create an application. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 2. |
The database server is responsible for database storage, access, and processing. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 3. |
Data processing logic includes such activities as data validation and identification of processing errors. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 4. |
Query-by-Example (QBE) is the most widely available direct-manipulation database query language. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 5. |
ODBC requires the specific driver. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 6. |
A fat client is a PC configured for handling user interfaces and some application processing, usually with no or limited local data storage. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 7. |
Centralized systems are more susceptible to security threats than client/server architectures. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 8. |
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. | 1 |
| B. | |
| Answer» B. | |
| 9. |
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. | |
| 10. |
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 | |
| 11. |
With an asynchronous system, the requesting system waits for a response in real time. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 12. |
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. | |
| 13. |
Massively parallel processing (MPP) systems require a complete copy of the operating system to be resident in each dedicated memory. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 14. |
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. | |
| 15. |
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. | |
| 16. |
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 | |
| 17. |
Symmetric multiprocessing (SMP) architectures are useful for situations where data must remain in memory during processing to achieve the desired performance level. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 18. |
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 | |
| 19. |
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. | |
| 20. |
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. | 1 |
| B. | |
| Answer» B. | |
| 21. |
The first client/server architectures developed were file servers. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 22. |
The Windows operating system and Windows applications are event driven. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 23. |
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. | |
| 24. |
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 | |
| 25. |
Three-tier architecture includes which of the following? |
| A. | Three server layers |
| B. | A client layer and two server layers |
| C. | Two client layers and one server layer |
| D. | Three client layers |
| Answer» C. Two client layers and one server layer | |
| 26. |
Activities of a DBMS occur in the processing component logic. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 27. |
Stored procedures have which of the following advantages? |
| A. | It takes a longer time to write them as compared to writing Visual Basic. |
| B. | Network traffic increases |
| C. | Data integrity improves as multiple applications access the same stored procedure. |
| D. | Result in thicker client and thinner database server. |
| Answer» D. Result in thicker client and thinner database server. | |
| 28. |
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. | |
| 29. |
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. | |
| 30. |
Which of the following statements is true about symmetric multiprocessing? |
| A. | A single copy of the operating system resides in each processor. |
| B. | Useful for situations where data must remain in memory to process. |
| C. | Bottlenecks increase with uniprocessor systems because tasks are not shared. |
| D. | The problems of memory contention are unlikely. |
| Answer» C. Bottlenecks increase with uniprocessor systems because tasks are not shared. | |