Databases Interview Questions
Questions Answers Views Company eMail

Can sub procedure/function be called recursively?

542

What happens if recursive calls get out of control?

551

How to get a list of all background sessions in the database?

542

How to get execution statistics reports on query statements?

572

How to shutdown your 10g xe server from command line?

557

How to export your connection information to a file?

600

How to shutdown your 10g xe server?

625

How a tablespace is related to data files?

583

Where is the export dump file located?

575

What are the original export and import utilities?

573

What is a connect identifier?

543

How to view all columns in an existing table?

552

What is an anonymous block?

627

How many anonymous blocks can be defined?

589

How to load data through external tables?

585


Un-Answered Questions { Databases }

Are there any features that are decommissioned in 11g that are not present in 11g?

1599


How many types of canvases are there.

1


How to speed up webrick?

601


how can we submit a form without a submit button? : Sql dba

540


What is bulk compiling in pl/sql.?

613






What is the difference between varchar and varchar(max) datatypes?

565


What is storage encryption?

5


How do I view tables in mysql?

547


How to return query output in xml format?

600


How to implement database security?

539


What are the types of sql commands?

555


how to analyze tables with 'mysqlcheck'? : Sql dba

547


Can videos be stored in a database?

488


What is the data type for image?

618


What is pl sql block structure?

547