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

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 10761

what operator performs pattern matching?

2 11810

Which command executes the contents of a specified file?

ABC, InfoMedia,

2 8170

Which command displays the SQL command in the SQL buffer, and then executes it?

TCS,

3 18917

Which system tables contain information on privileges granted and privileges obtained

1 7172

Which system table contains information on constraints on all the tables created?

2 7433

what command is used to create a table by copying the structure of another table?

7 15137

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 9875

What is the use of CASCADE CONSTRAINTS?

3 11448

What is the difference between join and union.

3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

27 181556

What is the difference between anonymous block and named blocks?

3 10794

What is user Account in Oracle database ?

2 4949

How will you enforce security using stored procedures ?

2 6042

What are the dictionary tables used to monitor a database spaces ?

2 8822

What are the responsibilities of a Database Administrator ?

3 8231

Un-Answered Questions { Databases }

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2335

What is the current version of postgresql?

1144

Why and when do stored procedure recompile?

1042

what is collation? : Sql dba

1211

How can I check that whether automatic statistic update is enabled or not?

1101

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?

1899

Are you familiar with user exits in reports?

Suppose database is running slow, what will you do?

2580

what are all the common sql function? : Sql dba

1113

How to select all columns of all rows from a table in oracle?

1107

how many tables will create when we create table, what are they? : Sql dba

1129

Can we rollback truncate?

1059

Can one drop a column from a table?

1075

what is the command syntax for inserting a document?

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?

1200

For More Un-Answered { Databases } Questions Click Here