There are two ways of executing this project. Details for each are described below
1. Command Line
i. Compile the .java file to generate .class file to run the class
javac <Path to HomeSecSys.java>
ii. Run the Class file using below command
Q-2Problem B DDL
Assume that you are designing a database with the following tables:
CUSTOMER (CustomerID, LastName, FirstName, Phone, Email)
PURCHASE (InvoiceNumber, Date, PreTaxAmount, CustomerID)
PURCHASE_ITEM (InvoiceNumber, ItemNumber, RetailPrice)
Q1. What memory structures are a required part of the SGA?
ANS:The basic memory structures associated with Oracle include:
1.System Global Area (SGA), which is shared by all server and background processes.
2.Program Global Areas (PGA), which is private
Problem A SQL SELECT
Given a table definition:
Employees ( employee_id, first_name, last_name, salary,
manager_id, hire_date, commission_pct,department_id)
Write the following SQL statements
(I have create schema home and inside it is Emplo
Name Sukhchain Singh ID 90771
Q1. Describe the stages of database startup.
Ans-1 The Oracle database is associated with an Oracle instance. When a database is started on a database server (regardless of the type of computer),
Oracle allocates a memory a