Aug 15

Oracle Fundamental Concepts #40

Terms
Database: In oracle, the term database refers to the files required for the operation of Oracle. These files include:data files, temporary data files, redo log files, control files, and parameter files

Instance: All the processes and memory structures required to operate the database

Users: Users are accounts that can be used to log in to the database.

Schema: A schema is the collection of all the objects owned by a user

Security: Oracle provides privilege-based securities. Oracle uses two types of privileges. System privilege, and object privilege. To facilitate the easy operation of privilege-based securities oracle uses roles.

SYS and SYSTEM Account: Administrative Accounts. Have unrestricted access. SYS account owns the data dictionary. SYSTEM account owns the tables used to store information for features and options of the database. SYSTEM is the default administrative account. It is recommended that you do not use SYSTEM account to administer the database; rather create your own DBA account to administer.

SQL*PLUS: Is a client tool to interact with the Oracle database using SQL.

Data Dictionary: A repository that keeps track of all the database objects

SQL: A language to interact with the database such as insert data into the database, update data, retrieve data from the database, control transactions

PL/SQL: A procedural language that can be used to write custom programs and procedural codes to run inside the database

Oracle SQL Types

  • Data Manipulation Language (DML)
  • Data Definition Language (DDL)
  • Transaction control statements
  • Session control statements
  • System control statements

Joins in Oracle

NATURAL
INNER
OUTER – LEFT
OUTER – RIGHT
OUTER – FULL

SET Operations Supported by Oracle:
UNION, UNION ALL, INTERSECT, MINUS

Select, Insert, Update, Delete operations are similar to the ANSI SQL

Transaction Management DML SQLs: COMMIT, ROLL BACK, SAVEPOINT, ROLL BACK TO , SET TRANSACTION,SET CONSTRAINT(S)

User Creation in Oracle:
create user oracle_admin identified by password;
grant create session, dba to oracle_admin;

Oracle Architecture Areas

  • User Processes: Such as a client tool
  • The Oracle Listener: Runs in the oracle database server and listens to the clients
  • The Oracle Net Client: How to talk to the server processes
  • Parameter files
  • Control Files
  • Data Files
  • Tablespaces
  • Segments
  • Extents
  • Data Blocks
  • Pre-allocated Files
  • Redo Log Files
  • Temporary Files
  • Oracle Managed Files
  • Memory Areas
  • Background Processes

From: http://sitestree.com/?p=5048
Categories:40
Tags:
Post Data:2013-05-14 18:15:24

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>