McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Master of Computer Applications (MCA) .
Chapters
| 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» C. Third normal form | |
| 2. |
Given the functional dependencies X →W; X→Y; Y→Z and Z→PQ Which of the following doesn’t hold well? |
| A. | X→Z |
| B. | W→Z |
| C. | X→WY |
| D. | None of the above |
| Answer» B. W→Z | |
| 3. |
Relations produced from an E-R model will always be in |
| A. | First normal form |
| B. | Second normal form |
| C. | Third normal form |
| D. | Fourth normal form |
| Answer» A. First normal form | |
| 4. |
An attribute of one table matching the primary key of another table, is called as |
| A. | Foreign key |
| B. | Secondary key |
| C. | Candidate key |
| D. | Composite key |
| Answer» A. Foreign key | |
| 5. |
If a relation scheme is in BCNF, then it is also in |
| A. | First normal form |
| B. | Second normal form |
| C. | Third normal form |
| D. | Fourth normal form |
| Answer» C. Third normal form | |
| 6. |
A primary key when combined with a foreign key create |
| A. | Parent child relationship between the tables that connect them. |
| B. | Network model between the tables that connect them. |
| C. | Many-to-many relationship between the tables that connect them. |
| D. | None of the above. |
| Answer» A. Parent child relationship between the tables that connect them. | |
| 7. |
The set of permitted value for each attribute is called its |
| A. | Attribute set |
| B. | Attentive range |
| C. | Domain |
| D. | Group |
| Answer» C. Domain | |
| 8. |
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» C. Flight number+ date | |
| 9. |
A functional dependency of the form X→Y is trivial if |
| A. | YC= X |
| B. | Y C X |
| C. | X C =Y |
| D. | X C Y and Y C X |
| Answer» A. YC= X | |
| 10. |
In transactions, in ACID property A stands for |
| A. | Atomicity |
| B. | Acidity |
| C. | Alphabetically |
| D. | None of the above. |
| Answer» A. Atomicity | |
| 11. |
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R. |
| A. | It will result in a deadlock situation. |
| B. | It will immediately be granted. |
| C. | It will immediately be reject |
| Answer» B. It will immediately be granted. | |
| 12. |
A schedule S of n transactions is serializable if it is equivalent to some |
| A. | Serial schedule of the same n transactions. |
| B. | Non-serial schedule of the same n transactions. |
| C. | Serial schedule of different n transactions. |
| D. | Non-serial schedule of different n transactions. |
| Answer» A. Serial schedule of the same n transactions. | |
| 13. |
In two-phase locking protocol. |
| A. | All unlocking operations precede the first lock operation. |
| B. | All locking operations precede the first unlock operation. |
| C. | Locking and unlocking takes place simultaneously. |
| D. | None of the above. |
| Answer» B. All locking operations precede the first unlock operation. | |
| 14. |
Transaction timestamp is: |
| A. | Not unique for each transaction |
| B. | Larger for older transaction |
| C. | Unique identifier assigned to each transaction. |
| D. | None of the above. |
| Answer» C. Unique identifier assigned to each transaction. | |
| 15. |
The granularity of a database item can be chosen to be |
| A. | A whole file |
| B. | A database record |
| C. | The whole database |
| D. | All of the above. |
| Answer» D. All of the above. | |
| 16. |
If the complete execution of the transaction(s) takes the database from one consistent state to the other then that property of transaction is called: |
| A. | Isolation |
| B. | Durability |
| C. | Consistency preservation |
| D. | None of the above |
| Answer» C. Consistency preservation | |
| 17. |
Which of the following is not the state that the transaction undergoes? |
| A. | Failed |
| B. | Active |
| C. | Partially committed |
| D. | Non active |
| Answer» D. Non active | |
| 18. |
Timestamp can be generated by: |
| A. | Counter |
| B. | Current date/time |
| C. | None of the above |
| D. | Both (a) and (b) |
| Answer» D. Both (a) and (b) | |
| 19. |
Which of the following is the formal process for deciding which attributes should be grouped together in a relation? |
| A. | Normalization |
| B. | Performance Tuning |
| C. | Optimization |
| D. | None of the above |
| Answer» A. Normalization | |
| 20. |
Who developed normalization process? |
| A. | C.J. Date |
| B. | E.F. Codd |
| C. | Donald Chamberlain |
| D. | Collin White |
| Answer» B. E.F. Codd | |
| 21. |
Who developed the BCNF? |
| A. | Boyd and Cromwell |
| B. | Date and Codd |
| C. | Date and White |
| D. | Boyce and Codd |
| Answer» D. Boyce and Codd | |
| 22. |
What is the expansion of BCNF? |
| A. | Boyd-Cromwell Normal Form |
| B. | Boyce-Codd Normal Form |
| C. | Boyd-Codd Normal Form |
| D. | All of the above |
| Answer» B. Boyce-Codd Normal Form | |
| 23. |
Which of the following is the result of a transitive dependency? |
| A. | Insertion anomaly |
| B. | Modification anomaly |
| C. | Deletion anomaly |
| D. | All of the above |
| Answer» D. All of the above | |
| 24. |
Which of the following is true? |
| A. | Normalized data is the best representation of data. |
| B. | Data stored non-redundantly will be accessed faster than data stored many times. |
| C. | Normalized tables are the best way to store data. |
| D. | All of the above |
| Answer» D. All of the above | |
| 25. |
How many inference rules are there for functional dependencies? |
| A. | 4 |
| B. | 5In t |
| C. | 6 |
| D. | 7 |
| Answer» C. 6 | |
| 26. |
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» A. Dependency preservation property | |
| 27. |
Every relation in BCNF is also in |
| A. | 3NF |
| B. | 2NF |
| C. | 1NF |
| D. | None of the above |
| Answer» A. 3NF | |
| 28. |
A table that contains one or more repeating groups is in which normal form? |
| A. | 1NF |
| B. | 2NF |
| C. | 3NF |
| D. | Unnormalized Form |
| Answer» D. Unnormalized Form | |
| 29. |
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» A. Database application and the database | |
| 30. |
Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM? |
| A. | IDMS |
| B. | DB2 |
| C. | dBase-II |
| D. | R:base |
| Answer» B. DB2 | |
| 31. |
The following are components of a database except ________ . |
| A. | user data |
| B. | Metadata |
| C. | Reports |
| D. | Indexes |
| Answer» C. Reports | |
| 32. |
An application where only one user accesses the database at a given time is an example of a(n) ________ . |
| A. | single-user database application |
| B. | multiuser database application |
| C. | e-commerce database application |
| D. | data mining database application |
| Answer» A. single-user database application | |
| 33. |
An on-line commercial site such as Amazon.com is an example of a(n) ________ . |
| A. | single-user database application |
| B. | multiuser database application |
| C. | e-commerce database application |
| D. | data mining database application |
| Answer» C. e-commerce database application | |
| 34. |
SQL stands for ________ . |
| A. | Structured Query Language |
| B. | Sequential Query Language |
| C. | Structured Question Language |
| D. | Sequential Question Language |
| Answer» A. Structured Query Language | |
| 35. |
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» C. self-describing | |
| 36. |
The following are functions of a DBMS except ________ . |
| A. | creating and processing forms |
| B. | creating databases |
| C. | processing data |
| D. | administrating databases |
| Answer» A. creating and processing forms | |
| 37. |
Helping people keep track of things is the purpose of a(n) ________ . |
| A. | Database |
| B. | Table |
| C. | Instance |
| D. | Relationship |
| Answer» A. Database | |
| 38. |
A DBMS that combines a DBMS and an application generator is ________ . |
| A. | Microsoft's SQL Server |
| B. | Microsoft's Access |
| C. | IBM's DB2 |
| D. | Oracle Corporation's Oracle |
| Answer» B. Microsoft's Access | |
| 39. |
Which of the following is related to information? |
| A. | Data |
| B. | Communication |
| C. | Knowledge |
| D. | All of these. |
| Answer» A. Data | |
| 40. |
Data is: |
| A. | A piece of fact |
| B. | Metadata |
| C. | Information |
| D. | None of these. |
| Answer» A. A piece of fact | |
| 41. |
Which of the following is element of the database? |
| A. | Data |
| B. | Constraints and schema |
| C. | Relationships |
| D. | All of these. |
| Answer» D. All of these. | |
| 42. |
What represent a correspondence between the various data elements? |
| A. | Data |
| B. | Constraints |
| C. | Relationships |
| D. | Schema |
| Answer» C. Relationships | |
| 43. |
Which of the following is an advantage of using database system? |
| A. | Security enforcement |
| B. | Avoidance of redundancy |
| C. | Reduced inconsistency |
| D. | All of these. |
| Answer» D. All of these. | |
| 44. |
Which of the following is characteristic of the data in a database? |
| A. | Independent |
| B. | Secure |
| C. | Shared |
| D. | All of these. |
| Answer» D. All of these. | |
| 45. |
Relationships could be of the following type: |
| A. | One-to-one relationship |
| B. | One-to-many relationships |
| C. | Many-to-many relationships |
| D. | All of these. |
| Answer» D. All of these. | |
| 46. |
In a file-oriented system there is: |
| A. | Data inconsistency |
| B. | Duplication of data |
| C. | Data independence |
| D. | Al of these. |
| Answer» D. Al of these. | |
| 47. |
In a database system there is: |
| A. | Increased productivity |
| B. | Improved security |
| C. | Economy of scale |
| D. | All of these. |
| Answer» D. All of these. | |
| 48. |
VDL is used to specify: |
| A. | Internal schema |
| B. | External schema |
| C. | Conceptual schema |
| D. | None of these. |
| Answer» D. None of these. | |
| 49. |
The DML provides following functional access to the database: |
| A. | Retrieve data and/or records |
| B. | Add (or insert) records |
| C. | Delete records from database files |
| D. | All of these |
| Answer» B. Add (or insert) records | |
| 50. |
4GL has the following components inbuilt in it: |
| A. | Query languages |
| B. | Report generators |
| C. | Spreadsheets |
| D. | All of these. |
| Answer» D. All of these. | |
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.