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 of the following is not comparison operator? |
| A. | <> |
| B. | < |
| C. | 0 |
| D. | >= |
| Answer» D. >= | |
| 2. |
The phrase “greater than at least one” is represented in SQL by |
| A. | < all |
| B. | < some |
| C. | > all |
| D. | > some |
| Answer» E. | |
| 3. |
A logical description of some portion of database that is required by a user to perform task is called as |
| A. | system view |
| B. | user view |
| C. | logical view |
| D. | data view |
| Answer» C. logical view | |
| 4. |
A functional dependency between two or more non-key attributes is called |
| A. | transitive dependency |
| B. | partial transitive dependency |
| C. | functional dependency |
| D. | partial functional dependency |
| Answer» B. partial transitive dependency | |
| 5. |
A relation that has no partial dependencies is in which normal form |
| A. | first |
| B. | second |
| C. | third |
| D. | bcnf |
| Answer» C. third | |
| 6. |
In DBMS FD stands for _______ |
| A. | facilitate data |
| B. | functional data |
| C. | facilitate dependency |
| D. | functional dependency |
| Answer» E. | |
| 7. |
Which algebra is widely used in DBMS? |
| A. | relational algebra |
| B. | arithmetic algebra |
| C. | both |
| D. | none |
| Answer» B. arithmetic algebra | |
| 8. |
In an Entity-Relationship Diagram “Diamonds†represents |
| A. | attributes |
| B. | multi-valued attributes |
| C. | weak entity set |
| D. | relationship sets |
| Answer» E. | |
| 9. |
In an Entity-Relationship Diagram “Ellipses†represents |
| A. | attributes |
| B. | weak entity set |
| C. | relationship sets |
| D. | multi-valued attributes |
| Answer» B. weak entity set | |
| 10. |
Who proposed the relational model? |
| A. | bill gates |
| B. | e.f. codd |
| C. | herman hollerith |
| D. | charles babbage |
| Answer» C. herman hollerith | |
| 11. |
Which of the following is Relation-algebra Operation |
| A. | select |
| B. | union |
| C. | rename |
| D. | all of the above |
| Answer» E. | |
| 12. |
In mathematical term Row is referred as |
| A. | relation |
| B. | attribute |
| C. | tuple |
| D. | domain |
| Answer» D. domain | |
| 13. |
In mathematical term Table is referred as |
| A. | relation |
| B. | attribute |
| C. | tuple |
| D. | domain |
| Answer» B. attribute | |
| 14. |
A Relation is a |
| A. | subset of a cartesian product of a list of attributes |
| B. | subset of a cartesian product of a list of domains |
| C. | subset of a cartesian product of a list of tuple |
| D. | subset of a cartesian product of a list of relations |
| Answer» C. subset of a cartesian product of a list of tuple | |
| 15. |
Which of the following represents a relationship among a set of values. |
| A. | a row |
| B. | a table |
| C. | a field |
| D. | a column |
| Answer» B. a table | |
| 16. |
In an Entity-Relationship Diagram Rectangles represents |
| A. | entity sets |
| B. | attributes |
| C. | database |
| D. | tables |
| Answer» B. attributes | |
| 17. |
In a large DBMS |
| A. | each subschema contains every field in the logical schema |
| B. | each user can access every subschema |
| C. | none of the options |
| D. | each user can "see" only a small part of the entire database |
| Answer» E. | |
| 18. |
A set of programs that handle a firm's database responsibilities is called |
| A. | database management system (dbms) |
| B. | data management system (dms) |
| C. | all of the options |
| D. | database processing system (dbps) |
| Answer» D. database processing system (dbps) | |
| 19. |
The language used application programs to request data from the DBMS is referred to as the |
| A. | ddl |
| B. | all of the options |
| C. | dml |
| D. | query language |
| Answer» D. query language | |
| 20. |
Database management systems are intended to |
| A. | eliminate data redundancy |
| B. | establish relationship among records in different files |
| C. | manage file access and maintain data integrity |
| D. | all of the options |
| Answer» E. | |
| 21. |
The model for a record management system might be |
| A. | all of the options |
| B. | a business form |
| C. | handwritten list |
| D. | a rolodex card file |
| Answer» B. a business form | |
| 22. |
A file produced by a spreadsheet |
| A. | none of the options |
| B. | is generally stored on disk in an ascii text fromat |
| C. | can be used as is by the dbms |
| D. | both is generally stored on disk in an ascii text fromat and can be used as is by the dbms |
| Answer» C. can be used as is by the dbms | |
| 23. |
A transparent DBMS |
| A. | both can not hide sensitive information from users and keeps its logical structure hidden from users |
| B. | keeps its physical structure hidden from users |
| C. | can not hide sensitive information from users |
| D. | keeps its logical structure hidden from users |
| Answer» C. can not hide sensitive information from users | |
| 24. |
Large collection of files are called |
| A. | sectors |
| B. | database |
| C. | fields |
| D. | records |
| Answer» C. fields | |
| 25. |
Batch processing is appropriate if |
| A. | only a few transactions are involved |
| B. | none of the options |
| C. | large computer system is available |
| D. | only a small computer system is avilbale |
| Answer» C. large computer system is available | |
| 26. |
In the DBMS approach, application programs perform the |
| A. | storage function |
| B. | access control |
| C. | all of the options |
| D. | processing functions |
| Answer» E. | |
| 27. |
Choose the RDBMS which supports full fledged client server application development |
| A. | dbase v |
| B. | ingress |
| C. | oracle 7.1 |
| D. | foxpro 2.1 |
| Answer» D. foxpro 2.1 | |
| 28. |
A top-to-bottom relationship among the items in a database is established by a |
| A. | hierarchical schema |
| B. | all of the options |
| C. | network schema |
| D. | relational schema |
| Answer» B. all of the options | |
| 29. |
Which of the following is not a relational database? |
| A. | dbase iv |
| B. | foxpro |
| C. | reflex |
| D. | 4th dimension |
| Answer» D. 4th dimension | |
| 30. |
Primitive operations common to all record management system include |
| A. | look-up |
| B. | all of the options |
| C. | |
| D. | sort |
| Answer» B. all of the options | |
| 31. |
The ascending order of a data hirerchy is: |
| A. | bit-byte-file-record-field-database |
| B. | bit-byte-field-record-file-database |
| C. | bit-byte-record-field-file-database |
| D. | byte-bit-field-record-file-database |
| Answer» C. bit-byte-record-field-file-database | |
| 32. |
The relational database environment has all of the following components except |
| A. | users |
| B. | database |
| C. | query languages |
| D. | separate files |
| Answer» E. | |
| 33. |
Information can be transferred between the DBMS and a |
| A. | spreadsheet program |
| B. | word processor program |
| C. | graphics program |
| D. | all of the options |
| Answer» E. | |
| 34. |
What is the language used by most of the DBMSs for helping their users to access data? |
| A. | high level language |
| B. | 4gl |
| C. | query language |
| D. | sql |
| Answer» D. sql | |
| 35. |
A command that lets you change one or more fields in a record is |
| A. | none of the options |
| B. | modify |
| C. | insert |
| D. | lookup |
| Answer» C. insert | |
| 36. |
The function of a database is ... |
| A. | to check all input data |
| B. | to output data |
| C. | to collect and organize input data |
| D. | to check all spelling |
| Answer» D. to check all spelling | |
| 37. |
One data dictionery software package is called |
| A. | db/dc dictionary |
| B. | datapac |
| C. | total |
| D. | access |
| Answer» B. datapac | |
| 38. |
A record management system |
| A. | can handle many files of information at a time |
| B. | always uses a list as its model |
| C. | both can handle many files of information at a time and always uses a list as its model |
| D. | can be used to extract information stored in a computer file |
| Answer» E. | |
| 39. |
Which of the following is true of a network structure? |
| A. | it will be dominant data base of the future |
| B. | it allows a many-to-many relationship |
| C. | it is a physical representation of the data |
| D. | it is conceptually simple |
| Answer» C. it is a physical representation of the data | |
| 40. |
Report generators are used to |
| A. | store data input by a user |
| B. | answer queries |
| C. | both retrieve information from files and answer queries |
| D. | retrieve information from files |
| Answer» D. retrieve information from files | |
| 41. |
Which of the following is not an advantage of the database approach |
| A. | elimination of data redundancy |
| B. | ability of associate deleted data |
| C. | increased security and program/data independence |
| D. | all of the above |
| Answer» E. | |
| 42. |
Which of the following is a problem of file management system? |
| A. | data redundancy and program dependence |
| B. | all of the options |
| C. | difficult to update |
| D. | lack of data independence |
| Answer» C. difficult to update | |
| 43. |
If a piece of data is stored in two places in the database, then |
| A. | in can be more easily accessed |
| B. | both storage space is wasted and changing the data in one spot will cause data inconsistency |
| C. | storage space is wasted |
| D. | changing the data in one spot will cause data inconsistency |
| Answer» C. storage space is wasted | |
| 44. |
A form defined |
| A. | none of the options |
| B. | where data is placed on the screen |
| C. | the width of each field |
| D. | both where data is placed on the screen and the width of each field |
| Answer» C. the width of each field | |
| 45. |
A type of query that is placed within a WHERE or HAVING clause of another query is called |
| A. | multi-query |
| B. | sub query |
| C. | super query |
| D. | master query |
| Answer» C. super query | |
| 46. |
A lock that allows concurrent transactions to access different rows of the same table is known as a |
| A. | row-level lock |
| B. | database-level lock |
| C. | field-level lock |
| D. | table-level lock |
| Answer» D. table-level lock | |
| 47. |
A table that displays data redundancies yields ____________ anomalies |
| A. | insertion |
| B. | deletion |
| C. | update |
| D. | all of the options |
| Answer» E. | |
| 48. |
_____________ refers to the correctness and completeness of the data in a database? |
| A. | data independence |
| B. | data integrity |
| C. | data security |
| D. | data constraint |
| Answer» C. data security | |
| 49. |
______________ is a classical approach to database design? |
| A. | bottom – up approach |
| B. | top – down approach |
| C. | left – right approach |
| D. | right – left approach |
| Answer» C. left – right approach | |
| 50. |
The minimal set of super key is called |
| A. | primary key |
| B. | secondary key |
| C. | foreign key |
| D. | candidate key |
| Answer» E. | |