Exams
Subjects
Classes
Home
Computer Science
List of top Computer Science Questions on SQL
Briefly explain about any two column constraints used in SQL.
Kerala Plus Two(Class 12) - 2026
Kerala Plus Two(Class 12)
Computer Science
SQL
Describe about any two DML commands of SQL.
Kerala Plus Two(Class 12) - 2026
Kerala Plus Two(Class 12)
Computer Science
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?
CUET (UG) - 2024
CUET (UG)
Computer Science
SQL
Which SQL expression calculates the square root of 16?
CUET (UG) - 2024
CUET (UG)
Computer Science
SQL
What is the result of the following arithmetic operation in SQL: SELECT 5 + NULL AS RESULT?
CUET (UG) - 2024
CUET (UG)
Computer Science
SQL
Which of the following is correct syntax for inserting foreign key constraint in a relation?
CUET (UG) - 2024
CUET (UG)
Computer Science
SQL
Consider the following SQL functions:
(A) CURDATE()
(B) CURRENT DATE()
(C) CURRENT DATE
(D) TODAY()
CUET (UG) - 2024
CUET (UG)
Computer Science
SQL
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;
CUET (UG) - 2024
CUET (UG)
Computer Science
SQL
SQL applies conditions on the groups through ________ clause after groups have been formed?
CUET (UG) - 2024
CUET (UG)
Computer Science
SQL
What is the output of the SQL statement?
SELECT MID('CUET2024',2,5)?
CUET (UG) - 2024
CUET (UG)
Computer Science
SQL
In SQL, which of the following constraint means that no two values in any column should be the same?
CUET (UG) - 2023
CUET (UG)
Computer Science
SQL
SQL applies conditions on the groups through which clause after groups have been formed?
CUET (UG) - 2023
CUET (UG)
Computer Science
SQL
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;} \]
CUET (UG) - 2023
CUET (UG)
Computer Science
SQL
Which of the following is not an aggregate function?
CUET (UG) - 2023
CUET (UG)
Computer Science
SQL
What is the output of the following SQL query?
\[ \text{mysql} \,>\, \text{SELECT RIGHT("PRAYGRAJ", 3);} \]
CUET (UG) - 2023
CUET (UG)
Computer Science
SQL
Before the usage of .................. table command to add a primary key, one needs to make sure that the field is ...........
CUET (UG) - 2023
CUET (UG)
Computer Science
SQL