Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Opening a Database in Restricted Mode
Published by :
Obay Salah , November 19, 2024
In this mode, users are prevented from entering the database unless the user has the RESTRICTED SESSION PRIVILEGE privilege.In fact, this mode i... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Opening a Database in Read-Only Mode
Published by :
Obay Salah , November 19, 2024
The database is opened in Only Read mode to prevent any modifications to the database, but users can connect to the database and perform queries... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Shutdown Database
Published by :
Obay Salah , November 19, 2024
When closing the database, you must have the SYSOPER OR SYSDBA permission. There are several ways to close the database:1- NORMAL.2- TRANSA... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Startup Database
Published by :
Obay Salah , November 19, 2024
To run the database, you must specify the state in which you want your database to operate:1- NOMOUNT.2- MOUNT.3- OPEN.NOMOUNT:You can run... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Controlling The Database on Windows
Published by :
Obay Salah , November 19, 2024
Imagine that you are the administrator of a huge database, you are required to make this database available to everyone until a specific time, a... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Specifying CREATE DATABASE Statement Clauses
Published by :
Obay Salah , November 19, 2024
When you execute the CREATE DATABASE statement, Oracle Database performs several operations. The operations that are performed depend on the nod... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Creating a Database with the CREATE DATABASE Statement
Published by :
Obay Salah , November 19, 2024
Manual method to create database instead of using DBCA tool but after creating database using Create Database Statement additional procedures mu... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Prerequisites for Database Creation
Published by :
Obay Salah , November 19, 2024
To ensure that the database is created successfully, the following requirements must be met:The Oracle Software must be installed: This includes... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
About Selecting a Character Set
Published by :
Obay Salah , November 19, 2024
It is important to choose the appropriate Character Set for the database, Oracle recommends using AL32UTF8 as the Character Set.AL32UTF8 is Orac... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
About Creating an Oracle Database
Published by :
Obay Salah , November 19, 2024
We usually create the database during the installation of Oracle Database Software, however you can create the database after installing Oracle... Continue Reading