1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

Difference between Triggers and Stored Procedure

Claimat, HCL, Protech, Silgate,

23 66786

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

 6 5584

scope of exception handling in plsql

Wipro,

4 11251

How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar

 3 6612

Explain 1st, 2nd, 3rd normalization form of data base

KH, Thermotech,

3 21800

What is different bet native dynamic sql and Dbms_Sql?

Thermotech,

4 14790

What is TNS File

Thermotech,

7 29244

What is flashback Query ? And Use ?

Thermotech,

4 7745

What is Trace File ?

Thermotech,

4 23937

What is forall Statement ?

Thermotech,

2 4938

Tell me New Feature of Oracle 10g?

Thermotech,

5 9383

Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)

Thermotech,

4 5822

how to find the second highest salary from emp table?

CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

211 320552

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

Deloitte, Ness Technologies,

5 13004

How to list all tables having unique constraints in any of the columns in a database.

 1 3874

Un-Answered Questions { Databases }

What are the types of schema?

394

How to enter date and time literals in ms sql server?

496

How many clustered indexes can be created on a table?

577

What is simple indexing method?

564

what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?

1879




How to include text values in sql statements?

575

What is data model in mongodb?

1

Why do we need mysql?

513

I am using the switchboard manager in ms access. I am getting an error message "there was an error executing this command." What could be wrong?

502

What is a table in a database?

563

what protocol both networks use? : Sql server database administration

524

How do I partition a table in sql server?

525

Is it possible to automate the ms access database through menu driven selections? If yes, how?

431

How do I start mysql in linux?

467

What is 4nf in normalization form?

552

For More Un-Answered { Databases } Questions Click Here