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

When should an artificial (or derived) primary key be used?

1 672

Give one method for transferring a table from one schema to another?

1 658

How many control files should you have?

1 650

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

1 687

What happens if the constraint name is left out of a constraint clause?

1 606

How do you prevent output from coming to the screen?

1 608

What is dump destination? What are bdump, cdump and udump?

1 654

When configuring sqlnet on the server what files must be set up?

1 721

I have applied the following commands: now what will happen, will the database will give an error / it will work?

1 634

What are the requirements of simple database?

1 636

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

1 652

What command is used to type files to the screen?

1 658

How can you find out how many users are currently logged into the database?

1 668

How can you determine if an index needs to be dropped and rebuilt?

1 629

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

1 743

Un-Answered Questions { Databases }

What is the current version of postgresql?

1170

Who proposed the relational model?

1027

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

what is schema? : Sql dba

1137

What is standby servers? Explain types of standby servers.

1075

What are the source of constraints?

1006

1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used? IBM 1. What is virtual dataset? 2. How do you handle reject link to a peek stage? 3. What is transaction table? 4. Which one is the efficient from the following? a. ODBC enterprise b. Oracle enterprise 5. How can you extract data from excel sheet? Do you know how to parameterize, this option? 6. Six pages of complex query I have, how do you simplify this query? 7. Difference between dataset and lookup file set?

1982

What is current version of mysql?

1071

How do I start sql server 2017?

1011

Do we need to rebuild index after truncate?

1129

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

1127

Why we use the openxml clause?

1072

How to start an oracle instance?

1099

what is collation? : Sql dba

1224

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2291

For More Un-Answered { Databases } Questions Click Here