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,

1444

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 3083

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 2505

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,

1349

how to find 6th highest salary

Chetak Logistics,

1528

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

1581

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

Accenture,

1805

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

1442

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

1 2398

what are sequences

1744

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

1269

how to hide the stored procedure inside a package

1 2116

Explain few examples of stored procedure over triggers?

ADITI,

1041

What are the different types of backups that exist?

ADITI,

1167

What can be used instead of trigger?

ADITI,

1156

Un-Answered Questions { Databases }

What is a field in a table?

1040

How do you optimize a stored procedure in sql?

957

Briefly explain what is literal? Give an example where it can be used?

1039

What are the types of database engines available in mysql?

1041

How to display a past time in days, hours and minutes?

1016

How do I switch users in mysql?

969

Can we delete column in sql?

1099

Explain various On-Delete options in a DB table. Which is the default option?

1466

How to convert numeric values to integers in ms sql server?

1092

What is inner join in mysql?

910

What is ASM (Automatic Storage Management) in Oracle?

1196

1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?

1783

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2222

Is sql server a database?

995

How to return the second 5 rows in ms sql server?

1058

For More Un-Answered { Databases } Questions Click Here