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

Interview Questions

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, 3 years3 years 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, 3 years3 years 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, 3 years3 years ago
Database Interview Questions

Oracle Database Interview Questions Set-1

1-Maximum number of Cluster Database Instances per Database we can create? Answer-Operating system-dependent 2- How many Row-level Locks can occur in Database? Answer-Unlimited 3-How many Distributed Lock Manager can occur in Database? Answer-Operating system dependent 4-What is the Maximum value of SGA in Database? Answer-Operating system-dependent (2 to 4 GB Read more…

By Ahmad, 3 years3 years ago

Posts navigation

Previous 1 … 10 11
Oracle ACE
Oracle ACE Associate
Awarded Top 60 Oracle Blogs
Recent Posts
  • Live Online Session 26th February 2023 Sunday
  • ORA-12520: TNS listener could not find available handler for requested type of server
  • Oracle GoldenGate 21c(21.3.0) is out for use!
Categories
  • Career (1)
  • Cloud (7)
  • Data Guard (3)
  • Database (104)
  • ERRORS (6)
  • GoldenGate (11)
  • Interview Questions (44)
  • Online Event (1)
  • Oracle12c (7)
  • Oracle19c (7)
  • Oracle20c (2)
  • Oracle21c (5)
  • Performance Tuning (4)
  • Personal (2)
  • RAC (6)
  • Webinars & Presentations (1)

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
  • Errors
  • Training
  • Contact Me
Developed and Maintained by Demunix