Welcome to our school
Best Place To Learn IT related Courses.
Interview questions are a powerful tool for gaining knowledge by uncovering insights into someone's experiences, skills, and perspectives. Open-ended questions encourage detailed responses that reveal problem-solving abilities, challenges faced, and industry knowledge. By actively listening and asking follow-up questions, interviewers can gain valuable information about decision-making, leadership styles, and best practices, expanding their own understanding of the subject.
1. List out 10 memory level parameters?
2. Which commands leads to sorting? What memory area is used for sorting? How will you increase the performance of sorting? Name the parameters?
3. What will happen if you give commit? What are the wait events that affect log buffer?
4. How will you increase the size of library cache? What is hard and soft parse?
5. What is checkpoint? How will reduce the checkpoint frequency?
6. Explain the steps that involved when bringing up the database? How to drop the database? how to change the mode of database?
7. Explain instance recovery? Who does instance recvoery? Where will you check whether the instance recovery happened or not? What files were involved in the Instance recovery?
8. Who read the data into memory? How will you increaase the performance of write from DBBC to datafiles?
9. What is inittrans, maxtrans. what is the default values for table and index?
10. What is logging ad nologging? What is use of pctfree/pctused and pct increase?
11. How will you find fragmentation? How will you rectify it?
12. What is row chain and row migration? How will you find it and rectify it?
13. Why we should analyze a table?How to check if the table/index is analyzed? What is the command to gather stats/analyze?
14. What is differnce between? spfile/pfile pinned buffer/dirty buffer latch /enqueue LMT/DMT btree/bitmap?
15. When and how to rebuild index?
16. What are the types of partitions? Explain composit partitons?
17. What is different between system/hash partition?
18. What is partiton PRUNING?
19. Explain instance recovery? Who does instance recvoery? Where will you check whether the instance recovery happened or not? What files were involved in the Instance recovery?
20. How will you check the following?
- Table/index/view size
- Free space in database/tablespace
- Used space in database/tablespace
- How many indexes present for a table? check indexes columns and its positon? On what function the index is created?
- How many constraints are there in the table and on what columns? What are the constraint types?
21. What are the types of grants? Difference between GRANT/ADMIN Option?
22. What is password verification function? Steps to implement it?
23. Will discuss about profiles? Try to learn Password Resources?
24. What is snapshot too old error?
25. What is different between lock and deadlock?
26. How will you multiplex controlfile and logfile? How to increase the size of logfiles and datafiles?
27. What is the use of UNDO tablespace? How to hange the name of undo tablespace and location?
28. What is the use of temp tablespcae? how to change the location of temp tablespace?
29. What are the steps to create dbms scheduler? How to check the failed job / status?
30. What is use of flashback query /version/transaction/table?
31. What is UMASK?
32. How will find available port?
33. How to delete files that are older than 10 days?
34. Explain the logic for monitoring alert log, file system check?
35. How will you pass arguments to a shell scrits? How will you call them inside the shell? How to check how many number of arguments passed and list out them?
36. How to check the previous command that was execute is successful?
37. How to check the following?
- IpAddress
- Server Name
- OS release
- CPU count
- RAM size
- Users GroupName
- CPU Utilization
- IO Utilization
- Virtual Memory Utilization
38. Which command is used to find the process that was locking/using the file?
39. Which command is used to find the user who is using the file?
40. How to change the ownership of a file?
41. Prerequisite to install oracle on Linux? Expain kernel parameters?
42. Steps to configure silent mode installation?
43. Expain PATH, ORACLE_HOME,ORACLE_BASE,DISPLAY variables?
44. How to create database using dbca using putty with GUI terminal?
45. What is OMF? How will you use it?
46. What is oratab? What is the use of it?
47. Steps to configure automatic start and shut options? What is the use of chkconfig command?
48. What will happen if you execute root.sh?
49. What is rpm? How will you install rpm? How to check the existance of rpm?
50. Explain all the linux compression commands?
51. Explain crontab and its parameters?
52. What is Logical and Physical backup? Hot and Cold backup?
53. Explain the internals of hot backup in UMB?
54. Explain the steps to take hot backup in UMB?
55. How to recover a system datafile/non system datafile that is running in a production env?
56. How to recover a UNDO datafile/ tempfile that is running in a Production env?
57. How to recover a corrupted logfile,controlfile,spfile?
58. How to take a backup using rman and location should be in "/backup"?
59. How to increase the performance of RMan backup and explain it advantages over UMB?
60. What is the use of crosscheck, obsolete, expired commands?
61. Difference between differential and cumulative backup?
62. What is the use of BCT?
63. How to increase the performance of RMAN nackup?
64. How will recover a table sing RMAN? Explain the stepswith commands?
65. What is schema refresh?what are the post refresh activities after schema refresh?
66. Given a exp/expdp full dump (with out export logfile) how will you create a database with it?
67. What is the use of compress , consistent for exp?
68. What is teh performance parameters for exp/imp/expdp/impdp?
69. What are the performance parameters for SQL loader?
70. How will you take export of 20 tables? explain steps with commands?
71. Given a 100gb table dump, but having 5 gb of undo, how will you import the table?
72. On which oracle utility you will get snapshot too old error?
73. What is use of resumable_timeout parameter in DB as well as EXP/expdp?
74. How will you do schema refresh without removing grants from target schema?
75. How to export set of record from a table?
76. A datapump export is running with parllel=2. Now you are asked to increase the parallel=4 from another terminal, How will you do it?
77. Having the DB size ad 600GB. How will you take a database dumpfiles and copy that to another server. Explain the steps?
78. Is it possible to do a schema copy to another db with out dumpfile?
79. Explain the steps to transport tablespace?
80. What is the advantage of datapump over exp/imp?
81. Need to export a database using exp from putty even we get a network issue?$_COOKIE
82. Import a schema which is in tablespace USERS to another schema which is in tablespace USERS2?
83. how to goback to client mode from interactive mode in datapump?
84. How will you trouble shoot a client server connetion issue? Expplain all the possible issues?
85. If listerner is down, what will happen to the existeing connetion? what will happen to new connection?
86. How to check how many listeners are running on the server? How tio check their status?
87. Is it possible to change the listener and tnsnames location ? If so how to do that?
88. Expain the steps to recover a database using a backup from a location?
89. Explain the steps Rman cloning and active cloning?
90. Can we have 2 listeners for a single database and 1 listener for multiple database? If so How?
91. How to register a database to a listener?
92. How to setup a recover catalog? explain with steps?
93. Find the user who is locking a table?
94. How to find if a query is using index?
95. What are the possible chances that a index is not used by a query? How to force a index to be used?
96. How to intrepret execution pan?
97. If a user reports that a query hangs, how will you trouble shoot?
98. If a query run yesterday for 2 mins and it takes more than 1 hr, what might be the possible issue?
99. How will you kill a session even after it marked for killing in DB?
100. How will you check how many plans exists for a query?
101. How to check the duration of current running SQLS?
102. How to get the execution plan for a Query?
103. How will you trace a session? explain the steps? What will you check in it?
104. What is AWR? When will you go for AWR? how to take it and what will you look in to it?
105. Name some wait events (atleast 10) and explain how to resolve it?
106. What is ASH? Give the views related to ASH?
107. Explain joining methods with examples?
108. Name some hints (10 hints) and explain when that will be used?
109. How to make the query not to use the index?
110. What is the prerequisite to do upgrade / patching?
111. How to check the conflict of a patch?
112. How to install / rollback a patch?
113. How to list the patches installed? What does ./datapatch -verbose do?
114. What are the type of patches?
115. What is opatch and opatch auto?
116. How will you monitor while patching? Where the logs will be stored?
117. How to check how many users are connect to database from linux command?
118. How to remove kernel memory (shared/semaphores) from unix?
119. How to estimate the remaining time of running rman backup / gather stats?
1. What is Java?
2. What are the main features of Java?
3. What is the difference between JDK, JRE, and JVM?
4. What is the difference between `==` and `.equals()`?
5. What is the `final` keyword in Java?
6. What are the four principles of OOPS?
7. What is the difference between method overloading and overriding?
8. What is the difference between an abstract class and an interface?
9. What is a singleton class?
10. What is the `super` keyword used for?
11. What is the difference between checked and unchecked exceptions?
12. What is the `finally` block used for?
13. What is the difference between `throw` and `throws`?
14. What is the difference between `ArrayList` and `LinkedList`?
15. What is the difference between `HashMap` and `HashTable`?
16. What is the purpose of the `equals()` and `hashCode()` methods?
17. What is the difference between `Thread` and `Runnable`?
18. What is the `synchronized` keyword used for?
19. Write a program to reverse a string?
20. Write a program to check if a number is prime?
21. What is the difference between `public`, `private`, `protected`, and default access modifiers?
22. What is the difference between `String`, `StringBuilder`, and `StringBuffer`?
23. What is the `static` keyword used for?
24. What is a constructor?
25. What is the difference between a constructor and a method?
26. What is polymorphism?
27. What is encapsulation?
28. What is the difference between `this` and `super`?
29. What is an abstract class?
30. What is an interface?
31. What is a `try-catch` block?
32. What is a custom exception?
33. What is the difference between `final`, `finally`, and `finalize`?
34. What is the difference between `ArrayList` and `Vector`?
35. What is the difference between `HashSet` and `TreeSet`?
36. What is the difference between `HashMap` and `TreeMap`?
37. What is the purpose of the `Comparable` and `Comparator` interfaces?
38. What is a thread?
39. What is the difference between `start()` and `run()` methods in threads?
40. What is the `volatile` keyword used for?
41. What is the difference between `ArrayList` and `LinkedList`?
42. What is the difference between `HashMap` and `ConcurrentHashMap`?
43. What is the purpose of the `transient` keyword?
44. What is the difference between `Serializable` and `Externalizable`?
45. What is the difference between `wait()` and `sleep()`?
46. Write a program to find the factorial of a number?
47. Write a program to check if a string is a palindrome?
48. Write a program to find the largest number in an array?
49. Write a program to reverse a linked list?
50. Write a program to find the Fibonacci series?
1. What is vacuum & vacuumfull?
2. What are the database created during installation?
3. Difference between pg_dump, pg_dump all
4. Explain pg_upgrade
5. Explain replication set up
6. Explain migration set up
7. What is CTID in postgres?
8. What is temp buffer used for?
9. What is work mem used for?
10. What is WAL?
11. Explain architecture?
12. Difficulties faced in migration
13. Equivalent of BLOB, CLOB in postgres?
14. What is token?
15. Types of tablespaces?
16. What are types of index?
17. Which index will be used for jsonb datatype?
18. How will u start server?
19. Types of server start?
20. Fetch first five rows?
21. Transaction control in postgres?
22. Types of operator in postgres?
23. How will you dry run upgrade?
24. Can we restore a backup taken from version 12 to version 13?
25. Syntax for pg_basebackup with parameters explanation?
26. What is MVCC?
27. How to check idle and active sessions in postgres?
28. How and Why will you rebuild index?
29. How to check table fragmentation?
30. Explain pg_badger?
31. What is schema?
32. What is role?
33. How to take incremental backup? (pg_backrest - third party tool)
34. What is explain plan?
35. What is analyze?
36. What is pg_basebackup..steps?
37. What is PITR and explain steps?
38. What is freeze?
39. Type of authentication in pg_hba?
40. What is peer authentication?
41. Backup of data alone?
42. How to find locks?
43. What are the steps to follow if my query is slow?
44. How to schedule jobs in postgres?
45. What is max size of table in postgres?
46. What is CLOG?
47. Why BYTEA is used for?
48. What is sequence in postgres?
49. What is pg_repack?
50. How will you change standby to primary?
51. Find database, table size?
52. Change default tablespace of table/schema to user defined TBS?
53. What is DBlink?
54. Where is WAL file located and how to change the max value?
55. What will you analyze in pg_badger?
56. Work of BGwriter?
EduWell is the professional HTML5 template for your school or university websites.
You can download and use this EduWell Template for your teaching and learning stuffs.
Please tell your friends about the best CSS template website that is TemplateMo.
Aenean bibendum consectetur ex eu porttitor. Pellentesque id ultrices metus.
In non nisi eget magna efficitur ultricies non quis sapien. Pellentesque tellus.
Aenean bibendum consectetur ex eu porttitor. Pellentesque id ultrices metus.
In non nisi eget magna efficitur ultricies non quis sapien. Pellentesque tellus.
Aenean bibendum consectetur ex eu porttitor. Pellentesque id ultrices metus.
In non nisi eget magna efficitur ultricies non quis sapien. Pellentesque tellus.
Aenean bibendum consectetur ex eu porttitor. Pellentesque id ultrices metus.
In non nisi eget magna efficitur ultricies non quis sapien. Pellentesque tellus.
Praesent accumsan condimentum arcu, id porttitor est semper nec. Nunc diam lorem.
Master Java programming and build enterprise-level applications and dynamic web applications.
Learn more
Master PHP to build dynamic and interactive web applications and dynamic web applications.
Learn more
Learn containerization with Docker, manage microservices, and streamline deployments.
Deploy and orchestrate containers with Kubernetes for scalable, reliable apps.
Build cloud-native apps and ace AWS certifications with real-time cloud lab practice.
Deploy and orchestrate containers with Kubernetes for scalable, reliable apps.
Design data pipelines, manage big data tools, and ensure data reliability.
Learn more
Experts produced visual aids for enhanced understanding and learning.
VIEW VIDEOS
Refine yourself with model interview questions and gain the confidence to succeed.
EXPLORE QUESTIONS
Read insightful articles and offline guidance prepared by industry professionals.
Kogi VHS freegan bicycle rights try-hard green juice probably haven't heard of them cliche la croix af chillwave.
“just think about TemplateMo if you need free CSS templates for your website”
“think about our website first when you need free HTML templates for your website”
“just think about our website wherever you need free templates for your website”
“Praesent accumsan condimentum arcu, id porttitor est semper nec. Nunc diam lorem.”
“Praesent accumsan condimentum arcu, id porttitor est semper nec. Nunc diam lorem.”
“Praesent accumsan condimentum arcu, id porttitor est semper nec. Nunc diam lorem.”
“Praesent accumsan condimentum arcu, id porttitor est semper nec. Nunc diam lorem.”
“Praesent accumsan condimentum arcu, id porttitor est semper nec. Nunc diam lorem.”
Copyright © 2022 EduWell Co., Ltd. All Rights Reserved.
Design: TemplateMo
