-
web.groovymark@gmail.com
- December 5, 2024
Question 41
What is the purpose of the Oracle Scheduler?
A) To manage memory allocation
B) To schedule and run jobs
C) To manage database backup and recovery
D) To handle redo log archiving
Correct Answer: B) To schedule and run jobs
Explanation: The Oracle Scheduler is used to schedule and run jobs, such as batch processing or maintenance tasks.
Question 42
Which of the following statements is true about Oracle Managed Files (OMF)?
A) OMF requires manual file management.
B) OMF automatically creates and manages data files.
C) OMF is deprecated in Oracle 12c.
D) OMF cannot be used with ASM.
Correct Answer: B) OMF automatically creates and manages data files.
Explanation: Oracle Managed Files (OMF) allows Oracle to automatically manage the creation and deletion of data files.
Question 43
Which of the following SQL statements creates an undo tablespace?
A) CREATE UNDO TABLESPACE undotbs DATAFILE ‘undotbs01.dbf’ SIZE 500M;
B) CREATE TABLESPACE undotbs UNDO FILE ‘undotbs01.dbf’ SIZE 500M;
C) CREATE TABLESPACE undotbs UNDO DATAFILE ‘undotbs01.dbf’ SIZE 500M;
D) CREATE UNDO DATAFILE undotbs SIZE 500M;
Correct Answer: A) CREATE UNDO TABLESPACE undotbs DATAFILE 'undotbs01.dbf' SIZE 500M;
Explanation: The correct syntax for creating an undo tablespace is CREATE UNDO TABLESPACE.
Question 44
Which of the following actions is performed by the Oracle listener process?
A) Manages background processes
B) Listens for and establishes client connections
C) Manages data file backups
D) Handles redo log writing
Correct Answer: B) Listens for and establishes client connections
Explanation: The listener process is responsible for listening for client connection requests and establishing connections to the database.
Question 45
Which SQL statement disables a role for the current session?
A) ALTER SESSION DISABLE ROLE;
B) SET ROLE NONE;
C) ALTER SESSION SET ROLE DISABLED;
D) ALTER ROLE DISABLE
Correct Answer: B) SET ROLE NONE;
Explanation: SET ROLE NONE disables all roles for the current session.
Question 46
Which view provides information about the files that belong to locally managed temporary tablespaces?
A) DBA_TEMP_FILES
B) DBA_DATA_FILES
C) DBA_TABLESPACES
D) DBA_FREE_SPACE
Correct Answer: A) DBA_TEMP_FILES
Explanation: The DBA_TEMP_FILES view provides information about the temporary files in locally managed temporary tablespaces.
Question 47
What is the smallest allocation unit in Oracle’s storage hierarchy?
A) Data block
B) Extent
C) Segment
D) Data file
Correct Answer: A) Data block
Explanation: The smallest allocation unit in Oracle is the data block, which consists of multiple operating-system blocks.
Question 48
Which process is responsible for updating the control files and data file headers with the latest checkpoint information?
A) CKPT
B) DBWn
C) LGWR
D) PMON
Correct Answer: A) CKPT
Explanation: The CKPT process updates the control files and data file headers with the checkpoint information.
Question 49
Which of the following components are stored in a tablespace?
A) Control files
B) Redo log files
C) Permanent segments
D) Temporary redo logs
Correct Answer: C) Permanent segments
Explanation: Permanent segments are stored in tablespaces, while control files and redo log files are stored outside tablespaces.
Question 50
Which SQL statement changes the default temporary tablespace for a user?
A) ALTER USER SET DEFAULT TEMPORARY TABLESPACE temp;
B) ALTER USER SET TEMPORARY TABLESPACE temp;
C) ALTER USER SET TEMPORARY TABLESPACE = temp;
D) ALTER USER SET TEMP = temp;
Correct Answer: B) ALTER USER SET TEMPORARY TABLESPACE temp;
Explanation: The correct statement to change a user's default temporary tablespace is ALTER USER SET TEMPORARY TABLESPACE tem
