Database Questions

• A data dictionary is a special file that contains
• We Can still delete a row from primary table if there are related rows in secondary table once a refferential integrity is enforced
• A subset of the database which contain virtual data that is derived from the database files but is not explicitly stored is called
• Database is a collection of concepts that can be used to describe the structure of a database
• Representation level data models provide the concepts that are close to the way many users perceive data
• Physical data models describe the details of how data is stored in the computers
• What is schema?
• The capacity to change the conceptual schema without having to change external schemas or application programs is called
• What are different types of DBMS?
• The no of entities participating in a relation is called
• The relationship where both the participating entities belong to same entity type is called
• Which among the following is the relationship constraints
• Which among the following is the disadvantage of circular list?
• The time complexity of sequential search is
• If you are using C language to implement the heterogeneous linked list, what pointer type will you use?
• Does the minimum spanning tree of a graph give the shortest distance between any 2 specified nodes?
• Which of the following products implemented the CODASYL DBTG model?
• Which of the following indicates the maximum number of entities that can be involved in a relationship?
• A reason for using an SQL view to hide columns is:
• Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?