Refine
All questions
351 resultsIn the LIKE clause, which wildcard character replaces zero or more characters?
Show answer
Evaluate the Java logical expression: !(2 > 6)
Show answer
Which pattern matches first names having exactly 6 characters and starting with 'S'?
Show answer
Evaluate the Java logical expression: (4 == 4) && (5 != 5)
Show answer
Which clause is used to sort the result of a SELECT query?
Show answer
Evaluate the Java logical expression: (4 == 4) || (5 != 5)
Show answer
Which keywords are used to test for NULL values in SQL?
Show answer
How many times does the loop body execute? for(int count=1; count<=5; count++)
Show answer
A query written inside another query's WHERE clause is called a:
Show answer
How many times does the loop body execute? for(int count=1; count<10; count++)
Show answer
Which of the following is NOT one of the standard SQL aggregate functions?
Show answer
How many times does the loop body execute? for(int count=0; count<5; count++)
Show answer
Which aggregate function returns the number of tuples in the result of a query?
Show answer
How many times does the loop body execute? for(int count=2; count<=20; count = count + 2)
Show answer
What is the difference between COUNT(Salary) and COUNT(*)?
Show answer
How many times does the loop body execute? for(int count=5; count>=1; count--)
Show answer
Which clause is used to group rows sharing a common value in one or more columns, typically with an aggregate function?
Show answer
How many times does the loop body execute? for(int count=10; count>1; count--)
Show answer
Which clause is used to filter groups AFTER a GROUP BY has been applied (as opposed to filtering individual rows)?
Show answer
How many times does the loop body execute? for(int count=1; count<=7; count++)