Dynamic

select (select 'Space_GIVEN_to_DB' from dual) as Note,

round(sum(d.bytes)/1024/1024/1024 + (sum(t.bytes)/1024/1024/1024),2) as Size_in_GB  

from

v$datafile d,

v$tempfile t

where

d.file#=t.file#(+)

group by 1

union

select

(select 'Space_USED_by_DB' from dual) as Note,

round(sum(size_in_bytes)/1024/1024/1024,2) Size_in_GB

from

(select

     tablespace_name,

     sum(bytes) size_in_bytes

  from

     dba_segments

  group by

     tablespace_name)

group by 1

order by 2 desc;

MoidIITDocID-640: Steps to get Oracle Certified (SQL Fundamentals, OCA / OCP)? --Moid Muhammad

As of 11/12/2024

Oracle Database SQLExam Number: 1Z0-071

Oracle Database Administration I Exam Number: 1Z0-082
Oracle Database Administration II Exam Number: 1Z0-083

Certification fee for each of the three (Oracle SQL Fundamentals, OCA and OCP) is $245. Only 1 attempt for exam. 

Format: Multiple Choice

Duration: 120 minutes

Number of Questions: 63 or 72

Passing Score: 63%

shop.oracle.com --> sign-in --> Browse Products --> Oracle University --> Exam Subscriptions --> Oracle Technology Exam Subscription --> Add to cart --> $245

Good site to practice: https://www.examtopics.com/exams/oracle/ and then select the following:

1z0-071: Oracle Datbase 12c SQL 

1z0-082: Oracle Database Administration I 

1z0-083: Oracle Database Administration II

Document is here.

Moid Muhammad