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 5239

In join, which clause in not used?

HCL, NIIT, TCS,

4 12851

can we call a procedure from a function?

Mind Tree,

9 20238

how many instance use in sql server 2005

EFI, HCL,

4 12255

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

ABC,

1 5858

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

Exilant,

1 11864

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

2 8946

Un-Answered Questions { Databases }

What is Service Broker in sql server 2012?

1020

How to monitor firebird server activity?

969

How to turn off warning messages during php execution?

1044

What are drillthrough reports?

155

State about the security aspects of stored procedures?

976

How many types of segments in Oracle?

1070

Mention the command used to rename the database.

1005

What are mysql functions?

947

What are local and global Indexes and where they are useful.

1442

How do I know if localdb is running?

952

Explain about system database?

1062

How to start your 10g xe server?

1041

How can you access different databases temporarily?

What is normalization in database with example?

910

Explain how dts is used to extract, transform and consolidate data?

998

For More Un-Answered { Databases } Questions Click Here