Class 12

An attribute used in the GROUP BY clause must also appear:

How many times does the loop body execute? for(int count=3; count<=15; count = count + 3)

A SELECT query that finds no matching rows results in:

For String myString = "Computer Science"; what does myString.length() return?

Using arithmetic operators (like *, +, -) is allowed directly within a SELECT clause, e.g., Salary*1.1 AS New_Salary.

For String myString = "Computer Science"; what does myString.toUpperCase() return?

Boolean operators AND and OR can be used within a WHERE clause to combine multiple conditions.

For String myString = "Database System"; what does myString.length() return?

A nested (subquery) approach can always be rewritten using an equivalent JOIN-based query for these kinds of examples.

For String myString = "Database System"; what does myString.toUpperCase() return?

Write an SQL query to retrieve all information about the Teacher with Teacher_ID = 101.

For String myString = "Java Programming"; what does myString.length() return?

Write an SQL query to find the first and last names of all teachers earning more than 50000.

For String myString = "Java Programming"; what does myString.toUpperCase() return?

Write an SQL query to display Teacher_ID, First_Name, Last_Name and Dept_No of teachers who belong to department number 4 or 7.

Write an SQL query using a join to retrieve names of all teachers and the names/numbers of their respective departments.

Write an SQL query to retrieve the names of teachers working in the Chemistry department (using a join).

Write an SQL query using table aliases T (Teacher) and D (Department) to retrieve names of teachers in the Hindi department.

Write an SQL query to list distinct department numbers having male teachers.

Write an SQL query to retrieve names of teachers whose first name starts with the letter 'S'.