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?

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 want to access data from the 'Customer' table in the database. You generate a DataSet named 'MyDataSet' by adding 'Customer' table to it. Which of the following statements should you use to load the data from the database into 'MyDataSet' which has been loaded with multiple tables, using a SqlDataAdapter named 'MyAdapter'

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';