Oracle Database

DATABASE ARCHITECTURE:

-Database Architecture 
-Difference between local inventory and global inventory:
-Sga_max_size & sga_target / memory_target & memory_max_target
-Database character set

-Users with sysdba can login to database without password!

-Oracle 11G New Features

-SID is different from Service name in Oracle

ORACLE - DATABASE Features:

-Oracle database 12c Feature:

-Oracle 19c feature

ORACLE - 12C:

1.Max_string_size parameter in oracle 12c:

2.Oracle multitenant 12c database architecture

3.Oracle_scripts  parameter  in oracle 12c:

4.Pdb starts automatically

5.Sys password change in oracle 12cR2 and 18c:

6. 

7. Oracle database interactive quick reference:

8. Unplugging/Plugging PDB:

SCAN:

1.Rename scan port in cluster:

2.How to rename scan in cluster:

3.Single client access name (SCAN):

4.Oracle RAC VIP and SCAN IPs

ORACLE DB PATCH:

1.Gid psu patch

ORACLE STANDBY:

1.Physical standby database

2.Creating standby database using rman

3.Switchover on oracle standby database

4.Physical standby differs from logical standby

DATABASE UPGRADE:

1. Database upgrade from 11.2.0.4 to 19.2.0.0 using manual method:

2.Interview Questions - Upgrade

ORACLE MISCELLANEOUS: 

1.Tns: lost contact ora-12547 

2.Script to check object lock

3.Interview question answer 

4.Invalid object count

5.Lock,block and deadlock

6.Use of the V$PWFILE_USERS:

7.PMON Process related to oracle home:

8.Oracle Version Details:

9.Difference between count(*) and count(col)

10.SQL*Plus not showing headings when running query:

11.Huge Archive/Redo data generated

12.ORA-04031 unable to allocate XXX bytes of shared memory

13.Redo logs Details.

14.Recover a table 

15. OMF (Oracle Manage Files)

16. Undo Tablespace/Undo Management in Oracle:

ORACLE DB INTERVIEW:

1. Oracle DBA Interview Questions

2.Expdp/Impdp – Datapump Questions/Answers:

3.Rman related question/answer:

4.Oracle DBA Interview Questions and Answers - Architecture

5.ORACLE  INTERVIEW QUESTION -DATA GUARD

6.Oracle DBA Interview Question - Export/Import:

7. Oracle DBA Interview Questions - Backup and Recovery

8.Oracle DBA Interview Questions- Patching,Cloning and Upgrade

9. Interview Question Answer

Export/Import:

Expdp/Impdp – Datapump Questions/Answers:

Oracle DBA Interview Question - Export/Import: