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. 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?

Change the CONTROL_FILES parameter in the init.ora file.

Use the alter database add LOGFILE GROUP 5;

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 1 of 40

2. 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 drop column

alter table modify column

alter table set unused column

truncate table

Question 2 of 40

3. 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 B-tree index to a reverse-key index.

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.

Question 3 of 40

4. Which of the following is the init.ora parameter that indicates the size of each buffer in the buffer cache?

DB_BLOCK_BUFFERS

BUFFER_SIZE

DB_BLOCK_SIZE

ROLLBACK_SEGMENTS

Question 4 of 40

5. Which of the following choices identifies a constraint on performing alter tablespace resize operation if the intended size of the tablespace is larger than the tablespace’ s current size?

Presence of objects in the datafile resized

Whether AUTOEXTEND is in use on datafiles for the tablespace

Availability of space on disk where datafiles are added

Availability of space in memory for temporary storage of blocks in tablespace

Question 5 of 40

6. 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?

Data segment

Temporary segment

Undo segment

Sequence segment

Question 6 of 40

7. You issue the following statement from SQL*Plus: startup mount. Where does Oracle obtain values for starting the instance?

From the default settings in your redo log file

From Oracle default values in OS

From your init.ora file or spfile

From the default settings for the tablespace

Question 7 of 40

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

alter system

alter user

grant

alter database

Question 8 of 40

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

Human error

Statement failure

Process failure

Instance failure

Question 9 of 40

10. 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 BACKGROUND_DUMP_DEST.

Values specified for CONTROL_FILES.

Question 10 of 40

11. When choosing a character set and national character set, which of the following factors should not enter into consideration?

Oracle supports only English-like languages as its character set for entering SQL and PL/SQL commands

Your character set must either be US7ASCII or a superset of it.

Your national character set and character set should be closely related where possible.

You can use variable-length multibyte character sets as both character sets on your database.

Question 11 of 40

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

Shared pool

Control file

SGA

Library cache

Question 12 of 40

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

Oracle immediately puts the tablespace into read-only mode.

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 puts the tablespace into read-only mode after the last user logs off.

Oracle returns an error.

Question 13 of 40

14. After creating a new user for your Oracle database, a user still complains he or she cannot log in because of insufficient privileges errors. Which of the following actions should you take?

Grant the CONNECT role to the user

Grant create table privileges to the user

Reset the user's password

Unlock the user's account

Question 14 of 40

15. You are trying to find the ALERT file on a host machine for a database (11g and below) you have never administered before. Which of the following initialization parameters is used to identify the location of the ALERT file?

LOG_ARCHIVE_DEST

CORE_DUMP_DEST

USER_DUMP_DEST

BACKGROUND_DUMP_DEST

Question 15 of 40

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

CKPT

PMON

LCK

SMON

Question 16 of 40

17. You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?

alter system

alter database

alter redo log

alter user

Question 17 of 40

18. 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 18 of 40

19. 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

Function-based index

Bitmap Index

Question 19 of 40

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

Reads information into memory for users

Writes dirty buffers to disk

Writes current redo log number to datafile headers

Writes redo log information to disk

Question 20 of 40

21. A DBA manages a database that is operating in NOARCHIVELOG mode. Which one of the following options should he include in his backup strategy?

Whole database backup after the database is gracefully closed

Whole database backup while the database is open

Can only perform logical backups

Cannot perform any backups in this mode

Question 21 of 40

22. Records from the data dictionary information are stored in which of the following database memory areas?

Session UGA

Row cache

Buffer cache

Library cache

Question 22 of 40

23. You are using locally managed tablespaces in Oracle. Which of the following choices best describes the way Oracle implements this feature in the database?

Using a flat file in the local directory storing the datafile

Using the data dictionary in a distributed database

Using the data dictionary on the local database

Using a bitmap in the space header segment

Question 23 of 40

24. Which one of the following statements is incorrect about direct-path insert operations?

To load data using the serial mode, you must activate the direct-path insert by specifying the SERIAL hint.

It speeds up the insert operation, bypassing the buffer cache.

Direct-path insert can be performed when using the INSERT INTO... SELECT statement.

Direct-path insert enables you to copy data from one table to another table within the same database.

Direct-path insert can be implemented either in the serial mode or the parallel DML mode.

Question 24 of 40

25. Which of the following clauses in a create user statement restricts the number of tables a user can add to a tablespace?

default tablespace

profile

identified by

quota on

Question 25 of 40

26. 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_PARAMETERS

NLS_DATE_FORMAT

DBA_DATES

V$NLS_VALID_VALUES

Question 26 of 40

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

Large area

In the redo log buffer

In the PGA

In the buffer cache keep area

In the shared pool area

Question 27 of 40

28. 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 cascade constraints

alter database datafile offline drop

drop tablespace including contents

Question 28 of 40

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

default role

profile

temporary tablespace

identified by

Question 29 of 40

30. Which one of the following RMAN commands is equivalent to the SQL statement ALTER DATABASE RENAME FILE ?

SWITCH

RENAME

CATALOG

CHANGE

Question 30 of 40

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

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

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.

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

Question 31 of 40

32. When we issue the commit statement in the session, which of the following things will not occur?

Acquired undo segment locks are released.

Redo entry generated for committed transaction.

Cached data is saved immediately to disk.

Acquired row or table locks are released.

Question 32 of 40

33. You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas?

Buffer cache

Row cache

Library cache

PGA

Dictionary cache

Question 33 of 40

34. 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 has only one datafile.

One tablespace can have many datafiles.

Many tablespaces can share one datafile.

One datafile can contain many tablespaces.

Question 34 of 40

35. 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_SEGMENTS

DBA_INDEXES

DBA_FREES_SPACE

DBA_OBJECTS

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_SOURCE_SCRIPT

RC_STORED_SCRIPT_LINE

RC_STORED_SCRIPT_CODE

Question 36 of 40

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

Serial number

Username

Password

SID

Question 37 of 40

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

CONNECT

DBA

DEFAULT

None

Question 38 of 40

39. 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?

PUBLIC

SCOTT

SYS

SYSTEM

Question 39 of 40

40. During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?

DBW0

PMON

LGWR

ARCH

SMON

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 : This post covers on how to prepare for Oracle cloud infrastructure Associate Architect examination (1Z0 932 /1072)
Oracle sql online test :Check out this Oracle sql online test for interview preparation & certification. This will help in checking your understanding on Oracle SQL
Tips for Passing OCI examination : Here is Oracle provided tips to clear OCI certification
Oracle Performance & Tuning Quiz : Check out this Oracle performance online test for interview preparation & certification. This will help in checking your understanding on Oracle SQL
Oracle Database Quiz : This is a Oracle Database Quiz to check your understanding on Oracle concepts. This will be helpful for interview and certification examination
oracle quiz : This is a online Oracle Quiz to check your understanding on Oracle stuff like Truncate,delete, drop ,constraints, select query,distinct and many more

Instructions for online test

Reader Interactions

Leave a Reply Cancel reply