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

2230

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 5463

In join, which clause in not used?

HCL, NIIT, TCS,

4 13082

can we call a procedure from a function?

Mind Tree,

9 20549

how many instance use in sql server 2005

EFI, HCL,

4 12469

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

ABC,

1 5970

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

Exilant,

1 11955

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

2 9053

Un-Answered Questions { Databases }

Is microsoft getting rid of access?

877

What is clustered index

1069

What is in place upgrade in sql server?

1113

do you know how to configure db2 side of the application? : Sql server database administration

1106

Can sql servers link to other servers like oracle?

900

What are the advantages of database?

1003

Were you involved in any data conversion, which one?

How to start an oracle instance?

1086

What are different types of constraints?

981

What is acid mean in sql server?

1218

When should you use an instead of trigger?

1033

What is subquery? Explain the properties of a subquery?

1046

What is the difference between for xml raw and for xml auto?

1095

Is there some bulk load or other way to import a lot of data fast?

923

1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used? IBM 1. What is virtual dataset? 2. How do you handle reject link to a peek stage? 3. What is transaction table? 4. Which one is the efficient from the following? a. ODBC enterprise b. Oracle enterprise 5. How can you extract data from excel sheet? Do you know how to parameterize, this option? 6. Six pages of complex query I have, how do you simplify this query? 7. Difference between dataset and lookup file set?

1959

For More Un-Answered { Databases } Questions Click Here