MCQs > IT & Programming > ASP.NET With SQL Server MCQs > General MCQs

General MCQ for ASP.NET With SQL Server

1. The names of those departments where there are more than 100 employees have to be displayed. Given two relations, employees and departments, what query should be used? Employee --------- Empno Employeename Salary Deptno Department --------- Deptno Departname

2. Consider the query: SELECT name FROM Student WHERE name LIKE '_a%'; Which names will be displayed?

3. What is the order of precedence among the following operators? 1. IN 2. NOT 3. AND 4. OR

4. You want to display the titles of books that meet the following criteria: 1. Purchased before November 11, 2002 2. Price is less than $500 or greater than $900 You want to sort the result by the date of purchase, starting with the most recently bought book. Which of the following statements should you use?

5. A production house needs a report about the sale where total sale of the day is more than $20,000. Which query should be used?

6. Examine the query:- select (2/2/4) from tab1; where tab1 is a table with one row. This would give a result of:

7. Consider the following table structure of students: rollno int name varchar(20) course varchar(20) What will be the query to display the courses in which the number of students enrolled is more than 5?

8. Which one of the following correctly selects rows from the table myTable that have null in column column1?

ASP.NET With SQL Server MCQs | Topic-wise

MCQ on Basic ASP.NET with SQL Server General ASP.NET With SQL Server MCQs
Buy us a coffee
ASP.NET With SQL Server Subjects
Basic ASP.NET with SQL Server MCQs
More Resources
ASP.NET With SQL Server Skill Assessment
ASP.NET With SQL Server PDF
Related MCQs
Assembla
Assembly language
AWS Lambda
Bash
Bluetooth Technology
search
Buy us a coffee
ASP.NET With SQL Server Subjects
Basic ASP.NET with SQL Server MCQs
More Resources
ASP.NET With SQL Server MCQ
ASP.NET With SQL Server Skill Assessment
ASP.NET With SQL Server PDF
Related MCQs
Assembla
Assembly language
AWS Lambda
Bash
Bluetooth Technology
Logo

Join our newsletter for the latest updates.

play store app store
Coming Soon

Our Products

Skill Assessment
Categories
MCQs
PDFs
Buy us a coffee

Company

About
Advertising
Privacy Policy
Terms & Conditions
Sitemap
Contact
Blog
Back to top back to top
Logo
play store app store
Coming Soon
Buy us a coffee

© Copyrights 2025 Quizack.com