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

Can you tell me how to add new column in existing views?how?How is possible?

FIS,

1519

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

IBM, Saama Tech,

1 3191

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from ; except this you can't use another select statement. You can use no of variables as per requirement.

1 2611

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

Infosys,

1398

how to find 6th highest salary

Chetak Logistics,

1591

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1635

difference of using cursor for loop and open,fetch,close.which one is better

Accenture,

1867

What are local and global Indexes and where they are useful.

1499

how are rank and dense rank being alloted for column with same values over a particular column

1 2498

what are sequences

1824

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1304

how to hide the stored procedure inside a package

1 2206

Explain few examples of stored procedure over triggers?

ADITI,

1122

What are the different types of backups that exist?

ADITI,

1230

What can be used instead of trigger?

ADITI,

1211

Un-Answered Questions { Databases }

List the ways in which dynamic sql can be executed?

1063

How do I add a column to a table in mysql?

972

How to do clean up if create database failed?

1073

What is the most important object in an access database?

789

Define views.

1074

How to create an oracle database manually?

1134

Discuss transparent DBMS?

1251

Explain what are the authentication modes in sql server?

1073

How to retrieve data from multiple collections in mongodb?

What is crud diagram?

996

What is sql select statement?

1090

How can you count the total number of records of any table?

983

Explain about sybase 365?

922

What is use of except clause?

1147

What is distributed queries?

1001

For More Un-Answered { Databases } Questions Click Here