DBA is responsible for product upgrades, patches, access control, reviews, Server admin activities, Interface teams, Storage, performance, and maintaining database objects. DBA Responsibilities Responsible for DB/2 products in production and test environments. TMON monitoring tool, and the Platinum tools (RC Query, RC Migrator, Plan Analyzer, and Database Analyzer). Monitor DB/2 production servers…

UnboundLocalError While the variable in the function has already been defined, during execution, the result prints with an error of UnboundLocalError. Below, you will find an example that explains the issue and resolution. Error: file ‘example.txt’ not found Traceback (most recent call last): File “main.py”, line 16, in <module> open_file(“example.txt”) File “main.py”, line 11, in…

The condition is a variable you can use in the IF logic whether to continue the logic or to skip the logic in python. Here’s the best example for your reference. Python logic that uses condition statement # Python logic shows how to use condition statement password = "admIn" condition = (password == "admin") # if…

Here’re SQL queries that create a temp table from another in Oracle. The first SQL query creates a temp table’s structure. The second one creates a temp table with data. Temporary table structure Here I have created the customer table and inserted rows. --create table customer (name char(20), cust_id number); --insert into customer values('SRINI'…

Here are five tips every professional must read to have success in their life. Keeping boss happy Do you know exactly what your boss expects of you? If so: how do you know? Have you and your boss discussed these expectations? Here’s something you could do: write down the ten things that you…

Beyond the waterfall model and Agile model, you can see DevOps is a powerful model. Its functionality is powerful, and you can find Continuous integration and continuous delivery. So the deployment you can do seamlessly. DevOps CI CD Interview Questions 1.What is DevOps? DevOps, Continuous Practices, or DevOps Practices! DevOps is a culture transformation! …

I am practicing Hyperledger. This is one of the top listed blockchains. This architecture follows R3 Corda specifications. Sharing the interview questions with you that I have prepared for my interview. Though Ethereum leads in the real-time applications. The latest Hyperledger version is now ready for production applications. …

You can create and schedule a job in Oracle by using certain conditions. The conditions can be when to run and procedure details. The frequency of the job you can set. Below is an example that you can use for your practice. Note: The job scheduling you can do in…

Here is a SQL query you can use in the oracle database to search for a column name in which table it is used. So you can find the Table name. Recently in our application, we found an error. The error displayed a column name. But we had no clue…