Home 2022 February

Monthly Archives: February 2022

full frame shot of shelf

Data Consistency

Data Consistency In Oracle Database, each user must see a consistent view of the data, including visible changes made by a user's own transactions and...

Introduction to Oracle SQL

Structured Query Language (SQL) is the set of statements with which all programs and usersaccess data in an Oracle Database. Application programs and Oracle...
pieces of paper with words

Sample Schemas

In Oracle Database, a database schema is a collection of logical data structures, or schema objects. A database user owns a database schema, which...
crop unrecognizable man inserting flashcard into laptop slot

Datafiles in Oracle (Physical Storage)

Overview of Data Files At the operating system level, Oracle Database stores database data in structures called data files. Every Oracle database must have at...
battle black blur board game

Oracle Database 19c – Practical & Assignments

PARAMETER & PASSWORDFILE: * Create pfile from spfile to location '/home/oracle/init<sid.ora>' * Create password file with sys password as oracle1 * Create parameterfile in different location /u01...