Databases Interview Questions
Questions Answers Views Company eMail

How to open a cursor variable?

613

What happens to indexes if you drop a table?

702

How to test null values?

680

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

531

How to do a full database export?

640

How to bring a tablespace online?

522

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

538

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

617

How many file formats are supported to export data?

661

Why cursor variables are easier to use than cursors?

573

How to insert a record into a table?

643

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

581

How to invoke the original export import utilities?

507

What is the difference between formal parameters and actual parameters?

547

How to view the dropped tables in your recycle bin?

1 869


Un-Answered Questions { Databases }

Explain mutating table error.

651


what is the use of ocr?

602


how many columns can be used for creating index? : Sql dba

524


what are sequences

1100


What is data store? How to create data store?

328






Describe mysql transaction properties.

525


What is mysql and how it works?

466


What is numeric function sql?

544


What are the sql aggregate functions?

612


Explain something about security and SQL Azure?

90


Does execute immediate commit?

702


Which is faster join or subquery in oracle?

537


What is indexing a document?

559


Is sql easier than java?

529


What is a data definition language?

560