30 DBMS MCQ Questions and Answer-DBMS Tutorial

Functional dependency is a relationship between or amongA. EntitiesB. RowsC. AttributesD. TablesAns : C Which functional dependency types is/are not present in the following dependencies?Empno -> EName, Salary, Deptno, DNameDeptNo -> DNameEmpNo -> DNameA. Full functional dependencyB. Partial functional dependencyC. Transitive functional dependencyD. Both B and CAns : B If one attribute is determinant of … Read more

151 DBMS MCQ Questions and Answer-DBMS Tutorial

This post includes the latest 151 questions and answers related to the database management system. Latest MCQ questions. A relational database consists of a collection ofa) Tablesb) Fieldsc) Recordsd) Keyse) none of these A __ in a table represents a relationship among a set of values.a) Columnb) Keyc) Rowd) Entrye) none of these b The … Read more

DBMS MCQ Questions and Answer Set-9


It Includes the latest DBMS MCQ Questions and Answer.SQL Online test questions and answers. 1.Evaluate the SQL statement: SELECT ROUND (TRUNC (MOD (1600, 10),-1), 2) FROM dual; What will be displayed? a) 0 b) 1 c) C.0.00 d) D.an error statement Ans A 2.Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about … Read more

DBMS MCQ Questions and Answer Set-4


1. Which of the following relational algebra operations do not require the participating tables to be union-compatible? (A) ) Union (B) Intersection (C) Difference (D) Join Ans: (D) 2. Which of the following is not a property of transactions? (A) Atomicity (B) Concurrency (C) Isolation (D) Durability Ans: (B) 3. Checkpoints are a part of … Read more

DBMS Assignment-Level-1


Create table Vendors as follows: Ven_id Ven_name Contact Street City Salary Dept_id 1 Ratna 9044670000 Rajiv Chowk Delhi 30000 A01 2 Anjali 9839780000 Vijay Nagar Kanpur 21000 A01 3 Rahul 9532890000 Model Town Delhi 35000 B02 4 Ankit 7522900000 Rajajipuram Lucknow 24500 C03 5 Sumit 7271000000 Ramadevi Kanpur 26000 B02 6 Kapil 7890120000 Mall Road … Read more