Databases Interview Questions
Questions Answers Views Company eMail

How to build data dictionary view an new database?

520

How to get a create statement for an existing table?

558

How to pass parameters to procedures?

542

How to use "in" parameter properly?

606

How to run create database statement again?

613

How to run queries on external tables?

555

What privilege is needed for a user to delete rows from tables in another schema?

557

How to rename a column in an existing table?

607

How to view existing locks on the database?

537

How much memory your 10g xe server is using?

571

How to recover a dropped index?

1 895

How to assign values to data fields in record variables?

570

How to create a new table by selecting rows from another table?

537

How to create tables for odbc connection testing?

479

What is a named program unit?

564


Un-Answered Questions { Databases }

what are archived logs?

1700


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1547


What is java sql connection?

503


What are the three basic rules which are to be followed for the relational model of the database?

551


Which is the best mongodb gui?

1






How a database is related to tablespaces?

568


Can you lock more than one database at the same time in mongodb?

5


What is the dbcc command and why is it used?

556


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

513


What is iapxtb structure? Explain its importance

1


What is the cartesian product of table?

537


What is data management process?

485


What is the difference between left outer join and left join?

499


What is sql*loader?

560


Does pl/sql support create command?

564