Oracle Architecture MCQ

This Oracle Architecture MCQ test check the understanding on various topics like Recovery Manager (RMAN), Oracle Architecture concept like shared pool ,PGA, Library cache size,Backup & recovery , Oracle Memory structure, Background processes, Dictionary views , alert logs ,oracle tablespace ,indexes , profiles and many more

The below test is randomized Oracle Architecture MCQ 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. What is the significance of using the command SET NEWNAME in the script shown in the following code?
Run
{
allocate channel c1 type disk;
set newname for datafile 1 to '+DATA';
restore datafile 1;
switch datafile 1;
recover datafile 1;
sql 'Alter database open';
}

Specifies a new location in the RUN block where the data file needs to be restored

Renames the data file in the RUN block

Control file is updated with the new location specified in the RUN block

Prompts the user to enter a new name after the execution of the RUN block

Question 1 of 40

2. Which one of the following parameters when specified determines the maximum number of the files that can be stored in each backup set?

FILESPERSET

BACKUPPERSET

MAXSETSIZE

FILESPERBACKUP

Question 2 of 40

3. Which Oracle background process frees SGA resources that were allocated to a user process that failed?

LGWR

PMON

SMON

ckPt

Question 3 of 40

4. an oracle instance is made up of

sga and background process

sga and data file , control files , and redo logs

sga and the init.ora

sga , alert log, trace file

Question 4 of 40

5. What can you see when querying V$LOGMNR_CONTENTS?

The SQL statement run, and the relevant undo SQL statement.

Only the redo generated by the current schema.

The SQL statement run, and the new image.

The SQL statement run and the old image.

The old image and the new image of the row that was modified.

Question 5 of 40

6. Which one of the following views must you query from the recovery catalog database to obtain information about the backup sets that were created using RMAN?

V$BACKUP_SET

RC_DATABASE

RC_BACKUP_SET

V$BACKUPSET

Question 6 of 40

7. In which one of the following loading methods does SQL*Loader compete with the other processes to acquire buffer resources?

Direct path load

Conventional path load

Distributed path load

None of the above

Question 7 of 40

8. which of the following is the first step in oracle’s recommended tuning

tune the database

tune the application

all the above are equally important

tune the network

Question 8 of 40

9. Which one of the following views would you query to obtain information about data files that need recovery?

V$DATAFILE

V$DATAFILE_HEADER

V$DATAFILE_COPY

V$DATAFILE_RECOVERY

Question 9 of 40

10. which of the following views contains information about overall system statistics, both previously and currently connected

v$systat

v$sgastat

v$statname

v$sesstat

Question 10 of 40

11. Which three statements about fine-grained access control are true?

The application context is required.

The application context is not required, but recommended.

Security cannot be bypassed as it built into the database server.

Security can be built in the database server instead of each application.

Security cannot be bypassed as it is built into each application.

Question 11 of 40

12. Among the listed recovery method types, which recovery requires the DBA to explicitly issue a recovery command?

Crash recovery

Media recovery

Thread recovery

Instance recovery

Question 12 of 40

13. Which one of the following statements about the tnsping utility is correct?

It helps you to determine whether or not the Oracle database is running.

It requires the username and password to check the connectivity of the service.

It does not require the username and password to check the connectivity of the service.

It establishes a session with the database and checks the connectivity of the service.

Question 13 of 40

14. Which Oracle process is responsible for archiving the online redo log files when the automatic archiving feature is enabled in ARCHIVELOG mode?

ARCn

SMON

LGWR

DBWn

PMON

Question 14 of 40

15. What is the result of issuing the following command? SQL> ALTER SYSTEM SET SHARED_SERVERS=0;

The database will be restarted.

It disables the shared server.

The minimum number of shared server processes will be run.

All the existing connections will be terminated immediately.

Question 15 of 40

16. The buffers in the database buffer cache that are currently being accessed by a server process are referred to as?

Pinned buffers

Free buffers

Dirty buffers

Reuse buffers

Question 16 of 40

17. which of the following lock type is the most restrictive

exclusive

None of the above

unique

exclusion

Question 17 of 40

18. Which one of the following configuration files can be used to implement the host naming method?

sqlnet.ora, names.ora

sqlnet.ora

host.ora, tnsnames.ora

tnsnames.ora, sqlnet.ora, host.ora

sqlnet.ora, tnsnames.ora

Question 18 of 40

19. Which one of the following commands must be issued to remove a stored script from the recovery catalog?

ERASE SCRIPT

UNCATALOG SCRIPT

DELETE SCRIPT

REMOVE SCRIPT

Question 19 of 40

20. which dba view would show storage, row, and block information for an table

dba_tab_privs

dba_table_size

dba_tables

dba_objects

Question 20 of 40

21. Which one of the following Oracle components or products must be installed and configured to enable the secure communications between the client and the server over the network?

Intelligent agent

Connection Manager

Security server

Advanced network option

Question 21 of 40

22. index organized tables store row data that exceeds the index’s pct threshold in what type of segment

index segment

excess segment

overflow segment

chain segment

Question 22 of 40

23. Prior to performing an incomplete database recovery, what is the most important task that you are supposed to perform as a DBA?

Perform a full backup.

Open the database in NOMOUNT mode.

Restore the control files.

Restore the archived redo log files.

Question 23 of 40

24. Assume that you need to restore and recover a database that's operating in ARCHIVELOG mode. The archive log files available for recovery start from log sequence 21156 to 21190. If the archived log files with sequence number 21187, 21184, and 21180 are corrupted, then until which log sequence can you recover the database?

21187

21184

21190

21180

Question 24 of 40

25. Due to a media failure, all the members that are part of an online redo log group are lost. Under what conditions can you still recover the database without data loss?

You cannot perform recovery when all the members associated with an online redo log group are lost

The lost redo log group has already been archived.

The lost redo log group is the CURRENT group.

The lost redo log group is not the CURRENT group but has not yet been archived.

Question 25 of 40

26. Which one of the following statements is true about the LogMiner utility?

LogMiner can be used for media recovery.

LogMiner generates SQL_REDO as well as SQL_UNDO with primary key information.

LogMiner can be used by Oracle for log recovery.

LogMiner can be used for instance recovery.

Question 26 of 40

27. response time is a measure of

how much processing the system can do during a given amount of time

how long it takes for oracle to find data without using an index

how fast user’s pc can refresh the screen with new data

the time it takes for a single user to receive a result set back when working form within a application

Question 27 of 40

28. Which one of the following options would you use with RMAN to back up archive log files along with other files?

PLUS archivelog

ENABLE archivelog

INCLUDE archivelog

ADD archivelog

Question 28 of 40

29. Which one of the following files contains records that are rejected by SQL*Loader due to invalid input format?

Discard

Parameter file

log

Control

Bad

Question 29 of 40

30. Which one of the following statements enables the control file AUTOBACKUP feature?

RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;

RMAN>CONFIGURE CONTROLFILE AUTO ON;

RMAN>SHOW ALL;

RMAN>CONFIGURE CONTROLFILE BACKUP AUTO;

RMAN>CONTROLFILE AUTO BACKUP;

Question 30 of 40

31. which of the following components of the SGA records changes made to the database for recovery purpose

shared pool

redo log buffer

large pool

database buffer cache

Question 31 of 40

32. if the init.ora optimizer mode is set to choose, but no statistics have been generated for the application’s tables and indexes, which optimizer mode will oracle user

rule

none of the above

hint

cost

Question 32 of 40

33. throughput is a measure of

how fast a user’s pc can refresh the screen with new data

the time it takes for a single user to receive a result set back when working from within the application

how long it takes for oracle to find data without using an index

how much processing the system can do during a given amount of time

Question 33 of 40

34. Which one of the following commands can you use to display whether or not the automatic archiving feature is enabled?

ARCHIVE LOG LIST

ARCHIVE LOG STATUS

ARCHIVE LOG NEXT

ARCHIVE LOG REPORT

Question 34 of 40

35. What must you do after the completion of copying the data files while performing online database backup?

Execute the ALTER SYSTEM SWITCH LOGFILE command and copy the archive log files since the beginning of online backup.

Back up the online redo log files.

Execute the ALTER SYSTEM CHECKPOINT command.

Shut down the database gracefully and restart.

Question 35 of 40

36. To enable a database to have more than one service associated with it, the connect descriptor SID parameter in the tnsnames.ora file has been replaced by which two parameters?(Choose two)

SERVICE _NAME

DISPATCHERS.

LISTENER_NAME.

INSTANCE_NAME.

Question 36 of 40

37. which of the following factors would not make a column a good candidate for b-tree index

most queries on the table return only small portion of all row

the column frequently used in sql statement where clause

none of the above

the data in the column has low cardinality

Question 37 of 40

38. Due to a media failure the user10.dbf data file was lost. Which one of the following commands must DBA use at the RMAN prompt, to copy the data files from the backup location to their default location before performing recovery operations?

ALLOCATE

RESTORE

REINSTATE

RECOVER

Question 38 of 40

39. the alert log contains information on all but which of the following

creation of new database users

instance startup and shutdown

redo log switches

all of the above are in the alert log

Question 39 of 40

40. Which two statements are true when corrupted blocks are skipped?

If the freelist is corrupt the table has to be re-created.

Indexes pointing to corrupt blocks will be marked as invalid.

All rows in a corrupt block are inaccessible.

Queries have to be rewritten so they will skip corrupted blocks.

Referential integrity may be violated.

Only the corrupted rows within a block will be inaccessible.

Question 40 of 40

I hope you like this Oracle Architecture MCQ 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
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
Oracle DBA quiz : this is a oracle dba quiz to check your understanding on DBA concepts.This will help in Passing oracle certification examination and the interview also
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 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
https://en.wikipedia.org/wiki/Oracle_Database

Instructions for online test

Related Posts

Leave a Comment Cancel Reply