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 4755

What is the difference between CHAR and VARCHAR data types?

Ramco,

2 8891

Give the syntax of REVOKE commands?

1 4417

Give the syntax of GRANT commands?

3 6360

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

3 8882

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

4 8561

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 7997

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

CarrizalSoft Technologies, Sonata,

7 11294

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 6477

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 5383

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 4441

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 4173

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

8 13288

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 22293

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 3981

Un-Answered Questions { Databases }

What is Command line parameters in PLSQL.?

1133

How do I view blob data?

863

How to know, what indexes exist in a collection?

What is %type in pl sql?

972

What type of database is sql?

1032

Can I download microsoft access for free?

823

What are the new features of sql server 2008 r2 reporting service?

209

What are indexes in oracle?

1091

What are the 3 levels of data abstraction?

847

How much memory that we are using in Logshipping Concept?

1800

What is difference between temp table and cte?

1030

How to check database size in sybase iq?

988

Is sql a case sensitive language?

951

What is an oracle stored procedure?

1058

How to assign sql query results to pl sql variables?

1086

For More Un-Answered { Databases } Questions Click Here