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

One table how may column and Primary key

3 5351

How to update salary of employees department wise?

6 15190

what are the methods using performance tunning in sql and pl/sql

2 6625

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

IBM, Loginworks, OFSS,

2 10655

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 7358

How do you use collections in procedure to return the resultset?

2238

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2265

Psudo colums

HP,

1 4559

how will you see when the database was started using sql prompt?

IBM,

2 6601

how to call forms in parametar forms

2 6093

how to create parameterised form in oracle 10g? and create another form from the value of the form? AND how to assign value to a parameter? sincerly your mamun

2 4881

How to get second highest salary from a table

3 7167

How can i retrieve the pseudoColumn values of a table in sybase? In oracle, we can get the same as 'ROWID'. Likewise in sybase which one is pseudo column?

1 6827

In TeraData We have 5 SQL queries, without using BTEQ how can we execute those queries?

CTS,

1 4825

If we execute an query in MLOAD it's ran successfully, my questions is after successfully ran MLOAD. In error tables we can see anything there! is it possible than what are they?

CTS,

3 6155

Un-Answered Questions { Databases }

What is cost in sql execution plan?

982

How to implement service broker?

1011

what is foreign key? : Sql dba

1048

What is inner join? Explain with an example?

1222

What is right join in sql?

1090

What are fact tables and dimension tables ? What is dimensional modeling and star schema design

890

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

984

How many types of cursor type are there?

1090

How to view existing indexes on an given table using sys.indexes?

1091

What is the difference between mongodb and redis database?

What is the difference between 10g OEM and 11g OEM?

965

What is the difference between db-lib and ct-lib in sybase?

832

Is a primary key unique?

991

Which rendering formats are affected by the pagesize properties?

144

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1024

For More Un-Answered { Databases } Questions Click Here