Home⇒ Computer Engineering⇒ Database management system
| 1-Dont try to cram or spend more time here just read it fast and cover syllabus then practice MCQ's cheptor of same topic to check your progress. . |
| 2-Wrong options are also given but dont concentrate there, Right answer is in bold format. |
| Q1 ⇒ Views are useful for _____ unwanted information, and for collecting together information from more than one relation into a single view. Hiding [other wrong options] [Discuss in forum] |
| Q2 ⇒ The User Work Area (UWA) is a set of Program variables declared in the host program to communicate the contents of individual records between Host program and DBMS [other wrong options] [Discuss in forum] |
| Q3 ⇒ Value that appears in one relation for a given set of attributes also appears for a certain set of attributes in another relation. Referential Integrity [other wrong options] [Discuss in forum] |
| Q4 ⇒ Manager&rsquos salary details are to be hidden from Employee Table. This Technique is called as External level Datahiding [other wrong options] [Discuss in forum] |
| Q5 ⇒ Referential integrity is directly related to Foreign key [other wrong options] [Discuss in forum] |
| Q6 ⇒ Tuple in relational algebra refers to: Row [other wrong options] [Discuss in forum] |
| Q7 ⇒ Which level of Abstraction describes what data are stored in the Database ? Logical level [other wrong options] [Discuss in forum] |
| Q8 ⇒ Data items stored as grouped items is: Record [other wrong options] [Discuss in forum] |
| Q9 ⇒ Employee (name, sex, salary, deptname) Consider the following SQL query Select deptname from Employee Where sex = ‘M’ group by deptname having avg (salary) > {select avg (salary) from Employee} Output Average salary of male employees in a department is more than average salary of the organization [other wrong options] [Discuss in forum] |
| Q10 ⇒ Who is more concerned about the conceptual level of the DBMS DBA [other wrong options] [Discuss in forum] |
| Q11 ⇒ Why do we go for Normalization of Data Bases? Avoid redundancy [other wrong options] [Discuss in forum] |
| Q12 ⇒ The Index consists of : None of the above [other wrong options] [Discuss in forum] |
| Q13 ⇒ Thoma’s-write rule is ______. Time stamp ordering protocol [other wrong options] [Discuss in forum] |
| Q14 ⇒ In an E-R diagram ellipses represents attributes [other wrong options] [Discuss in forum] |
| Q15 ⇒ Embedded pointers provide a secondary access path [other wrong options] [Discuss in forum] |
| Q16 ⇒ Third normal form is based on the concept of ______. Transitive Dependency [other wrong options] [Discuss in forum] |
| Q17 ⇒ Locking can be used for: All of the above [other wrong options] [Discuss in forum] |
| Q18 ⇒ An entry in a telephone book can be compared to a Record [other wrong options] [Discuss in forum] |
| Q19 ⇒ What is Granularity ? The size of data item [other wrong options] [Discuss in forum] |
| Q20 ⇒ A DBMS consists of application programs called : BPL [other wrong options] [Discuss in forum] |
| Or |