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

How to find no of saturdays in a month using single sql ?

2 5803

How to create index-by table in oracle?

3 6723

What is Pointer ?

Cap Gemini, CarrizalSoft Technologies,

3 6788

what is call by value & call by reference ?

Cap Gemini,

2 13432

What is trigger ?

Cap Gemini, SQL,

7 12331

What is full form of XP ?

Cap Gemini, Infosys, Microsoft, Oracle, Reliance,

42 74923

can any one explain about normalization forms with clear explanation in interview point of view. thanks for ur answers.

1 5943

Is data insertion is fast in SYBASE IQ if we have more indexes on a table?

FIC,

3 8878

What will happen if we create more indexes on a sysbase iq table?

1 7374

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1 2023

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

TCS,

1 2152

what is the querry to get first 10 records from the emp table?(emp no is the primary key)

Verizon,

4 8318

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 15953

what is procedure in sql?

Millennium, SQL,

2 7303

How create table structure only from tableA to TableB if TableA have some data?

4 7208

Un-Answered Questions { Databases }

Can we do dml on views?

1024

How to convert numeric expression data types using the cast() function?

1133

What versions of clipper does netlib support?

1062

What is the best sql course?

1031

what is sql server agent? : Sql dba

1162

Explain system functions or built-in functions? What are different types of system functions?

1052

what are aggregate and scalar functions? : Sql dba

1116

What are wait types?

1219

what is collation? : Sql dba

1211

What is the current version of postgresql?

1144

What is an indexed view?

1013

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?

1959

How to connect php with different port numbers?

1159

What are the advantages of database?

1003

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

1101

For More Un-Answered { Databases } Questions Click Here