Oracle General Interview Questions
Questions Answers Views Company eMail

How to do a full database export?

637

How to bring a tablespace online?

520

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

536

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

617

How many file formats are supported to export data?

660

Why cursor variables are easier to use than cursors?

571

How to insert a record into a table?

642

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

580

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 868

How to define an anonymous procedure without variables?

553

How many data types are supported?

622

How to connect to the server with user account: sys?

566

How to define default values for formal parameters?

598


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

1749


How to select some columns from a table in oracle?

553


What is an oracle table?

557


Explain a private synonyms?

635


What is difference between cartesian join and cross join?

591






How to list all indexes in your schema?

584


What happens if recursive calls get out of control?

551


How to run create database statement again?

622


What happens if you use a wrong connect identifier?

504


What is parameterized cursor in oracle?

578


What is save point in oracle database?

730


Difference between inner join vs where ?

611


How to increment dates by 1 in oracle?

562


you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1564


What the is the diff between local index and global index. give some example.

1136