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 5241

In join, which clause in not used?

HCL, NIIT, TCS,

4 12854

can we call a procedure from a function?

Mind Tree,

9 20241

how many instance use in sql server 2005

EFI, HCL,

4 12258

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

ABC,

1 5859

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

Exilant,

1 11869

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

2 8947

Un-Answered Questions { Databases }

Which storage engine is best in mysql?

952

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1098

Which is better varchar or nvarchar?

997

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

1068

How to define a procedure inside another procedure?

1024

What is abstracting periodical?

946

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1040

Is sql similar to python?

973

define sql delete statement ? : Sql dba

1018

how to reverse engineer views(how to load the data from views)?

552

issues involved in modeling and building data werahouses

1964

How do I add a database to sql?

1125

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2311

Does postgres create indexes for foreign keys?

898

Why would someone use a database?

921

For More Un-Answered { Databases } Questions Click Here