MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 24 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Fundamentals knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Object=_________+relationships. |
| A. | data |
| B. | attributes |
| C. | entity |
| D. | constraints |
| Answer» D. constraints | |
| 2. |
A model developed by Hammer and Mc Leod in 1981. |
| A. | SDM |
| B. | OODBM |
| C. | DDM |
| D. | RDM |
| Answer» B. OODBM | |
| 3. |
DBMS manages the interaction between __________ and database. |
| A. | Users |
| B. | Clients |
| C. | End Users |
| D. | Stake Holders |
| Answer» D. Stake Holders | |
| 4. |
Hierarchical model is also called |
| A. | Plex Structure |
| B. | Tree structure |
| C. | Table Structure |
| D. | Normalize Structure |
| Answer» C. Table Structure | |
| 5. |
To delete a particular column in a relation the command used is: |
| A. | DROP |
| B. | UPDATE |
| C. | DELETE |
| D. | ALTER |
| Answer» E. | |
| 6. |
_________ data type can store unstructured data |
| A. | CHAR |
| B. | RAW |
| C. | VARCHAR |
| D. | NUMERIC |
| Answer» C. VARCHAR | |
| 7. |
The collection of information stored in a database of a particular moment is ____________ |
| A. | schema |
| B. | view |
| C. | subschema |
| D. | instance |
| Answer» E. | |
| 8. |
The method of access which uses key transformation is known as |
| A. | Hash |
| B. | Direct |
| C. | Sequential |
| D. | Random |
| Answer» B. Direct | |
| 9. |
In E-R diagram generalization is represented by |
| A. | Dashed ellipse |
| B. | Ellipse |
| C. | Triangle |
| D. | Rectangle |
| Answer» D. Rectangle | |
| 10. |
The ______ operator is used to compare a value to a list of literals values that have beenspecified. |
| A. | ANY |
| B. | BETWEEN |
| C. | ALL |
| D. | IN |
| Answer» C. ALL | |
| 11. |
A B-tree of order m has maximum of _____________ children |
| A. | m 1 |
| B. | m |
| C. | m/2 |
| D. | m-1 |
| Answer» B. m | |
| 12. |
What techniques are used to retrieve data from more than one table in single SQL STATEMENT? |
| A. | union |
| B. | Joins |
| C. | all the above |
| D. | nested selects |
| Answer» D. nested selects | |
| 13. |
A data manipulation command the combines the records from one or more tables is called |
| A. | PROJECT |
| B. | SELECT |
| C. | PRODUCT |
| D. | JOIN |
| Answer» E. | |
| 14. |
_________ is a virtual table that draws its data from the result of an SQLSELECT statement. |
| A. | Synonym |
| B. | View |
| C. | Transaction |
| D. | Sequence |
| Answer» C. Transaction | |
| 15. |
A_MODEL_DEVELOPED_BY_HAMMER_AND_MC_LEOD_IN_1981.?$ |
| A. | SDM |
| B. | OODBM |
| C. | DDM |
| D. | RDM |
| Answer» B. OODBM | |
| 16. |
Object=_________+relationships.$ |
| A. | data |
| B. | attributes |
| C. | entity |
| D. | constraints |
| Answer» D. constraints | |
| 17. |
IMS stands for? |
| A. | Information Mastering System |
| B. | Instruction Management System |
| C. | Instruction Manipulating System |
| D. | Information Management System |
| Answer» E. | |
| 18. |
The restrictions placed on the data. |
| A. | Relation |
| B. | Attribute |
| C. | Parameter |
| D. | Constraint |
| Answer» E. | |
| 19. |
A characteristic of an entity. |
| A. | Relation |
| B. | Attribute |
| C. | Parameter |
| D. | Constraint |
| Answer» C. Parameter | |
| 20. |
Database is generally __________ |
| A. | System-centered |
| B. | User-centered |
| C. | Company-centered |
| D. | Data-centered |
| Answer» C. Company-centered | |
| 21. |
Which of the following is not involved in DBMS? |
| A. | End Users |
| B. | Data |
| C. | Application Request |
| D. | HTML |
| Answer» E. | |
| 22. |
DBMS manages the interaction between __________ and database. |
| A. | Users |
| B. | Clients |
| C. | End Users |
| D. | Stake Holders |
| Answer» D. Stake Holders | |
| 23. |
DBMS is software. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 24. |
A collection of related data. |
| A. | Information |
| B. | Valuable information |
| C. | Database |
| D. | Metadata |
| Answer» D. Metadata | |