A table has the following data : [[5, Null, 10]]. What will the average function return ?
An insert statement followed by a create table statement followed by rollback ? Will the rows be inserted ?
Are views automatically updated when base tables are updated ?
Assume that there are multiple databases running on one machine. How can you switch from one to another ?
Can a trigger written for a view ?
Can Check constraint be used for self referential integrity ? How ?
Can database trigger written on synonym of a table and if it can be then what would be the effect if original table is accessed.
Can dual table be deleted, dropped or altered or updated or inserted ?
Can Long/Long RAW be clustered ?
Can null keys be entered in cluster index, normal index ?
Can one read/write files from PL/SQL?
Can one use dynamic SQL within PL/SQL? OR Can you use a DDL in a procedure ? How ?
Can views be specified in a trigger statement ?
Can you alter synonym of view or view ?
Can you create index on view ?
Can you increase the size of a tablespace ? How ?
Can you pass a parameter to a cursor ?
Can you Rollback to any savepoint ?
Can you use %RowCount as a parameter to a cursor ?
Consider a sequence whose currval is 1 and gets incremented by 1 by using the nextval reference we get the next number 2. Suppose at this point we issue an rollback and again issue a nextval. What will the output be ?
Definition of relational DataBase by Dr. Codd (IBM)?
Describe Oracle database’s physical and logical structure ?
For which relational operators in where clause, index is not used ?
How can I protect my PL/SQL source code?
How can you avoid indexes ?
If all the values from a cursor have been fetched and another fetch is issued, the output will be : error, last record or first record ?
If any other table same as dual is created would it act similar to dual?
If content of dual is updated to some value computation takes place or not ?
If I have an execute privilege on a procedure in another users schema, can I execute his procedure even though I do not have privileges on the tables within the procedure ?
If you insert a row in a table, then create another table and then say Rollback. In this case will the row be inserted ?
Is Sysdate a system variable or a system function?
Is there a limit on the size of a PL/SQL block?
Is there a PL/SQL Engine in SQL*Plus?
What all important parameters of the init.ora are supposed to be increased if you want to increase the SGA size ?
What are actual and formal parameters ?
What are cascading triggers? What is the maximum no of cascading triggers at a time?
What are constraining triggers ?
What are mutating triggers ?
What are the advantages of clusters ?
What are the advantages of Oracle ?
What are the disadvantages of clusters ?
What are the min. extents allocated to a rollback extent ?
What are the states of a rollback segment ? What is the difference between partly available and needs recovery ?
What are the types of Notation ?
What are the values of :new and 
ld in Insert/Delete/Update Triggers ?
What are the various types of queries ??
What are the various types of RollBack Segments ?
What are various types of joins ?
What is a forward declaration ? What is its use ?
What is a package cursor ?
What is a transaction ?
What is Auditing ?
What is implicit cursor and how is it used by Oracle ?
What is Multi Threaded Server (MTA) ?
What is PL/SQL?
What is the advantage of a stored procedure over a database trigger ?
What is the difference between a view and a synonym ?
What is the difference between alias and synonym ?
What is the difference between foreign key and reference key ?
What is the difference between unique key and primary key ?
What is the effect of synonym and table name used in same Select statement ?
What is the maximum no. of columns a table can have ?
What is the maximum no. of statements that can be specified in a trigger statement ?
What is the significance of the & and && operators in PL SQL ?
What is the use of Control files ?
What is the use of Data Dictionary ?
What’s the length of SQL integer ?
When to create indexes ?
Which are initial RDBMS, Hierarchical & N/w database ?
Which of the following is not a schema object : Indexes, tables, public synonyms, triggers and packages ?
Which symbol preceeds the path to the table in the remote database ?
While designing in client/server what are the 2 imp. things to be considered ?
This post was tagged with the following: Database Interview Questions, Oracle Dba Interview Questions, Oracle Faq, Oracle Forms Interview Questions, Oracle Pl/Sql Interview Questions, Pl/Sql Interview Questions, Sql Interview Questions, Unix Interview Questions