adplus-dvertising
frame-decoration

Question

Which of the following fields are displayed as output for following query? 
Select * from employee where salary>10000 and dept_id=101;

a.

Salary, dept_id

b.

Employee

c.

Salary

d.

All the field of employee relation

Posted under SQL Server

Answer: (d).All the field of employee relation

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which of the following fields are displayed as output for following query?
Add Comment

Similar Questions

Discover Related MCQs

Q. To delete a database ___________ command is used.

View solution

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

View solution

Q. _______________ joins are SQL server default.

View solution

Q. To alter a database ___________ command is used.

View solution

Q. The EXISTS keyword will be true if ____________

View solution

Q. Which of the following is an aggregate function?

View solution

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

View solution

Q. The UNION SQL clause can be used with ____________

View solution

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

View solution

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

View solution

Q. Point out the correct statement.

View solution

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

View solution

Q. Constraints can be applied on ___________

View solution

Q. Point out the wrong statement.

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution
View All MCQs on SQL Server

Suggested Topics

Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...

CSS

Polish your web design skills with our CSS MCQs. Learn about selectors, properties,...

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

Visual Basic

Enhance your knowledge of Microsoft's event-driven programming language with our...

MySQL Database

Enhance your knowledge of relational databases with our MySQL MCQs. Understand...