| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| SQL stops working in every 15 days displaying message that
database log file is full. Log file size is 3.95 GB. It is
happening after shrinking the database also. What is
solution to overcome this problem. Please help me as it's
urgent. | | 4 |
| I need a query that retrieves info from an Oracle table and
a query that retrieves info from a SQL Server table. The
info has to be joined together according to Record ID
numbers. I have very limited access to the Oracle database
but full control of the SQL Server database.How do I join
two different queries from two different databases?
| | 1 |
| what is IDE,DMV in sql server? | Value-Labs | 1 |
| Hi..here i would like to know the Backup and Restore models? | HCL | 2 |
| How to select nth record from a table? | DELL | 9 |
| What command do we use to rename a db? | | 3 |
| Which virtual table does a trigger use? | | 3 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| How to list all tables having unique constraints in any of
the columns in a database. | | 1 |
| difference between sql server2000 and sql server2005
| KPMG | 1 |
| Can Having clause be used without Group by clause? | CTS | 3 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | | 2 |
| how to find out the repeated value from table using groupby
function? | | 3 |
| Following are some of the question related to below
mentioned query?
select e1.salary from employee3 e1
where 2=
(
select count(distinct(e2.salary))
from employee3 e2 where e2.salary>=e1.salary
)
1) What the query returns?
2) How it works? - Detail explanation (what the sub query
does, why it is (where 2=)....etc...Please?
| | 3 |
| What's the difference between a primary key and a unique key? | Wipro | 8 |
| Can you tell me the difference between DELETE & TRUNCATE
commands? | | 11 |
| Which virtual table does a trigger use? | TCS | 5 |
| WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER? | | 6 |
| how will u create "n" possible tables in sql...
| Oracle | 1 |
| Is it possible to allow NULL values in foreign key?
I s it possible to use different constraints for the same
column in the table
(i.e) (id int NOT NULL,UNIQUEUE) | | 1 |
| |
| For more SQL Server Interview Questions Click Here |