1.What will happened if the database archive log destination is full and what will happened to the application transactions
2.How do you decommission a oracle database
3.What is psu, cpu and ru patches difference
4.What are the steps for upgrades from 11g to 12c and 12c to 19c
5.What to do if my query or batch job is taking time
6.What is database character set what is the difference between al32utf8 and other character set
7.Checklist before installing a oracle database and creating databases
8.How make the expdp and impdp to run faster lets say there is 5tb of db how to make it faster what are the various parameters
9.Yesterday the query is taking 5mins and today its taking 30mins why and what are the steps
10.You have completed patching on dev, test and preprod and now think you were doing patching on production environment and its taking much time so how can you handle this
11.You were doing upgrades from 11g to 19c and you were found invalid objects during upgrade and how can you fix those things
12.Have you done cross platform migrations and migration from on premises to cloud
14.Top things you will be checking in awr report
15.Golden gate exposure
16.What are the parameters to check while creating container database and pluggable database max, how many containers databases we can create
17.What is acfs, cachefusion, shared pool, scan ip, virtual ip, logical standby, physical standby db
18.How many ip's we need to configure for 2node rac
19.Can you please tell the steps to upgrade 2 node rac
20.Steps to apply a patch on dataguard environment and command to start a mrp process
21.what are the high level steps to apply a patch and how can you rollback a patch
22.What if my pfile and spfile is lost and how we start the database and what is the default location of pfile
23.What if control file is lost and how can we recover with rman
24.How the select, update, delete statement works in oracle database
25.How to recover if redo log member is lost and how to add a redo member to a grop
26.How to recovery if datafile is lost
27.A datafile was wrongly added on file system instead of ASM disk group. How to move it to the ASM disk group again?
28.How to apply a patch on 2node rac with standby database
29.How to configure fast start failover
30.What is ocr, olr, crsd, cssd and voting disk
31.What is cache fusion, cache coherence
32.What is vip, scanip how the nodes communicates each other
33.What is difference between rman and expdp
35.How to resolve block corruption with rman and will it resolve thru expdp
36.What is the role of pga during update statement
37.What is sql profile and db profile and how it works and how can you change the Plug a better plan hash value
38.I have a backup taken at 12.10AM and 12.30AM and how to restore the backup taken at 12.10 only
39.What is normal change and expedite change
40.I have a 4 node rac and if node is evicted then how to resolve it and how to relocate the services from one node to another node command to check the services
41.What is latch and how does it will occur and how to resolve it
42.My application is hanging and how do you trouble shoot it quickly
43.Suddenly the database performance is low after adding a disk to asm
44.What is backup piece
45.How to backup control file with rman
46.What is catalogue command in rman
47.Can we backup a online redo log file
48.What are the high level patching steps on oracle rac database
49.What is asm_power_limit what is the default value in higher versions
50.What is split brain syndrome
51.What if my ocr is corrupted and what are the steps and how to take a backup of ocr and voting disk
52.What if one of my voting disk is corrupted out of 5 voting disk
53.One of my table is dropped how to recover that table alone in oracle 12c
54.Junior dba removed oracle home with rm -rf command what will happen to the db can we recover the db
55.Junior dba removed the restore point from my primary database how to recover to the last restore point and is it possible to restore to the last restore point
56.You have upgraded the database from 11g to 12c or 19c after some days the application team wants to restore to the older version
57.How to restore if my compatible parameter is not set or if you have set the compatible parameter then can we restore to older version?
58.How to configure a 4 node rac what are the high level steps
59.How to upgrade the rac database/primary db with standby with lesser downtime
59.Orainventory is corrupted and how to recreate it
60.How to convert from noncdb to cdb
61.How to convert from nonasm to asm
62.Do you a have any basic knowledge in sqlservers
63.Do you a basic knowledge in goldengate
64.How to covert from physical standby to logical standby and physical to snapshot standby database
65.What Happened to Database, Suddenly Listener Got Down and how can you troubleshoot listener issues
66.What is oracle fine grained auditing and
67.What will you do if you see the cpu usage is 90 or 100%
68.What is in-memory, sga and pga and is sga and pga are dynamic parameters and how to increase memory the sga and pga and what prechecks you will do
69.How can you fin dout that there is a shortage of memory in the server and how will you increase it
70.What is crsctl disable/enable crs
71.What are the different types of rman backups available in rman and how to speed up the rman backup
72.What is cumulative and differential and what is full backup and level0 backup
73.What is block change tracking in rman
74.How many ip's do we need to configure for 2 node rac and 5 node rac and which ip's are to be in same subnet
75.What is public, private, scan ip and vip
76.What is Addm, Ash, and Awr and what are the things you will check in these reports
77.How can you find out if there are any vulnerabilities in oracle database
78.What are the things you will run after db creation how many ways you can create the db
79.What are the v$views, baseviews, dictionary views how to update these views
80.What are ways you can do for oracle database migration, what are the things you will check before migration
81.Which migration method did you used in your earlier project
82.What are the new features in oracle 19c,21c and which feature have you used in your recent project
83.How can you read the dumpfile if the logfile are not there
84.How many redundancy available in asm and what are those by default if we add a disk what is the redundancy
85.What is password file in oracle database
86.What is character set and how many types of character set in oracle
87.What is proactive and reactive tunning
88.What is pctfree and pctused
89.What are the waitevents in oracle rac and how to resolve it
90.What is haip in oracle rac
91.What if the private connection fails in oracle rac what are the steps to take inorder to avoid it
92.What is dB sequential and dbscaterred wait events and how to resolve
93.What is fragmentation how to resolve it
94.What to do if there heavy bulk inserts and updates on the db level
95.What is automatic and manual memory management
96.What to do if there are heavy sorts in oracle database what need to check at the pga and temporary tablespace level
97.What are hints and name some of the hints that we used
98.How to avoid the swiping and memory issues at the Linux os level
99.How can we run the rman backup job from a particular node in oracle rac, how can we configure the services to run on a particular node in oracle rac
100.What is MGMT database in Oracle 12c?
101.How to log all the dml activity of user on a table
102.If we apply a patch on 12c pdb and cdb will it apply to all or only to cdb
103.What does the AWR DB time represent?
104.I have taken export of A,B,C and D schemas and while importing if i mention remap_schema=A:B and
what will happen if i don't mention remap_schema=C:D and how it works
105.What is the difference between data guard and physical standby database
106.What are the mandatory background process for a oracle database, a rac and grid
107.Db is dropped but no space is released from asm disk ?
108.What is the difference between crosscheck, validate, obsolete and expired
