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
9. Look at the following CREATE DATABASE command, and find the errors. Then please correct the problem.
CREATE DATABASE ultradb FOR UPDATE OF paralleldb
DATAFILE TABLESPACE 'ORACLE_BASEoradatasystem01.dbf'
LOGFILE GROUP A ('D:oraclelogsredoA.log') SIZE 50M,
GROUP B ('D:oraclelogsredoA.log') SIZE 50M;