Q.1
Which SQL keyword is used to sort the result-set?
Q.2
Which of the following group functions ignore NULL values?
Q.3
Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?
Q.4
Select the right statement to insert values to the student table.
Q.5
............. joins two or more tables based on a specified column value not equaling a specified column value in another table.
Q.6
In SQL, which command is used to change a table's storage characteristics?
Q.7
In SQL, which of the following is not a data definition language commands?
Q.8
Which of the following query finds the total rating of the sailors who have reserved boat "103"?
Q.9
The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs
Q.10
Which of the following is illegal?
Q.11
If a query involves NOT, AND, OR with no parenthesis
Q.12
Let the statement
SELECT column1 FROM myTable;
return 10 rows. The statement
SELECT ALL column1 FROM myTable;
will return
Q.13
Find the name of cities with all entries whose temperature is in the range of 71 and 89
Q.14
Which of the following query finds the names of the sailors who have reserved at least one boat?
Q.15
Which of the following query finds colors of boats reserved by "Dustin"?
Q.16
What does the following query find?
(SELECT DISTINCT r.sid
FROM boats b, reserves r
WHERE b.bid = r.bid
AND b.color = 'red')
MINUS
(SELECT DISTINCT r.sid
FROM boats b, reserves r
WHERE b.bid = r.bid
AND b.color = 'green')
Q.17
Which of the following query finds the name of the sailors who have reserved at least two boats?
Q.18
What is the full form of SQL?
Q.19
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Q.20
Which operator performs pattern matching?
0 h : 0 m : 1 s