List of interview based or generic questions of Database concepts/SQL Server
Please share with me if you have more on this subject.
Errors and ommisions are expected so please ingore
if you find any. also some question formation may be wrong if you come across let me
know. Lets go ahead with few
Do you have anything to
contribute here. YES! then mail me immediately at email@mahendar.com
For printer friendly version of this questionare Click here PRINT THIS PAGE
Data types with SQL server
|
|
OLAP? how it works with SQL
|
|
advantages of SQL 7.0 over 2000
|
|
What is DTS
|
|
explain recovery process in SQL server
|
|
What are database fine tuning parameters in SQL server
|
|
Explain about client server technology
|
|
We have a database of 7 lakh records or more, than how we can display so that the software
will give an optimum performance.
|
|
If we wantto insert 14 fields of information into 14 different tables is it possible? If yes,
how it can be done.
|
|
How to generate sequence in SQL server
|
|
How to make an access o records in a restricted manner.
|
|
How SQL server authentication is more secured than Windows NT.
|
|
OLAP concepts - where it makes difference on SQL 7.0 and SQL 2000
|
|
If a record with Identity column is deleted, is it possible to add a new record in its place.
|
|
Truncate a table means data will be lost, but structure of the table will be prevented in database. Is it TRUE?
|
|
If you drop a table then the structure of the table also dropped along with it. TRUE?
|
|
You cant delete a table; you can delete the data in a record wise manner. TRUE?
|
|
The difference between the truncate and delete is you can delete data at a stretch by using truncate
but cannot using delete. TRUE?
|
|
When you have truncated the table then all records will be lost. If you immediately insert a record
the row number will be "1". TRUE?
|
|
If you have clustered index on a column, then also you can assign a primary key to that coloumn. TRUE?
|
|
you are having row ID already. Why you are going for index.
|
|
How many non-clustered indexes can be allowed in a table.
|
|
Is is possible to drop a rule
|
|
What is difference between rule and check contraint.
|
|
How many types of keys are there? what is the importance of those Keys.
|
|
What is difference between primary key and unique key.
|
|
What is the primary key and candidate key and what are there advantages.
|
|
Is it possible to hide database.
|
|
What is the maximum size of a Row
|
|
What is the maximum numbers of rows and columns allowed on a table.
|
|
What is normalisation.
|
|
what is redundancy
|
|
What are the normalisation forms.
|
|
What is the difference between DBMS/RDBMS
|
|
What is replication? what are types of replication.
|
|
Differenc between SQL server 7.0 and SQL server 2000
|
|
What is SQL in SQL-Server and Oracle
|
|
what are different types of constraints
|
|
Is if possible to create a View without a base table.
|
|
Index is only the second object, which holds data in the database
|
|
What is join. how many types of joins are there.
|
|
Explain the difference between inner join and left outer join
|
|
how to make a copy of Table ( if you have table with some name X, is it possible to
creat a table with a name Y by usin the table X)
|
|
Is is possible to create trigger on multiple tables
|
|
Is is possible to create a single stored procedure on multiple tables
|
|
Write a stored procedure which takes Empid as input parameter and gives salary
as output value
|
|
Top
|
