Databases Interview Questions
Questions Answers Views Company eMail

How to create a table index?

564

How to assign data of the deleted row to variables?

579

How to work with data objects interactively?

553

How to add a new column to an existing table with a default value?

543

How to get a list of all tables in the database?

1 3699

How to set up autotrace for a user account?

593

How to run the anonymous block again?

595

How to see the table columns used in an index?

591

How to drop an index?

539

What happens to the current transaction if the session is killed?

536

How to define an external table with a text file?

579

How to get a list of all user accounts in the database?

615

How to define a sub function?

662

How to define a data field as not null?

631

How to enter a new row into a table interactively?

546


Un-Answered Questions { Databases }

What is buffer cash in sql server?

604


Explain the Normalized Relations?

2304


How secure is sql server database?

523


What is a master or primary?

1


How to delete duplicate records based on single column from a table?

601






What is a checkpoint and When does it occur?

464


Describe in brief databases and sql server databases architecture.

524


Can you pass expressions to function parameters?

537


What's the difference between clustered and non-clustered indexes?

493


Explain what is meant by replication of database?

531


How to create prepared statements using odbc_prepare()?

565


What are information schema views?

546


How to implement a database management system?

495


What is foreign key in java?

457


Explain about extended stored procedure?

488