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

Why should one not prefix user stored procedures with ‘sp_’?

1 1127

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1 1065

What are the new data types are introduced in sql 2000?

1 972

List some of the rules that apply to creating and using a ‘view’

1 945

Explain active/passive and active/active cluster configurations?

1 1124

Can a database be shrunk with users active?

1 1223

How you can change a cross join into an inner join?

1 1057

How you can add messages to the nt event log from within a stored procedure?

1 1173

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1 1167

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1 1081

Can a rule be bound to any column of any data type?

1 1033

can an order by clause be used in a creation of a view?

1 1254

Define constraints and give an example of their use?

1 1112

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

1 1007

How can a user-defined datatype be created?

1 1057

Un-Answered Questions { Databases }

How to export data from database and import into another?

990

How many concurrent programs you have customized, can you name some of them?

How to put more than 1000 values into an oracle in clause?

1107

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1901

What is sql server query analyzer?

1122

define sql insert statement ? : Sql dba

1094

what are the advantages of sql ? : Sql dba

1136

Is microsoft getting rid of access?

881

How to convert character strings into numeric values?

1186

How to start an oracle instance?

1096

What are the two main functions of queries in databases?

1523

How do I find the sql server version?

1099

Who proposed the relational model?

1027

What is subquery? Explain the properties of a subquery?

1056

How did mongodb get its name?

For More Un-Answered { Databases } Questions Click Here