MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 95 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which of the following projects illustrates a database being designed from existing data? |
| A. | A database using the Production Department's spreadsheets |
| B. | A database designed to produce production reports for a new Production Department manufacturing process |
| C. | A database that will combine two databases currently used by the Production Department |
| D. | None of the above is correct. |
| Answer» B. A database designed to produce production reports for a new Production Department manufacturing process | |
| 2. |
You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________. |
| A. | user data |
| B. | metadata |
| C. | A report |
| D. | indexes |
| Answer» C. A report | |
| 3. |
In E-R diagram generalization is represented by |
| A. | Ellipse |
| B. | Dashed ellipse |
| C. | Rectangle |
| D. | Triangle |
| Answer» E. | |
| 4. |
Hierarchical model is also called |
| A. | Tree structure |
| B. | Plex Structure |
| C. | Normalize Structure |
| D. | Table Structure |
| Answer» B. Plex Structure | |
| 5. |
In E-R Diagram relationship type is represented by |
| A. | Ellipse |
| B. | Dashed ellipse |
| C. | Rectangle |
| D. | Diamond |
| Answer» E. | |
| 6. |
__________________ is collection of interrelated data and set of program to access them. |
| A. | Data Structure |
| B. | Programming language |
| C. | Database Management System |
| D. | Database |
| Answer» D. Database | |
| 7. |
Database is collection of ____. |
| A. | Modules |
| B. | Data |
| C. | None of these |
| D. | Programs |
| Answer» C. None of these | |
| 8. |
Related fields in a database are grouped to form a |
| A. | Data file |
| B. | Data record. |
| C. | Menu. |
| D. | Bank. |
| Answer» C. Menu. | |
| 9. |
In __________ data can be stored in structured manner. |
| A. | None of these |
| B. | CPU |
| C. | Database |
| D. | ALU |
| Answer» D. ALU | |
| 10. |
Long form of DBA is ______________. |
| A. | Database Application |
| B. | None of these |
| C. | Database Admin |
| D. | Database Administrator |
| Answer» E. | |
| 11. |
DBMS stands for __________. |
| A. | None of these |
| B. | Database Administrator System |
| C. | Database Basic Management System |
| D. | Database Management System |
| Answer» E. | |
| 12. |
A database is a complex type of ______. |
| A. | None of these |
| B. | Application |
| C. | Data Structure |
| D. | Manager |
| Answer» D. Manager | |
| 13. |
The DBMS acts as an interface between what two components of an database system ? |
| A. | Data and Database |
| B. | Database and User |
| C. | Database and SQL |
| D. | Database Application and Database |
| Answer» E. | |
| 14. |
Before use of DBMS information was stored using __________. |
| A. | Cloud Storage |
| B. | None of these |
| C. | File Management System |
| D. | Data System |
| Answer» D. Data System | |
| 15. |
Which of the following is considered as DBMS ? |
| A. | Oracle |
| B. | Foxpro |
| C. | All of these |
| D. | Access |
| Answer» D. Access | |
| 16. |
DBMS should provide following feature(s) ______. |
| A. | Protect data from system crash |
| B. | All of these |
| C. | Safety of the information stored |
| D. | Authorized access |
| Answer» C. Safety of the information stored | |
| 17. |
The method in which records are physically stored in a specified order according to a key field in each record is |
| A. | Hash |
| B. | Direct. |
| C. | Sequential |
| D. | All of the above. |
| Answer» B. Direct. | |
| 18. |
Which one of the following statements is false? |
| A. | The data dictionary is normally maintained by the database administrator. |
| B. | Data elements in the database can be modified by changing the data dictionary. |
| C. | The data dictionary contains the name and description of each data element. |
| D. | The data dictionary is a tool used exclusively by the database administrator. |
| Answer» C. The data dictionary contains the name and description of each data element. | |
| 19. |
A subschema expresses |
| A. | The logical view |
| B. | The physical view. |
| C. | The external view. |
| D. | All of the above. |
| Answer» D. All of the above. | |
| 20. |
Conceptual design |
| A. | Is a documentation technique. |
| B. | Needs data volume and processing frequencies to determine the size of the database. |
| C. | Involves modelling independent of the DBMS |
| D. | Is designing the relational model. |
| Answer» D. Is designing the relational model. | |
| 21. |
The relational model feature is that there |
| A. | Is no need for primary key data |
| B. | Is much more data independence than some other database models |
| C. | Are explicit relationships among records |
| D. | Are tables with many dimensions |
| Answer» C. Are explicit relationships among records | |
| 22. |
The way a particular application views the data from the database that the application uses is a |
| A. | Module. |
| B. | Relational model. |
| C. | Schema. |
| D. | Sub schema. |
| Answer» E. | |
| 23. |
The property / properties of a database is / are : |
| A. | It is an integrated collection of logically related records. |
| B. | It consolidates separate files into a common pool of data records. |
| C. | Data stored in a database is independent of the application programs using it |
| D. | All of the above |
| Answer» E. | |
| 24. |
The database environment has all of the following components except: |
| A. | Users. |
| B. | Separate files |
| C. | Database. |
| D. | Database administrator |
| Answer» C. Database. | |
| 25. |
Which of the following are the properties of entities? |
| A. | Groups |
| B. | Table |
| C. | Attributes |
| D. | Switchboards |
| Answer» D. Switchboards | |
| 26. |
_______ produces the relation that has attributes of R1 and R2 |
| A. | Cartesian product |
| B. | Difference |
| C. | Intersection |
| D. | Product |
| Answer» B. Difference | |
| 27. |
SET concept is used in : |
| A. | Network Model |
| B. | Hierarchical Model |
| C. | Relational Model |
| D. | None of these |
| Answer» B. Hierarchical Model | |
| 28. |
Data independence means |
| A. | Data is defined separately and not included in programs |
| B. | Programs are not dependent on the physical attributes of data. |
| C. | Programs are not dependent on the logical attributes of data |
| D. | Both (B) and (C). |
| Answer» E. | |
| 29. |
E-R model uses this symbol to represent weak entity set ? |
| A. | Dotted rectangle |
| B. | Diamond |
| C. | Doubly outlined rectangle |
| D. | None of these |
| Answer» D. None of these | |
| 30. |
A DBMS query language is designed to |
| A. | Support end users who use English-like commands |
| B. | Support in the development of complex applications software |
| C. | Specify the structure of a database. |
| D. | All of the above. |
| Answer» E. | |
| 31. |
Which are the two ways in which entities can participate in a relationship? |
| A. | Passive and active |
| B. | Total and partial |
| C. | Simple and Complex |
| D. | All of the above |
| Answer» C. Simple and Complex | |
| 32. |
Which of the following is an advantage of view? |
| A. | Data security |
| B. | Derived columns |
| C. | Hiding of complex queries |
| D. | All of the above |
| Answer» E. | |
| 33. |
Which database level is closest to the users? |
| A. | External |
| B. | Internal |
| C. | Physical |
| D. | Conceptual |
| Answer» B. Internal | |
| 34. |
The users who use easy-to-use menu are called |
| A. | Sophisticated end users |
| B. | Na ve users. |
| C. | Stand-alone users. |
| D. | Casual end user |
| Answer» C. Stand-alone users. | |
| 35. |
A primary key is combined with a foreign key creates |
| A. | Parent-Child relationship between the tables that connect them |
| B. | Many to many relationship between the tables that connect them. |
| C. | Network model between the tables that connect them. |
| D. | None of the above |
| Answer» B. Many to many relationship between the tables that connect them. | |
| 36. |
Which of the following is record based logical model? |
| A. | Network Model |
| B. | Object oriented model |
| C. | E-R Model |
| D. | None of these |
| Answer» B. Object oriented model | |
| 37. |
A file manipulation command that extracts some of the records from a file is called |
| A. | SELECT |
| B. | PROJECT |
| C. | JOIN |
| D. | PRODUCT |
| Answer» B. PROJECT | |
| 38. |
NULL is |
| A. | The same as 0 for integer |
| B. | The same as blank for character |
| C. | The same as 0 for integer and blank for character |
| D. | Not a value |
| Answer» E. | |
| 39. |
A data dictionary is a special file that contains: |
| A. | The name of all fields in all files. |
| B. | The width of all fields in all files. |
| C. | The data type of all fields in all file |
| D. | All of the above |
| Answer» E. | |
| 40. |
Which of the following is another name for weak entity? |
| A. | Child |
| B. | Owner |
| C. | Dominant |
| D. | All of the above |
| Answer» B. Owner | |
| 41. |
Which of the operations constitute a basic set of operations for manipulating relational data? |
| A. | Predicate calculus |
| B. | Relational calculus |
| C. | Relational algebra |
| D. | None of the above |
| Answer» D. None of the above | |
| 42. |
A set of possible data values is called |
| A. | Attribute |
| B. | Degree. |
| C. | Tuple. |
| D. | Domain. |
| Answer» E. | |
| 43. |
The result of the UNION operation between R1 and R2 is a relation that includes |
| A. | All the tuples of R1 |
| B. | All the tuples of R2 |
| C. | All the tuples of R1 and R2 |
| D. | All the tuples of R1 and R2 which have common columns |
| Answer» D. All the tuples of R1 and R2 which have common columns | |
| 44. |
Which of the following database object does not physically exist? |
| A. | Base table |
| B. | Index |
| C. | View |
| D. | None of the above |
| Answer» D. None of the above | |
| 45. |
The conceptual model is |
| A. | Dependent on hardware |
| B. | Dependent on software. |
| C. | Dependent on both hardware and software |
| D. | Independent of both hardware and software |
| Answer» E. | |
| 46. |
The RDBMS terminology for a row is |
| A. | Tuple. |
| B. | Relation. |
| C. | Attribute. |
| D. | Degree. |
| Answer» B. Relation. | |
| 47. |
What is a relationship called when it is maintained between two entities? |
| A. | Unary |
| B. | Binary |
| C. | Ternary |
| D. | Quaternary |
| Answer» C. Ternary | |
| 48. |
It is better to use files than a DBMS when there are |
| A. | Stringent real-time requirements |
| B. | Multiple users wish to access the data |
| C. | Complex relationships among data |
| D. | All of the above. |
| Answer» C. Complex relationships among data | |
| 49. |
In a relation |
| A. | Ordering of rows is immaterial |
| B. | No two rows are identical |
| C. | (A) and (B) both are true |
| D. | None of these |
| Answer» D. None of these | |
| 50. |
Which of the following operation is used if we are interested in only certain columns of a table? |
| A. | PROJECTION |
| B. | SELECTION |
| C. | UNION |
| D. | JOIN |
| Answer» B. SELECTION | |