Home / My courses / UGRD-IT6203A-2333T / PRELIM EXAM / PRELIM EXAM
Started on Saturday, 18 May 2024, 6:28 PM
State Finished
Completed on Saturday, 18 May 2024, 8:03 PM
Time taken 1 hour 35 mins
Marks 47.00/50.00
Grade 94.00 out of 100.00
Question 1
Correct
Mark 1.00 out of 1.00
Oracle database has at least one ___________ that maintains the metadata of the database.
a. tablespace
b. redo log file
c. archive log
d. control file
Your answer is correct.
Question 2
Correct
Mark 1.00 out of 1.00
Following are a few sample substitution variable types. except?
a. %%
b. %f
c. %d
d. %s
Your answer is correct.
Question 3
Correct
Mark 1.00 out of 1.00
It is a block of executable code designed to perform a specific task?
a. oracle instance
b. background process
c. system global area
d. user global area
Your answer is correct.
Question 4
Correct
Mark 1.00 out of 1.00
SGA component that holds the most recent changes to the data blocks in the datafiles. When the redo log buffer is one-third full, or
every 3 seconds, Oracle writes redo log records to the redo log files.
a. redo log buffer
b. java pool
c. shared pool
d. streams pool
Your answer is correct.
Question 5
Correct
Mark 1.00 out of 1.00
It is a multiplexing solution that automates the layout of datafiles, control files, and redo log files by distributing them across all
available disks?
a. asm
b. rac
c. pga
d. reco
Your answer is correct.
Question 6
Correct
Mark 1.00 out of 1.00
An area that stores the Oracle executable files that are running as part of an Oracle instance?
a. streams pool
b. java pool
c. buffer cache
d. software code area
Your answer is correct.
Question 7
Correct
Mark 1.00 out of 1.00
Commands are usually grouped and run inside of a command block using the RUN command.
a. standalone commands
b. job commands
c. none of the above
d. offline backup
Your answer is correct.
Question 8
Correct
Mark 1.00 out of 1.00
A ___________ files created with the BACKUP AS BACKUPSET commands are stored in the flash recovery area.
a. flashback logs
b. control file automatic
c. archived redo log files
d. rman backupsets
Your answer is correct.
Question 9
Correct
Mark 1.00 out of 1.00
A command that displays information about backupsets and image copies in the repository and can also store the contents of scripts
stored in the repository catalog.
a. view command
b. list command
c. delete command
d. backupset
Your answer is correct.
Question 10
Correct
Mark 1.00 out of 1.00
You can use _________ backups for any database that is running in ARCHIVELOG mode. In this mode, the online redo logs are archived,
creating a log of all transactions within the database.
a. none of the above
b. online backup
c. cold backup
d. offline backup
Your answer is correct.
Question 11
Correct
Mark 1.00 out of 1.00
Smallest unit storage in Oracle can use or allocate?
a. control file
b. block
c. segment
d. extent
Your answer is correct.
Question 12
Correct
Mark 1.00 out of 1.00
Whenever data is added, removed, or change in a table, index, or other oracle objects, an entry is written to the current ________.
a. redo log file
b. datafile
c. tablespace
d. control file
Your answer is correct.
Question 13
Correct
Mark 1.00 out of 1.00
An ___________ is an exact copy of a tablespace’s datafile, an archived redo log file, or a control file.
a. dbid
b. image copy
c. backupset
d. channel
Your answer is correct.
Question 14
Correct
Mark 1.00 out of 1.00
An area that is private to each server and background process?
a. sca
b. uga
c. sga
d. pga
Your answer is correct.
Question 15
Correct
Mark 1.00 out of 1.00
A database backups involve copying the files that constitute the database. These backups are also referred to as file system backups
because they involve using operating system file backup commands.
a. physical backup
b. offline backup
c. logical backup
d. none of the above
Your answer is correct.
Question 16
Incorrect
Mark 0.00 out of 1.00
An RMAN backup can be one of the following types: except?
a. cumulative level 0 backup
b. whole database backup
c. incremental level 0 backup
d. full backup
Your answer is incorrect.
Question 17
Correct
Mark 1.00 out of 1.00
_________ is an RMAN command that is executed only at the RMAN> prompt and is self-contained.
a. none of the above
b. job commands
c. offline backup
d. standalone commands
Your answer is correct.
Question 18
Correct
Mark 1.00 out of 1.00
It is the next level of logical grouping in the oracle database?
a. asm
b. block
c. control file
d. extent
Your answer is correct.
Question 19
Incorrect
Mark 0.00 out of 1.00
LGWR stands for?
a. log writer process
b. load writer process
c. load writer path
d. log writer path
Your answer is incorrect.
Question 20
Correct
Mark 1.00 out of 1.00
RMAN stores _____________ backups in the flash recovery area.
a. archived redo log files
b. datafile copies
c. control file automatic
d. flashback logs
Your answer is correct.
Question 21
Correct
Mark 1.00 out of 1.00
Users who connect to an ASM instance as _____________ can perform all ASM operations, such as creating and deleting disk groups, as
well as adding and removing disks from disk groups.
a. sysoper
b. sysdba or sysasm
c. none of the above
d. sys
Your answer is correct.
Question 22
Correct
Mark 1.00 out of 1.00
A backups back up all changed blocks since the last level 0 incremental backup?
a. whole database backup
b. full backup
c. incremental level 0 backup
d. cumulative level 1 backup
Your answer is correct.
Question 23
Correct
Mark 1.00 out of 1.00
A database backup that involves reading a set of database rows and writing them to a file?
a. offline backup
b. logical backup
c. physical backup
d. none of the above
Your answer is correct.
Question 24
Correct
Mark 1.00 out of 1.00
Which of the following command used to turn off block change tracking?
a. alter database disable block change tracking;
b. alter database blocking track;
c. change database enable block tracking;
d. alter database disable block temp tracking;
Your answer is correct.
Question 25
Correct
Mark 1.00 out of 1.00
This is an area that allocates once the database instance is started?
a. uga
b. pga
c. sca
d. sga
Your answer is correct.
Question 26
Correct
Mark 1.00 out of 1.00
This backup can consist of a single datafile or tablespace.
a. whole database backup
b. full backup
c. incremental level 0 backup
d. cumulative level 0 backup
Your answer is correct.
Question 27
Correct
Mark 1.00 out of 1.00
The following are some of the major features of RMAN: except?
a. open database backups
b. skip unused blocks
c. decrypted backups
d. multiple I/O channels
Your answer is correct.
Question 28
Correct
Mark 1.00 out of 1.00
SGA components. Except?
a. data dictionary cache
b. redo log buffer
c. software code area
d. large pool
Your answer is correct.
Question 29
Incorrect
Mark 0.00 out of 1.00
Which of the following command is used to create and enable block change tracking?
a. alter database enable block change tracking;
b. change database block change tracking;
c. alter database enable blocking track;
d. change database enable block tracking;
Your answer is incorrect.
Question 30
Correct
Mark 1.00 out of 1.00
Oracle database 11g created default tablespace. Except?
a. useraux
b. undotbs1
c. system
d. users
Your answer is correct.
Question 31
Correct
Mark 1.00 out of 1.00
A backup that includes all blocks in a database object except for blocks that were never used above the HWM?
a. incremental level 0 backup
b. full backup
c. cumulative level 0 backup
d. whole database backup
Your answer is correct.
Question 32
Correct
Mark 1.00 out of 1.00
SGA components that hold blocks of data from a disk that have been recently read to satisfy a SELECT statement or that contain
modified blocks that have been changed or added from DML statement.
a. library cache
b. buffer cache
c. redo log buffer
d. data dictionary cache
Your answer is correct.
Question 33
Correct
Mark 1.00 out of 1.00
A _______is an object-specific to RMAN and which only RMAN can create and read.
a. rman
b. tablespace
c. backupsets
d. image copies
Your answer is correct.
Question 34
Correct
Mark 1.00 out of 1.00
A _________ backup produces a multipiece backupset from a single datafile and uses several channels, to disk or tape, to back up each
piece of the datafile in parallel.
a. multisection
b. axis
c. compressed
d. multi parallel
Your answer is correct.
Question 35
Correct
Mark 1.00 out of 1.00
CTWR background process stands for?
a. change tracking writer
b. change tracking waste
c. close trip writer
d. close tracking writer
Your answer is correct.
Question 36
Correct
Mark 1.00 out of 1.00
It is a command-line utility that provides an easy way for you to browse and maintain objects within ASM disk groups by using a
command set similar to Linux shell commands such as ls and mkdir.
a. asmcmd utility
b. asm utility
c. rman utility
d. none of the above
Your answer is correct.
Question 37
Correct
Mark 1.00 out of 1.00
This backup includes a copy of all datafiles in the database plus the control file?
a. full backup
b. whole database backup
c. cumulative level 0 backup
d. incremental level 0 backup
Your answer is correct.
Question 38
Correct
Mark 1.00 out of 1.00
If the DBA performs a _________ backup, the backup files are simply operating system copies of the datafiles, redo log files, control
files, archvielog files and so on and so forth.
a. cold
b. increment
c. online
d. hot
Your answer is correct.
Question 39
Correct
Mark 1.00 out of 1.00
It is an area of memory allocating dynamic sections of itself, privately for one set of connection processes?
a. uga
b. pga
c. sga
d. sca
Your answer is correct.
Question 40
Correct
Mark 1.00 out of 1.00
SGA component that holds information about SQL and PL/SQL statements that are run against the database?
a. data dictionary cache
b. buffer cache
c. shared pool
d. library cache
Your answer is correct.
Question 41
Correct
Mark 1.00 out of 1.00
DBWn stand for?
a. datafile writer process
b. datafile writer path
c. database writer path
d. database writer process
Your answer is correct.
Question 42
Correct
Mark 1.00 out of 1.00
There are three initialization parameters that control the default locations for new control files, online redo log files, and datafiles:
except?
a. db_recovery_files_dest
b. db_create_online_log_dest_n
c. db_create_file_dest
d. db_create_files_n
Your answer is correct.
Question 43
Correct
Mark 1.00 out of 1.00
In RMAN duplexing has a few restrictions: You cannot duplex backups to the flash recovery area, and you cannot duplex image copies.
except?
a. backupsets
b. control file
c. archivelog
d. database
Your answer is correct.
Question 44
Correct
Mark 1.00 out of 1.00
An Oracle tablespace consists of one or more ___________.
a. datafiles
b. segment
c. system
d. user
Your answer is correct.
Question 45
Correct
Mark 1.00 out of 1.00
Backups that occur when the database has been shut down normally using the NORMAL, IMMEDIATE, or TRANSACTIONAL option of
the SHUTDOWN command.
a. logical backup
b. offline backup
c. physical backup
d. none of the above
Your answer is correct.
Question 46
Correct
Mark 1.00 out of 1.00
A ___________ are stored in the flash recovery area when Flashback Database is enabled.
a. datafiles copies
b. none of the above
c. rman backupsets
d. flashback logs
Your answer is correct.
Question 47
Correct
Mark 1.00 out of 1.00
It is the default type of incremental backup that backs up all changed blocks since the last level 0 or level 1 incremental backup?
a. cumulative level 0 backup
b. differential level backup
c. incremental level 1 backup
d. incremental level 0 backup
Your answer is correct.
Question 48
Correct
Mark 1.00 out of 1.00
Another way to improve the performance of incremental backups is to enable a _________________?
a. data change tracking
b. redo change tracking
c. file change tracking
d. block change tracking
Your answer is correct.
Question 49
Correct
Mark 1.00 out of 1.00
When you use the RMAN command BACKUP AS COPY, the ___________ are stored in the flash recovery area by default.
a. rman backupsets
b. datafile copies
c. flashback logs
d. none of the above
Your answer is correct.
Question 50
Correct
Mark 1.00 out of 1.00
If you want to keep recent backupsets on disk and older backupsets on tape, you can use the COMPLETED and __________ options.
a. alter input
b. delete input
c. crosscheck
d. change
Your answer is correct.
◄ Announcements
Jump to...
Prelim Lab Exam ►
