Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

What is the use of indexing table?

2 5368

what is the difference between MyIsam and InnoDb engine?

2 5522

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 7066

What are the steps need to be take improve the speed of a SQLDATA Server?

IBM,

2 4267

What is sqlcode -923 ?

1 9680

candidate key is subset of super key but not vice-verse explain

1579

can u give guidance abt packages of plsql

Mphasis,

1646

what is the disadvantage of SQL Loder?

TCS,

1 6094

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

TCS,

7 9939

"primary key=unique+null" is equal,reson?not,reason?

5 5466

How to define a cusotmer as a supplier in ORACLE R12

Intelligroup,

1726

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

Intelligroup,

1705

what is difference between Enterprise Manager and Query Analyer

CTS,

6 7749

what is shared memory?

IBM,

1 3475

what is semphore explian it?

IBM,

2247

Un-Answered Questions { Databases }

What are the protection features in ms access?

492

What is logical replication in postgresql?

509

What is sql in dbms?

512

what are isolation levels? : Sql server database administration

497

What is the difference between getdate and sysdatetime?

535

What is the difference between mysql and mysqli?

582

what is sub-query? : Transact sql

599

How to convert a date to char in oracle? Give one example.

589

Differentiate between truncate vs delete in mssql?

528

How to bring a tablespace online?

518

How do you pronounce sql?

551

What is the innodb in mysql?

508

What are the constraints in odi?

321

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

280

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

1827

For More Un-Answered { Databases } Questions Click Here