Wednesday, April 25, 2012

Fresher interview questions for Oracle Database, SQL, Forms & Reports

Interviewing a fresher for working on Oracle projects. Following points can be handy in checking their knowledge in different areas of RDBMS concepts, SQL, PL/SQL, Forms and Reports.

DBMS
Introduction to DBMS
Views
Database concepts
Normalization
E-R Diagrams
Types of Databases
Database Model
Oracle SQL
Basics of Oracle SQL
Character, Number and Miscellaneous Functions
Date and Conversion Functions
Aggregate Functions, GROUP BY and HAVING clauses
Equijoins, Outer Joins
Subqueries
SET Operators
Complex Joins
INSERT, UPDATE and DELETE
CREATE, ALTER and DROP tables
Views, Indexes and Sequences
Data Dictionary and Security
Regular expressions and hierarchical queries
Oracle PL/SQL
PL/SQL Programming Fundamentals
SQL in PL/SQL
Conditional Statements: IF & CASE
Iterative Loops
Error handling and exceptions in PL/SQL
Basics of PL/SQL Cursors
Advanced Cursors
Triggers
Compound Triggers
Collections
Records
Native Dynamic SQL
Bulk SQL
Procedures
Functions
Packages
UTL_File
Introduction to SQL * Loader
Oracle Forms
Introduction to Forms GUI
Forms Layout editor and property palette
Manipulating properties and property classes
Executing PL/SQL block(s) and Items in Forms
Defining Master-Detail relationships in Forms
Using Triggers in Forms
Alerts and Editors
LOV and Record groups in Forms
Passing parameters to a form and canvas views
Editing/Creating Form Menus
Error Handling in Forms
Oracle Reports
Data Modeling in Reports
Introduction to Reports GUI
Reports Layout editor
Implementing formulas and summaries in report
Embedded SQL in Reports
Embedded PL/SQL blocks in Reports

No comments:

Post a Comment