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

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

Write short notes on XSU and JAVA

1 4742

What is the difference between CHAR and VARCHAR data types?

Ramco,

2 8881

Give the syntax of REVOKE commands?

1 4410

Give the syntax of GRANT commands?

3 6347

How many ways we can we find the current date using MySQL?

3 8866

What is the maximum length of a table name, a database name, or a field name in MySQL?

4 8550

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 7984

write down the code for "how we delete a table without using of Drop command " ?

CarrizalSoft Technologies, Sonata,

7 11270

Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.

3 6462

Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters

3 5375

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 4434

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 4169

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 13268

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 22248

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 3978

Un-Answered Questions { Databases }

What are subquery and its properties?

1049

What is maximum table size in mysql?

948

Is mongodb free for commercial use?

Does postgres automatically index primary key?

791

What is data types in mysql?

923

What are external procedures ? Why and when they are used?

846

What is database client?

1001

Do I need to pay for mysql?

898

Where mongodb data is stored?

Which dbms is best?

913

What is a initialization parameter file in oracle?

1035

Explain storage manager?

1038

Define Business Edition in SQL Azure?

100

What is procedure cache and data cache in sybase?

838

How to rename an existing column with sql server management studio?

999

For More Un-Answered { Databases } Questions Click Here