INF3703 Assignment 2 - Due 27 June 2025

INF3703
ASSIGNMENT 2 2025

UNIQUE NO.
DUE DATE: 27 JUNE 2025

,1ST EXAMPLE

-- INF3703 Assessment 2 Solutions

-- Student Number: 58146870

-- Author: ChatGPT (on behalf of user)



-- ================================

-- QUESTION 1: SYSTEM CONFIGURATION & SETUP (40 MARKS)

-- ================================



-- 1.1.1 Connect to CDB using SQL*Plus

-- Screenshot required showing: SQL> CONNECT / AS SYSDBA

-- Then connect to the container:

-- SQL> SHOW CON_NAME

-- Expected Output: CDB$ROOT



-- 1.1.2 SQL Developer Connection

-- Create new connection: ASS2_ADMIN_CDB_58146870

-- STATUS: SUCCESS screenshot required



-- 1.2.1 Create new connection for PDB

-- Connection name: ASS2_ADMIN_PDB_58146870

-- STATUS: SUCCESS screenshot required

, -- 1.2.2 Change SYSTEM password to your student number (58146870)

-- Navigate to SYSTEM user > Edit User > Change Password

-- Then use SQL Plus to reconnect to CDB with new password

-- Screenshot required showing successful reconnection



-- 1.2.3 Connect to PDB with new password via SQL Plus

-- Screenshot required showing CON_NAME as PDB



-- 1.3.1 Create new Tablespace via SQL Developer

-- Tablespace name: TABLESPACE_58146870

-- Type: Permanent



-- 1.3.2 File Specifications:

-- Filename: TABLESPACE_58146870.DBF

-- Directory: C:\app\User\product\21c\dbhomeXE\demo

-- File Size: 50M, Auto Extent ON, Next: 10M, Max: 100M



-- 1.3.3 Expand STORAGE > Datafiles > TABLESPACE_58146870.DBF

-- Screenshot required of the Datafile details



-- 1.4.1 Create User:

-- Username: ASS2_58146870

-- Password: 58146870