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

Which of the following is not a valid SQL OPERATOR?

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

Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statements is correct with regard to this code?

Which of the following are aggregate functions in SQL?

What is the correct SQL syntax for selecting all the columns where the 'LastName' is alphabetically between (and including) 'Hansen' and 'Pettersen'?

You are creating an ASP.net application to enter timesheet data intuitively. Users will enter data using a DataGrid. You have added a button column to your DataGrid. The button column uses a custom button to allow users to initiate some calculations on the data in the grid. Which event does the DataGrid control raise when the custom button is clicked?

You are creating an ASP.NET application that will record each customer's entry. It is possible that thousands of entries could be posted at any given time. Your application will be hosted on twenty Web servers. As customers enter information into your application, maintaining state information will be important. This information should be stored securely and should be capable of being restored in the event that a Web server is restarted. Customers will enter data into three separate pages in your application. Which of the following methods of storing state information would best suit the situation?

You want to create a cookie object named 'CustomerAddress' of type 'CustomerInfo' to maintain address information of customers who buy products online. Which of the following code snippets should you use to create this cookie?

You are debugging a Visual Basic.NET application. You add a variable to the watch window. When Visual Basic enters break mode, the Value of the expression variable is ''''. What is the most likely cause of the problem?

You need to install an online parcel tracking application and its supporting assemblies so that the application and its assemblies can be uninstalled using the Add/Remove Programs Control Panel applet. What should you do?