Class 12
Information Technology (802)
351 questions available
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++)