You have a table named 'employees', having the following structure.

empid int(4)

deptname varchar(50)

salary int(4)

And a view is created as follows:

create view viemployees as select * from employees

You want to insert a new row into the table having the following values:

empid=1010, deptname=HR, salary=10000.

Which of the following are the correct insert SQL queries?

Examine the data in the EMPLOYEES table given below: LAST_NAME DEPARTMENT_ID SALARY Allen 10 3000 Miller 20 1500 King 20 2200 Davis 30 5000 Which of the following sub-queries work?

Which of the following are not Database Models?

Which functions does the following SQL QUERY perform? DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)

You have a table named 'employees' with the following table structure: empid int(4) deptname varchar(50) salary int(4) The following select query is executed on this table: SELECT * FROM employees ORDER BY deptname DESC, salary DESC What will be the output of the above query?

Which edition of the SQL SERVER 2005 will best meet the following scenario? A company has an online shopping website named www.shoppingxyz.com. It also has to handle its line of business portion. Its main server supports 4 CPUs and a multi-core processor.

In regard to SQL Server Mirroring - A server instance can be a partner in some sessions and a witness in other sessions.

What does the Query Analyzer, or SQL Server Management Studio, tool do?

What is the role of a processadmin user?

Differential backups do what?

In this statement, 'SELECT * FROM employees e JOIN timesheets t ON t.employeeid = e.employeeid ', the JOIN term is the same as: