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

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

FIS,

1392

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 3012

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 2438

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,

1306

how to find 6th highest salary

Chetak Logistics,

1492

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

1547

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

Accenture,

1752

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

1401

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

1 2286

what are sequences

1675

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

1232

how to hide the stored procedure inside a package

1 2042

Explain few examples of stored procedure over triggers?

ADITI,

976

What are the different types of backups that exist?

ADITI,

1123

What can be used instead of trigger?

ADITI,

1113

Un-Answered Questions { Databases }

Explain the primary key?

752

How to pipe multiline string to isql?

979

What is the quickest way to export a table to a flat file?

934

Mention what are the file storage options provided by oracle database for oracle rac?

what are constraints? : Sql server database administration

1004

How does one use sql*loader to load images, sound clips and documents? : aql loader

1139

how would you check that a given index is consistent and has no corruption? If corruption occurred on a database what would your process be?

102

What is the Cdc?

670

What is the best free database?

870

Where is sql database stored?

939

What is cursor in pl sql?

1075

You want to delete a table in sybase. How would you do it?

812

Can we use views in stored procedure?

994

What is third normal form?

885

What are the uses of merge?

1130

For More Un-Answered { Databases } Questions Click Here