Question: Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools. A. Cross-tabs B. Snapshot C.…

Question: Thus a _______ of course data gives the values of all attributes, such as title anddepartment, of all courses at a particular point in time. A. Instance B. Snapshot C. Both Instance and Snapshot D. All of the mentioned…

Question: Which of the following gives a logical structure of the database graphically? A. Entity-relationship diagram B. Entity diagram C. Database diagram D. Architectural representation Answer» a. Entity-relationship diagram Note: The above multiple-choice question is for all general and Competitive…

Question: _____________ can help us detect poor E-R design. A. Database Design Process B. E-R Design Process C. Relational scheme D. Functional dependencies Answer» d. Functional dependencies Note: The above multiple-choice question is for all general and Competitive Exams in…

Question: Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here theonly functional dependencies are from dept name to the other attributes. This relation is in A. Fourth NF B. BCNF C. Third NF D. Second…

Question: Which of the following is example of Object based logical model ? A. Relational Model B. Hierarchical Model C. Network Model D. Entity Relationship Model Answer» d. Entity Relationship Model Note: The above multiple-choice question is for all general…

Question: Which of the following has each related entity set has its own schema and there is anadditional schema for the relationship set. A. A many-to-many relationship set B. A multivalued attribute of an entity set C. A one-to-many relationship…

Question: Data Model is collection of conceptual tools for describing – A. Data B. All of these C. Data Schema D. Consistency Constaints Answer» b. All of these Note: The above multiple-choice question is for all general and Competitive Exams…

Question: Designers use which of the following to tune the performance of systems to support timecritical operations? A. Denormalization B. Redundant optimization C. Optimization D. Realization Answer» a. Denormalization Note: The above multiple-choice question is for all general and Competitive…

Question: In the schema (dept name, size) we have relations total inst 2007, total inst 200Q:8) Whichdependency have lead to this relation ? A. Dept name, year->size B. Year->size C. Dept name->size D. Size->year Answer» a. Dept name, year->size Note:…