Oracle General Interview Questions
Questions Answers Views Company eMail

What are the restrictions on external table columns?

547

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

560

How to loop through data rows in the implicit cursor?

539

How to create additional tablespaces for an new database?

570

How many categories of data types?

570

Can you assign multiple query result rows to a variable?

546

How to use fetch statement in a loop?

551

How do I call oracle stored procedures that take no parameters?

562

How do I learn what codesets are available in oracle?

573

How do I use os authentication with weblogic jdriver for oracle and connection pools?

573

How do I limit the number of oracle database connections generated by weblogic server?

543

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

606

How do I use unicode codesets with the weblogic jdriver for oracle driver?

548

Why does for update in oracle 8 cause an ora-01002 error?

543

How to find the duplicate rows count from employees table in oracle?

542


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What happens in oracle commit?

561


When do we use group by clause in a sql query?

567


How do you store pictures in a database?

555


What are the four Oracle system processes that must always be up and running for the database to be useable?

589


How a tablespace is related to data files?

581






How to find out what oracle odbc drivers are installed?

568


How to delete a column in an existing table in oracle?

601


What is the difference between formal parameters and actual parameters?

541


What is enter substitution variable in oracle?

570


What privilege is needed for a user to create tables in oracle?

548


How to create additional tablespaces for an new database?

570


What is snapshot is too old? Give and example for better understand.

1097


definition of cluster and non-clustered index?

2475


How to use regular expression in pattern match conditions in oracle?

573


What is an oracle database?

610