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

How do I debug a stored procedure in sql server?

1046

What action plan is preferred if sql server is not responding?

1047

How can I change procedure name in sql server?

989

How do I create a partition table in sql server?

1061

Can we add a cpu to sql server?

971

How optimize sql query with multiple joins in sql server?

845

What is a partition function in sql server?

1046

How do I view a stored procedure in sql server?

954

How do you delete duplicate records in sql server?

1012

How do I edit a stored procedure in sql server?

895

What is the maximum size of sql server database?

959

What is postgresql server?

951

How do I edit a procedure in sql server?

912

Where is trigger in sql server?

1004

Is mysql the same as sql server?

926

Un-Answered Questions { Databases }

which table keeps the locking information? : Sql server administration

1028

How to use "begin ... End" statement structures in ms sql server?

977

Explain in brief about Microsoft SQL server?

1027

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

971

How do I rename a column in postgresql?

852

how many triggers you can have on a table? : Sql server database administration

926

What does set rowcount do?

873

How to execute a stored program unit?

1019

Explain entity type?

952

How to list all tables in your schema?

999

What is federated tables in mysql?

872

Explain enable novalidate constraint.

1046

Does access use sql?

979

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1911

How to get help information from the server?

995

For More Un-Answered { Databases } Questions Click Here