Oracle Database MCQ (Multiple Choice Questions)

Here are 1000 Oracle Database MCQ (Chapterwise).

1. What is Oracle?
a) Oracle is a programming language
b) Oracle is a database
c) Oracle is a sripting language
d) Oracle is an operating system
View Answer

Answer: b
Explanation:

2. Which of the following is correct about Oracle?
a) Oracle is a relational database management system
b) Oracle was built in 1977
c) OracleDB is another name for it
d) All of the mentioned
View Answer

Answer: d
Explanation: Oracle is a relational database management system. OracleDB, or just Oracle, is another name for it. Oracle Corporation is the company that produces and sells it. Lawrence Ellison and other engineers built it in 1977.

3. Which of the following database was designed first for enterprise grid computing?
a) Oracle database
b) SQL
c) MongoDB
d) Google database
View Answer

Answer: a
Explanation: Oracle was the first database to be created specifically for enterprise grid computing and data warehousing. The most versatile and cost-effective way to handle information and applications is through enterprise grid computing.

4. Which of the following is not a Oracle Database feature?
a) Scalability
b) Availability
c) Analytics
d) None of the mentioned
View Answer

Answer: d
Explanation: The features of Oracle Database features are:
i) Availability: Because of the Oracle Data Guard feature, it ensures that databases are always available.
ii) Security: To prevent unwanted access, Oracle has a system for controlling and accessing the database.
iii) Scalability: It has capabilities such as RAC (Real Application Cluster) and Portability, which allow an Oracle database to scale up or down depending on usage.
iv) Performance: Oracle Advanced Compression, Oracle Database In-Memory, Oracle Real Application Testing, and Oracle Times Ten Application-Tier Database Cache are some of the speed enhancement solutions available.
v) Analytics: Oracle has the following solutions in the field of analytics:
a) OLAP (Oracle Analytic Processing)
b) Oracle Advanced Analytics
vi) Management: Oracle Multitenant is a database management system that combines a single container database with a number of pluggable databases in a single unified design.

5. Which of the following is an advantage of Oracle database?
a) Portability
b) Flashback Technology
c) Performance
d) All of the mentioned
View Answer

Answer: d
Explanation: The following are the advantages of an Oracle database:
Performance: Oracle has procedures and principles that help us to get high levels of database performance.
Portability: The Oracle database can be ported on all different platforms than any of its competitors.
Backup and Recovery: Using the Oracle database, it is simple to perform a rapid recovery using RMAN (Recovery Manager) feature.
PL/SQL: One of the greatest benefits of using the Oracle database is to support PL/SQL extension for procedural programming.
Multiple Database: Oracle database allows several database instances management on a single server.
Flashback Technology: It enables user to recover data that has been wrongly deleted or lost due to human errors.
advertisement
advertisement

6. Which of the following is a disadvantage of Oracle database?
a) Difficult to manage
b) Cost
c) Complexity
d) All of the mentioned
View Answer

Answer: d
Explanation: The disadvantages of the Oracle database are:
Complexity: Oracle is not advised for use by those who are not technically aware and have just rudimentary knowledge of the Oracle Database.
Cost: Oracle products are extremely expensive when compared to alternative databases.
Difficult to manage: Oracle databases are difficult to manage when it comes to specific operations.

7. What is Oracle database used for?
a) Creating backup for data
b) Accessing database servers
c) Store and retrieve relevant data
d) Both a & c
View Answer

Answer: c
Explanation: An Oracle database is a collection of data that is viewed as if it were a single entity. A database’s main goal is to store and retrieve relevant data. The key to tackling information management issues is a database server.

8. Which of the following components comprise an Oracle architecture?
a) Tablespaces
b) Datafiles
c) Database related background processes
d) All of the Mentioned
View Answer

Answer: d
Explanation: Oracle architecture consists of DB process, Table space, Datafiles.

9. Which of the following area of PGA stores binding variables and run-time buffers information?
a) Stack space
b) SQL area
c) Session area
d) Private SQL area
View Answer

Answer: d
Explanation: PGA (Program Global Area) is a non-shared memory region that contains data and control information exclusively for use by an Oracle process.The PGA is created by Oracle Database when an Oracle process is started.

10. Which of the following is the smallest unit of storage in an Oracle database?
a) Segment
b) Extent
c) Data File
d) Data Block
View Answer

Answer: d
Explanation: The logical units of database space allocation are data blocks.

11. Which of the following is another name of Oracle database’s design?
a) Database Instance
b) Database Schema
c) Database Abstraction
d) None of the Mentioned
View Answer

Answer: b
Explanation: Oracle database’s design is done on the schema level.

12. Which of the following is used to logically group data together?
a) Tablespace
b) Datafiles
c) Object
d) Database
View Answer

Answer: a
Explanation: Oracle database consists of one or more logical storage units called tablespaces.

13. Which of the following package procedure is UNRESTRICTED in Oracle?
a) CLEAR_BLOCK
b) USER_EXIT
c) CALL_INPUT
d) EXECUTE_QUERY
View Answer

Answer: b
Explanation: A user exit is a C subroutine and called by Oracle Forms to do special-purpose processing.It can display messages on the Oracle Forms status line, get and set field values, do high-speed computations and table look-ups, and manipulate Oracle data.

14. Oracle server configuration is dedicated for
a) One server process – One user process
b) Many server processes – Many user processes
c) Many server processes – One user process
d) One server process – Many user processes
View Answer

Answer: a
Explanation: Single-process Oracle is a database system in which all Oracle code is executed by one process. Different processes are not used to separate execution of the parts of Oracle and the client application program. Instead, all code of Oracle and the single user’s database application is executed by a single process.
advertisement

15. Which schema object instructs Oracle to connect to remotely access an object of a database?
a) Database Link
b) Sequence
c) Data Link
d) Remote Link
View Answer

Answer: c
Explanation: A DATABASE LINK value references a resource outside the underlying data source through a URL.

16. When a transaction modifies the database, Oracle copies the original data before modifying it. What is the original copy of the modified data called?
a) Redo Data
b) Undone Data
c) Undo Data
d) Archive Data
View Answer

Answer: c
Explanation: Before transaction happen the Oracle kept the files in Undo Data to overcome form any failure.

17. A new user on the database is created by executing the following command:

SQL> CREATE USER user01 IDENTIFIED BY user01 
DEFAULT TABLESPACE users 
TEMPORARY TABLESPACE temp; 

Then you granted the following privileges to user01 by executing the following command: 

SQL> GRANT CREATE SESSION, CREATE TABLE TO user01; 

Which of the following is correct in this scenario?
a) The user cannot query any tables
b) The user can not create tables
c) The user can create tables
d) None of the Mentioned
View Answer

Answer: c
Explanation: GRANT command give access to user.GRANT CREATE SESSION, CREATE TABLE TO user01 get the access for that session to create tables.

18. Which of the following is referred to as the language used application programs to request data from the DBMS?
a) DDL
b) Query language
c) DML
d) All of the Mentioned
View Answer

Answer: c
Explanation: The effect of a DML statement is not permanent until you commit the transaction that includes it. A transaction is a sequence of SQL statements that Oracle Database treats as a unit.
advertisement

19. Which of the following RDBMS supports full fledged client server application development?
a) FoxPro 2.1
b) Ingress
c) Oracle 7.1
d) dBase V
View Answer

Answer: c
Explanation: Oracle 7.1 support the all server-client application development.

20. Which of the following is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
a) Data Manipulation Language(DML)
b) Data Definition Language(DDL)
c) DDL and DML
d) None of the Mentioned
View Answer

Answer: b
Explanation: The Data Definition Language is used to manage table and index structure.CREATE, ALTER, RENAME, DROP and TRUNCATE statements are the names of few data definition elements.

21. Which of the following is not included in DML (Data Manipulation Language)?
a) UPDATE
b) CREATE
c) INSERT
d) DELETE
View Answer

Answer: b
Explanation: The CREATE TABLE statement is used to create a table in a database.Tables are organized into rows and columns; and each table must have a name.

22. Which of the following keyword is used with Data Control Language (DCL) statements?
a) INSERT
b) SELECT
c) GRANT
d) DELETE
View Answer

Answer: c
Explanation: GRANT is the keyword which is used with Data Control Language statements.

23. Which of the following command is used to obtain the structure of an Oracle table?
a) DESC TABLE [TableName].
b) STRUCTURE [TableName].
c) DESCRIBE [TableName].
d) DESCRIBE STRUCTURE [TableName].
View Answer

Answer: c
Explanation: DESCRIBE command is used to get the structure of the Oracle Table.

24. Which of the following is not a type of SQL statement?
a) Data Definition Language (DDL)
b) Data Control Language (DCL)
c) Data Communication Language (DCL)
d) Data Manipulation Language (DML)
View Answer

Answer: c
Explanation: Data Communication Language (DCL) is not a type of SQL statement.

25. command to use iscommand is used for removing a table and all its data from the database?
a) Alter table command
b) Create command
c) Drop table command
d) All of the Mentioned
View Answer

Answer: c
Explanation: The DROP INDEX statement is used to delete an index in a table.

26. Which of the following is/are the DDL statements?
A) Drop
B) Alter
C) Create
D) All of the Mentioned
View Answer

Answer: d
Explanation: All the mentioned commands are the part of DDL statements.

27. The SQL statement
SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’, ‘b’), 4) FROM DUAL;
a) 2345
b) 456789
c) 6789
d) 1234
View Answer

Answer: a
Explanation: INSTR function in SQL is used to find the starting location of a pattern in a string. The syntax for the INSTR function is as follows:INSTR(str,pattern):Find the starting location of pattern in string str and SUBSTR Function:- The Substring function in SQL is used to grab a portion of the stored data.

28. Which of the following command is used to SELECT only one copy of each set of duplicable rows in SQL?
a) SELECT UNIQUE
b) SELECT DIFFERENT
c) SELECT DISTINCT
d) All of the Mentioned
View Answer

Answer: c
Explanation: The keyword allows us to grab all information from a column (or columns) on a table. This, of course, necessarily means that there will be redundancies. What if we only want to select each distinct element? This is easy way to accomplish in SQL. All we need to do is that to add after The syntax is:SELECT DISTINCT column_name FROM table_name;.

29. Which of the following is record based logical model?
a) E-R Model
b) Network Model
c) Object oriented model
d) None of the Mentioned
View Answer

Answer: b
Explanation: The network model is a database model conceived as a flexible way of representing objects and their relationships.

30. Which of the following is not a Key in SQL Server?
a) Alternate
b) Secondary
c) Foreign
d) Primary
View Answer

Answer: b
Explanation: Except Secondary all are the types of key in SQL server.

31. Which of the following is not a component of a data warehouse?
a) Data metadata
b) Data extraction/cleaning/preparation programs
c) Data warehouse data
d) None of the Mentioned
View Answer

Answer: a
Explanation: Data warehouse is not deal with the Data metadata.

32. Which of the following is the oldest database model?
a) Deductive
b) Physical
c) Network
d) Relational
View Answer

Answer: c
Explanation: Network Model is the oldest database model.

33. Which of the following object types below cannot be replicated?
a) Sequence
b) Data
c) Trigger
d) View
View Answer

Answer: a
Explanation: Use the CREATE SEQUENCE statement to create a sequence, which is a database object from which multiple users may generate unique integers. You can use sequences to automatically generate primary key values.

34. What is the result of the following ‘ORA’NULL’CLE’?
a) ORA CLE
b) Error
c) NULL
d) ORACLE
View Answer

Answer: d
Explanation: In Oracle NULL values represent missing unknown data.

35. The redo log buffer and Shared pool are elements of?
a) SGA
b) PGA and Buffer cache
c) Buffer cache
d) PGA
View Answer

Answer: a
Explanation: SGA (System Global Area) contains Shared Pool, Database Buffer Cache, Java Pool, redo Log Buffer.

36. Which processes is an instance made of Oracle?
a) Data processes
b) Oracle background processes
c) Memory processes
d) All of the Mentioned
View Answer

Answer: b
Explanation: Oracle creates a set of background processes for an instance to manage memory structure, asynchronously perform I/O to write data to disk, and do general maintenance tasks.


Chapterwise Multiple Choice Questions on Oracle Database

Oracle Database MCQ - Multiple Choice Questions and Answers

Our 1000+ MCQs focus on all topics of the Oracle Database subject, covering 100+ topics. This will help you to prepare for exams, contests, online tests, quizzes, viva-voce, interviews, and certifications. You can practice these MCQs chapter by chapter starting from the 1st chapter or you can jump to any chapter of your choice.
  1. Oracle Database 11g Architecture Options
  2. Planning Oracle Applications
  3. SQL Basics
  4. Accessing Remote Data
  5. Using Oracle Text for Text Searches
  6. SQL Functions
  7. Subquery and Joins
  8. Changing Data
  9. Creating and Managing Tables, Views, Indexes and Sequences
  10. Procedures, Functions and Packages
  11. Using Native Dynamic SQL and DBMS_SQL
  12. Triggers
  13. Implementing Object Types, Object Views, and Methods
  14. JDBC Programming

1. Multiple Choice Questions on Oracle Database 11g Architecture Options

The section contains multiple choice questions and answers on oracle db 11g architecture, databases and instances, programmatic oracle structures, storing and guarding the data, installing the oracle database and creating a database.

  • Oracle Database 11g Architecture
  • Databases and Instances
  • Storing and Guarding the Data
  • Programmatic Oracle Structures
  • Installing Oracle Database 11g and Creating a Database
  • 2. MCQ on Planning Oracle Applications

    The section contains Oracle questions and answers on approaches, risks and standards, atomic data and business models, data entry, query and reporting, normalization, foreign key, primary and unique keys.

  • Approaches, Risks and Standards
  • The Atomic Data Models and Business Models
  • Data Entry, Query and Reporting
  • Normalization (1NF, 2NF, 3NF)
  • Foreign, Candidate, Primary, Composite, Unique Keys
  • Attribute, Tuple and Entity
  • 3. Oracle Database Multiple Choice Questions on SQL Basics

    The section contains Oracle MCQs on structured query language, ddl, dml, dcl and tcl commands, select statements, arithmetic operators, alias, writing sql statements and literal characters.

  • Structured Query Language
  • DDL command
  • DML command
  • DCL and TCL command
  • Basic Select Statements
  • Writing SQL Statements
  • Arithmetic Operators
  • Defining a Column Alias
  • Literal Character Strings
  • 4. Oracle Database MCQ on Accessing Remote Data

    The section contains Oracle Database multiple choice questions and answers on sql development environment, database connection and sql worksheet.

  • Development Environmnets for SQL
  • Database Connection
  • SQL Worksheet
  • 5. Multiple Choice Questions on Using Oracle Text for Text Searches

    The section contains Oracle Database questions and answers on sql wildcards, comparison and logical conditions, sorting and variables.

  • Limiting Rows Using a Selection
  • SQL Wildcards
  • Comparison Conditions
  • Logical Conditions
  • Sorting
  • Substitution Variables
  • 6. Oracle Database MCQ on SQL Functions

    The section contains Oracle MCQs on sql functions.

  • SQL Functions – 1
  • SQL Functions – 2
  • SQL Functions – 3
  • SQL Functions – 4
  • 7. Oracle Database Multiple Choice Questions on Subquery and Joins

    The section contains Oracle Database multiple choice questions and answers on groups of data, joins, non equijoins, sql clauses, subqueries and its types.

  • Creating Groups of Data
  • Joins
  • Non-Equijoins
  • Subquery Syntex
  • Types of Subqueries
  • SQL Clauses (AND, OR, LIKE, TOP)
  • 8. Oracle Database MCQ on Changing Data

    The section contains Oracle questions and answers on set operators, script creation, updating rows, delete statement, database transactions, read consistency, database objects and data types.

  • Set Operators
  • Creating a Script
  • Updating Rows
  • Delete Statement
  • Database Transcations – 1
  • Database Transcations – 2
  • Read Consistency
  • Database Objects
  • Data Types – 1
  • Data Types – 2
  • 9. Oracle Database MCQ on Creating and Managing Tables, Views, Indexes and Sequences

    The section contains Oracle Database MCQs on constraints, views, sequences, indexes, data dictionary structure, constraint and view information.

  • Constraints – 1
  • Constraints – 2
  • View – 1
  • View – 2
  • Sequences
  • Indexes
  • Data Dictionary Structure
  • Constraint Information
  • View Information
  • 10. Oracle Database Multiple Choice Questions on Procedures, Functions and Packages

    The section contains Oracle multiple choice questions and answers on pl/sql introduction, procedures, parameters, functions, packages and records, persistent state of packages, oracle supplied packages, job creation, dynamic sql, sql execution flow, pl/sql block and dbms_sql package.

  • PL/SQL Introduction
  • Procedures in PL/SQL
  • PL/SQL Parameters
  • Functions in PL/SQL
  • PL/SQL Packages – 1
  • PL/SQL Packages – 2
  • PL/SQL Records
  • Package Functions in SQL
  • Persistent State of Packages
  • Oracle Supplied Packages
  • Creating a Job
  • Data Dictionary Views
  • Execution Flow of SQL
  • Dynamic SQL
  • Dynamically Executing of PL/SQL Block
  • DBMS_SQL Package
  • 11. Oracle Database MCQ on Using Native Dynamic SQL and DBMS_SQL

    The section contains Oracle Database questions and answers on pl/sql wrapper, cursor, synonym and collections, autonomous transactions, bulk binding and dependencies.

  • PL/SQL Wrapper
  • PL/SQL Cursor
  • PL/SQL Synonym
  • PL/SQL Collections
  • Standardizing Constants and Exceptions
  • Autonomous Transactions
  • Bulk Binding
  • Dependencies – 1
  • Dependencies – 2
  • 12. Oracle Database Multiple Choice Questions on Triggers

    The section contains Oracle MCQs on lob datatypes, bfiles, triggers, database triggers, native compilation and pl/sql warnings.

  • LOB Data Types
  • BFILEs
  • Triggers – 1
  • Triggers – 2
  • Database Triggers
  • Native Compilation
  • PL/SQL Warnings
  • 13. Oracle Database MCQ on Implementing Object Types, Object Views, and Methods

    The section contains Oracle Database multiple choice questions and answers on oracle sequences, tablespace, security, replication and backup.

  • Oracle Sequences
  • Oracle Tablespace
  • Oracle Security
  • Oracle Replication
  • Oracle Backup
  • 14. Oracle Database Multiple Choice Questions on JDBC Programming

    The section contains Oracle questions and answers on jdbc programming.

  • JDBC Programming – 1
  • JDBC Programming – 2
  • JDBC Programming – 3
  • JDBC Programming – 4
  • If you would like to learn "Oracle Database" thoroughly, you should attempt to work on the complete set of 1000+ MCQs - multiple choice questions and answers mentioned above. It will immensely help anyone trying to crack an exam or an interview.

    Wish you the best in your endeavor to learn and master Oracle Database!

    advertisement
    Manish Bhojasia - Founder & CTO at Sanfoundry
    Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

    Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.