InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
………. is a repository collection of related data(a) data(b) Information(c) database(d) tuple |
|
Answer» database is a repository collection of related data |
|
| 2. |
………. gives meaningful information(a) data(b) Information(c) row(d) tuple |
|
Answer» Information gives meaningful information |
|
| 3. |
Which model establishes many to many relationships?(a) Network(b) Relational(c) Hierarchical(d) Object |
|
Answer» Network model establishes many to many relationships. |
|
| 4. |
Entire collection of related data in one table, is referred to as ……… or …… |
|
Answer» File or Table |
|
| 5. |
…… are raw facts stored in a computer(a) data(b) Information (c) row (d) tuple |
|
Answer» Data are raw facts stored in a computer. |
|
| 6. |
Pick the odd out.Oracle, Foxpro, MariaDB, SQLite |
|
Answer» Answer is Foxpro |
|
| 7. |
……… uniquely identifies a particular tuple in a table |
|
Answer» Relation key |
|
| 8. |
Fill in the blanks.1. Each table ………. represents a Field2. Each ……… in table represents a record. |
|
Answer» 1. column 2. row |
|
| 9. |
Find the true statement(a) Data redundancy is exhibited by DBMS(b) Data redundancy is not present in DBMS |
|
Answer» (a) Data redundancy is exhibited by DBMS |
|
| 10. |
The relational model was developed in the year ……….(a) 1980(b) 1970(c) 1965(d) 1985 |
|
Answer» The relational model was developed in 1970 |
|
| 11. |
………….. is one who manages the complete database management system(a) Manager(b) Engineer(c) DBA(d) Service Person |
|
Answer» DBA is one who manages the complete database management system |
|
| 12. |
How many different types of a data model are there? (a) 2 (b) 3 (c) 4 (d) 5 |
|
Answer» There are 5 types of a data model |
|
| 13. |
Which database Model is the extended form of hierarchical data Model?(a) Network(b) Relational(c) Flat File(d) Object |
|
Answer» Network is the extended form of hierarchical data Model |
|
| 14. |
……. Model of data storage is used in DBMS. |
|
Answer» Navigational |
|
| 15. |
What is the acronym of DBMS?(a) DataBase Management Symbol(b) Database Managing System(c) DataBase Management System(d) DataBasic Management System |
|
Answer» (c) DataBase Management System |
|
| 16. |
What type of relationship does hierarchical model represents?(a) one-to-one(b) one-to-many(c) many-to-one(d) many-to-many |
|
Answer» (b) one-to-many |
|
| 17. |
Relational database model was first proposed by ……..(a) E F Codd(b) E E Codd(c) c) E F Cadd(d) E F Codder |
|
Answer» (a) E F Codd |
|
| 18. |
Which database model represents parent-child relationship?(a) Relational(b) Network(c) Hierarchical(d) Object |
|
Answer» (c) Hierarchical |
|
| 19. |
What is the role of DBA? |
|
Answer» Database Administrator 1. Database Administrator or DBA is the one who manages the complete database management system. 2. DBA takes care of the security of the DBMS, managing the license keys, managing user accounts and access etc. |
|
| 20. |
What is the difference between Hierarchical and Network data model? |
|
Answer» Network database model is an extended form of hierarchical data model. The difference between hierarchical and Network data model is : 1. In hierarchical model, a child record has only one parent node, 2. In a Network model, a child may have many parent nodes. It represents the data in manyto-many relationships. 3. This model is easier and faster to access the data. |
|
| 21. |
List some examples of RDBMS? |
|
Answer» SQL server, Oracle, mysql, MariaDB, SQLite. |
|
| 22. |
Mention few examples of a database? |
|
Answer» Examples of popular DBMS: Dbase, FoxPro |
|
| 23. |
Write a note on different types of DBMS users? |
|
Answer» Types of DBMS Users (i) Database Administrator: Database Administrator or DBA is the one who manages the complete database management system. DBA takes care of the security of the DBMS, managing the license keys, managing user accounts and access etc. (ii) Application Programmers or Software Developers: This user group is involved in developing and designing the parts of DBMS. (iii) End User: End users are the one who store, retrieve, update and delete data. (iv) Database designers: are responsible for identifying the data to be stored in the database for choosing appropriate structures to represent and store the data. |
|
| 24. |
What is the difference between Select and Project command? |
|
Answer» Select: THE SELECT operation is used for selecting a subset with tuples according to a given condition. Select filters out all tuples that do not satisfy C. Project: The projection eliminates all attributes of the input relation but those mentioned in the projection list. The projection method defines a relation that contains a vertical subset of Relation. |
|
| 25. |
Find the wrongly matched pair.(a) Entities – Rectangle(b) Ellipse – attributes(c) Diamond – relationship(d) row – square |
|
Answer» (d) row – square |
|
| 26. |
Find the wrong statement about DBMS?(a) segregation of application program(b) Maximum data Redundancy(c) Easy retrieval of data(d) Reduced development time |
|
Answer» (b) Maximum data Redundancy |
|
| 27. |
Which is the language used to write commands to access, insert, update data stored in database?(a) DataBase Access Languages (b) Javascript (c) Basic (d) Foxpro |
|
Answer» (a) DataBase Access Languages |
|
| 28. |
Find the wrong pair(a) Union U(b) cartesian product P(c) project n(d) select o |
|
Answer» (b) cartesian product P |
|
| 29. |
………… is a procedural query language used to query the database tables using SQL |
|
Answer» Relational Algebra |
|