1 / 22

DBM 438 Enthusiastic Study / snaptutorial.com

. TCO 1 - In Windows, the default ORACLE_BASE path is ____.<br>2. TCO 1 – Which configuration below is the most standard or typical setup for an Oracle10g database?<br>3. TCO 1 - The ____ does not write any data to disks. It signals the DBWn to begin writing to disk by issuing a checkpoint<br>4. TCO 1 - The tnsnames.ora file is typically found in the ____ directory on a UNIX, Linux, or Windows system<br>

Stephenson23
Download Presentation

DBM 438 Enthusiastic Study / snaptutorial.com

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 10g’s 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 can’t 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

More Related