Practice online oracle dba quiz

I am presenting here the Oracle DBA quiz. I hope you like it

This Oracle DBA online test check the understanding on various topics like RMAN, Oracle Structures,Backup & recovery , Oracle Memory structure, Background processes, Dictionary views , alert logs ,oracle tablespace ,indexes , profiles and many more

The below test is randomized Oracle DBA quiz and select 40 questions from the set of many questions,so each time you try to attempt it, you will get different questions in different order and option would also be in different order, So it will be fun practicing with this tool. You can try as many times as you want till you feel comfortable about it

Instructions for online test

1.This quiz consists of 40 questions .It is recommended to complete the test in 60 min
2. It consists both single choice and more than one choice questions to test your knowledge
3. You can press the submit button at the end of your test and get the final score
4.You will also get the know the correct choice after you finished the test.

1. Which two of the following items are required for killing a user session?

Username

SID

Serial number

Password

Question 1 of 40

2. The DBA issues the following statement:
CREATE USER APPLDBA
IDENTIFIED BY APPLDBA;
What profile will user APPLDBA have?

DEFAULT

CONNECT

None

DBA

Question 2 of 40

3. You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources?

SGA

Library cache

Shared pool

Control file

Question 3 of 40

4. The location of indexes in a database and the size of those indexes is information that can be found in which of the following dictionary views?

DBA_INDEXES

DBA_SEGMENTS

DBA_OBJECTS

DBA_FREES_SPACE

Question 4 of 40

5. You are defining storage for various segment types in the Oracle database. Which of the following is not a valid type of segment in Oracle?

Temporary segment

Sequence segment

Undo segment

Data segment

Question 5 of 40

6. You want to perform some maintenance and You issue the shutdown command at 9 p.m. on a Saturday. One hours later, the database is still in the process of shutting down. Which of the following options did you most likely use in order to shut down the database?

shutdown immediate

shutdown transnational

shutdown normal

shutdown abort

Question 6 of 40

7. A organization is taking online backups of the database, with the database operating in ARCHIVELOG mode. Due to a media failure they lost the SYSTEM tablespace data files. What must they do to recover the data files?

Shut down the database, restore the lost file, mount the database, and recover the database

Take the tablespace offline, restore the lost file, and issue the RECOVER TABLESPACE command

Take the tablespace offline; restore the lost file, and issue the RECOVER DATAFILE command

Shut down the database, restore all the Oracle files, and open the database with the RESETLOGS option

Question 7 of 40

8. Which one of the following statements is true while taking tablespace backups using RMAN?

You need to make the tablespace offline.

You need to keep the tablespace in backup mode explicitly.

RMAN generates extra redo information during online backups when compared with user-managed online backups.

RMAN does not require the tablespace to be in backup mode

Question 8 of 40

9. We are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?

One tablespace can have many datafiles.

One datafile can contain many tablespaces.

Many tablespaces can share one datafile.

One tablespace has only one datafile.

Question 9 of 40

10. You are processing an update statement. At what point in SQL statement processing is the data change actually made to block buffers?

When the statement is executed

When the statement is parsed

When the cursor is opened

When data is fetched from the cursor

Question 10 of 40

11. A disk crashes that contains the only copies of all four of your online redo log files. How would you alter your Oracle database to prevent this from causing much damage in the future?

Use the alter database add LOGFILE GROUP 5;

Change the CONTROL_FILES parameter in the init.ora file.

Create multiple members for each of your four groups and place them on different disks.

Set LOG_BLOCK_CHECKSUM in the init.ora file.

Question 11 of 40

12. Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener?

PMON

SMON

CKPT

LCK

Question 12 of 40

13. You are attempting to locate your control files on an Oracle database called TEST. In which of the following files might you look for this information?

init.ora

control01.ctl

utlrp.sql

pwdORCL.ora

Question 13 of 40

14. Which of the following operations do not require Oracle to store information in an undo segment as part of the transaction?

insert

delete

update

select

Question 14 of 40

15. You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?

Writes current redo log number to datafile headers

Reads information into memory for users

Writes dirty buffers to disk

Writes redo log information to disk

Question 15 of 40

16. You are performing the steps that will create your Oracle data dictionary. The objects in the Oracle data dictionary are part of which of the following schemas?

SCOTT

SYS

PUBLIC

SYSTEM

Question 16 of 40

17. You issue the alter tablespace read only command against an Oracle database. Which of the following choices best describes what happens next?

Oracle returns an error.

Oracle puts the tablespace into read-only mode after the last prior transaction against that tablespace commits while preventing subsequent DML until the change happens.

Oracle immediately puts the tablespace into read-only mode.

Oracle puts the tablespace into read-only mode after the last user logs off.

Question 17 of 40

18. The user is selecting data from the Oracle database. Which of the following processes handles obtaining data from Oracle for that user?

The listener process obtains information for the user.

The server process obtains information for the user.

The DBW0 process obtains information for the user

The user process obtains information on its own.

Question 18 of 40

19. Session information when dedicated servers are being used is stored where in the Oracle database?

In the shared pool area

Large area

In the redo log buffer

In the PGA

In the buffer cache keep area

Question 19 of 40

20. Your Oracle EMP table contains many unique values in the FIRST_NAME column. You want to index that column to take advantage of this fact in query access. Which of the following indexes might you use?

reverse key index

Simple B-tree index

Bitmap Index

Function-based index

Question 20 of 40

21. You are implementing control file multiplexing. Which of the following choices identifies how Oracle knows the locations of the control files it is supposed to maintain?

Values specified in V$DATABASE.

Oracle knows automatically where to look.

Values specified for CONTROL_FILES.

Values specified for BACKGROUND_DUMP_DEST.

Question 21 of 40

22. Which one of the following statements is incorrect with respect to RMAN's CROSSCHECK command?

It updates the non-availability of the files by updating the information in the recovery catalog with the appropriate status.

It identifies the backup sets or image copies that are either corrupted or have been accidentally deleted.

RMAN crosschecks the availability of the backup sets by verifying the information stored in its repository with the backup sets that are physically available.

RMAN automatically deletes information pertaining to the image copy from the repository if it is physically not available.

Question 22 of 40

23. You alter a tablespace’ s default storage settings in the Oracle database to increase the size of initial extents. Which of the following choices identifies when the change will take effect for tables that already exist in that tablespace?

The change takes effect when data is removed from the table.

The change takes effect immediately.

The change will not take effect for existing tables.

The change takes effect when data is added to the table.

Question 23 of 40

24. You need to remove a column from the database. Which of the following choices best identifies how to do so if your objective is to quickly execute the task without necessarily freeing up space in your tablespace?

alter table modify column

alter table set unused column

alter table drop column

truncate table

Question 24 of 40

25. The best choice for decreasing size requirements for tables that need only be accessed via the primary key in oracle is which of the following?

Create an index-organized table to store the data.

Increase the PCTFREE value set for table blocks.

Drop the primary key

Create more indexes on the table.

Question 25 of 40

26. A User accidentally drops a very critical table. What kind of failure just occurred?

Human error

Instance failure

Process failure

Statement failure

Question 26 of 40

27. If you wished to make it so that every user in Oracle could have only one connection to the database at a time, which of the following choices identifies how you would do it?

Set IDLE_TIME in the DEFAULT profile to 1

Set LICENSE_MAX_SESSIONS = 1 in init.ora

Set SESSIONS_PER_USER = 2 in init.ora

Set SESSIONS_PER_USER in the DEFAULT profile to 1

Question 27 of 40

28. To allocate another role to a user, which command is most appropriate?

alter system

grant

alter user

alter database

Question 28 of 40

29. Which of the following choices lists an alter user option that can be executed by the user herself or himself?

temporary tablespace

default tablespace

profile

identified by

Question 29 of 40

30. On an Oracle server installation, which of the following reorganizations of your indexes would be appropriate in order to improve performance of queries on tables containing all words in the dictionary starting with the letter 'S'?

Convert your bitmap index to a B-tree index.

Convert your reverse-key index to a B-tree index.

Convert your B-tree index to a bitmap index.

Convert your B-tree index to a reverse-key index.

Question 30 of 40

31. You are considering using the MTS architecture on the Oracle database. Session information when shared servers are being used is stored where in the Oracle database?

In the PGA

In the shared pool

In the redo log buffer

Large pool area

In the buffer cache keep area

Question 31 of 40

32. As the DBA, you are attempting to limit user's misuse of Oracle's ability to use host machine resources. Which of the following features of the Oracle database is useful for this purpose?

Parameter files

Profiles

Roles

Undo segments

Question 32 of 40

33. You have assigned 10 tables to the keep pool. How should you determine the appropriate size for your keep pool?

Based on the size of your shared pool

Based on the number of blocks in associated indexes only

Based on the number of blocks in the table only

Based on the number of blocks in the table plus blocks in associated indexes

No Answer is Correct

Question 33 of 40

34. You attempt to issue the alter tablespace rename datafile command in the Oracle database. Which of the following choices indicates a step that must take place after this command is issued?

Physically move the datafile to the new location

Bring the tablespace offline

Bring the tablespace online

Execute IMPORT to load the new metadata

Question 34 of 40

35. You are about to drop a tablespace. Which of the following statements can be used for dropping tablespaces that contain parent tables in foreign key relationships?

alter tablespace offline immediate

drop tablespace including contents

drop tablespace cascade constraints

alter database datafile offline drop

Question 35 of 40

36. Which one of the following RMAN views must you query to view the code of an existing stored script in the recovery catalog?

RC_STORED_SCRIPT

RC_STORED_SCRIPT_CODE

RC_SOURCE_SCRIPT

RC_STORED_SCRIPT_LINE

Question 36 of 40

37. You are working in an organization which is situated in many countries. You maintain databases in multiple countries in multiple languages. To determine the date conventions for a database in a particular country, you might use which of the following database views?

V$NLS_VALID_VALUES

V$NLS_PARAMETERS

DBA_DATES

NLS_DATE_FORMAT

Question 37 of 40

38. Which of the following clauses are available in alter user statements but not in create user statements?

identified by

default role

profile

temporary tablespace

Question 38 of 40

39. You want to find out the names and locations of all control files in your database. Which two of the following performance views would you query?

V$CONTROLFILE

V$PARAMETER

V$CONTROLFILE_RECORD_SECTION

V$DATABASE

Question 39 of 40

40. You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?

DBA_TABLES

SYS.AUD$

EMP

V$DATABASE

Question 40 of 40

I hope you like this Oracle DBA online quiz and it helps in your examination preparation. Best of Luck for the Oracle certification Examination. Please do provide feedback on it. We will also be adding more quizzes and questions in future.

Happy Learning!!!!

Related Articles
How to prepare for OCI Associate Certified Examination
Oracle sql online test
Tips for Passing OCI examination
Oracle Performance & Tuning Quiz

Instructions for online test

Reader Interactions

Leave a Reply Cancel reply