Class 11

Write an SQL query to display PrName and UnitPrice of products whose manufacturer name starts with 'A' from table GYM.

Which logical operator returns true only if BOTH connected conditions are true?

Write an SQL query to display PrName and UnitPrice of products whose name contains the word 'Exerciser' from table GYM.

Which method converts a String value to an int in Java?

Write an SQL query to display Name and cost of shoes with size greater than 8 from table Shoes.

Which method converts an integer value to a String in Java?

Write an SQL query to display Name and cost of shoes with cost less than 2000 from table Shoes.

In the code: if(condition) { statementBlock1; } else { statementBlock2; } — what happens if the condition evaluates to false?

Write an SQL query to display Name and cost of shoes of type 'Sports' from table Shoes.

Curly braces {} are mandatory around a statement block in an if statement when:

Write an SQL query to display Name and cost of shoes with quantity in stock less than 10 from table Shoes.

A switch statement is generally preferred over multiple if/else-if statements when:

Write the SQL statement to display the structure of the table 'Shoes'.

In Java, a variable must be declared before it can be used.

Write the SQL statement to view the names of all tables in the currently selected database.

The float data type in Java occupies 8 bytes of memory.

Write the SQL statement to delete the table named 'Orders' from the database.

Object Oriented Programming allows wrapping of data and methods together into a single unit, known as data encapsulation.

Write the SQL statement to add a new column 'Games' of type VARCHAR(20) to the table 'Student'.

Inheritance in OOP allows a programmer to give a generic name to various methods or operators.