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 14483

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 7365

Target,

6 8485

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 5446

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

1 3792

what is maximum size of temp db?

iSoft,

4 11840

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

Oracle,

4 11985

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 6291

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

HCL, IBM, NIIT, Wipro,

38 89638

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

6 14447

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.

2179

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

TCS,

2 5446

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

Genpact,

8 18069

how to connect oracle in unix prompt?

Polaris,

4 12653

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.

2929

Un-Answered Questions { Databases }

How can you determine what protocol is being used for interconnect traffic?

explain pdq priority?

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1147

Can you tell any two advantages of stored procedures?

1058

How to display row numbers with the records?

1079

How do I change global variables in mysql?

903

Is sql port 1433 encrypted?

1023

What is the difference between nested table and varray?

1003

How many types of synonyms in Oracle?

1124

Explain foreign key in sql server?

1030

What are queries used for?

952

explain databases and sql server databases architecture? : Sql server database administration

961

What is the syntax and use of the coalesce function?

1173

How to experiment a data lock in oracle?

1056

What is oracle update statement with inner join ?

1059

For More Un-Answered { Databases } Questions Click Here