DBM 438 DBM438 DBM/438 ENTIRE COURSE HELP – DEVRY UNIVERSITY

Description

DBM 438 DBM438 DBM/438 ENTIRE COURSE HELP – DEVRY UNIVERSITY

DBM 438 Quiz 1

DBM 438 Quiz 2

DBM 438 Quiz 3

DBM 438 Quiz 4

DBM 438 Week 1 Hands-On Exercise

DBM 438 Week 1 iLab

DBM 438 Week 1 Quiz

DBM 438 Week 1 Quiz

DBM 438 Week 1 Quiz

DBM 438 Week 2 iLab Hands-On Exercise

DBM 438 Week 2 Quiz

DBM 438 Week 2 Quiz

DBM 438 Week 3 Hands-On Exercise

DBM 438 Week 3 Quiz

DBM 438 Week 3 Quiz

DBM 438 Week 4 Hands-On Exercise

DBM 438 Week 4 iLab

DBM 438 Week 4 Quiz

DBM 438 Week 5 iLab

DBM 438 Week 7 iLab

DBM 438 DBM438 DBM/438 ENTIRE COURSE HELP – DEVRY UNIVERSITY

DBM 438 Quiz 1

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

5. TCO 9 – Select which tool below provides the network link between the Oracle10g database and most applications that communicate with the database.

6. TCO 9 – The ____ migrates data from older versions to newer versions of the database.

7. TCO 9 – To start Net Manager in Unix or Linux, type ____ on the command line of a shell.

8. TCO 1 – Oracle has over 10 background processes that run when Oracle starts up.

These background porcesses support and monitor the server processes and handle database management tasks to keep the database running effeciently and to help maintain fast performance. List 4 of these background processes and describe exactly their functionality. Please be thorough in your response.

9. TCO 9 – You are a junior DBA who has been asked to do some work in the database environment. Briefly discuss the steps you would take to startup the SQL *Plus editor application and SQL *Plus Worksheet so you can do your work.

DBM 438 DBM438 DBM/438 ENTIRE COURSE HELP – DEVRY UNIVERSITY

DBM 438 Quiz 2

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. TCO 2 – The DBCA tool executes the ____ for you, in order to configure the new database’s Named Service.

5. TCO 2 – To start up the database, you can use the SQL*Plus ____ command

6. TCO 2 – If you install Oracle 10g Enterprise Edition on Windows 2000, the storage space of the ORACLE_HOME drive for Oracle binary files (system drive) should be at least ____ megabytes

7. TCO 2 – There are ____ options for the SHUTDOWN COMMAND

8. TCO 2 – Briefly discuss the difference between ASM and raw device storage mechanisms.

9. TCO 2 – You are in a database meeting with your fellow collegues. One DBA is talking about the advantages of User Managed Files but you think Oracle Managaed Files have more advantages. What would you say? Please be thorough in your response.

DBM 438 DBM438 DBM/438 ENTIRE COURSE HELP – DEVRY UNIVERSITY

DBM 438 Quiz 3

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.

4. TCO 3 – When you type the ____ command, the redo log buffer’s redo records are moved to the redo log files

5. TCO 6 – All of the data dictionary views except those starting with the ____ prefix have public synonyms and public permission to query

6. TCO 6 – ____ partitioning divides partition values evenly based on hash values calculated from a column value or values in each row of a table

7. TCO 6 – Oracle ____ are much like opening a direct pipeline between different servers and databases

8. TCO 6 – Oracle-managed log groups may be added to OMF databases by using the following command: ____.

9. TCO 3 – Describe the steps and commands needed to place a database that is in NOARCHIVE Log mode to ARCHIVELOG mode.

10. TCO 6 – What are 3 dynamic performance views your book talks about? List 3 of them and then give a thorough response for each one