🧪 Oracle DB MCQ Quiz Hub

1. A ____ is a set of tables physically stored together as one table that shares a common column
Index
Object
Datafiles
Cluster

2. Where is data dictionary kept?
SYSTEM Tablespace
Stack Space
Data File
None of the mentioned

3. The ORDER BY clause can only be used in _______
SELECT queries
INSERT queries
GROUP BY queries
HAVING queries

4. Which of the following rule below are categories of index?
Column and Functional
Multiple Column and Functional
To create an index in another schema
none of the mentioned

5. What is the purpose of SMON (System Monitor Process) background process?
Performs crash recovery when a failed instance starts up again
Performs recovery when a user process fails
Writes redo log entries to disk
All of the Mentioned

6. Recycle bin can be turned on or off this. This parameter is stored in which of the below file?
PARAMETER FILE
PARFILE
DATAFILES
PFILE

7. When a transaction modifies the database, Oracle copies the original data before modifying it. The original copy of the modified data is called
Undone Data
Archive Data
Redo Data
Undo Data

8. What does DLL stand for ?
Dynamic Link Library
Dynamic Language Library
Dynamic Load Library
none of the mentioned

9. POST-BLOCK trigger is also a ?
Navigational Trigger
Key Trigger
Transaction Trigger
All of the Mentioned

10. The system variable that records the select statement that SQL * FORMS most recently used to populate a block is ____
SYSTEM.LAST_RECORD
SYSTEM.CURSOR_RECORD
SYSTEM.CURSOR_FIELD
SYSTEM.LAST_QUERY

11. In Oracle, which of the following package procedure is UNRESTRICTED ?
CALL_INPUT
CLEAR_BLOCK
EXECUTE_QUERY
USER_EXIT

12. What is SQL * FORMS ?
SQL * FORMS is a 4GL tool for developing and executing Oracle based interactive based application
SQL * FORMS is a 3GL tool for connecting to a Database
SQL * FORMS is a reporting tool
None of the mentioned

13. Which of the following statement is false ?
Any procedure can raise a error and return an user message and error number
Error number is ranging from 20000 to 20999 are reserved for user defined messages
Oracle checks Uniqueness of User defined errors
Raise_Application_error is used for raising an user defined error

14. What is the result of the following ‘PAN’NULL’KAJ’?
Error
PAN KAJ
PANKAJ
NULL

15. Below is the EMP table EMPNO ENAME SALARY A29 PANKAJ 10000 A23 SAHIL 20000 A48 ABHYUDAY A83 KRISHNA 30000 Select count(SALARY) from EMP; will result in
1
0
3
None of the mentioned

16. What will be the value of svar after execution? Declare fvar number :=null; svar number :=5; Begin goto <<>> if fvar is null then <<>> svar:=svar+5; end-if; End;
Error
10
5
None of the mentioned

17. Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?
select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null;
select job, sum(Sal) from Emp where comm is null group by job having sum(Sal) > 2500;
select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null group by job;
select job, sum(Sal) from Emp group by job having sum(Sal) > 2500 and comm is not null;

18. What SYSTEM VARIABLE is used to refer DATABASE TIME ?
$$dbtime$$
$$time$$
$$datetime$$
none of the mentioned

19. You notice that the database instance takes a long time to start up after the instance crash. How will you resolve the problem?
Increase the size of the redo log files
Decrease the number of redo log members
Set LOG_CHECKPOINT_TO_ALERT to TRUE
Decrease the value for the FAST_START_MTTR_TARGET initialization parameter

20. Which statement is correct regarding undo management?
The database can have more than one undo tablespaces
The undo data must be purged manually when the transaction is over
The UNDO_TABLESPACE parameter is valid only if the UNDO_MANAGEMENT parameter is set AUTO OFF
Undo management is automatic by default even if the UNDO_MANAGEMENT initialization parameter is set to NULL

21. Which operations can be performed using the Data Recovery Ad-visor?
Diagnosing data failure
It is a percentage of rows in which the statistics are collected incrementally for partitions
Presenting appropriate repair options
Generating reports for possible causes of failure

22. A user receives the following error while executing a query: ORA-01555: snapshot too old Predict one way to avoid such errors in near future.
Increase the size of redo log files
Increase the size of the undo tablespace
Increase the size of the Database Buffer Cache
Increase the size of the default temporary tablespace

23. You want to be warned automatically when more than 100 sessions are opened with your database instance.Identify the action that would help you achieve this.
Set the TRACE_ENABLED parameter to TRUE
Set the threshold for the Current Logons Count metric
Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE
Set the SESSIONS_PER_USER limit in the profiles used by users

24. You created a new user on the database 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 true in this scenario?
The user can not create tables
The user can create tables
The user cannot query any tables
None of the mentioned

25. Examine the following settings for the initialization parameters: MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M SGA_TARGET=300M PGA_AGGREGATE_TARGET=70M Which statement is true about the memory management for the newly started database instance?
MEMORY_TARGET defines the maximum limit for SGA_TARGET
SGA_TARGET and PGA_AGGREGATE_TARGET combined will never grow beyond 500M
The value for MEMORY_MAX_TARGET is the sum of SGA_TARGET and PGA_AGGREGATE_TARGET
SGA_TARGET and PGA_AGGREGATE_TARGET will keep growing till a maximum of 300M and 70M, respectively

26. Database management systems are intended to ______
Eliminate data redundancy
Establish relationship among records in different files
Manage file access
All of the Mentioned

27. One approach to standardization storing of data ?
MIS
Structured programming
CODASYL specification
None of the mentioned

28. The language used application programs to request data from the DBMS is referred to as the
DML
DDL
Query language
All of the Mentioned

29. Report generators are used to
Store data input by a user
Retrieve information from files
Answer queries
Retrieve information from files and Answer queries

30. The management information system (MIS) structure with one main computer system is called a
Hierarchical MIS structure
Distributed MIS structure
Centralized MIS structure
Decentralized MIS structure

31. Which of the following is not true of the traditional approach to information processing
There is common sharing of data among the various applications
It is file oriented
Programs are dependent on the file
All of the Mentioned

32. Choose the RDBMS which supports full fledged client server application development
dBase V
Oracle 7.1
FoxPro 2.1
Ingress

33. Which of the following situation requires the use of ID-dependent entities ?
Association relationships only
Multivalued attributes only
Instance relationships only
All of the Mentioned

34. Which of the following statements concerning business rules is true?
It should be complex.
It should not be convertible to computer code.
It may include restrictions.
All of the Mentioned

35. In order to use a record management system
you need to understand the low level details of how information is stored
you need to understand the model the record management system uses
you need to understand both information storage and the model of record management system
None of the mentioned

36. A collection of data designed to be used by different people is called a/an
Organization
Database
Relationship
Schema

37. Which of the following is the process of selecting the data storage and data access characteristics of the database?
Logical database design
Physical database design
Testing and performance tuning
Evaluation and selecting

38. The relationship between DEPARTMENT and EMPLOYEE is a
One-to-one relationship
One-to-many relationship
Many-to-many relationship
Many-to-one relationship

39. If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called
Consistent state
Inconsistent state
Durable state
Atomic state

40. When an entity instance must be a member of only one sub-type, it is which of the following?
Disjoint with total specialization
Disjoint with partial specialization
Overlap with total specialization
Overlap with partial specialization

41. A supertype/subtype hierarchy is which of the following?
Each subtype has only one attribute
Each supertype has only one attribute
Each subtype has only one supertype
Each supertype has only one subtype

42. Use of a supertype/subtype relationship is necessary when which of the following exists?
An instance of a subtype participates in a relationship that is unique to that subtype
An instance of a subtype participates in a relationship that is the same as the other subtypes
Attributes apply to all of the instances of an entity type
No attributes apply to any of the instances of an entity type

43. Which of the following is not one of the three ways to classify an action assertion?
Condition
Integrity Control
Authorization
Enabler

44. A BI reporting system does not _______
Create meaningful information
Deliver information to users on a timely basis
Use statistical procedures to predict future events
Use disparate data sources

45. The “curse of dimensionality” relates to which problem of using operational data for BI reporting?
Dirty data
Inconsistent data
Too much data
Non-integrated data

46. A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?
Push
Pull
RFM
OLAP

47. Business Intelligence (BI) reporting systems cannot do which of the following operations?
Filter data
Group data
Modify data
Both filter and group data

48. Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row
Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column
Three rows have the values Brown, NULL, and Blue in the same column
One row has the value “He is interested in a Silver Porsche from the years 1978-1988” in a column

49. The benefits of a standard relational language include which of the following ?
Reduced training costs
Increased dependence on a single vendor
Applications are not needed
All of the Mentioned

50. Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = ‘VA’;
SELECT NAME IN CUSTOMER WHERE STATE IN (‘VA’);
SELECT NAME IN CUSTOMER WHERE STATE = ‘VA’;
SELECT NAME IN CUSTOMER WHERE STATE = ‘V’;
SELECT NAME FROM CUSTOMER WHERE STATE IN (‘VA’);