Oracle 1Z0-52 Dba 11g

The Differents Between A Level 1 And Level 0
Changes are done, please view the flashcard.

Preview Flashcards

Level 0 backups everything .....

Level 1 Differential incremental backs up changes .from level 0 and changes since the level 1 backup.....

Level 1 Cumulative incremental backups all blocks that have changed since the most recent level 0 backup.........

That means
Level 0 -- 1 cumulate
0 - 1 cumulate
Level 0 - 1 differential
0 - 1 differental - 1 differental

Database writer
can have more then one dw
and also will write whenever a checkpointing happens


RMAN automatic backups

will configure using autobackup
Control file and
Server parameter fil

Data Recovery Advisor (DRA) will not help you
on a standby database or recover from failures in RAC

You can create an index on a table
Create a synonym on a table
for a external table

A B-tree index has lef blocks that are doubly linked and the space is available if a row is logical deleted in a left block
A database Global Database Name is the
database name
the domain name.......

The operating system group must have permission to write to the inventory directory - else the installer will ask for the path and also - you will need the operating system group name
A extent can not spread across a data file.

Do you know what a extent is????

Run Memory advisor (Buffer cache) if Automatic Shared Memory Manager is disable and you have poor performance. for SQL
Tempory tables can have Indexes and views and.
are created in temporay tablespaces and Locks (DML) and not acquired.

Upgrade and get a lot more done!