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