Oracle Ride
  • Home
  • About Me
  • Database
  • Cloud
  • GoldenGate
  • Exadata
  • Training
    • Online Training
    • Registration
    • Feedback
  • Contact Me

November 2019

Database Interview Questions

Oracle Database Interview Questions Set-4

1-What is Minimum Value of Database Block Size? Answer-2048 bytes (2 KB) (Must be a multiple of operating system physical block size) 2- What is Maximum Value of Database Block Size? Answer-32 KB 3- How many Database Blocks will be allocated in an initial extent of a segment? Answer-2 blocks 4- Read more…

By Ahmad, 1 year9 months ago
Database Oracle12c

Instance Architecture Enhancements In 12.2(12c R2)

Instance Architecture Enhancements In 12.2(12c R2) From Oracle Database 12c Release 2 (12.2), read-only and read/write instances can co-exist within a single database. It supports for read/write and read-only instances in the same database. As we know that every database instance is either read/write or read-only. Read-Only Instances Read-only instances Read more…

By Ahmad, 1 year7 months ago
Database Interview Questions

Oracle Database Interview Questions Set-3

1-Maximum levels of Subqueries in a SQL statement we can write? Answer-Unlimited in the FROM clause & 255 Subqueries in the WHERE clause 2-Maximum length of linear partitioning key in Per Partition? Answer-4 KB (overhead) 3-Maximum number of columns in partition key in Per Partition? Answer-(1024K – 1) 4-Maximum number Read more…

By Ahmad, 1 year9 months ago
Database Interview Questions

Oracle Database Interview Questions Set-2

 1-How many Shared Servers Maximum Per Instance we can Configure? Answer-Unlimited 2- How many Dispatchers Maximum Per Instance we can Configure? Answer-Unlimited 3-How many Parallel Execution Slaves Maximum Per Instance? Answer-Unlimited 4-How many Backup Sessions Maximum Per Instance? Answer-Unlimited 5-How many Services Maximum per Instance? Answer-8200 6-How many Indexes Maximum Read more…

By Ahmad, 1 year9 months ago

Posts navigation

1 2 Next
Oracle ACE Associate
Awarded Top 60 Oracle Blogs
Recent Posts
  • New Features for Database in Oracle 19c !!
  • New Features in Oracle Database 21c
  • Attention Log in Oracle 21c !!
Categories
  • Career (1)
  • Cloud (7)
  • Data Guard (3)
  • Database (94)
  • GoldenGate (10)
  • Interview Questions (44)
  • Oracle12c (7)
  • Oracle19c (7)
  • Oracle20c (2)
  • Oracle21c (3)
  • Performance Tuning (3)
  • Personal (1)
  • RAC (6)
Archives
  • January 2021 (5)
  • December 2020 (3)
  • November 2020 (5)
  • October 2020 (6)
  • September 2020 (9)
  • August 2020 (8)
  • July 2020 (21)
  • April 2020 (1)
  • February 2020 (2)
  • January 2020 (3)
  • December 2019 (6)
  • November 2019 (5)
  • October 2019 (5)
  • September 2019 (1)
  • August 2019 (1)
  • December 2018 (4)
  • November 2018 (6)
  • October 2018 (4)

Riaz Ahmad Ansari is an Oracle Consultant, Speaker, Blogger, YouTuber & Mentor.

He is famous for Ahmad’s nickname in the IT industry.

He has many years of experience as a production Oracle DBA managing all operating system based Oracle Databases.

He started working with Oracle Database starting from Oracle 9i to 10g/11g/12c18c/19c.

He has hands-on experience in real-world Production environments.

He is skilled with Oracle technologies such as Core DBA work, Data Guard, RMAN, Backup & Recovery, RAC, Cloud Control, and Performance Tuning.

  • Email
    ahmad@oracleride.com
  • Phone
    +91 9648108988
Follow Me
  • whatsapp
  • linkedin
  • facebook
  • twitter
  • youtube

Copyright ©️ 2020 OracleRide. All Rights Reserved.


  • Home
  • About Me
  • Database
  • Cloud
  • GoldenGate
  • Exadata
  • Training
  • Contact Me
Developed and Maintained by Demunix