SQL Server Interview Online Test


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

78 days 17 hours 39 minutes ago

Thet Thet Mar

so nice question. Thanks a lot!

120 days 1 hours 32 minutes ago

Bhavani

good check for beginners

134 days 19 hours 5 minutes ago

Anuj Sharma

Nice questions but corrected 11 only :(

149 days 18 minutes ago

C.Mogana

Its very useful thank you..

213 days 14 hours 52 minutes ago

asad malik

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

220 days 18 hours 15 minutes ago

Sirgwaje

good

269 days 14 hours 32 minutes ago

Siva

Thanks.

330 days 1 hours 19 minutes ago

P.Bhagyalakshmi

its a good preperation

342 days 23 hours 35 minutes ago

navin

really good one.

1108 days 1 minutes ago

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

Your Facebook Friends on WizIQ

More Tests By Author

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