×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
What is the output for the following SQL query?
SQL > SELECT (10+20) AS ADDITION2.
Based on the following table, what is the output of the SQL query:
STUDENT
| ID | NAME | ADDRESS |
|---|---|---|
| 015 | Bob | 20 |
| 020 | Alice | 18 |
| 105 | Mike | 25 |
| 151 | Tara | NULL |
SQL > SELECT COUNT (ID) FROM STUDENT;3.
Which of these about primary key constraint is not true in SQL?
4.
Which of these about unique key constraint is not true in SQL?
5.
In SQL, which of the following joins are used to retrieve records that are common between two tables?
6.
Based on the following table, what is the output of the SQL query:
STUDENT
| ID | NAME | AGE |
|---|---|---|
| 01 | Bob | 20 |
| 02 | Mike | 18 |
| 03 | Alice | 25 |
| 04 | Ben | 30 |
| 05 | Mary | 29 |
SQL > SELECT ID FROM STUDENT WHERE AGE NOT BETWEEN 20 AND 30;7.
Which of the following commands is used to modify the structure of a table in SQL?
8.
Which SQL statement should be used to select rows containing a NULL value from the following table:
STUDENT
| ID | NAME | AGE |
|---|---|---|
| 01 | John | 20 |
| 02 | Alice | 18 |
| 03 | Bob | 25 |
| 04 | Ben | NULL |
9.
What is the output of the following SQL query:
SQL > SELECT 2*2 FROM DUAL;10.
Based on the following table, what is the output of the SQL query:
STUDENT
| ID | NAME | AGE |
|---|---|---|
| 01 | Mike | 20 |
| 02 | Alice | 18 |
| 03 | Bob | 25 |
| 04 | Mary | NULL |
SQL > SELECT NAME FROM STUDENT WHERE NAME LIKE 'M%' ORDER BY NAME;