ORACLE 9i : TECHNICAL INTERVIEW QUESTIONS

1. What is DDL, DML ? How are they different?
2. What are different types of joins in SQL?
3. How do you select unique rows using SQL?
4. What is the difference between DELETE and TRUNCATE ?
5. What is the difference between a "where" clause and a "having" clause?
6. What is the difference between "procedure" and "function"?
7. What is the difference between "translate" and "replace" ?
8. How to remove duplicate records from a table?
9. What is a "trigger"?
10.What is the difference between "translate" and "replace"?
11.What is a VIEW?
12.What is the difference among "dropping a table", "truncating a table"
and "deleting all records" from a table
13.Explain new feature of 9i Database ? Explain new feature of 10g Database ?
14.How to use DECODE function?
15.What is “Group by” clause?
16.What are cursors and what are the situations you will use them?
17.What default packages are provided by Oracle?
18.How do you debug a oracle procedure /function?
19.How many triggers are available?
20.How are procedures executed?
21.Which date function is used to find the difference between two dates?
22.What is the advantage of specifying WITH GRANT OPTION in the GRANT command?
23.What is the use of CASCADE CONSTRAINTS?
24.Which function is used to find the largest integer less than or equal to a specific value?
25.What is the parameter substitution symbol used with INSERT INTO command?
26.Which command displays the SQL command in the SQL buffer, and then executes it?
27.What are the wildcards used for pattern matching?
28.What are the privileges that can be granted on a table by a user to others?
29.What command is used to get back the privileges offered by the GRANT command?
30.Which system tables contain information on privileges granted and privileges obtained?
31.Which system table contains information on constraints on all the tables created?
32.What is the difference between TRUNCATE and DELETE commands?
34.What command is used to create a table by copying the structure of another table?
35.What is the use of the DROP option in the ALTER TABLE command?
36.What is the difference between Single row sub-Query and Scalar sub-Query?
37.Difference between Store Procedure and Trigger?
38.Explain normalization with examples?
39.How to find out the database name from SQL*PLUS command prompt?
40.Whats the back end processes when we type "Select * from Table"?
41.What is the difference between SQL and SQL Server?
42.What is table space?
43.What is difference between Co-related sub query and nested sub query?
44.What is reference cursor?
45.What is difference between Oracle and MS Access? What are disadvantages in Oracle and MS Access? What are features&advantages in Oracle and MS Access?
46.Difference between a equijoin and a union?
47.Difference between VARCHAR and VARCHAR2?
48.How write a SQL statement to query the result set and display row as columns and columns as row?
49.What is cluster.cluster index and non cluster index?
50.What is difference between DBMS and RDBMS?
51.How to test the complex view using manually testing?
52.When using a count(distinct) is it better to use a self-join or temp table to find redundant data ?
53.What is the advantage to use trigger in your PL?
54.What the difference between UNION and UNIONALL?
55.What do you mean by TCL ? Give examples .