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

Oracle (3253)
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 4866

What is the difference between CHAR and VARCHAR data types?

Ramco,

2 9044

Give the syntax of REVOKE commands?

1 4554

Give the syntax of GRANT commands?

3 6576

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

3 9018

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

4 8743

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 8319

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

CarrizalSoft Technologies, Sonata,

7 11556

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 6659

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 5560

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 4576

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 4264

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

8 13583

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 22849

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 4081

Un-Answered Questions { Databases }

What is temporary table in sql server? Why we use temp table?

1008

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

1117

Can sql servers link to other servers like oracle?

910

Design database draw er diagram for a certain scenario ?

4645

how to start mysql server? : Sql dba

1258

What is a view in sql?

1035

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2174

How do I remove duplicates in two columns?

1177

Equi join and non equi join is possible with sql server?

1125

How can we solve concurrency problems?

1116

What is subquery? Explain the properties of a subquery?

1055

How did mongodb get its name?

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1841

How raid can influence database performance?

1108

Does view occupy space?

1005

For More Un-Answered { Databases } Questions Click Here