Play and learn 300 000+ tabs online

Sunday, January 24, 2010

Interview Questions - SQL*Plus, PL/SQL, ORACLE Concepts

1.     What are the minimum priveleges required to be given to a newly created user?
2.     What is a synonym? Diff between a view and a synonym
3.     If Db is mounted but not open, which view can U access
4.     Contents of  a control file
5.     How to mirror a control file?
6.     What is a instance?
7.     Where does oracle log its errors?
8.     Which process does automatic recovery if an instance fails before writing into datafile but after issuing a commit statement?
9.     How can u maintain consistency across forms?
10.     How do constraints differ from DB triggers?
11.     If rollback statement has been dropped or corrupted( eg. By deleting the file in O.S ) what will hapen during startup of the instance? How can the situation be handled?
12.     What are the issues to be attended to when a tablespace has to be designed and created?
13.     When will you experience the following error - “Snapshot too old” How can it be attended?
14.     What is a mutating and a constraining table?
15.     How do you monitor locks in Oracle?
16.     If a user has locked a resource for a long time and is not using it, How will you handle the situation and release the resource?
17.     What are the differences bet a trigger and a stored procedure?
18.     What is a pl/sql table?
19.     What is a record datatype?
20.     What will happen when a table begin accessed by a stored procedure is dropped?
21.     What is table stripping?
22.     Which view will give the details of datafiles?
23.     Which default tablespace is created by ORACLE?
24.     How do you decide the size of the DB block ?
25.     How do you increase the DB block size?
26.     What are priveleges?
27.     What are tuning steps?
28.     What are the diagnostic tools available for Tuning?
29.     What are the advantages of stored procedures?
30.     If a user does have access rights on a table but has executable rights on a procedure accessing that table; what will happen?
31.     what will happen when importing a table with duplicates in it?
32.     What is a Instance?
33.     Can you have multiple instances of the same DB/
34.     Can you share bet two instances?
35.     What features are provided by Oracle for DB Audit Trail?
36.     How do you avoid using indexes?
37.     What is cluster? How is it stored?
38.     What is ananymous block?
39.     If a SQL statements are given one by one from the SQL prompt and if they are written in a file and executed then what will be the difference?
40.     Is it possible to use a index in SQL?
41.     What is the criteria for creating a index?
42.     Will droping a index and recreating it increase performance? If yes, Why?
43.     What is analyzing a table?
44.     Diff bet “Union” and “Union All”?
45.     Result of count(*) and count(field name) , DIFF?
46.     What are DCL statements?
47.     What is a exetent, segment?
48.     How many types of segments exists in Oracle?
49.     Can you create rollback segments and data segments explicitly?
50.     How are execptions raised in pl/sql?
51.     Implicit and explicit cursors, diff?
52.     Can you use DDL statements in PL/SQl?
53.     How is a SQL statement parsed?
54.     How can you delete duplicates in a table?
55.     what is the diff bet rowid and rownum?
56.     What are hierarchical queries? ( connect by prior)
57.     What is a transaction?
58.     What is a read lock?
59.     What are SQL statements you can use in case of read transcation?
60.     In case of a trigger firing another trigger and that in turn firing another and so on ; upto what level is this kind of nesting allowed ? ( ans. 32 )
61.     What is referential integrity?
62.     Normalisation and De-normalisation?
63.     Diff bet 2nd and 3rd normal form?
64.     Optimiser 1. Cost based 2. Rule based . Diff? Which is used by Oracle?
65.     When is index recreated  or remapped?
66.     Diff bet truncate and delete?
67.     Will a “After-delete” trigger fire when the table is truncated?
68.     What are the things you will keep in mind when writing SQL statement?
69.     In case of a join statement which should be the driving table? ( ans. With max number of records.)
70.     Upto what level can you nest blocks in PL/SQL ? ( ans. 200 depending on the stack status ).
71.     What are the multithreaded server  and how it is different from dedicated server .
72.     What are the new features incorporated in ORACLE 7.2 version.
73.     What are the various difference between ORACLE 6.0 ORCALE7.0.
74.     How many types of triggers U have used in your application.
75.     How are the various variables in Proc and how we are declaring it.
76.     What is meant by Indicator variable in Pro*C
77.     What is difference between SQLCA and ORACA.
78.     How You are trapping errors in Pro*C program
79.     What is difference between UserExits and Pro*C program
80.     What are the various difference in UNIX and WINDOWS95 Operating systems.
81.     How You are connecting to Oracle database and what is meant by connect string.
82.     What is meant by partition view.
83.     What are various triggers that You have extensively used in your application.
84.     What is Dynamic SQL.
85.     What are the backup procedures for oracle.
86.     What is meant by 2 phase commit.
87.     Which case designer you have used and what was the version of it.
88.     what is SQL loader.
89.     What are the various security provided by oracle.
90.     What is difference between content and stacked canvas
91.     Database triggers call database procedures and vice versa.
92.     You will define and raise  your own exceptions.
93.     many error codes you  can use to have your own error messages.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.