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-12

1-Which statement would add a column CGPA to a table Student which is already created? ALTER TABLE Student ADD COLUMN (CGPA NUMBER(3,1)); ALTER TABLE Student CGPA NUMBER(3,1); ALTER TABLE Student ADD (CGPA NUMBER(3,1)); ALTER TABLE Student ADD CGPA NUMBER(3,1); 2- Which statement is TRUE regarding ALTER statement? ALTER TABLE cannot be used to remove a … Read more