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

10 DBMS MCQ Questions and Answer

Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?A.Null statusB.Data typeC.Default valueD.Data constraints Answer: Option C Which of the following is a correlated subquery?A.Uses the result of an inner query to determine the processing of an outer query.B.Uses … Read more

20 DBMS MCQ Questions and Answer

A collection of interrelated records is called a a) Databaseb) Spreadsheetc) Management information systemd) Text filee) None of these In a database, related fields are grouped to a) Fileb) Bankc) Menud) Data recorde) None of these Which of the following refers to the level of data abstraction that describes exactly how the data actually stored? … 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