🧪 Oracle DB MCQ Quiz Hub

1. What is Oracle?
Oracle is a programming language
Oracle is a database
Oracle is a sripting language
Oracle is an operating system

2. Which of the following is correct about Oracle?
Oracle is a relational database management system
Oracle was built in 1977
OracleDB is another name for it
All of the Mentioned

3. Which of the following database was designed first for enterprise grid computing?
Oracle database
SQL
MongoDB
Google database

4. Which of the following is not a Oracle Database feature?
Scalability
Availability
Analytics
None of the mentioned

5. Which of the following is an advantage of Oracle database?
Portability
Flashback Technology
Performance
All of the Mentioned

6. Which of the following is a disadvantage of Oracle database?
Difficult to manage
Cost
Complexity
All of the Mentioned

7. What is Oracle database used for?
Creating backup for data
Accessing database servers
Store and retrieve relevant data
Both A & C

8. Which of the following components comprise an Oracle architecture?
Tablespaces
Datafiles
Database related background processes
All of the Mentioned

9. Which of the following area of PGA stores binding variables and run-time buffers information?
Stack space
SQL area
Session area
Private SQL area

10. Which of the following is the smallest unit of storage in an Oracle database?
Segment
Extent
Data File
Data Block

11. Which of the following is another name of Oracle database’s design?
Database Instance
Database Schema
Database Abstraction
None of the mentioned

12. Which of the following is used to logically group data together?
Datafiles
Tablespace
Object
Database

13. Which of the following package procedure is UNRESTRICTED in Oracle?
CLEAR_BLOCK
USER_EXIT
CALL_INPUT
EXECUTE_QUERY

14. Oracle server configuration is dedicated for
One server process – One user process
Many server processes – Many user processes
Many server processes – One user process
One server process – Many user processes

15. Which schema object instructs Oracle to connect to remotely access an object of a database?
Database Link
Sequence
Data Link
Remote Link

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?
Redo Data
Undone Data
Undo Data
Archive Data

17. Which of the following is referred to as the language used application programs to request data from the DBMS?
DDL
Query language
DML
All of the Mentioned

18. Which of the following RDBMS supports full fledged client server application development?
FoxPro 2.1
Ingress
Oracle 7.1
dBase V

19. Which of the following is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Data Manipulation Language(DML)
Data Definition Language(DDL)
DDL and DML
None of the mentioned

20. Which of the following is not included in DML (Data Manipulation Language)?
UPDATE
CREATE
INSERT
delete

21. Which of the following keyword is used with Data Control Language (DCL) statements?
INSERT
SELECT
GRANT
DELETE

22. Which of the following command is used to obtain the structure of an Oracle table?
DESC TABLE [TableName].
STRUCTURE [TableName].
DESCRIBE [TableName].
DESCRIBE STRUCTURE [TableName].

23. Which of the following is not a type of SQL statement?
Data Definition Language (DDL)
Data Control Language (DCL)
Data Communication Language (DCL)
Data Manipulation Language (DML)

24. command to use iscommand is used for removing a table and all its data from the database?
Alter table command
Create command
Drop table command
All of the Mentioned

25. Which of the following is/are the DDL statements?
Drop
Alter
Create
All of the Mentioned

26. The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’, ‘b’), 4) FROM DUAL;
2345
456789
6789
1234

27. Which of the following command is used to SELECT only one copy of each set of duplicable rows in SQL?
SELECT UNIQUE
SELECT DIFFERENT
SELECT DISTINCT
All of the Mentioned

28. Which of the following is not a Key in SQL Server?
Alternate
Secondary
Foreign
primary

29. Which of the following is not a component of a data warehouse?
Data metadata
Data extraction/cleaning/preparation programs
Data warehouse data
none of the mentioned

30. Which of the following is the oldest database model?
Deductive
Physical
Network
relational

31. Which of the following object types below cannot be replicated?
Sequence
Data
Trigger
View

32. What is the result of the following ‘ORA’NULL’CLE’?
ORA CLE
Error
NULL
Oracle

33. The redo log buffer and Shared pool are elements of?
SGA
PGA and Buffer cache
Buffer cache
PGA

34. Which processes is an instance made of Oracle?
Data processes
Oracle background processes
Memory processes
All of the Mentioned

35. What is the use of Library cache?
Contains User information, such as user privileges
Used to store shared SQL
Log of changes made to the database
All of the Mentioned

36. Which of the following segment is destroyed when the SQL statement is finished?
Data Segment
Object Segment
Temporary Segment
All of the mentioned

37. What is the use of an index?
Retrieve data more quickly and efficiently
Related data requires much less I/O overhead if accessed simultaneously
Simplify the user’s perception of data access
All of the Mentioned

38. What is the use of extent in Oracle?
Stores user data within the database
Stores rollback information used when data must be rolled back
Minimize the amount of wasted (empty) storage
None of the mentioned

39. Which area of PGA stores binding variables and run-time buffers information?
SQL area
Private SQL area
Stack space
Session area

40. The ____________ contains a set of tables and views that Oracle uses as a reference to the database.
PGA
Library cache
Data dictionary
SGA

41. In Oracle, which of below are types of segments?
Permanent Segment
Object Segment
Data Segment
All of the Mentioned

42. The Oracle environment of database is called as _____
Database Schema
Database Instances
Data Structure
All of the Mentioned

43. Which is the smallest unit of storage in an Oracle database?
Data Block
Segment
Extent
Data File

44. Collection of information stored in database at particular instance of time is called as ____
Instance of Database
Objects in Databases
Data structure
Database Schema

45. Oracle database’s design is also called as_____
Database Abstraction
Database Instance
Database Schema
none of the mentioned

46. What are the valid Oracle database schemas?
Logical Schema
Physical Schema
Logical and Physical Schema
None of the mentioned

47. What do the schema objects comprise of?
Table
Index
Cluster
All of the Mentioned

48. Map entities, attributes and relations in Oracle is represented by_____
Conceptual Schema
Logical Schema
Physical Schema
All of the Mentioned

49. Modification schema of oracle database in one level without affecting the schema in high level is called as _______
Data Migration
Data Isolation
Data Independence
Data Abstraction

50. A _____ is used to logically group data together
Database
Tablespace
Datafiles
Object