Oracle Quizzer
Settings
ORACLE SQLORACLE PL/SQLORACLE DBA
- 1.
- A.
Library Cache
- B.
PGA
- C.
SGA
- D.
Shared Pool
- E.
SQL Area
- 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
- 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
- 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
- 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
- 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
- 7.What is the best PCTINCREASE value for a Temporary tablespace?
- A.
100
- B.
80
- C.
50
- D.
10
- E.
0
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 15.Which Oracle background process is responsible for coalescing free space?
- A.
PMON
- B.
LGWR
- C.
SMON
- D.
ARCH
- E.
None of the above
Back to top