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

Explain hostprotectionattribute in sql server 2005?

1028

What is exclusive locks?

957

What is update locks?

887

Determine when an index is appropriate?

1076

Can you explain important index characteristics?

992

Explain the purpose of indexes?

976

Explain full-text indexing?

983

Do you know clustered and non-clustered index?

979

Explain the difference between clustered and non-clustered index?

923

Explain having clause and where clause?

1055

Explain indexes disadvantages?

1085

Explain what is it unwise to create wide clustered index keys?

978

Ms sql server index?

1063

Do you know what is fill factor and pad index?

1004

How to maintain a fill factor in existing indexes?

1006

Un-Answered Questions { Databases }

Who are naive users?

1001

What is cis and how can I use it?

1076

Do you know the cursor optimization tips?

985

How set mysql root password?

916

what is meant by nl2br()? : Sql dba

1044

What is a procedure in oracle?

1197

Why I am getting this error when dropping a database in ms sql server?

1072

What are ddl statements in mysql?

1059

what is uncommittable transactions? : Transact sql

996

What are primary key and foreign key and how they work?

977

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

2650

How many databases can sql express handle?

984

how many sql dml commands are supported by 'mysql'? : Sql dba

1122

Why truncate is used in sql?

1005

What is an application role and explain a scenario when you would use one?

1012

For More Un-Answered { Databases } Questions Click Here