Databases Interview Questions
Questions Answers Views Company eMail

How to create a table index?

803

How to assign data of the deleted row to variables?

832

How to work with data objects interactively?

741

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

790

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

1 3967

How to set up autotrace for a user account?

804

How to run the anonymous block again?

849

How to see the table columns used in an index?

805

How to drop an index?

745

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

765

How to define an external table with a text file?

819

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

859

How to define a sub function?

885

How to define a data field as not null?

867

How to enter a new row into a table interactively?

766


Un-Answered Questions { Databases }

What is multi-version control?

572


What is user in sql?

795


What does <> mean in access query?

655


How to drop an existing user defined function in ms sql server?

820


how to create “alternate row colour”?

128


Determine when to use stored procedure to complete sql server tasks?

748


What are the two types of exceptions.

862


How to use like conditions?

735


What are string constants in postgresql?

595


What are two types of data in a database environment?

682


What is microsoft access point?

600


How would you find total size of database in os level?

395


Is declare cursor executable?

723


Is postgresql free to use?

596


What are the uses of synonyms?

853