MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 13 Mcqs, each offering curated multiple-choice questions to sharpen your Master of Computer Applications (MCA) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
If every non-key attribute is functionally dependent on the primary key, then the relation will be in: |
| A. | First normal form |
| B. | Second normal form |
| C. | Third normal form |
| D. | Fourth normal form |
| Answer» D. Fourth normal form | |
| 2. |
The airline reservation system, the enables are date, flight number, place of departure, destination, type of plane & seats available. The primary key is |
| A. | Flight number |
| B. | Flight number + place of departure |
| C. | Flight number+ date |
| D. | Flight number + destination |
| Answer» D. Flight number + destination | |
| 3. |
A distributed database has which of the following advantages over a centralized database? |
| A. | Software cost |
| B. | Software complexity |
| C. | Slow Response |
| D. | Modular growth |
| Answer» E. | |
| 4. |
The DBMS acts as an interface between what two components of an enterprise-class database system? |
| A. | Database application and the database |
| B. | Data and the database |
| C. | The user and the database application |
| D. | Database application and SQL |
| Answer» B. Data and the database | |
| 5. |
When creating a database, in order to optimize performance, put high-usage tables in their own ____. |
| A. | data caches |
| B. | data spaces |
| C. | table caches |
| D. | table spaces |
| Answer» E. | |
| 6. |
Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally? |
| A. | Rollback |
| B. | Rollforward |
| C. | Switch to duplicate database |
| D. | Reprocess transactions |
| Answer» B. Rollforward | |
| 7. |
Association of unknown instances with known instances is a process of .technique |
| A. | Memory based reasoning |
| B. | Link analysis |
| C. | Neural network |
| D. | Genetic algorithm |
| Answer» B. Link analysis | |
| 8. |
Which of the following clause specifies the table or tables from where the data has to be retrieved? |
| A. | Where |
| B. | Table |
| C. | From |
| D. | None of these |
| Answer» D. None of these | |
| 9. |
Which property ensures that each functional dependency is represented in some individual relations resulting after decomposition? |
| A. | Dependency preservation property |
| B. | Fully Functional dependency |
| C. | Lossless Join |
| D. | None of the above |
| Answer» B. Fully Functional dependency | |
| 10. |
The ____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM. |
| A. | table space |
| B. | extends |
| C. | data cache |
| D. | SQL cache |
| Answer» D. SQL cache | |
| 11. |
The ____ is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions. |
| A. | sort cache |
| B. | SQL cache |
| C. | data cache |
| D. | optimizer mode |
| Answer» B. SQL cache | |
| 12. |
The architecture of a DBMS is represented by the ____ and structures used to manage a database. |
| A. | tables |
| B. | queries |
| C. | processes |
| D. | Logs |
| Answer» D. Logs | |
| 13. |
Because it contains a description of its own structure, a database is considered to be ________ . |
| A. | Described |
| B. | metadata compatible |
| C. | self-describing |
| D. | an application program |
| Answer» D. an application program | |