(A) identifying the owner entity type relevant to a given entity type
(B) whether the existence of an entity depends on it being related to another entity via the relationship type
(C) the role that a participating entity from the entity type plays in each relationship instance
(D) the constraints applicable in granting access to tables, columns and views in a database schema
Tag: Database Interview Questions
Identify the INCORRECT statement among the given?
(A) An entity may be an object with a physical existence like a car, a house or an Employee
(B) One cannot consider something which has conceptual existence like a course in a degree program as an entity
(C) Age can be considered as a single value attribute of a person
(D) An entity type describes the schema or intension for a set of entities which share the same structure
Identify the correct statement with respect to normalization?
(A) Normalization is a formal technique that can be used only at the starting phase of the database design
(B) Normalization can be used as a top-down standalone database design technique
(C) The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed
(D) The process of normalization through decomposition must achieve the dependency reservation property at any cost whereas the lossless join property is sometimes sacrificed
Identify the constraint that limits the values that can be placed in a column?
(A) NOT NULL
(B) CHECK
(C) FOREIGN KEY
(D) UNIQUE
A relation (from the relational database model) consists of a set of tuples, which implies that?
(A) all tuples in a relation must be distinct
(B) relational model supports multi-valued attributes whose values can be represented in sets
(C) for any two tuples, the values associated with all of their attributes may be the same
(D) all tuples in a particular relation may have different attributes
Which of the following is NOT a feature of Context DFD?
(A) one process (which represents the entire system)
(B) all sources/sinks (external entities)
(C) data flows linking the process to the sources and sinks (external entities)
(D) sub-processes (which explain and decomposed the major process into small processes)
Which one is the corrected way to implement M to M relation which designing data base?
(A) sing junction table with keys
(B) By splitting data into tables with PK and FK
(C) As a single table rarly as to tables with PK and FK
(D) By creating three tables and linking them through PK and FK
Given are the relations of student and Instructor, Which relational algebra operation could have been applied on the pair of relations Student and Instructor to obtain the above data?
(A) Instructor – Student
(B) Student ∩ Instructor
(C) Instructor ÷ Student
(D) Student – Instructor