DBM 438 Knowledge is divine / snaptutorial.com

1
DBM 438 Knowledge is divine / snaptutorial.com
2
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Quiz 1 For more classes
visit www.snaptutorial.com   1. TCO 1 - In
Windows, the default ORACLE_BASE path is ____. 2.
TCO 1 Which configuration below is the most
standard or typical setup for an Oracle10g
database?
3
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Quiz 2 For more classes
visit www.snaptutorial.com   1. TCO 2 - A(n) ____
database allows you to define anything and
everything this one is for the experts 2. TCO 2
- If you install Oracle 10g Enterprise Edition on
Windows 2000, the minimum requirements for
virtual memory are ____ megabytes of RAM
4
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Quiz 3 For more classes
visit www.snaptutorial.com   1. TCO 3 - The ____
tablespace contains Oracle optional software
metadata and data. 2. TCO 3 - ____ a redo log
group ensures that you can perform a complete,
up-to-the-minute recovery of your database in the
event of catastrophic failure, such as the loss
of a disk drive that held your SYSTEM
tablespace. 3. TCO 3 - ____ are the logical layer
of an Oracle database.
5
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Quiz 4 For more classes
visit www.snaptutorial.com   1. TCO 4 - When you
take a tablespace offline, there are ____ methods
you can specify for Oracle 10gs execution of the
command 2. TCO 4 - Each ____ represents a group
of bytes in the physical file
6
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 1 Hands-On Exercise For more
classes visit www.snaptutorial.com   DBM 438 Week
1 Hands-On Exercise  
7
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 1 iLab For more classes
visit www.snaptutorial.com   DBM 438 Week 1 iLab  
8
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 1 Quiz For more classes
visit www.snaptutorial.com   1. TCO 1 - The ____
does not write any data to disks. It signals the
DBWn to begin writing to disk by issuing a
checkpoint. 2. TCO 1 - The ____ does not write
any data to disks. It signals the DBWn to begin
writing to disk by issuing a checkpoint.
9
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 1 Quiz For more classes
visit www.snaptutorial.com   1. TCO 1 - The ____
does not write any data to disks. It signals the
DBWn to begin writing to disk by issuing a
checkpoint. 2. TCO 1 - The ____ does not write
any data to disks. It signals the DBWn to begin
writing to disk by issuing a checkpoint.
10
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 1 Quiz For more classes
visit www.snaptutorial.com   1. TCO 1 - The ____
does not write any data to disks. It signals the
DBWn to begin writing to disk by issuing a
checkpoint. 2. TCO 1 - The ____ does not write
any data to disks. It signals the DBWn to begin
writing to disk by issuing a checkpoint. 3. TCO 1
In order for computers to collaborate with one
another, they use ____ connections to communicate
with each other. 4. TCO 1 - On Windows, the
default ORACLE_HOME for an Oracle10g, Release 2,
database server
11
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 2 iLab Hands-On Exercise For more
classes visit www.snaptutorial.com   DBM 438 Week
2 iLab Hands-On Exercise  
12
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 2 Quiz For more classes
visit www.snaptutorial.com   1. TCO 2 - There are
____ options for the SHUTDOWN COMMAND. 2. TCO 2 -
If you install Oracle 10g Enterprise Edition on
Windows 2000, the minimum requirements for
virtual memory are ____ megabytes of RAM.
13
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 2 Quiz For more classes
visit www.snaptutorial.com   1. TCO 2 - There are
____ options for the SHUTDOWN COMMAND. 2. TCO 2 -
If you install Oracle 10g Enterprise Edition on
Windows 2000, the minimum requirements for
virtual memory are ____ megabytes of RAM.
14
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 3 Hands-On Exercise For more
classes visit www.snaptutorial.com   DBM 438
DBM/438 DBM438 Week 3 Hands-On Exercise  
15
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 3 Quiz For more classes
visit www.snaptutorial.com   1.TCO 3 - The ____
clause of the CREATE CONTROLFILE command tells
Oracle 10g to overwrite any existing control
files it finds. 2. TCO 3 - ____ partitioning
splits a table based on distinct ranges of
values, such as quarters in a year. 3. TCO 3 -
The status of a redo log group can be ____ if it
is not needed for crash recovery.
16
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 3 Quiz For more classes
visit www.snaptutorial.com   1.TCO 3 - The ____
clause of the CREATE CONTROLFILE command tells
Oracle 10g to overwrite any existing control
files it finds. 2. TCO 3 - ____ partitioning
splits a table based on distinct ranges of
values, such as quarters in a year.
17
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 4 Hands-On Exercise For more
classes visit www.snaptutorial.com   HANDS-ON 1
Storage Space Not Adequate Your current database
uses dictionary-managed tablespaces. In running
various performance-tuning scripts, you have
discovered that one of these tablespaces seems to
have run out of space long before you calculated
that it would. In tracking activity in the
tablespace, you discover that the process of
tables being created, then droppe
18
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 4 iLab For more classes
visit www.snaptutorial.com   DBM 438 DBM/438
DBM438 Week 4 iLab
19
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 4 Quiz For more classes
visit www.snaptutorial.com   1. TCO 4 - A
____-managed tablespace has a bitmap in the
header of the tablespace that stores all of the
details about free space, used space, and
location of extents.
20
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 5 iLab For more classes
visit www.snaptutorial.com   DBM 438 Week 5 iLab  
21
DBM 438 Knowledge is divine / snaptutorial.com
DBM 438 Week 7 iLab For more classes
visit www.snaptutorial.com   DBM 438 Week 7 iLab
22
DBM 438 Knowledge is divine / snaptutorial.com