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 of the following clauses in a create user statement restricts the number of tables a user can add to a tablespace?

profile

quota on

default tablespace

identified by

Question 1 of 40

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

Buffer cache

Session UGA

Library cache

Row cache

Question 2 of 40

3. You need to identify the remaining free space in a tablespace. From which of the following views would you get this information most easily?

DBA_TABLESPACES

V$TABLESPACE

DBA_FREE_SPACE

DBA_EXTENTS

Question 3 of 40

4. 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 added to the table.

The change will not take effect for existing tables.

The change takes effect immediately.

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

Question 4 of 40

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

pwdORCL.ora

utlrp.sql

init.ora

control01.ctl

Question 5 of 40

6. User JOHN has create any table privilege with administrative abilities on that privilege. Which of the following statements show how to revoke the administrative component from JOHN without limiting her overall ability to create tables?

None of these

revoke admin option from create any table; then grant create any table to JOHN;

revoke create any table from JOHN; then grant create any table to JOHN;

revoke admin option from create any table;

Question 6 of 40

7. You issue the following statement in Oracle:
CREATE UNIQUE BITMAP INDEX empl_lastname_indx_01
ON employee (lastname ASC);
What is wrong with this statement for dictionary-managed tablespaces?

Bitmap indexes cannot be unique.

The tablespace clause must be omitted.

You cannot use the nosort keyword in creating an index.

You should omit the asc keyword.

Question 7 of 40

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

9. 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_LINE

RC_STORED_SCRIPT

RC_STORED_SCRIPT_CODE

RC_SOURCE_SCRIPT

Question 9 of 40

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

Can only perform logical backups

Whole database backup after the database is gracefully closed

Whole database backup while the database is open

Cannot perform any backups in this mode

Question 10 of 40

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

Availability of space on disk where datafiles are added

Whether AUTOEXTEND is in use on datafiles for the tablespace

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

Question 11 of 40

12. Information in the buffer cache is saved back to disk in each of the following situations except one. In which situation does this not occur?

When a log switch occurs

When the shared pool is flushed

When a checkpoint occurs

When a time-out occurs

Question 12 of 40

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

profile

temporary tablespace

identified by

default tablespace

Question 13 of 40

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

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.

You need to make the tablespace offline.

RMAN does not require the tablespace to be in backup mode

Question 14 of 40

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

Unlock the user's account

Grant create table privileges to the user

Grant the CONNECT role to the user

Reset the user's password

Question 15 of 40

16. 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 dirty buffers to disk

Reads information into memory for users

Writes current redo log number to datafile headers

Writes redo log information to disk

Question 16 of 40

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

18. 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 redo log buffer

In the PGA

In the buffer cache keep area

In the shared pool

Large pool area

Question 18 of 40

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

When the cursor is opened

When data is fetched from the cursor

When the statement is parsed

When the statement is executed

Question 19 of 40

See also Histograms in Oracle

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

In the buffer cache keep area

Large area

In the shared pool area

In the PGA

In the redo log buffer

Question 20 of 40

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

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

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 DATAFILE command

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

Question 21 of 40

22. 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 user process obtains information on its own.

The server process obtains information for the user.

The DBW0 process obtains information for the user

Question 22 of 40

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

BACKGROUND_DUMP_DEST

USER_DUMP_DEST

LOG_ARCHIVE_DEST

CORE_DUMP_DEST

Question 23 of 40

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

DBA_DATES

V$NLS_VALID_VALUES

NLS_DATE_FORMAT

Question 24 of 40

25. 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 database datafile offline drop

drop tablespace including contents

alter tablespace offline immediate

drop tablespace cascade constraints

Question 25 of 40

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

alter system

alter database

grant

alter user

Question 26 of 40

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

insert

delete

select

update

Question 27 of 40

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

PMON

ARCH

DBW0

SMON

LGWR

Question 28 of 40

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

identified by

profile

temporary tablespace

default role

Question 29 of 40

30. 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 transnational

shutdown immediate

shutdown abort

shutdown normal

Question 30 of 40

31. 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$PARAMETER

V$CONTROLFILE

V$CONTROLFILE_RECORD_SECTION

V$DATABASE

Question 31 of 40

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

Oracle knows automatically where to look.

Values specified for BACKGROUND_DUMP_DEST.

Values specified for CONTROL_FILES.

Values specified in V$DATABASE.

Question 32 of 40

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

Library cache

SGA

Shared pool

Control file

Question 33 of 40

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

CKPT

SMON

LCK

PMON

Question 34 of 40

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

Undo segment

Temporary segment

Sequence segment

Question 35 of 40

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

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

Undo segments

Roles

Parameter files

Profiles

Question 37 of 40

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

SYS.AUD$

V$DATABASE

EMP

DBA_TABLES

Question 38 of 40

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

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

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

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

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

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

Question 39 of 40

40. 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 database

alter user

alter system

alter redo log

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

Related Posts

Leave a Comment Cancel Reply