×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
In MySQL, the CURRENT_USER() function returns the ______________________________________.
2.
In MySQL, which of the following keywords is used to eliminate duplicate rows from the result set?
3.
In MySQL, which of the following keywords is used to add rows to a table?
4.
In MySQL, which of the following built-in functions gives the current time?
5.
In MySQL, which of the following is not an aggregate function?
6.
In MySQL, which of the following commands is used to concatenate strings?
7.
In MySQL, which of the following field types is used to hold a .jpg image?
8.
In MySQL, which of the following is not a property of transactions?
9.
In SQL, which of the following joins are used to retrieve records that are common between two tables?
10.
Based on the following tables, what is the output of the SQL query:
Table: PRODUCT1
| PID | NAME |
|---|---|
| 100 | Samsung |
| 200 | Nokia |
| 400 | LG |
Table: PRODUCT2
| SL No | PID | NAME |
|---|---|---|
| 1 | 200 | Sony |
| 2 | 300 | Microsoft |
| 3 | 400 | Apple |
SQL > SELECT PID FROM PRODUCT1 UNION ALL SELECT PID
FROM PRODUCT2 ORDER BY PID;