How you will generate a report with minimum network traffic?

You are developing a website that has four layers. The layers are user interface (web pages), business objects, data objects, and database. You want to pass data from the database to controls on a web form. What should you do?

Which of the following is not a valid character datatype in SQL Server?

Which of the following statements about SQL Server comments is false?

Which of the following are not date parts?

Which one of the following must be specified in every DELETE statement?

Which of the following objects is required by the Dataset to retrieve data from a database and to save updated data back to the database?

Examine the description of the STUDENTS table: STD_ID INT COURSE_ID VARCHAR (10) START_DATE DATETIME END_DATE DATETIME The aggregate functions valid on the START_DATE column are:

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?

What is wrong with the following query? select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)

Consider the following queries: 1. select * from employee where department LIKE '[^F-M]%'; 2. Select * from employee where department = '[^F-M]%'; Select the correct option: