Explore BrainMass
Share

Oracle9i Database

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

1. You have three new consultants arriving to work for your company as database programmers. You want them to be able to create tables in the USER_AUTO tablespace that use up to a maximum of 10 M of space each. In addition, you want them to change their passwords every week, and you want the system to log them off the database if their sessions are idle for more than ten minutes. The three user names to create are CONS01, CONS02, and CONS03. The profile to create for the consultants is named TEMPCONSULT. Write and execute the commands needed to accomplish these goals. Save the SQL script in a file.

© BrainMass Inc. brainmass.com October 24, 2018, 8:21 pm ad1c9bdddf
https://brainmass.com/computer-science/files/oracle9i-database-94436

Attachments

$2.19
See Also This Related BrainMass Solution

Oracle9i Database

9. Look at the following CREATE DATABASE command, and find the errors. Then please correct the problem.

CREATE DATABASE ultradb FOR UPDATE OF paralleldb
MAXINSTANCES 25
DATAFILE TABLESPACE 'ORACLE_BASEoradatasystem01.dbf'
CHARACTER_SET US7ASCII
LOGFILE GROUP A ('D:oraclelogsredoA.log') SIZE 50M,
GROUP B ('D:oraclelogsredoA.log') SIZE 50M;

View Full Posting Details