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 is proper subset designed to support views belonging to different classes of users in order to hide or protect information. |
| A. | Schema |
| B. | Sub-schema |
| C. | Non-schema |
| D. | Non-sub schema |
| Answer» C. Non-schema | |
| 2. |
Which normal form is considered adequate for relational database design? |
| A. | 2 NF |
| B. | 3 NF |
| C. | 4 NF |
| D. | BCNF |
| Answer» C. 4 NF | |
| 3. |
In ..................... , we have a strict parent-child relationship only. |
| A. | hierarchical databases. |
| B. | network databases |
| C. | object oriented databases |
| D. | relational databases |
| Answer» B. network databases | |
| 4. |
Which contain information about a file needed by system programs for accessing file records? |
| A. | File blocks |
| B. | File operators |
| C. | File headers |
| D. | None of these |
| Answer» D. None of these | |
| 5. |
............................ is the powerful language for working with RDBMS. |
| A. | Embedded Programs |
| B. | Dynamic Programs |
| C. | Query Language |
| D. | Static Language Programs |
| Answer» D. Static Language Programs | |
| 6. |
………………. Allows definitions and query language statements to be entered; query results are formatted and displayed. |
| A. | Schema Processor |
| B. | Query Processor |
| C. | Terminal Interface |
| D. | None of the above |
| Answer» D. None of the above | |
| 7. |
A ……………… allows to make copies of the database periodically to help in the cases of crashes u0026 disasters. |
| A. | Recovery utility |
| B. | Backup Utility |
| C. | Monitoring utility |
| D. | Data loading utility |
| Answer» C. Monitoring utility | |
| 8. |
The file in DBMS is called as .................. in RDBMS. |
| A. | console |
| B. | schema |
| C. | table |
| D. | object |
| Answer» D. object | |
| 9. |
4NF stands for .. |
| A. | Fourth Normal File |
| B. | Fourth Normal Form |
| C. | Fourth Normal Fraction |
| D. | Fourth Negative File |
| Answer» C. Fourth Normal Fraction | |
| 10. |
Which if the following is not the type of data integrity. |
| A. | Key integrity |
| B. | Domain integrity |
| C. | Entity integrity |
| D. | Referential integrity |
| Answer» B. Domain integrity | |
| 11. |
Which can be used to delete all the rows if a table? |
| A. | Delete * from table_name |
| B. | Delete from table_name |
| C. | Delete table_name |
| D. | all rows cannot be deleted at a time. |
| Answer» B. Delete from table_name | |
| 12. |
Anything that affects the database schema is a part of |
| A. | DML |
| B. | DCL |
| C. | DDL |
| D. | All of the above |
| Answer» D. All of the above | |
| 13. |
Reflexivity property says that X - Y is true if Y is …………………. |
| A. | Subset of X |
| B. | Null set of X |
| C. | Super set of Y |
| D. | Subset of Y |
| Answer» B. Null set of X | |
| 14. |
In the ………………… mode any record in the file can be accessed at random |
| A. | Sequential access |
| B. | Random access |
| C. | Standard access |
| D. | Source access |
| Answer» C. Standard access | |
| 15. |
An instance of a relation is a time varying set of …………………. |
| A. | Tuples |
| B. | Rows |
| C. | Both of them |
| D. | None of them |
| Answer» D. None of them | |
| 16. |
The one guideline to be followed while designing the database is |
| A. | A database design may be ambiguous. |
| B. | Unrelated data should be in the same table so that updating the data will be easy. |
| C. | It should avoid/reduce the redundancy. |
| D. | An entity should not have attributes. |
| Answer» D. An entity should not have attributes. | |
| 17. |
HSAM stands for ………. |
| A. | Hierarchic Sequential Access Method |
| B. | Hierarchic Standard Access Method |
| C. | Hierarchic Sequential and Method |
| D. | Hierarchic Standard and Method |
| Answer» B. Hierarchic Standard Access Method | |
| 18. |
………………… approach reduces time and effort required for design and lesser risk in database management. |
| A. | Single global database |
| B. | Top-down approach |
| C. | Multiple databases |
| D. | None of the above |
| Answer» D. None of the above | |
| 19. |
…………. contains data assisting day to day activities of the organization. |
| A. | Control database |
| B. | Operational database |
| C. | Strategic database |
| D. | Sequential database |
| Answer» C. Strategic database | |
| 20. |
…………….. is a utility to capture a continuous record of server activity and provide auditing capability. |
| A. | SQL server Profile |
| B. | SQL server service manager |
| C. | SQL server setup |
| D. | SQL server wizard. |
| Answer» C. SQL server setup | |
| 21. |
SQL server stores index information in the ………… system table |
| A. | syst indexes |
| B. | system indexes |
| C. | sysind |
| D. | sys indexes |
| Answer» E. | |
| 22. |
Processed data is called ……………….. |
| A. | Raw data |
| B. | Information |
| C. | Useful data |
| D. | Source |
| Answer» C. Useful data | |
| 23. |
............. is a special type of stored procedure that is automatically invoked whenever the data in the table is modified. |
| A. | Procedure |
| B. | Trigger |
| C. | Curser |
| D. | None of the above |
| Answer» C. Curser | |
| 24. |
Some of the utilities of DBMS are .............i) Loading ii) Backup iii) File organization iv) Process Organization |
| A. | i, ii, and iv only |
| B. | i, ii and iii only |
| C. | ii, iii and iv only |
| D. | All i, ii, iii, and iv |
| Answer» C. ii, iii and iv only | |
| 25. |
Which of the following is/are the Database server functions?i) Data management ii) Transaction managementiii) Compile queries iv) Query optimization |
| A. | i, ii, and iv only |
| B. | i, ii and iii only |
| C. | ii, iii and iv only |
| D. | All i, ii, iii, and iv |
| Answer» B. i, ii and iii only | |
| 26. |
Which of the syntax is correct for insert statement?i) insert into values ii) insert into (column list) values |
| A. | i-only |
| B. | ii-only |
| C. | Both of them |
| D. | None of them |
| Answer» D. None of them | |
| 27. |
The relational model is based on the concept that data is organized and stored in two-dimensional tables called ………………………. |
| A. | Fields |
| B. | Records |
| C. | Relations |
| D. | Keys |
| Answer» D. Keys | |
| 28. |
A ............. represents the number of entities to which another entity can be associated |
| A. | mapping cardinality |
| B. | table |
| C. | schema |
| D. | information |
| Answer» B. table | |
| 29. |
……………….. contains information that defines valid values that are stored in a column or data type. |
| A. | View |
| B. | Rule |
| C. | Index |
| D. | Default |
| Answer» D. Default | |
| 30. |
......... is critical in formulating database design. |
| A. | row column order |
| B. | number of tables |
| C. | functional dependency |
| D. | normalizing |
| Answer» D. normalizing | |
| 31. |
To change column value in a table the ......... command can be used. |
| A. | create |
| B. | insert |
| C. | alter |
| D. | update |
| Answer» E. | |
| 32. |
When SQL statements are embedded inside 3GL, we call such a program as .......... |
| A. | nested query |
| B. | nested programming |
| C. | distinct query |
| D. | embedded SQL |
| Answer» E. | |
| 33. |
The SQL statement SELECT SUBSTR('123456789', INSTR('abcabcabc','b'), 4) FROM EMP; prints |
| A. | 6789 |
| B. | 2345 |
| C. | 1234 |
| D. | 456789 |
| Answer» C. 1234 | |
| 34. |
To pass on granted privileges to other user the ...... clause is used |
| A. | create option |
| B. | grant option |
| C. | update option |
| D. | select option |
| Answer» C. update option | |
| 35. |
……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity. |
| A. | Column |
| B. | Constraint |
| C. | Index |
| D. | Trigger |
| Answer» C. Index | |
| 36. |
In snapshot, …………………. clause tells oracle how long to wait between refreshes. |
| A. | Complete |
| B. | Force |
| C. | Next |
| D. | Refresh |
| Answer» E. | |
| 37. |
One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values can be assigned to each data items. This is referred to as |
| A. | Data Security |
| B. | Domain access |
| C. | Data Control |
| D. | Domain Integrity |
| Answer» E. | |
| 38. |
State true or false.i) Select operator is not a unary operator.ii) Project operator chooses subset of attributes or columns of a relation. |
| A. | i-True, ii-False |
| B. | i-True, ii-True |
| C. | i-False, ii-True |
| D. | i-False, ii-False |
| Answer» D. i-False, ii-False | |
| 39. |
Centralizing the integrity checking directly under the DBMS ………….. Duplication and ensures the consistency and validity of the database. |
| A. | Increases |
| B. | Skips |
| C. | Does not reduce |
| D. | Reduces |
| Answer» E. | |
| 40. |
State true or falsei) A candidate key is a minimal super key.ii) A candidate key can also refer to as surrogate key. |
| A. | i-true, ii-false |
| B. | i-false, ii-true |
| C. | i-true, ii-true |
| D. | i-false, ii-false |
| Answer» D. i-false, ii-false | |
| 41. |
Which of the following are the properties of entities? |
| A. | Groups |
| B. | Table |
| C. | Attributes |
| D. | Switchboards |
| Answer» D. Switchboards | |
| 42. |
The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is |
| A. | Procedural DML |
| B. | Non-Procedural DML |
| C. | Procedural DDL |
| D. | Non-Procedural DDL |
| Answer» C. Procedural DDL | |
| 43. |
Which of the following sorting algorithm is of priority queue sorting type? |
| A. | Bubble sort |
| B. | Insertion sort |
| C. | Merge sort |
| D. | Selection sort |
| Answer» E. | |
| 44. |
Partition and exchange sort is ........ |
| A. | quick sort |
| B. | tree sort |
| C. | heap sort |
| D. | bubble sort |
| Answer» B. tree sort | |
| 45. |
.......... is putting an element in the appropriate place in a sorted list yields a larger sorted order list. |
| A. | Insertion |
| B. | Extraction |
| C. | Selection |
| D. | Distribution |
| Answer» B. Extraction | |
| 46. |
State True or False for internal sorting algorithms.i) Internal sorting are applied when the entire collection if data to be sorted is small enough that the sorting can take place within main memory.ii) The time required to read or write is considered to be significant in evaluating the performance of internal sorting. |
| A. | i-True, ii-True |
| B. | i-True, ii-False |
| C. | i-False, ii-True |
| D. | i-False, ii-False |
| Answer» C. i-False, ii-True | |
| 47. |
........ sorting algorithm is frequently used when n is small where n is total number of elements. |
| A. | Heap |
| B. | Insertion |
| C. | Bubble |
| D. | Quick |
| Answer» C. Bubble | |
| 48. |
............ is the method used by card sorter. |
| A. | Radix sort |
| B. | Insertion |
| C. | Heap |
| D. | Quick |
| Answer» B. Insertion | |
| 49. |
......... is rearranging pairs of elements which are out of order, until no such pairs remain. |
| A. | Insertion |
| B. | Exchange |
| C. | Selection |
| D. | Distribution |
| Answer» C. Selection | |
| 50. |
............order is the best possible for array sorting algorithm which sorts n item. |
| A. | O(n logn) |
| B. | O(n2) |
| C. | O(n+logn) |
| D. | O(logn) |
| Answer» D. O(logn) | |