Databases Interview Questions
Questions Answers Views Company eMail

What are service-specific middleware?

519

Explain dml (data manipulation language)?

502

What are the ways to tune reporting services?

502

How do you call a stored procedure from jdbc?

527

Define data, entity, domain and referential integrity?

556

Explain atomicity and aggregation?

574

Which two can be implemented as a centrally located logical architecture?

538

What is data sparsity and how it effect on aggregation?

498

How to lock records in a table?

531

What is building blocks of client/server?

526

Explain the hierarchical database?

565

Explain data independence?

592

Explain dml compiler?

574

How to prevent firebird.log file from filling up the disk partition?

481

How to unzip a file in ssis?

531


Un-Answered Questions { Databases }

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

380


What is the function of myisamchk?

566


What is postgresql server?

514


What are triggers? Why do we use them? Diff types of triggers? What are magic tables?

493


What is the use of file param in imp command?

646






what is storage manager?

537


What are five types of database models?

480


What are page splits? : sql server architect

495


What is supporting issues GL AP and AR?

1996


What are reports usually used for?

569


What is the impact on other user sessions when creating indexes?

544


Please explain go command in sql server?

599


What does inner join mean?

558


Is mysql port 3306 tcp or udp?

518


How to convert csv to table in oracle?

528