Computer Scienc...

What SQL structure is used to limit column values of a table ?

A clause in SQL allows you to rename a table or a column temporarily by giving another name known as alias. The renaming is a temporary change and the actual table name does not change in the database. Which of the following clauses, allows such option?

Consider the following EMP table and answer the question below.

Which of the following select statement should be executed if we need to display the average salary of employees who belong to grade "E4"?

MySQL is examples of

Consider the following SQL query to retrieve ecode of employees from STUDENT table, whose address contains 'MUMBAI':

SELECT ecode

FROM STUDENT

WHERE _________;

Which of the following is most suitable to complete the query?

 With SQL, how can you return the number of records in the "persons" table? 

The value of each NULL is __________.

If the increment is in thousand then what is the average Increment for the below-given SQL query?

SELECT AVG(Increment)  FROM Employee

Expansion of RDBMS is ________.

Which of the following is used to manage Data Base ?