Oracle Quizzer
ORACLE SQL
ORACLE PL/SQL
ORACLE DBA
- 1.
Which component of an instance holds session variables and arrays when you are NOT running in MTS mode?
- A.
Library Cache
- B.
PGA
- C.
SGA
- D.
Shared Pool
- E.
SQL Area
Correct Answer
B. PGAExplanation
The PGA holds session variables and arrays.Rate this question:
-
- 2.
The DBA is creating a new user. Which of the following is NOT defined at user creation?
- A.
Default role
- B.
Default tablespace
- C.
Profile
- D.
Idle_time
Correct Answer
D. Idle_timeExplanation
Idle time is defined as part of user-profile creation and is not part user creation.Rate this question:
-
- 3.
Which character function can be used to return a specified portion of a character string?
- A.
SUBSTR
- B.
INSTR
- C.
SUBSTRING
- D.
POS
- E.
SFIND
Correct Answer
A. SUBSTRExplanation
The SUBSTR function will return a specified portion of a string.Rate this question:
-
- 4.
When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
- A.
Users tablespace
- B.
System tablespace
- C.
Default tablespace for the user
- D.
Undefined
- E.
Oracle will give an error
Correct Answer
C. Default tablespace for the userExplanation
DEFAULT TABLESPACE will be used to store segments without TABLESPACE clause.Rate this question:
-
- 5.
When should one back up a read-only tablespace?
- A.
Immediately after placing the tablespace into read-only mode
- B.
Prior to placing the tablespace into read-only mode
- C.
Prior to creating a new tablespace
- D.
Prior to altering the database structure
- E.
During regular backup window
Correct Answer
A. Immediately after placing the tablespace into read-only modeExplanation
One should backup a tablespace immediately after it has been placed in read-only mode.Rate this question:
-
- 6.
Which of the following contains the records of all transactions that occur in the database and plays an essential part in database recovery?
- A.
Datafiles
- B.
Redo log files
- C.
Control files
- D.
Parameter file
Correct Answer
B. Redo log filesExplanation
All transactions are recorded in the REDO LOG files.Rate this question:
-
- 7.
What is the best PCTINCREASE value for a Temporary tablespace?
- A.
100
- B.
80
- C.
50
- D.
10
- E.
0
Correct Answer
E. 0Explanation
PCTINCREASE=0 is best for a temprary tablespace.Rate this question:
-
- 8.
Which of the following actions is required to prevent row migration on a table?
- A.
Increase PCTFREE
- B.
Decrease PCTFREE
- C.
Decrease PCTUSED
- D.
Increase PCTUSED
- E.
Increase database block size
Correct Answer
A. Increase PCTFREEExplanation
Increasing PCTFREE will allocate more space for rows to grow within the block.Rate this question:
-
- 9.
Which Oracle access method is the fastest way for Oracle to retrieve a single row?
- A.
Access via unique index
- B.
Full table scan
- C.
Primary key access
- D.
Table access by ROWID
Correct Answer
D. Table access by ROWIDExplanation
Table Access by ROWID is the fastest access path.Rate this question:
-
- 10.
Select the VALID trigger type(s)?
- A.
UPDATE row trigger
- B.
DELETE row trigger
- C.
INSERT row trigger
- D.
AFTER statement trigger
- E.
All of the above
Correct Answer
D. AFTER statement triggerExplanation
AFTER statement trigger is a valid trigger type.Rate this question:
-
- 11.
In a PL/SQL block, a variable is declared as NUMBER without an initial value. What will its value be when it is first used in the executable section of the PL/SQL block?
- A.
NULL
- B.
0
- C.
Results in a compilation error
- D.
An exception will be raised
- E.
None of the above
Correct Answer
A. NULLExplanation
Uninitialized PL/SQL variables are set to NULL.Rate this question:
-
- 12.
Which physical file contains the name and location of datafiles?
- A.
Paramerter File
- B.
Redo log file
- C.
Control File
- D.
Password File
- E.
None of the above
Correct Answer
C. Control FileExplanation
The Control File contains the name and location of datafiles.Rate this question:
-
- 13.
What output will the follwing statement produce? Select NVL2(NULL,'NOT NULL', NULL) from dual;
- A.
Function NVL2 is not defined
- B.
NOT NULL
- C.
NULL
- D.
None of the above
Correct Answer
C. NULLExplanation
NVL() accepts 2 arguments, NVL2 (new SQL function) accepts 3.Rate this question:
-
- 14.
The primary key on table CLIENTAB is the IDCLI column. Which of the following statements will not use the associated index on CLIENTAB?
- A.
Select 1 from CLIENTAB where IDCLI = '59834';
- B.
Select IDCLI, NAME from CLIENTAB where IDCLI = '59384';
- C.
Select * from CLIENTAB where IDCLI= '59384';
- D.
Select * from CLIENTAB where nvl(IDCLI, '00000') = '59384';
- E.
None of the above
Correct Answer
D. Select * from CLIENTAB where nvl(IDCLI, '00000') = '59384';Explanation
Any function, including nvl() will cause the index to be ignored.Rate this question:
-
- 15.
Which Oracle background process is responsible for coalescing free space?
- A.
PMON
- B.
LGWR
- C.
SMON
- D.
ARCH
- E.
None of the above
Correct Answer
C. SMONExplanation
SMON coalesces free space (extents) into larger, contiguous extents.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2022Quiz Edited by
ProProfs Editorial Team -
Oct 21, 2009Quiz Created by
Bruno Miguel Red
Back to top