DBM 438 Enthusiastic Study / snaptutorial.com

1
DBM 438 Enthusiastic Study--snaptutorial.com
2
DBM 438 Enthusiastic Study--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. TCO 1 - The ____ does not write any
data to disks. It signals the DBWn to begin
writing to disk by issuing a checkpoint 4. TCO 1
- The tnsnames.ora file is typically found in the
____ directory on a UNIX, Linux, or Windows system
3
DBM 438 Enthusiastic Study--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 3. TCO 2
- The CREATE DATABASE ____ option is used to set
the maximum number of redo log files in each redo
log group
4
DBM 438 Enthusiastic Study--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 Enthusiastic Study--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 3. TCO 4 - The
second largest logical structure is a(n) ____. 4.
TCO 4 - To use ____ partitioning, you set up a
distinct list of partitioning key values and
define which values go into each partition.
6
DBM 438 Enthusiastic Study--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 Enthusiastic Study--snaptutorial.com
DBM 438 Week 1 iLab For more classes
visit www.snaptutorial.com   DBM 438 Week 1 iLab
8
DBM 438 Enthusiastic Study--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.
9
DBM 438 Enthusiastic Study--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 installation is ____.
10
DBM 438 Enthusiastic Study--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 installation is ____.
11
DBM 438 Enthusiastic Study--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 Enthusiastic Study--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. 3. TCO
2 - SHUTDOWN ____automatically completes and
commits all pending transactions, then forcibly
disconnects all connected users, and shuts down
the database. 4. TCO 2 - A(n) ____ database
allows you to define anything and everything
this one is for the experts.
13
DBM 438 Enthusiastic Study--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. 3. TCO
2 - SHUTDOWN ____automatically completes and
commits all pending transactions, then forcibly
disconnects all connected users, and shuts down
the database.
14
DBM 438 Enthusiastic Study--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 Enthusiastic Study--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. 4. TCO 3 -
There can be up to ____ archiver processes.
16
DBM 438 Enthusiastic Study--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. 4. TCO 3 -
There can be up to ____ archiver processes.
17
DBM 438 Enthusiastic Study--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 dropped and
re-created, with different storage settings, has
been excessive. Give an explanation for why your
tablespace might have a problem, and list two
actions you can take to lessen the problem.
18
DBM 438 Enthusiastic Study--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 Enthusiastic Study--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. 2. TCO 8 - The default value
for INITRANS is 1 for tables and ____ for
indexes. 3. TCO 8 - Dictionary-managed
tablespaces have a problem that causes slower
performance of ____ commands. 4. TCO 8 - A data
block cant be smaller than ____ or larger than
32KB.
20
DBM 438 Enthusiastic Study--snaptutorial.com
DBM 438 Week 5 iLab For more classes
visit www.snaptutorial.com   DBM 438 Week 5 iLab  
21
DBM 438 Enthusiastic Study--snaptutorial.com
DBM 438 Week 7 iLab For more classes
visit www.snaptutorial.com   DBM 438 Week 7 iLab  
22
DBM 438 Enthusiastic Study--snaptutorial.com