the same as blank for character

the same as 0 for integer and blank for character

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy%!

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');

How to select all data from student table starting the name from letter 'r'?%!

SELECT * FROM student WHERE name LIKE '%r%';

SELECT * FROM student WHERE name LIKE 'r%';

SELECT * FROM student WHERE name LIKE '%r%';

SELECT * FROM student WHERE name LIKE '%r';

SELECT * FROM student WHERE name LIKE '_r%';

The FROM SQL clause is used to...%!

specify range for search condition

specify what table we are selecting or deleting data FROM

specify range for search condition

Which of the following query finds the name of the sailors who have reserved at least two boats?%!

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid ‚Äö√¢‚Ä r2.bid

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(r1.bid) > r2.bid

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid r2.bid

Find the name of all cities with their temperature, humidity and countries.%!

SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

SELECT city, temperature, humidity, country FROM location;

SELECT weather.city, temperature, humidity, country FROM weather, location;

SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;

SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

*$_Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy?

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');

*/*_The FROM SQL clause is used to...?

specify range for search condition

specify what table we are selecting or deleting data FROM

specify range for search condition

*/*_Which of the following query finds the name of the sailors who have reserved at least two boats??

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid ‚Äö√¢‚Ä r2.bid

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(r1.bid) > r2.bid

SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid r2.bid

*/*_Find the name of all cities with their temperature, humidity and countries.?

SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

SELECT city, temperature, humidity, country FROM location;

SELECT weather.city, temperature, humidity, country FROM weather, location;

SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;

SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

*/*_How to select all data from student table starting the name from letter 'r'??

SELECT * FROM student WHERE name LIKE '%r%';

SELECT * FROM student WHERE name LIKE 'r%';

SELECT * FROM student WHERE name LIKE '%r%';

SELECT * FROM student WHERE name LIKE '%r';

SELECT * FROM student WHERE name LIKE '_r%';

%_What is the meaning of LIKE '%0%0%'_%

Feature has two 0's in it, at any position

_ If a query involves NOT, AND, OR with no parenthesis$?

NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.

NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.

NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.

AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.

The order of occurrence determines the order of evaluation.

_ Which of the SQL statements is correct?$?

SELECT Username, Password WHERE Username = 'user1'

SELECT Username AND Password FROM Users

SELECT Username, Password FROM Users

SELECT Username, Password WHERE Username = 'user1'

_ What does the following query find?(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'red')MINUS(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'green')$?

Find the sailor IDs of at least one sailor who have reserved red boats but not green boats

Find the sailor IDs of all sailors who have reserved red boats but not green boats

Find the sailor IDs of at least one sailor who have reserved red boats but not green boats

Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats

_ Find the names of the countries whose condition is sunny.$?

SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');

SELECT country FROM location WHERE condition = 'sunny';

SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');

SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');

SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny');

_ What SQL command can be used to add columns to a table?$?

ALTER TABLE TableName ADD COLUMN ColumnName

ALTER TABLE TableName ADD ColumnName

ALTER TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD ColumnName

MODIFY TABLE TableName ADD COLUMN ColumnName

_ Which of the following query is correct for using comparison operators in SQL?$?

SELECT name, course_name FROM student WHERE age>50 and WHERE age

SELECT name, course_name FROM student WHERE age>50 and

SELECT name, course_name FROM student WHERE age>50 and age

SELECT name, course_name FROM student WHERE age>50 and WHERE age

_ The HAVING clause does which of the following?$?

Acts like a WHERE clause but is used for rows rather than columns.

Acts EXACTLY like a WHERE clause.

Acts like a WHERE clause but is used for columns rather than groups.

Acts like a WHERE clause but is used for groups rather than rows.

Acts like a WHERE clause but is used for rows rather than columns.

_Find the temperature in increasing order of all cities$?

SELECT city, temperature FROM weather ORDER BY city;

SELECT city FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather;

SELECT city, temperature FROM weather ORDER BY temperature;

SELECT city, temperature FROM weather ORDER BY city;

_Which of the following is illegal?$?

SELECT SYSDATE - SYSDATE FROM DUAL;

SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;

SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;

81 + Mcqs in Sql Miscellaneous in Structured Query Language (SQL) Page 1 McqOptions

1.	NULL is%!
A.	the same as 0 for integer
B.	the same as blank for character
C.	the same as 0 for integer and blank for character
D.	not a value
Answer» E.

Discussion

2.	Which of the following is a valid SQL type?%!
A.	CHARACTER
B.	NUMERIC
C.	FLOAT
D.	All of the above
Answer» E.

Discussion

3.	Count function in SQL returns the number of%!
A.	values.
B.	distinct values.
C.	groups.
D.	columns.
Answer» B. distinct values.

Discussion

4.	'AS' clause is used in SQL for%!
A.	Selection operation.
B.	Rename operation.
C.	Join operation.
D.	Projection operation.
Answer» C. Join operation.

Discussion

5.	Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy%!
A.	SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');
B.	SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');
C.	SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');
D.	SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');
Answer» B. SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

Discussion

6.	How to select all data from student table starting the name from letter 'r'?%!
A.	SELECT * FROM student WHERE name LIKE 'r%';
B.	SELECT * FROM student WHERE name LIKE '%r%';
C.	SELECT * FROM student WHERE name LIKE '%r';
D.	SELECT * FROM student WHERE name LIKE '_r%';
Answer» B. SELECT * FROM student WHERE name LIKE '%r%';

Discussion

7.	What is an SQL virtual table that is constructed from other tables?%!
A.	view
B.	A relation
C.	Just another table
D.	Query results
Answer» B. A relation

Discussion

8.	The command to remove rows from a table 'CUSTOMER' is:%!
A.	DROP FROM CUSTOMER ...
B.	UPDATE FROM CUSTOMER ...
C.	REMOVE FROM CUSTOMER ...
D.	DELETE FROM CUSTOMER WHERE ...
Answer» E.

Discussion

9.	The SQL keyword(s) ________ is used with wildcards.%!
A.	NOT IN only
B.	LIKE only
C.	IN only
D.	IN and NOT IN
Answer» C. IN only

Discussion

10.	Which of the following do you need to consider when you make a table in SQL?%!
A.	Data types
B.	Primary keys
C.	Default values
D.	All of the above.
Answer» E.

Discussion

11.	The FROM SQL clause is used to...%!
A.	specify what table we are selecting or deleting data FROM
B.	specify range for search condition
C.	specify search condition
D.	None of these
Answer» B. specify range for search condition

Discussion

12.	Which of the following group functions ignore NULL values?%!
A.	MAX
B.	COUNT
C.	SUM
D.	All of the above
Answer» E.

Discussion

13.	Which of the following is a SQL aggregate function?%!
A.	LEFT
B.	AVG
C.	JOIN
D.	LEN
Answer» C. JOIN

Discussion

14.	Which of the following command makes the updates performed by the transaction permanent in the database?%!
A.	ROLLBACK
B.	COMMIT
C.	TRUNCATE
D.	DELETE
Answer» C. TRUNCATE

Discussion

15.	Which of the following query finds the name of the sailors who have reserved at least two boats?%!
A.	SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid ‚Äö√¢‚Ä r2.bid
B.	SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(r1.bid) > r2.bid
C.	SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid <> r2.bid
D.	All of these
Answer» D. All of these

Discussion

16.	Find the name of all cities with their temperature, humidity and countries.%!
A.	SELECT city, temperature, humidity, country FROM location;
B.	SELECT weather.city, temperature, humidity, country FROM weather, location;
C.	SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;
D.	SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;
Answer» D. SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

Discussion

17.	Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return%!
A.	less than 10 rows
B.	more than 10 rows
C.	exactly 10 rows
D.	None of these
Answer» D. None of these

Discussion

18.	*$_Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy?
A.	SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');
B.	SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');
C.	SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');
D.	SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');
Answer» B. SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

Discussion

19.	/_Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return?
A.	less than 10 rows
B.	more than 10 rows
C.	exactly 10 rows
D.	None of these
Answer» D. None of these

Discussion

20.	/_Which of the following group functions ignore NULL values??
A.	MAX
B.	COUNT
C.	SUM
D.	All of the above
Answer» E.

Discussion

21.	/_Which of the following is a SQL aggregate function??
A.	LEFT
B.	AVG
C.	JOIN
D.	LEN
Answer» C. JOIN

Discussion

22.	/_The FROM SQL clause is used to...?
A.	specify what table we are selecting or deleting data FROM
B.	specify range for search condition
C.	specify search condition
D.	None of these
Answer» B. specify range for search condition

Discussion

23.	/_Which of the following query finds the name of the sailors who have reserved at least two boats??
A.	SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid ‚Äö√¢‚Ä r2.bid
B.	SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(r1.bid) > r2.bid
C.	SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid <> r2.bid
D.	All of these
Answer» D. All of these

Discussion

24.	/_Find the name of all cities with their temperature, humidity and countries.?
A.	SELECT city, temperature, humidity, country FROM location;
B.	SELECT weather.city, temperature, humidity, country FROM weather, location;
C.	SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;
D.	SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;
Answer» D. SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

Discussion

25.	/_Which of the following command makes the updates performed by the transaction permanent in the database??
A.	ROLLBACK
B.	COMMIT
C.	TRUNCATE
D.	DELETE
Answer» C. TRUNCATE

Discussion

26.	/_In SQL, which command(s) is(are) used to change a table's storage characteristics??
A.	ALTER TABLE
B.	MODIFY TABLE
C.	CHANGE TABLE
D.	All of the above
Answer» B. MODIFY TABLE

Discussion

27.	/_What is an SQL virtual table that is constructed from other tables??
A.	view
B.	A relation
C.	Just another table
D.	Query results
Answer» B. A relation

Discussion

28.	/_The SQL keyword(s) ________ is used with wildcards.?
A.	NOT IN only
B.	LIKE only
C.	IN only
D.	IN and NOT IN
Answer» C. IN only

Discussion

29.	/_The command to remove rows from a table 'CUSTOMER' is:?
A.	DROP FROM CUSTOMER ...
B.	UPDATE FROM CUSTOMER ...
C.	REMOVE FROM CUSTOMER ...
D.	DELETE FROM CUSTOMER WHERE ...
Answer» E.

Discussion

30.	/_How to select all data from student table starting the name from letter 'r'??
A.	SELECT * FROM student WHERE name LIKE 'r%';
B.	SELECT * FROM student WHERE name LIKE '%r%';
C.	SELECT * FROM student WHERE name LIKE '%r';
D.	SELECT * FROM student WHERE name LIKE '_r%';
Answer» B. SELECT * FROM student WHERE name LIKE '%r%';

Discussion

31.	/_Which of the following do you need to consider when you make a table in SQL??
A.	Data types
B.	Primary keys
C.	Default values
D.	All of the above.
Answer» E.

Discussion

32.	%_What is the meaning of LIKE '%0%0%'_%
A.	Feature begins with two 0's
B.	Feature ends with two 0's
C.	Feature has more than two 0's
D.	Feature has two 0's in it, at any position
Answer» E.

Discussion

33.	_ In SQL, which command is used to change a table's storage characteristics?$?
A.	ALTER TABLE
B.	MODIFY TABLE
C.	CHANGE TABLE
D.	None of these
Answer» B. MODIFY TABLE

Discussion

34.	_ If a query involves NOT, AND, OR with no parenthesis$?
A.	NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.
B.	NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.
C.	AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.
D.	The order of occurrence determines the order of evaluation.
Answer» B. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.

Discussion

35.	_ The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;$?
A.	6789
B.	2345
C.	1234
D.	456789
Answer» C. 1234

Discussion

36.	_ Which of the following SQL commands is used to retrieve data?$?
A.	DELETE
B.	INSERT
C.	SELECT
D.	JOIN
Answer» D. JOIN

Discussion

37.	_ Which of the SQL statements is correct?$?
A.	SELECT Username AND Password FROM Users
B.	SELECT Username, Password FROM Users
C.	SELECT Username, Password WHERE Username = 'user1'
D.	None of these
Answer» C. SELECT Username, Password WHERE Username = 'user1'

Discussion

38.	_ What does the following query find?(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'red')MINUS(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'green')$?
A.	Find the sailor IDs of all sailors who have reserved red boats but not green boats
B.	Find the sailor IDs of at least one sailor who have reserved red boats but not green boats
C.	Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats
D.	None of These
Answer» B. Find the sailor IDs of at least one sailor who have reserved red boats but not green boats

Discussion

39.	_ Find the names of the countries whose condition is sunny.$?
A.	SELECT country FROM location WHERE condition = 'sunny';
B.	SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');
C.	SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');
D.	SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny');
Answer» C. SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');

Discussion

40.	_ Which of the following must be enclosed in double quotes?$?
A.	Dates
B.	Column Alias
C.	Strings
D.	All of the above
Answer» C. Strings

Discussion

41.	_ What operator tests column for the absence of data?$?
A.	EXISTS operator
B.	NOT operator
C.	IS NULL operator
D.	None of these
Answer» D. None of these

Discussion

42.	_ Which of the following is NOT a type of SQL constraint?$?
A.	PRIMARY KEY
B.	ALTERNATE KEY
C.	FOREIGN KEY
D.	UNIQUE
Answer» C. FOREIGN KEY

Discussion

43.	_ The command to eliminate a table from a database is:$?
A.	DROP TABLE CUSTOMER;
B.	DELETE TABLE CUSTOMER;
C.	REMOVE TABLE CUSTOMER;
D.	UPDATE TABLE CUSTOMER;
Answer» B. DELETE TABLE CUSTOMER;

Discussion

44.	_ What SQL command can be used to add columns to a table?$?
A.	ALTER TABLE TableName ADD ColumnName
B.	ALTER TABLE TableName ADD COLUMN ColumnName
C.	MODIFY TABLE TableName ADD ColumnName
D.	MODIFY TABLE TableName ADD COLUMN ColumnName
Answer» B. ALTER TABLE TableName ADD COLUMN ColumnName

Discussion

45.	_ Which of the following query is correct for using comparison operators in SQL?$?
A.	SELECT name, course_name FROM student WHERE age>50 and <80;
B.	SELECT name, course_name FROM student WHERE age>50 and age <80;
C.	SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;
D.	None of these
Answer» C. SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;

Discussion

46.	_ The HAVING clause does which of the following?$?
A.	Acts EXACTLY like a WHERE clause.
B.	Acts like a WHERE clause but is used for columns rather than groups.
C.	Acts like a WHERE clause but is used for groups rather than rows.
D.	Acts like a WHERE clause but is used for rows rather than columns.
Answer» D. Acts like a WHERE clause but is used for rows rather than columns.

Discussion

47.	_Find the temperature in increasing order of all cities$?
A.	SELECT city FROM weather ORDER BY temperature;
B.	SELECT city, temperature FROM weather;
C.	SELECT city, temperature FROM weather ORDER BY temperature;
D.	SELECT city, temperature FROM weather ORDER BY city;
Answer» D. SELECT city, temperature FROM weather ORDER BY city;

Discussion

48.	_............. joins two or more tables based on a specified column value not equaling a specified column value in another table.$?
A.	EQUIJOIN
B.	NON-EQUIJOIN
C.	OUTER JOIN
D.	NATURAL JOIN
Answer» C. OUTER JOIN

Discussion

49.	_Which of the following is illegal?$?
A.	SELECT SYSDATE - SYSDATE FROM DUAL;
B.	SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;
C.	SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;
D.	None of these
Answer» E.

Discussion

50.	_Which SQL keyword is used to sort the result-set?$?
A.	SORT BY
B.	ORDER
C.	ORDER BY
D.	SORT
Answer» D. SORT

Discussion

Explore topic-wise MCQs in Structured Query Language (SQL).

NULL is%!

Which of the following is a valid SQL type?%!

Count function in SQL returns the number of%!

'AS' clause is used in SQL for%!

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy%!

How to select all data from student table starting the name from letter 'r'?%!

What is an SQL virtual table that is constructed from other tables?%!

The command to remove rows from a table 'CUSTOMER' is:%!

The SQL keyword(s) ________ is used with wildcards.%!

Which of the following do you need to consider when you make a table in SQL?%!

The FROM SQL clause is used to...%!

Which of the following group functions ignore NULL values?%!

Which of the following is a SQL aggregate function?%!

Which of the following command makes the updates performed by the transaction permanent in the database?%!

Which of the following query finds the name of the sailors who have reserved at least two boats?%!

Find the name of all cities with their temperature, humidity and countries.%!

Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return%!

*$_Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy?

*/*_Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return?

*/*_Which of the following group functions ignore NULL values??

*/*_Which of the following is a SQL aggregate function??

*/*_The FROM SQL clause is used to...?

*/*_Which of the following query finds the name of the sailors who have reserved at least two boats??

*/*_Find the name of all cities with their temperature, humidity and countries.?

*/*_Which of the following command makes the updates performed by the transaction permanent in the database??

*/*_In SQL, which command(s) is(are) used to change a table's storage characteristics??

*/*_What is an SQL virtual table that is constructed from other tables??

*/*_The SQL keyword(s) ________ is used with wildcards.?

*/*_The command to remove rows from a table 'CUSTOMER' is:?

*/*_How to select all data from student table starting the name from letter 'r'??

*/*_Which of the following do you need to consider when you make a table in SQL??

%_What is the meaning of LIKE '%0%0%'_%

_ In SQL, which command is used to change a table's storage characteristics?$?

_ If a query involves NOT, AND, OR with no parenthesis$?

_ The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;$?

_ Which of the following SQL commands is used to retrieve data?$?

_ Which of the SQL statements is correct?$?

_ What does the following query find?(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'red')MINUS(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'green')$?

_ Find the names of the countries whose condition is sunny.$?

_ Which of the following must be enclosed in double quotes?$?

_ What operator tests column for the absence of data?$?

_ Which of the following is NOT a type of SQL constraint?$?

_ The command to eliminate a table from a database is:$?

_ What SQL command can be used to add columns to a table?$?

_ Which of the following query is correct for using comparison operators in SQL?$?

_ The HAVING clause does which of the following?$?

_Find the temperature in increasing order of all cities$?

_............. joins two or more tables based on a specified column value not equaling a specified column value in another table.$?

_Which of the following is illegal?$?

_Which SQL keyword is used to sort the result-set?$?

/_Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return?

/_Which of the following group functions ignore NULL values??

/_Which of the following is a SQL aggregate function??

/_The FROM SQL clause is used to...?

/_Which of the following query finds the name of the sailors who have reserved at least two boats??

/_Find the name of all cities with their temperature, humidity and countries.?

/_Which of the following command makes the updates performed by the transaction permanent in the database??

/_In SQL, which command(s) is(are) used to change a table's storage characteristics??

/_What is an SQL virtual table that is constructed from other tables??

/_The SQL keyword(s) ________ is used with wildcards.?

/_The command to remove rows from a table 'CUSTOMER' is:?

/_How to select all data from student table starting the name from letter 'r'??

/_Which of the following do you need to consider when you make a table in SQL??