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

Will the writetext statement activate a trigger?

1 1175

Other than truncate statement, which other command can by-pass the trigger on the tables?

1 1233

Is it important for a database administrator to understand the operating system and file access?

1 1059

What is the fastest way to permanently delete a 1 million row table named customers?

1 1367

How do you rebuild an identity column?

1 1021

Define a cross join?

1 1106

Explain an incremental backup?

1 1078

How will you know when statistics on a table are obsolete?

1 1146

How you can find out if an index is useful to the optimizer?

1 1004

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

1 1079

What are statistics?

1 1079

Can a unique index be created on a column, which contains null?

1 993

How can a database be repaired?

1 1055

What are the differences between triggers and stored procedures?

1 1141

Where are full-text indexes stored?

1 1056

Un-Answered Questions { Databases }

Disadvantages of the indexes?

1218

what are all the common sql function? : Sql dba

1125

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1064

Equi join and non equi join is possible with sql server?

1126

What are the types of database explain each of them briefly?

1052

Have you used lexical parameters in reports?

When should you use an instead of trigger?

1042

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2046

How do I start sql server 2017?

1011

How to start an oracle instance?

1098

What are the different subsets of sql?

1646

How can we solve concurrency problems?

1120

How to connect php with different port numbers?

1180

What is acid mean in sql server?

1237

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1948

For More Un-Answered { Databases } Questions Click Here