RDBMS & SQL QUERIES

What is the full form of SQL?

• Sub Query Language

• Structured Query Language

• Saturated Query Language

• None of the above

What will be the degree and cardinality of the cartesian product of two tables if the degree of first table is 3 and second table is 5. The cardinality of first table is 10 and cardinality of second table is 6.

• Degree 15, Cardinality 16

• Degree 8 Cardinality 16

• Degree 8 Cardinality 60

• Degree 15 cardinality 60

Select DDL commands from among the options...

• SELECT

• ALTER

• DROP

• DELETE

Choose the correct query

• SELECT * FROM EMP WHERE NAME=NULL

• SELECT * FROM EMP WHERE NAME IS NULL;

• SELECT FROM EMP WHERE NAME IS NULL;

• SELECT *FROM EMP WHERE NAME IS 'NULL';

The restrictions or conditions applied on data are known as (a)  

The primary key of a table which is present in another table for referencing is known as (a)  

The command which changes the structure of a table is (a)  

Which query is incorrect?

• SELECT * FROM EMP WHERE CITY IN ('MUMBAI','DELHI','CHENNAI');

• SELECT * FROM EMP WHERE CITY NOT IN ('MUMBAI','DELHI','CHENNAI');

• SELECT * FROM EMP GROUP BY DEPT;

• ALL THE ABOVE

What will be the output?

SELECT ROUND(36.7894,2)

• 36.78

• 38.79

• 36.7

• 36

What will be the output?

SELECT TRUNCATE(36.5643,2);

• 36.56

• 36.57

• 36.5643

• 36