Oracle DBMS Lab: Installing, Configuring, and Connecting as Admin and User, Assignments of Database Management Systems (DBMS)

Instructions for installing oracle database management system (dbms) and oracle database, accessing the database as a database administrator using sql plus, unlocking and changing the password for the user scott, connecting to the database as the scott user, finding the metadata of scott, and finding the output of all tables in the scott schema. Additionally, it explains the concept of client server architecture in oracle dbms and guides the user through configuring the client server architecture and enabling network and web access for all users.

Typology: Assignments

2020/2021

Uploaded on 09/29/2022

muhammad-chughtai
muhammad-chughtai 🇵🇰

1 document

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Lab 1
Database Management systems
After completing this lab, you should be able to learn the installation of
Oracle client server architecture and learn how to connect with database.
Perform the following tasks
1. Install oracle database management system
2. Install orcl Database
3. Access your database by SYS user as a database administrator by using SQL Plus
4. Unlock the user Scott and change its password
5. Connect to the database by Scott user
6. Find the metadata of Scott
7. Find the output of all tables in Scott Schema
8. What is a client server architecture in Oracle DBMS?
9. Configure the client server architecture as follow
10. Enable the network and web access of database for all users as follows.
pf3

Partial preview of the text

Download Oracle DBMS Lab: Installing, Configuring, and Connecting as Admin and User and more Assignments Database Management Systems (DBMS) in PDF only on Docsity!

Lab 1

Database Management systems

After completing this lab, you should be able to learn the installation of

Oracle client server architecture and learn how to connect with database.

Perform the following tasks

  1. Install oracle database management system
  2. Install orcl Database
  3. Access your database by SYS user as a database administrator by using SQL Plus
  4. Unlock the user Scott and change its password
  5. Connect to the database by Scott user
  6. Find the metadata of Scott
  7. Find the output of all tables in Scott Schema
  8. What is a client server architecture in Oracle DBMS?
  9. Configure the client server architecture as follow
  10. Enable the network and web access of database for all users as follows.