Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

2183

We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?

3 5244

In join, which clause in not used?

HCL, NIIT, TCS,

4 12859

can we call a procedure from a function?

Mind Tree,

9 20249

how many instance use in sql server 2005

EFI, HCL,

4 12264

How we Resize table,temp table, database and log file size in SQL Server 2005

ABC,

1 5861

How to call a stored procedure inside a trigger? Give an example.

Exilant,

1 11872

How to call a trigger inside a stored procedure?Give an example.

2 8949

Un-Answered Questions { Databases }

Explain user defined views?

966

What happens to the current transaction if the session is killed?

989

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

2228

Why truncate is ddl command?

1067

What is the use of sqldataadapter?

975

To do safe backups what is the feature in mongodb that you can use?

Do we need to create index on primary key?

929

How to change the database engine in mysql?

995

You want to implement the one-to-many relationship while designing tables. How would you do it?

961

Explain how to use transactions efficiently : transact sql

981

What is the difference between SQL notification and SQL invalidation?

1191

How to show table structure mysql?

1009

How many types of triggers are there?

1065

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

914

Can group functions be mixed with non-group selection fields in ms sql server?

944

For More Un-Answered { Databases } Questions Click Here