Olete.in – MCQs, Mock Tests & Government Job Prep | Oracle DB Oracle DB Mcq Question Set 1

What is Oracle?

1. Oracle is a programming language
2. Oracle is a database
3. Oracle is a sripting language
4. Oracle is an operating system

✅ Correct Answer: 2

Which of the following is correct about Oracle?

1. Oracle is a relational database management system
2. Oracle was built in 1977
3. OracleDB is another name for it
4. All of the Mentioned

✅ Correct Answer: 1

Which of the following database was designed first for enterprise grid computing?

1. Oracle database
2. SQL
3. MongoDB
4. Google database

✅ Correct Answer: 1

Which of the following is not a Oracle Database feature?

1. Scalability
2. Availability
3. Analytics
4. None of the mentioned

✅ Correct Answer: 4

Which of the following is an advantage of Oracle database?

1. Portability
2. Flashback Technology
3. Performance
4. All of the Mentioned

✅ Correct Answer: 4

Which of the following is a disadvantage of Oracle database?

1. Difficult to manage
2. Cost
3. Complexity
4. All of the Mentioned

✅ Correct Answer: 4

What is Oracle database used for?

1. Creating backup for data
2. Accessing database servers
3. Store and retrieve relevant data
4. Both A & C

✅ Correct Answer: 3

Which of the following components comprise an Oracle architecture?

1. Tablespaces
2. Datafiles
3. Database related background processes
4. All of the Mentioned

✅ Correct Answer: 4

Which of the following area of PGA stores binding variables and run-time buffers information?

1. Stack space
2. SQL area
3. Session area
4. Private SQL area

✅ Correct Answer: 4

Which of the following is the smallest unit of storage in an Oracle database?

1. Segment
2. Extent
3. Data File
4. Data Block

✅ Correct Answer: 4

Which of the following is another name of Oracle database’s design?

1. Database Instance
2. Database Schema
3. Database Abstraction
4. None of the mentioned

✅ Correct Answer: 2

Which of the following is used to logically group data together?

1. Datafiles
2. Tablespace
3. Object
4. Database

✅ Correct Answer: 2

Which of the following package procedure is UNRESTRICTED in Oracle?

1. CLEAR_BLOCK
2. USER_EXIT
3. CALL_INPUT
4. EXECUTE_QUERY

✅ Correct Answer: 2

Oracle server configuration is dedicated for

1. One server process – One user process
2. Many server processes – Many user processes
3. Many server processes – One user process
4. One server process – Many user processes

✅ Correct Answer: 1

Which schema object instructs Oracle to connect to remotely access an object of a database?

1. Database Link
2. Sequence
3. Data Link
4. Remote Link

✅ Correct Answer: 3

When a transaction modifies the database, Oracle copies the original data before modifying it. What is the original copy of the modified data called?

1. Redo Data
2. Undone Data
3. Undo Data
4. Archive Data

✅ Correct Answer: 3

Which of the following is referred to as the language used application programs to request data from the DBMS?

1. DDL
2. Query language
3. DML
4. All of the Mentioned

✅ Correct Answer: 3

Which of the following RDBMS supports full fledged client server application development?

1. FoxPro 2.1
2. Ingress
3. Oracle 7.1
4. dBase V

✅ Correct Answer: 3

Which of the following is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

1. Data Manipulation Language(DML)
2. Data Definition Language(DDL)
3. DDL and DML
4. None of the mentioned

✅ Correct Answer: 2

Which of the following is not included in DML (Data Manipulation Language)?

1. UPDATE
2. CREATE
3. INSERT
4. delete

✅ Correct Answer: 2

Which of the following keyword is used with Data Control Language (DCL) statements?

1. INSERT
2. SELECT
3. GRANT
4. DELETE

✅ Correct Answer: 3

Which of the following command is used to obtain the structure of an Oracle table?

1. DESC TABLE [TableName].
2. STRUCTURE [TableName].
3. DESCRIBE [TableName].
4. DESCRIBE STRUCTURE [TableName].

✅ Correct Answer: 3

Which of the following is not a type of SQL statement?

1. Data Definition Language (DDL)
2. Data Control Language (DCL)
3. Data Communication Language (DCL)
4. Data Manipulation Language (DML)

✅ Correct Answer: 3

command to use iscommand is used for removing a table and all its data from the database?

1. Alter table command
2. Create command
3. Drop table command
4. All of the Mentioned

✅ Correct Answer: 3

Which of the following is/are the DDL statements?

1. Drop
2. Alter
3. Create
4. All of the Mentioned

✅ Correct Answer: 4

The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’, ‘b’), 4) FROM DUAL;

1. 2345
2. 456789
3. 6789
4. 1234

✅ Correct Answer: 1

Which of the following command is used to SELECT only one copy of each set of duplicable rows in SQL?

1. SELECT UNIQUE
2. SELECT DIFFERENT
3. SELECT DISTINCT
4. All of the Mentioned

✅ Correct Answer: 3

Which of the following is not a Key in SQL Server?

1. Alternate
2. Secondary
3. Foreign
4. primary

✅ Correct Answer: 2

Which of the following is not a component of a data warehouse?

1. Data metadata
2. Data extraction/cleaning/preparation programs
3. Data warehouse data
4. none of the mentioned

✅ Correct Answer: 1

Which of the following is the oldest database model?

1. Deductive
2. Physical
3. Network
4. relational

✅ Correct Answer: 3

Which of the following object types below cannot be replicated?

1. Sequence
2. Data
3. Trigger
4. View

✅ Correct Answer: 1

What is the result of the following ‘ORA’NULL’CLE’?

1. ORA CLE
2. Error
3. NULL
4. Oracle

✅ Correct Answer: 4

The redo log buffer and Shared pool are elements of?

1. SGA
2. PGA and Buffer cache
3. Buffer cache
4. PGA

✅ Correct Answer: 1

Which processes is an instance made of Oracle?

1. Data processes
2. Oracle background processes
3. Memory processes
4. All of the Mentioned

✅ Correct Answer: 2

What is the use of Library cache?

1. Contains User information, such as user privileges
2. Used to store shared SQL
3. Log of changes made to the database
4. All of the Mentioned

✅ Correct Answer: 2

Which of the following segment is destroyed when the SQL statement is finished?

1. Data Segment
2. Object Segment
3. Temporary Segment
4. All of the mentioned

✅ Correct Answer: 3

What is the use of an index?

1. Retrieve data more quickly and efficiently
2. Related data requires much less I/O overhead if accessed simultaneously
3. Simplify the user’s perception of data access
4. All of the Mentioned

✅ Correct Answer: 1

What is the use of extent in Oracle?

1. Stores user data within the database
2. Stores rollback information used when data must be rolled back
3. Minimize the amount of wasted (empty) storage
4. None of the mentioned

✅ Correct Answer: 3

Which area of PGA stores binding variables and run-time buffers information?

1. SQL area
2. Private SQL area
3. Stack space
4. Session area

✅ Correct Answer: 2

The ____________ contains a set of tables and views that Oracle uses as a reference to the database.

1. PGA
2. Library cache
3. Data dictionary
4. SGA

✅ Correct Answer: 3

In Oracle, which of below are types of segments?

1. Permanent Segment
2. Object Segment
3. Data Segment
4. All of the Mentioned

✅ Correct Answer: 3

The Oracle environment of database is called as _____

1. Database Schema
2. Database Instances
3. Data Structure
4. All of the Mentioned

✅ Correct Answer: 2

Which is the smallest unit of storage in an Oracle database?

1. Data Block
2. Segment
3. Extent
4. Data File

✅ Correct Answer: 1

Collection of information stored in database at particular instance of time is called as ____

1. Instance of Database
2. Objects in Databases
3. Data structure
4. Database Schema

✅ Correct Answer: 1

Oracle database’s design is also called as_____

1. Database Abstraction
2. Database Instance
3. Database Schema
4. none of the mentioned

✅ Correct Answer: 3

What are the valid Oracle database schemas?

1. Logical Schema
2. Physical Schema
3. Logical and Physical Schema
4. None of the mentioned

✅ Correct Answer: 3

What do the schema objects comprise of?

1. Table
2. Index
3. Cluster
4. All of the Mentioned

✅ Correct Answer: 4

Map entities, attributes and relations in Oracle is represented by_____

1. Conceptual Schema
2. Logical Schema
3. Physical Schema
4. All of the Mentioned

✅ Correct Answer: 2

Modification schema of oracle database in one level without affecting the schema in high level is called as _______

1. Data Migration
2. Data Isolation
3. Data Independence
4. Data Abstraction

✅ Correct Answer: 3

A _____ is used to logically group data together

1. Database
2. Tablespace
3. Datafiles
4. Object

✅ Correct Answer: 2