MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which one of the following statements is / are true about SQL? |
| A. | SQL permits attribute names to be repeated in the same relation |
| B. | If there are no indexes on the relations then an SQL query will not work |
| C. | Duplicates are automatically eliminated by an SQL query |
| D. | None of the above |
| Answer» E. | |
| 2. |
Which normal relational database design the form that is considered adequate? |
| A. | 3NF |
| B. | 5NF |
| C. | 2NF |
| D. | 4NF |
| Answer» B. 5NF | |
| 3. |
The functional dependencies for the relational schema student performance (name, courseNo, rollno, grade) is given below :name, courseNo -> graderollno, courseNo -> gradename -> rollnorollno-> nameWhat is the highest normal form of this relational schema? |
| A. | 3NF |
| B. | 4NF |
| C. | BCNF |
| D. | 2NF |
| Answer» B. 4NF | |
| 4. |
What is the maximum possible size of the file in the index allocation scheme of blocks to a file depend on? (Database) |
| A. | The size of the blocks and the size of the address of the blocks |
| B. | The number of blocks used for the index, the size of the blocks and the size of the address of the blocks |
| C. | The number of blocks used for the index and the size of the blocks |
| D. | None of the above |
| Answer» D. None of the above | |
| 5. |
Which of the following may lead to an irrecoverable error in a database system? |
| A. | A transaction reads a data item after it is written by an uncommitted transaction |
| B. | A transaction reads a data item after it is written by a committed transaction |
| C. | A transaction reads a data item after it is read by an uncommitted transaction |
| D. | A transaction writes a data item after it is read by an uncommitted transaction |
| Answer» B. A transaction reads a data item after it is written by a committed transaction | |
| 6. |
Which type of clustering index is defined on the fields? |
| A. | Non-key and non-ordering |
| B. | Non-key and ordering |
| C. | Key and non-ordering |
| D. | Key and Ordering |
| Answer» C. Key and non-ordering | |
| 7. |
Which is the concurrency control protocol that ensure both conflict serializability and freedom from deadlock? (Database) |
| A. | Time stamp ordering |
| B. | 2 - phase locking |
| C. | Both A and B |
| D. | Neither A nor B |
| Answer» B. 2 - phase locking | |
| 8. |
What do you mean by atomicity? |
| A. | When an update occurs to a database, either all or none of the update becomes available to anyone |
| B. | It determines how the transaction integrity will be visible to the other users and systems |
| C. | The transactions have been committed and will survive permanently |
| D. | All of the above |
| Answer» B. It determines how the transaction integrity will be visible to the other users and systems | |
| 9. |
What type of relationship does a hierarchical schema help to establish between the items of a database? |
| A. | top-to-bottom relationship |
| B. | bottom-to-top relationship |
| C. | one-to-many relationship |
| D. | many-to-one |
| Answer» B. bottom-to-top relationship | |
| 10. |
What is truncating a table? |
| A. | Data alone deleted, Performs an automatic commit |
| B. | Data alone deleted, Doesn t perform automatic commit |
| C. | Table structure + Data are deleted |
| D. | Table structure alone deleted, Performs an automatic commit |
| Answer» B. Data alone deleted, Doesn t perform automatic commit | |
| 11. |
Which among the following comprises of a complete record of all activities responsible in affecting the database contents for a specific duration? |
| A. | Transaction log |
| B. | Data manipulation language |
| C. | Query language |
| D. | Report writer |
| Answer» B. Data manipulation language | |
| 12. |
What is 5NF? |
| A. | The database should be in 3NF and all tables can have only one primary key. |
| B. | There should be no cyclic dependencies in a composite key. |
| C. | All attributes within the entity should depend solely on the entity's unique identifier. |
| D. | Tables cannot have multi - valued dependencies on a Primary Key. |
| Answer» C. All attributes within the entity should depend solely on the entity's unique identifier. | |
| 13. |
What type of form says Each column type is unique ? |
| A. | 1NF |
| B. | 2NF |
| C. | 4NF |
| D. | BCNF |
| Answer» B. 2NF | |
| 14. |
Which of the following has a relationship between / among themselves as a functional dependency? |
| A. | Rows |
| B. | Relations |
| C. | Attributes |
| D. | Tables |
| Answer» D. Tables | |
| 15. |
Which of the following is used to define the schema of each database hosted in the DBMS? |
| A. | ER diagram |
| B. | UML |
| C. | Database model |
| D. | Both b and c above |
| Answer» D. Both b and c above | |
| 16. |
What is the highest level in a hierarchy of data organization? |
| A. | Data Record |
| B. | Data File |
| C. | Database |
| D. | None of the above |
| Answer» D. None of the above | |
| 17. |
Issuing which type of savepoint will cause the named savepoint to be discarded? (Database) |
| A. | TRUNCATE SAVEPOINT |
| B. | DELETE SAVEPOINT |
| C. | DISCARD SAVEPOINT |
| D. | RELEASE SAVEPOINT |
| Answer» E. | |
| 18. |
What is an audit trial? (Database) |
| A. | Used for making backup copies |
| B. | The recorded history of operations performed on a file |
| C. | Used for retrieving the lost information |
| D. | All of the above |
| Answer» C. Used for retrieving the lost information | |
| 19. |
Which SQL keyword is used to remove the duplication of rows from the result set? |
| A. | DELETE |
| B. | SELECT |
| C. | DISTINCT |
| D. | UNIQUE |
| Answer» D. UNIQUE | |
| 20. |
Which type of lock does a record or page get locked immediately? |
| A. | Pessimistic locking |
| B. | Optimistic locking |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. Optimistic locking | |
| 21. |
What is durability? |
| A. | When an update occurs to a database, either all or none of the update becomes available to anyone |
| B. | The transactions have been committed and will survive permanently |
| C. | It determines how the transaction integrity will be visible to the other users and systems |
| D. | All of the above |
| Answer» B. The transactions have been committed and will survive permanently | |
| 22. |
What are the Report Generators used for? |
| A. | Retrieve information from files |
| B. | Answer queries |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 23. |
Which is an essential characteristic of a normal form where every determi t in a table must be a candidate key? |
| A. | First |
| B. | Second |
| C. | Boyce - Codd |
| D. | Fifth |
| Answer» D. Fifth | |
| 24. |
Which of the following statement is / are nottrue about normal forms? (Database) |
| A. | Any relation with two attributes is in BCNF |
| B. | BCNF is stricter than 3NF |
| C. | Lossless, dependency - preserving decomposition into 3NF is always possible |
| D. | Lossless, dependency - preserving decomposition into BCNF is always possible |
| Answer» E. | |
| 25. |
Database: Which of the following fields in a student file can be used as a primary key? |
| A. | class |
| B. | Social Security Number |
| C. | GPA |
| D. | Major |
| Answer» C. GPA | |
| 26. |
Database: Which is the make given to the database management system which is able to handle full text data, image data, audio and video? |
| A. | full media |
| B. | graphics media |
| C. | multimedia |
| D. | hypertext |
| Answer» D. hypertext | |
| 27. |
Database: A condition that led to the development of database was |
| A. | A demand for more data to support information needs |
| B. | An increase in the amount of data handled by organizations |
| C. | The poliferation of data files |
| D. | All of above |
| Answer» E. | |
| 28. |
Which normal form is the partial dependency removed? |
| A. | First |
| B. | Second |
| C. | Third |
| D. | BCNF |
| Answer» C. Third | |
| 29. |
Which of the following is an Open Source DBMS? |
| A. | MySQL |
| B. | Microsoft SQL Server |
| C. | Microsoft Access |
| D. | Oracle |
| Answer» B. Microsoft SQL Server | |
| 30. |
State the concurrency protocols which ensure both conflict serializability and freedom from deadlock1. 2-phase locking2. Time-stamp ordering |
| A. | 1 only |
| B. | 2 only |
| C. | Both 1 and 2 |
| D. | Neither 1 nor 2 |
| Answer» C. Both 1 and 2 | |
| 31. |
When a primary key is define in the table, DBMS automatically creates a ____ on a primary key column. |
| A. | Unique index |
| B. | Sequence |
| C. | Trigger |
| D. | Synonym |
| Answer» B. Sequence | |
| 32. |
Match the followingA) Composite attribute ------ i) Attribute whose value is calculated from other attributesB) Multivalued Attribute ---- ii) Attribute that can be further subdivided to yield additional attributesC) Derived Attribute -------- iii) Attribute that can have more values |
| A. | A-i, B-ii, C-iii |
| B. | A-ii, B-i, C-iii |
| C. | A-ii, B-iii, C-i |
| D. | A-iii, B-ii, C-i |
| Answer» D. A-iii, B-ii, C-i | |
| 33. |
What is the responsibility of the buffer manager? |
| A. | Fetching data from disk storage into main memory, and deciding what data to cache in main memory. |
| B. | Allocation of space on disk storage and the data structures used to represent information stored on disk. |
| C. | Storing details such as how many users, which user has which permissions etc. |
| D. | None of the above |
| Answer» B. Allocation of space on disk storage and the data structures used to represent information stored on disk. | |
| 34. |
Why are B+ trees preferred over binary trees in databases? |
| A. | Disk capacities are greater than memory capacities |
| B. | Disk access is much slower than memory access |
| C. | Disk data transfer rates are much less than memory data transfer rates |
| D. | Disks are more reliable than memory |
| Answer» E. | |
| 35. |
Which of the following forms is considered as adequate for normal relational database design? |
| A. | 1NF |
| B. | 5NF |
| C. | 4 NF |
| D. | 3NF |
| Answer» E. | |