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

what the meaning of sql

8 14536

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

Target,

5 7414

Target,

6 8546

suppose there are two textfields t1,t2 in form and we have some value in textfield t1.now the question is that how can we copy the value of the t1 to textfield t2?

Oasis,

2 5473

Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL

1 3811

what is maximum size of temp db?

iSoft,

4 11871

What is a temp table? how to denote temp table?

Oracle,

4 12017

sequence of firing triggers for text-item is: 1)key_next_item, 2)when_validate_item, 3)post_text_item Now i change sequence of firing triggers like when_validate_item,key_next_item... Is it possible to change sequence? How?

ESS,

1 6313

what is Constraint? How many types of constraints in SQL ?

HCL, IBM, NIIT, Wipro,

38 89915

what r tyhe major differences between oracle 9i & 10g?

6 14509

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2193

How to write a script for upate the data in prod , i have 50000 row are there

TCS,

2 5474

Is primary key = unique key,not null? If yes,please explain IF No,please explain

Genpact,

8 18125

how to connect oracle in unix prompt?

Polaris,

4 12689

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2943

Un-Answered Questions { Databases }

What is integrity in sql?

1064

Is microsoft access pc only?

776

Can mongodb store files?

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3063

What is normalization? Explain its different types?

1108

How do you select unique values in sql?

1012

Explain the commit statement.

1171

How many levels of sp nesting are possible?

1037

What are joins, explain all types of joins?

2318

What jobs use sql?

989

What do you mean by field in sql?

1097

Can we use max in where clause?

945

List the various oracle database objects?

1070

Why we use sql profiler?

965

What are triggers and its uses?

1062

For More Un-Answered { Databases } Questions Click Here