Technical Interview didnt happen
Database Administrator Oracle Dba Interview Questions
593 database administrator oracle dba interview questions shared by candidates
Nothing as such. They asked me if I have experience to handle team
Asked about college projects and exposure to IT field in college
general oracle knowledge + example scenarios
mostly they asked me the issues i faced and did not have any technical questions for me that much they were asking about pl/sql develpment
I wasn't asked this question but it came up. With an Internet facing application, it would make more sense to move from single node databases to clustered databases. A single node Oracle database has to be shutdown to perform upgrades and some patches. With an Oracle RAC cluster , rolling upgrades can be performed while still maintain 100 percent uptime. It seems management is favorable to this move but it just doesn't seem to be a priority.
Tell me about yourself? Your role as a DBA? Your Day to Day activities? What is difference between oracle SID and Oracle service name? Oracle SID is the unique name that uniquely identifies your instance/database where as the service name is the TNS alias can be same or different as SID. What are the steps to install oracle on Linux system? List two kernel parameter that effect oracle installation? Initially set up disks and kernel parameters, then create oracle user and DBA group, and finally run installer to start the installation process. The SHMMAX & SHMMNI two kernel parameter required to set before installation process. What are bind variables? With bind variable in SQL, oracle can cache queries in a single time in the SQL cache area. This avoids a hard parse each time, which saves on various locking and latching resource we use to check object existence and so on. What is the difference between data block/extent/segment? A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents that an object takes when grouped together are considered the segment of the database object. What is the difference between PGA and UGA? When you are running dedicated server then process information stored inside the process global area (PGA) and when you are using shared server then the process information stored inside user global area (UGA). What is SGA? Define structure of shared pool component of SGA?
question about rac voting disk , global cache
Describe the node eviction and what causes it? What is OCLUMON? How would you tune query? How to backup a NOARCHIVELOG database without shutting it down? What is Fast Start Failover? Difference between ASMM and AMM?
Do you have any real time experience in oracle DBA
Viewing 411 - 420 interview questions