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

why we go for package? what are the advantages of using instead of seperate procuderes or functions

IBM, TCS,

3 10479

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

Cognizant,

7 14436

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4431

Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)

6 17436

what is the location of oracle inventory?

2122

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

Satyam,

2283

how fastest access of data can be done from database ?

3 5537

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

IBM,

2130

i had backup last manday.now i need back monday to now ..how do get backup?

Infozech, Wipro,

3 6272

now one user in online.now i want drop him..how do u drop him?

Wipro,

4 6777

What is nvl function?

Cap Gemini,

4 13295

what is 'force view'?

Cap Gemini, SPIC,

3 18550

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2167

5) Which acid property will effect when we use commit in trigger?

3 4556

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

IBM,

2215

Un-Answered Questions { Databases }

How to drop a stored function?

1193

How many types of normalization are there?

1025

Will mysql remain free?

1014

What are different types of collation sensitivity?

1034

What is a mysql server?

1037

What are the components of sql server service broker?

1081

What is the difference between local variables and global variables?

1189

What are the three main types of models?

956

Write a SQL command to insert and update only a particular field?

1197

What do you mean by erd and its main elements? Explain with example.

894

What is the difference between internal & external schema?

811

Can a foreign key be null?

1154

What are the tools available in market as an alternative to sql server reporting services?

138

What are the properties of primary key?

1028

Find nth lowest salary or get nth lowest salary?

1100

For More Un-Answered { Databases } Questions Click Here