Let's test your oracle database skills. Press start to initiate the quiz .
Start
Congratulations - you have completed .
You scored %%SCORE%% out of %%TOTAL%%.
Your performance has been rated as %%RATING%%
Your answers are highlighted below.
Question 1 |
How many datafiles can be created in a BIG tablespace ?
A | 1 |
B | 10 |
C | unlimited |
D | 99 |
Question 1 Explanation:
A big file tablespace can have only one datafile , which can be extended upto 128 TB.
Question 2 |
READ ANY TABLE privilege is available from which oracle version?
A | 10g |
B | 11g |
C | 12c |
D | no such privilege available |
Question 3 |
Which parameter defines the default location of oracle managed datafiles?
A | DB_CREATE_ONLINE_LOG_DEST |
B | DB_CREATE_FILE_DEST |
C | DB_RECOVERY_FILE_DEST |
D | LOG_ARCHIVE_DEST |
Question 4 |
To start the database in nomount stage, what is the minimum requirement?
A | valid controlfile should be present |
B | just a valid parameter file(pfile/spfile) is sufficient. |
C | all datafiles should be present. |
D | db should be in archivelog. |
Question 5 |
What is the default Oracle block size?
A | 2KB |
B | 8KB |
C | 4KB |
D | 32KB |
Question 6 |
Which tool can be used to configure listener ?
A | DBCA |
B | DBUA |
C | NETCA |
D | DGMGRL |
Question 7 |
In order to increase the size of redo log file, which one of the below is correct?
A | DB SHOULD BE IN MOUNT STAGE |
B | DB SHOULD BE IN ARCHIVE LOG MODE |
C | IT CAN BE DONE ONLINE WITHOUT ANY DOWNTIME |
D | DATABASE SHOULD DOWN COMPLETELY. |
Question 7 Explanation:
increasing redolog size means, Just add a new redolog of higher size and drop the inactive redologs. And it can done when the database is open.
Question 8 |
Which one of the following is not true regarding oracle 12.1.0.2 database?
A | We can move a table online. |
B | We can move a datafile online. |
C | We can move a partition online. |
D | We can add multiple partitions in one command. |
Question 8 Explanation:
We can move table online from 12.2 Release onward only.
Question 9 |
Which one of the following is true regarding oracle 12.1.0.2 database?
A | catbundle.sql script is used post psu patching. |
B | Import can be done without generating archivelog . |
C | Datafile cannot be renamed online. |
D | Datafile cannot be moved online. |
Question 9 Explanation:
A new parameter DISABLE_TRANSOFRM parameter is impdp is introduced which will supress the log redolog generation during import operation from oracle 12cR1 onwards.
Once you are finished, click the button below. Any items you have not completed will be marked incorrect.
Get Results
There are 9 questions to complete.
← |
List |
→ |
Return
Shaded items are complete.
| 1 | 2 | 3 | 4 | 5 |
| 6 | 7 | 8 | 9 | End |
Return
You have completed
questions
question
Your score is
Correct
Wrong
Partial-Credit
You have not finished your quiz. If you leave this page, your progress will be lost.
Correct Answer
You Selected
Not Attempted
Final Score on Quiz
Attempted Questions Correct
Attempted Questions Wrong
Questions Not Attempted
Total Questions on Quiz
Question Details
Results
Date
Score
Hint
Time allowed
minutes
seconds
Time used
Answer Choice(s) Selected
Question Text
All done
Need more practice!
Keep trying!
Not bad!
Good work!
Perfect!
