The Expert's number of “Accepted Answers” is a good indication of how many satisfied customers he or she has helped.
Carla's Bachelor's degree in Data
processing Technology was verified on or about January 2010 by a leading third-party verification service.View the Terms of Service section on verifications
Unix Programming: Using Ubuntu for Linux Distro
The first script that needs to be written is automating the shutdown procedure. Write a script that will perform the following tasks: Prompt the system administrator for all valid input parameters.
Ask if a wall needs to be sent, and if yes, send the message.
Ask if this is a shutdown or reboot, and process appropriately.
In addition, take this opportunity to describe the various UNIX run levels, what each level is used for, and how to boot to a specific run level.
Create an SQL database You are being asked to create the CREATE DATABASE script for a new database instance. The name of the new database should be LABII. Create a script file using Notepad that would create this database: • The following parameters need to be defined and settings assigned: o Maxlogfiles to allow up to 5 groups o Maxlogmembers to allow up to 4 o Maxdatafiles to allow up to 100 o Maxinstances to allow only 2
• A system datafile should be based on the following guidelines: o Named SYSTEM01.DBF located on the C: with the directory path noted above. Have a storage clause set to AUTOEXTEND ON NEXT 10240K and should have a MAXSIZE of UNLIMITED. o Have a file size of 100M.
• A system auxiliary datafile should be based on the following guidelines: o Named SYSAUX01.DBF located on the C: with the directory path noted above. Have a storage clause set to AUTOEXTEND ON NEXT 10240K and should have a MAXSIZE of UNLIMITED. o Have a file size of 100M.
• Two logfile groups should be created based on the following guidelines: o Each group should have two 4M log files. Log group one will have file REDO01A.LOG located on the C: drive and REDO01B.LOG located on the E: drive. Each drive should use the directory path noted above in the opening scenario/summary section. o Log group two will have file REDO02A.LOG located on the E: drive and REDO02B.LOG located on the F: drive. Each drive should use the directory path noted above in the opening scenario/summary section. You can include settings for character sets if you wish; however, since this database resides in an already defined DBMS, the default character sets defined with Oracle was installed would be used. Be sure to include a semicolon at the end of the script to indicate the end of the script.
REMEMBER-–you are not required, nor should you try, to execute this script.
Here is the instruction file: http://ge.tt/6jir8Hx/v/0