adplus-dvertising
frame-decoration

Question

The query given below will not give an error. Which one of the following has to be replaced to get the desired output?
Select ID, name, dept name, salary * 1.1 where instructor;

a.

Salary*1.1

b.

ID

c.

Where

d.

Instructor

Posted under SQL Server

Answer: (c).Where

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. The query given below will not give an error. Which one of the following has to be replaced to get the desired output?

Similar Questions

Discover Related MCQs

Q. To delete a database ___________ command is used.

Q. Which is a duplicate copy of a file program that is stored on a different storage media than the original location?

Q. _______________ joins are SQL server default.

Q. To alter a database ___________ command is used.

Q. The EXISTS keyword will be true if ____________

Q. Which of the following is an aggregate function?

Q. Which is the duplication of computer operations and routine backups to combat any unforeseen problems?

Q. The UNION SQL clause can be used with ____________

Q. Find all the tuples having temperature greater than ‘Paris’.

Q. Which of the following is not a class of constraint in SQL Server?

Q. Point out the correct statement.

Q. Which of the following constraint does not enforce uniqueness?

Q. Constraints can be applied on ___________

Q. Point out the wrong statement.

Q. Purpose of foreign key constraint in SQL Server is __________

Q. Which of the following is not a foreign key constraint?

Q. Which of the following foreign key constraint specifies that the deletion fails with an error?

Q. How many types of constraints are present in SQL Server?

Q. Which of the constraint can be enforced one per table?