List of top Computer Science Questions on SQL

Briefly explain about any two column constraints used in SQL.

Describe about any two DML commands of SQL.

Amit wants to be familiar with SQL. One of his friends Anand suggests him to execute the following SQL commands:
(A) Create Table Student
(B) Use Database DB
(C) Select * from Student
(D) Insert into Student
In which order Amit needs to run the above commands?

Which SQL expression calculates the square root of 16?

What is the result of the following arithmetic operation in SQL: SELECT 5 + NULL AS RESULT?

Which of the following is correct syntax for inserting foreign key constraint in a relation?

Consider the following SQL functions:
(A) CURDATE()
(B) CURRENT DATE()
(C) CURRENT DATE
(D) TODAY()

Consider the following two tables emp1 and emp2:

emp1
Id	Name
1	Amit
2	Punita

emp2
Id	Name
1	Punita
2	Anand

What is the output of the following query?
SELECT name from emp1 minus SELECT name from emp2;

SQL applies conditions on the groups through ________ clause after groups have been formed?

What is the output of the SQL statement?
SELECT MID('CUET2024',2,5)?

In SQL, which of the following constraint means that no two values in any column should be the same?

SQL applies conditions on the groups through which clause after groups have been formed?

If column "Payment" contains the data set \{10000, 15000, 25000, 10000, 15000\}, what will be the output after the execution of the given query? \[ \text{SELECT SUM(DISTINCT PAYMENT) FROM EMPLOYEE;} \]

Which of the following is not an aggregate function?

What is the output of the following SQL query? \[ \text{mysql} \,>\, \text{SELECT RIGHT("PRAYGRAJ", 3);} \]

Before the usage of .................. table command to add a primary key, one needs to make sure that the field is ...........