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

DBMS MCQ Questions and Answer Set-13

1.  The EXISTS keyword will be true if: Any row in the subquery meets the condition only All rows in the subquery fail the condition only Both of these two conditions are met Neither of these two conditions is met Explanation: EXISTS keyword checks for existance of a condition. 2. How many tables may be … Read more

What is a Correlated subquery in SQL

In this tutorial, you will learn about the Oracle SQL correlated subquery, and also you will learn how to execute Oracle correlated subquery and differences between subquery and correlated Query. correlated subquery means that subquery depends on the outer query result i.e. the subquery which is depending on the outer query output is known as … Read more