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 choices lists an alter user option that can be executed by the user herself or himself?

temporary tablespace

identified by

profile

default tablespace

Question 1 of 40

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

Many tablespaces can share one datafile.

One tablespace has only one datafile.

One tablespace can have many datafiles.

One datafile can contain many tablespaces.

Question 2 of 40

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

select

insert

delete

update

Question 3 of 40

4. 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;

Set LOG_BLOCK_CHECKSUM in the init.ora file.

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

Question 4 of 40

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

revoke admin option from create any table;

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;

None of these

Question 5 of 40

6. 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 a time-out occurs

When a checkpoint occurs

When the shared pool is flushed

Question 6 of 40

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

Instance failure

Human error

Statement failure

Process failure

Question 7 of 40

8. 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 buffer cache keep area

Large pool area

In the redo log buffer

Question 8 of 40

See also How to Stop/Start HFM services

SCOTT

SYSTEM

PUBLIC

SYS

Question 21 of 40

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

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

Whether AUTOEXTEND is in use on datafiles for the tablespace

Presence of objects in the datafile resized

Availability of space on disk where datafiles are added

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

Question 23 of 40

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

The server process obtains information for the user.

The user process obtains information on its own.

The listener process obtains information for the user.

The DBW0 process obtains information for the user

Question 24 of 40

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

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

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.

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.

Question 25 of 40

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

Control file

Shared pool

SGA

Question 26 of 40

27. 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_FREES_SPACE

DBA_INDEXES

DBA_OBJECTS

Question 27 of 40

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

RC_SOURCE_SCRIPT

RC_STORED_SCRIPT_LINE

RC_STORED_SCRIPT

Question 28 of 40

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

Sequence segment

Temporary segment

Data segment

Undo segment

Question 29 of 40

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

Cannot perform any backups in this mode

Can only perform logical backups

Whole database backup while the database is open

Question 30 of 40

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

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

PGA

Dictionary cache

Library cache

Row cache

Question 32 of 40

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

utlrp.sql

control01.ctl

init.ora

pwdORCL.ora

Question 33 of 40

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

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

You need to keep the tablespace in backup mode explicitly.

You need to make the tablespace offline.

Question 34 of 40

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

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

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

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 returns an error.

Question 36 of 40

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

identified by

quota on

default tablespace

profile

Question 37 of 40

38. 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 redo log

alter system

alter database

alter user

Question 38 of 40

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

shutdown transnational

shutdown normal

shutdown immediate

Question 39 of 40

40. 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 create table privileges to the user

Unlock the user's account

Reset the user's password

Grant the CONNECT role to the user

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