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

How will u test the stroded procedures and functions? difference between SP and Triggers

TCS,

2 7927

how to genarate random numbers in oracle for particular row?

3 7876

What is use of oracle?

Satyam,

2 5602

what is difference b/w pravite procedures and public procedures?

Steria, Wipro, Zensar,

3 20408

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2573

explain the type of contraints

3 5539

Why do you want to join software field as you have done your BE in Electronics?

Cap Gemini, HCL,

2202

what is sql injection?

2 6086

i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash

2 10363

Can we passed multiple recordset(set of records) using a Stored Procedure

2 5534

cursor types? explain with example programs?

HP,

1 6042

<> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

ITC Infotech,

1 4971

what is the use of HASH, LIST partitions?

ITC Infotech,

1 5462

what is SCALAR Queries?

ITC Infotech,

2 7969

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2057

Un-Answered Questions { Databases }

What is truncate oracle?

1027

What is parallel hint?

1429

Compare join and subquery in performance?

1007

What is aws aurora postgres?

856

Can you please explain the difference between primary keys and foreign keys?

1177

what are the drivers in mysql? : Sql dba

1067

How to round a numeric value to a specific precision?

1126

what is a composite key ? : Sql dba

1103

What is 'cross join'? Or what is cartesian product?

925

query optmization techniques and quwry analyser+projects+ppts

2478

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1090

Explain the use of analyse option in exp command.

1207

How many ways we can retrieve the date in result set of mysql using php?

1177

How do I enable sql encryption?

1082

If a ‘movechunk’ fails, is it necessary to cleanup the partially moved docs?

For More Un-Answered { Databases } Questions Click Here