Databases Interview Questions
Questions Answers Views Company eMail

What do you understand by pl/sql cursors?

524

Enlist the characteristics of pl/sql?

1210

What do you understand by pl/sql records?

506

What do you understand by exception handling in pl/sql?

550

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?

1 3654

What are the ways on commenting in a pl/sql code?

486

What is sql comments?

634

Write a sql select query that only returns each name only once from a table?

536

Which tcp/ip port does sql server run?

510

What are different clauses used in sql?

561

What are different joins used in sql?

535

Why do we use sql constraints? Which constraints we can use while creating database in sql?

524

What are different types of statements supported by sql?

583

How many aggregate functions are available there in sql?

503

Why do we use sql constraints?

616


Un-Answered Questions { Databases }

What is the difference between couchdb and rdbms?

1


Does facebook still use mysql?

479


How do I check if log truncation is blocked in sybase?

414


What is merge in oracle?

532


Define truncate and delete commands?

504






when would you go for denormalization? : Sql server database administration

467


What is cluster in postgresql?

409


How much memory does postgresql need?

435


Define database lock and its types.

490


What is normalization? What number of normalization shapes are there?

579


What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

581


What is the difference between star flake and snow flake schema?

451


How large can a postgresql database be?

396


Explain what is lock escalation?

544


What are the differences between number and binary_float in oracle?

544