Access over 20 million homework & study documents

Week8

Content type
User Generated
Subject
Computer Science
Type
Homework
Rating
Showing Page:
1/14
1.
---SCRIPT
CREATE USER DBSEC_ADMIN IDENTIFIED BY Is481admin
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP";
Screenshot
---script
CREATE USER DBSEC_CLERK IDENTIFIED BY Is481clerk
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP";
---Screen

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/14
---Script
CREATE USER DBSEC_DEV IDENTIFIED BY Is481dev
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP";
----screen
---script
CREATE USER DBSEC IDENTIFIED BY Is481#1

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/14

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 14 pages?
Access Now
Unformatted Attachment Preview
1. ---SCRIPT CREATE USER DBSEC_ADMIN IDENTIFIED BY Is481admin DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; Screenshot ---script CREATE USER DBSEC_CLERK IDENTIFIED BY Is481clerk DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; ---Screen ---Script CREATE USER DBSEC_DEV IDENTIFIED BY Is481dev DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; ----screen ---script CREATE USER DBSEC IDENTIFIED BY Is481#1 DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; ---screen ---Script CREATE USER VPD_CLERK1 IDENTIFIED BY john$22 DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; --screen --script CREATE USER VPD_CLERK2 IDENTIFIED BY nancy$46 DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; ---screen 2. --script CREATE TABLE "SYSTEM"."CUSTOMER" ( "SALES_REP_ID" NUMBER(4,0), "CUSTOMER_ID" NUMBER(8,0) NOT NULL ENABLE, "CUSTOMER_SSN" VARCHAR2(9 BYTE), "FISRT_NAME" VARCHAR2(20 BYTE), "LAST_NAME" VARCHAR2(20 BYTE), "ADDR_LINE" VARCHAR2(60 BYTE), "CITY" VARCHAR2(30 BYTE), "STATE" VARCHAR2(30 BYTE), "ZIP_CODE" VARCHAR2(9 BYTE), "PHONE" VARCHAR2(15 BYTE), "EMAIL" VARCHAR2(80 BYTE), "CC_NUMBER" VARCHAR2(30 BYTE), "CREDIT_LIMIT" NUMBER, "GENDER" CHAR(1 BYTE), "STATUS" CHAR(1 BYTE), "COMMENTS" VARCHAR2(1024 BYTE), "CTL_UPD_DTTM" DATE, "CTL_UPD_USER" VARCHAR2(30 BYTE), "CTL_REC_STAT" CHAR(1 BYTE) ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREEL ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Great content here. Definitely a returning customer.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4