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:

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?

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

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

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?

Which of the following queries is valid?

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?

How you will generate a report with minimum network traffic?

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

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

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