Oracle multiple choice questions

Home > Multiple choice questions > Oracle MCQs

Oracle part 1 (40 questions) Oracle part 2 (30 questions)
Oracle DBA (30 questions) Oracle PLSQL (30 questions)
Oracle Replication (20 questions) Oracle Architecture (20 questions)
Oracle Transaction(20 questions)
Placement papers on Oracle - Set 1 Placement papers on Oracle - Set 2
Placement papers on Oracle - Set 3 Placement papers on Oracle - Set 4
Placement papers on Oracle - Set 5 Placement papers on Oracle - Set 6
Creating an Oracle Database Starting Up and Shutting Down
Managing Oracle Database Processes Managing Control Files
Managing the Redo Log Managing Archived Redo Logs
Managing Tablespaces Managing Datafiles and Tempfiles
Managing the Undo Tablespace Oracle-Managed Files
Automatic Storage Management Schema Objects
Managing Space for Schema Objects Managing Tables
Managing indexes Managing Partitioned Tables and Indexes
Managing Clusters Managing Hash Clusters
Managing Views, Sequences, and Synonyms Oracle Scheduler Concepts
Oracle Scheduler Administering the Oracle Scheduler
Oracle Distributed Database Concepts Managing a Oracle Distributed Database
Developing Applications for a Distributed Database System Oracle Distributed Transactions Concepts
Managing Oracle Distributed Transactions Administering an Oracle Database

These tests include oracle topics such as

Oracle processes Oracle memory area Oracle file types
Oracle database objects Oracle operators Oracle composite
Oracle constraints Oracle data types Oracle DML commands
Oracle error handling Oracle functions Oracle import and export
Oracle sub queries Oracle table Oracle triggers
Oracle views Oracle synonym Oracle indexes
Oracle joins Oracle cursors Oracle form
Oracle security Oracle system privilege Oracle object privileges
Oracle table privileges Oracle DBA Oracle PL/SQL
Oracle replication Oracle transaction Oracle exceptions
Oracle sequences Oracle tablespaces Oracle object datatypes
Latest oracle interview questions and answers

Explain Row level and statement level trigger.
Advantage of a stored procedure over a database trigger.
What is a join, explain the types of joins?
Differences between CHAR and NCHAR in Oracle.
Differences between CHAR and VARCHAR2 in Oracle.
What are LOB datatypes?
Explain the attributes of explicit cursor.
What are the drawbacks of a cursor?
Can you pass a parameter to a cursor? Explain with an explain



Write your comment - Share Knowledge and Experience

Discussion Board
More multiple choice questions

PHP multiple choice questions
Java multiple choice questions
IQ test - multiple choice
JDBC multiple choice questions
Linux multiple choice questions
Oracle multiple choice questions
ASP.NET multiple choice questions
VB.NET multiple choice questions
C++ multiple choice questions


Career 12-19-2011 04:42 AM

Oracle multiple choice questions

Quantity and quality - both are good. Hope to see more test. Please upload more questions on PLSQL

Cassi 11-5-2011 01:38 AM

Oracle multiple choice questions

I have appeared for these test and scored around 90%. I hope my preparation is good enough to take up interview calls

Amitesh 11-4-2011 06:13 AM

 

 

Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring