SQL Server Interview Online Test


2
3
7
Statement will generate an error.
Create Index indexname On Employee (EmpID), What will be result of this Query?
Create a Clusterd index on EmpID Column of Employee Table.
Create a Non Clustered index on EmpID Column of Employee Table.
Create a Composite index On Employee table
Create a Unique Index on Employee Table.
Which of the following is not an aggregate function in SQL SERVER 2005?
MIN
MAX
AVG
COUNT
SUM
GROUP
What will happen when will execute the following SQL Query [Select ‘Customer’ + CustomerID FROM Tbl_Customer] CustomerID is an integer type Column in Tbl_Customer Table
The Query will generate Error
The Query Will generate Error and Can be Rewritten as Select ‘Customer’ + Convert(VACHAR,10, CustomerID) FROM Tbl_Customer
The SQL Server will use default conversion FROM Int to Varchar and will be executed successfully
The Query will be executed successfully
How many clustered indexes can be created on single table?
1
128
Up to number of columns in table
256
Which is not the type of JOIN in SQL SERVER 2005?
INNER
LEFT
CROSS
MULTIPLE
RIGHT
Which of the following is not a valid constraint in SQL SERVER?
DEFAULT
CHECK
DISTINCT
UNIQUE
_________ removes all rows from a table, but the table structure and its columns, constraints, indexes and so on remain. The counter used by an identity for new rows is reset to the seed for the column.
DELETE
TRUNCATE
DROP
ALTER
Choose the statement that best describes a composite index.
It physically sorts the rows in a table.
It contains multiple keys.
It logically sorts the rows in a table in both ascending and descending order.
It contains multiple columns in its key.
Omitting the WHERE clause from a TRUNCATE statement has which of the following effects?
The truncate statement will fail because there are no records to delete.
The truncate statement will prompt the user to enter criteria for the deletion
The truncate statement will fail because of syntax error.
The truncate statement will remove all records from the table.
In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed?
before the WHERE clause
before the FROM clause
after the ORDER BY clause
after the WHERE clause
What statement could you use in the WHERE clause to select all the rows in a table where no price is defined?
WHERE price <>NULL
WHERE price != 0
WHERE price IS NULL
WHERE price IS NOT NULL
Referential integrity refers to what?
The enforced uniqueness of a row in a table
The enforced uniqueness of a column in a table
Ensuring that a Foreign Key attribute cannot be NULL
The enforced synchronization of Primary Key and Foreign Key values
Where the first name is Bobby or Bobbi. Choose all that apply.
WHERE name = ‘Bobby’ or name = ‘Bobbi’
WHERE name LIKE ‘Bobb_’
WHERE name LIKE ‘Bobb[iy]’
Above all
How many non clustered indexes can be there on single table in SQL Server 2005?
1
Multiple
A ________________ is a special type of index that reorders the way records in the table are physically stored.
clustered index
non – clustered index
composite index
You are transferring records from one database to another through app server. You need to decide on appropriate method to do bulk insert operation to transfer the records. What should you do?
Ensure that the source database is Microsoft SQL Server and use SqlBulkCopy class.
Use OpenXML method of Microsoft SQL Server.
Pass the data as string in the Stored procedure and Create a temporary table and use cursors to insert rows
Perform an insert operation for each record in the source object and in a foreach loop.
Description:

Objective type MS SQL Server 2005 interview questions (Indexes, SQL Queries, Database Structure and Normalization) for Software Engineer, DBA Database Developer.

Discussion

Ihead Go

Found a site (http://www.iheadgo.com) that offers tons of practice exams for multiple subjects. They offer practice exams for almost anything possible. Check it out.
Checking out this site and looks interesting...a lot of different Exams TI.
http://www.iheadgo.com

27 days 4 hours 2 minutes ago

Thet Thet Mar

so nice question. Thanks a lot!

68 days 11 hours 54 minutes ago

Bhavani

good check for beginners

83 days 5 hours 28 minutes ago

Anuj Sharma

Nice questions but corrected 11 only :(

97 days 10 hours 41 minutes ago

C.Mogana

Its very useful thank you..

162 days 1 hours 14 minutes ago

asad malik

Good one... Maybe a little more complexity.
Cheers.

169 days 4 hours 37 minutes ago

Sirgwaje

good

218 days 54 minutes ago

Siva

Thanks.

278 days 11 hours 41 minutes ago

P.Bhagyalakshmi

its a good preperation

291 days 9 hours 57 minutes ago

navin

really good one.

1056 days 10 hours 24 minutes ago

Gurjinder Singh Brar
Director of Product – WizIQ.Com
User
2 Members Recommend
192 Followers

Your Facebook Friends on WizIQ

More Tests By Author

Microsoft.Net Framework, ASP.NET Interview
40 Questions | 20744 Attempts

Explore Similar Courses

Oracle SQL & PL/SQL Training

Price:$99

Batch Starting 25th Sept,2014