What will happen if you query the emp table as shown below:

select empno, DISTINCT ename, Salary from emp;

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

In SQL Server, which of the following is not a control statement?

Which of the following is the syntax for creating an Index?

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 queries is valid?

You are using Visual Basic to retrieve class information from a Microsoft SQL Server database named ClassList. The database Resides on a server named Neptune. Which code fragment will create a connection to this data source?

When designing a database table, how do you avoid missing column values for non-primary key columns?

A company has the following departments: Marketing, Designing, production, Packing What will be the result of the following query? select * from table where department < 'marketing';

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?