Databases Interview Questions
Questions Answers Views Company eMail

How to open a cursor variable?

775

What happens to indexes if you drop a table?

905

How to test null values?

836

How to define a data source name (dsn) in odbc manager?

737

How to do a full database export?

840

How to bring a tablespace online?

731

Can group functions be mixed with non-group selection fields?

730

What is the relation of a user account and a schema?

857

How many file formats are supported to export data?

862

Why cursor variables are easier to use than cursors?

765

How to insert a record into a table?

824

How to define a variable to match a table column data type?

751

How to invoke the original export import utilities?

678

What is the difference between formal parameters and actual parameters?

723

How to view the dropped tables in your recycle bin?

1 1137


Un-Answered Questions { Databases }

Can we use having clause without group by?

739


what is the difference difference between procedure and packages

9676


What is postmaster pid file in postgres?

671


How is a database related to a table?

721


Can I use google sheets as a database?

643


How can you fetch first 5 characters of the string?

718


Is sql dba a good career? : SQL DBA

722


What is normalization? What are different type of normalization?

662


Is mysql owned by oracle?

710


How to use union to merge outputs from two queries together in ms sql server?

759


Explain what are the restrictions while creating batches in sql server?

803


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1770


What command must you use to include the not null constraint after a table has already been created?

765


What is the full form of rdbms?

687


What is tns name?

724