Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

IBM interview questions

-
IBM:
Tell me about yourself?
Day to day activities?
Monitoring Services in RAC?
How to find RAC instance?
Patch Steps?
how to find patch whether successfully applied or not?
How to recover the standby database not in sync with primary ?
How will find the gap in standby database?
Backup strategy in RMAN?
Restore scenario in RMAN?
Traditional exp/imp and Datapump difference?
Cloning Steps in RMAN?
How do you tune SQL queries to improve performance?
How to analyze query using explain paln?
How will you analyze AWR report?
Cummulative and Differential bkp difference?
Advantage of Catalog Mode in RMAN?


Temenos:

Tell me about yourself?
Day to day activities?
Patch Steps?
Difference in CPU and PSU Patch?
Traditional exp/imp and Datapump difference?
Performace parameter in Datapump?
Consistent Backup in Datapump and exp/imp
How will take table/tablespace/User Backup in exp/imp and Datapump?
Restore scenario in RMAN?
Incremental Backup in RMAN?
Datafile recovery step in RMAN?
How do you tune SQL queries to improve performance?
How to analyze query using explain paln?
How will you analyze AWR report?
Catalog and NoCatalog  Mode difference in RMAN?



Comments

Post a Comment

Popular posts from this blog

Pgbadger Feature In Postgresql

-
1. pgBadger reports everything about your SQL queries            Overall statistics            The most frequent waiting queries.            Queries that waited the most.            Queries generating the most temporary files.            Queries generating the largest temporary files.            The slowest queries.            Queries that took up the most time.            The most frequent queries.            The most frequent errors.            Histogram of query times.            Histogram of sessions times.            Users involved in top queries.            Applications involved in to...
Read more

ERROR: operator does not exist: text ->> unknown LINE 1: ...stomer' as customer_name,sales_info ->>'PRODUCTS' ->>'produc... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

-
postgres=# select * from sales; id | sales_info ----+---------------------------------------------------------------------------------- 1 | { "customer": "NIJAM", "PRODUCTS": {"product_name": "choclate","total_item": 6}} 2 | { "customer": "ABU", "PRODUCTS": {"product_name": "badam","total_item": 5}} 3 | { "customer": "UMAR", "PRODUCTS": {"product_name": "mobile","total_item": 1}} (3 rows) postgres=# SELECT sales_info ->>'customer' as customer_name,sales_info ->>'PRODUCTS' ->>'product_name' as name_of_product from sales where sales_info ->>'customer'='UMAR'; ERROR: operator does not exist: text ->> unknown LINE 1: ...stomer' as customer_name,sales_info -...
Read more

rman interview and scenario based questions and answer and also rman(backup and recovery) discussions panel

-
set 1 1.What is RMAN? Recovery Manager (RMAN) is a utility that can manage your entire Oracle backup and recovery activities. 2.What is the difference between using recovery catalog and control file?  When new incarnation happens, the old backup information in control file will be lost. It will be preserved in recovery catalog. In recovery catalog we can store scripts.  Recovery catalog is central and can have information of many databases. 3.Can we use same target database as catalog?      No, The recovery catalog should not reside in the target database (database should be backed up), because the database can’t be    recovered in the mounted state. 4.How do you know that how much RMAN task has been completed?    By querying v$rman_status or v$session_longops 5.From where list & report commands will get input? Both the commands command quering v$ and recovery catalog views. V$BACKUP_FILES or many of the recovery catalog views such as RC_...
Read more

PostgreSQL Enterprise Manager - PEM Monitoring Tools

-
Image
Database administration and management is required for any database on which there are continuous business transactions.  If databases across enterprises are not monitored and maintained, then such databases are vulnerable to disasters, which eventually brings downtime to missions-critical application and, of course, it will incur losses in the business. Data is now one of the key assets for running a business, globally. Hence, it is one of the major responsibilities of enterprises to invest in resources for database monitoring and management. There are many database management and monitoring tools available for proactive database monitoring. In this article, we will look at  PEM – “PostgreSQL Enterprise Manager” .Enterprise Manager, or PEM, is a graphical database management/monitoring tool that can help database administrators, system administrators, database developers, database managers, system architects, and performance analysts manage databases efficiently and proacti...
Read more

7 Steps to configure BDR replication in postgresql

-
Image
 The  BDR  (Bi-Directional Replication) project adds multi-master replication to PostgreSQL 9.4.  Postgres-BDR has a lower impact on the masters(s) than trigger-based replication solutions. There is no write-amplification, as it does not require triggers to write to queue tables in order to replicate writes.   Here We are using  postgres version 9.4.12 and bdr version 1.0.2. for configuring  multi master replication . Simply Following 7 steps you can configure the multi master replication in postgresql. To download the bdr in below link. .   https://github.com/2ndQuadrant/bdr/archive/bdr-pg/REL9_4_12-1.tar.gz $ tar -xzvf REL9_4_12-1.tar.gz $ wget https://github.com/2ndQuadrant/bdr/archive/bdr-plugin/1.0.2.tar.gz $ tar -xzvf 1.0.2.tar.gz 1. To install BDR. $ cd ~/bdr-bdr-pg-REL9_4_12-1 $ ./configure --prefix=/usr/lib/postgresql/9.4 --enable-debug --with-openssl $ make -j4 -s install-world $ cd ~/bdr-bdr-plugin-1.0.2 $ PATH=/usr/lib/p...
Read more