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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 11g Architecture Options
- Planning Oracle Applications
- SQL Basics
- Accessing Remote Data
- Using Oracle Text for Text Searches
- SQL Functions
- Subquery and Joins
- Changing Data
- Creating and Managing Tables, Views, Indexes and Sequences
- Procedures, Functions and Packages
- Using Native Dynamic SQL and DBMS_SQL
- Triggers
- Implementing Object Types, Object Views, and Methods
- 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.
|
|
|
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.
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.
|
|
|
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.
|
|
|
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.
|
|
|
6. Oracle Database MCQ on SQL Functions
The section contains Oracle MCQs on sql functions.
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
14. Oracle Database Multiple Choice Questions on JDBC Programming
The section contains Oracle questions and answers on jdbc programming.
|
|
|
Wish you the best in your endeavor to learn and master Oracle Database!
