• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Interview Questions

Oracle RAC Interview Questions – Coherence and Split-Brain

By admin

What is Split-Brain? The term "Split-Brain" is often used to describe the scenario when two or more co-operating processes in a distributed system, typically a high availability cluster, lose connectivity with one another but then continue to operate independently of each other, including acquiring logical or physical resources, under the incorrect assumption that the other process(es) are no longer operational or using the said resources. What does "co-operating" mean? Co-operating … [Read more...] about Oracle RAC Interview Questions – Coherence and Split-Brain

Filed Under: Interview Questions, oracle, RAC

Linux Interview Questions – Linux Printing (CUPS)

By admin

This post covers the most often asked how-to questions about Linux printing support. What tool provides Linux printing support? CUPS, the Common Unix Printing System What kinds of printers can be attached to a Linux system? Linux support printers which are connected using any of the following: Locally Attached Printer (LPT) through a local parallel printer port. Locally Attached Printer (USB) through a local USB port. Remotely Attached Printer (IPP) using the Internet Printing … [Read more...] about Linux Interview Questions – Linux Printing (CUPS)

Filed Under: Interview Questions, Linux

Oracle Interview Questions – Flash Recovery Area

By admin

Naming convention: Oracle 10g: FLASH Recovery Area Oracle 11g: FAST Recovery Area 1. What is a Flash Recovery Area ? The flash recovery area is an Oracle-managed directory, file system, or Automatic Storage Management disk group that provides a centralized disk location for backup and recovery files. All the files you need to completely recover a database from a media failure are part of the Flash Recovery Area. Oracle creates archived logs and flashback logs in the flash recovery area. … [Read more...] about Oracle Interview Questions – Flash Recovery Area

Filed Under: Interview Questions, oracle

Oracle RMAN interview questions

By admin

General RMAN Questions What is RMAN and How to configure it? RMAN is an Oracle Database client that performs backup and recovery tasks on your databases and automates the administration of your backup strategies. It greatly simplifies the dba jobs by managing the production database's backing up, restoring, and recovering database files. This tool integrates with sessions running on an Oracle database to perform a range of backup and recovery activities, including maintaining an RMAN … [Read more...] about Oracle RMAN interview questions

Filed Under: Interview Questions, oracle, RMAN

Oracle Interview Questions : Recovery catalog for RMAN backup

By admin

Why use a recovery catalog? The RMAN catalog has several benefits. It makes restore if all the target database is lost, including the controlfile. As that controlfile contains all backup information, the catalog would then be used to identify a controlfile backup. If an RMAN catalog is not used, the controlfile autobackup should be configured to ON. There are some features which are only supported using an RMAN catalog. Primarily the ability to store scripts which would be available to all … [Read more...] about Oracle Interview Questions : Recovery catalog for RMAN backup

Filed Under: Interview Questions, oracle, RMAN

Oracle Interview Questions : Grid Infrastructure Single Client Access Name (SCAN)

By admin

SCAN Concepts Single client access name (SCAN) is the virtual hostname to provide for all clients connecting to the cluster (as opposed to the VIP hostnames in 10g and 11gR1). SCAN is a domain name registered to at least one and up to three IP addresses, either in the domain name service (DNS) or the Grid Naming Service (GNS). By default, the name used as the SCAN is also the name of the cluster and must be globally unique throughout your enterprise. The default value for the SCAN is based … [Read more...] about Oracle Interview Questions : Grid Infrastructure Single Client Access Name (SCAN)

Filed Under: Interview Questions, oracle, RAC

MySQL Interview Questions : Multi-source Replication in MySQL Server

By admin

Can I upgrade my slave from 5.6 to 5.7 and connect more masters to it? When upgrading so that the master version is lower/earlier than the slave version there is always a large risk it will not work. This is because newer versions may have made incompatible changes that means the older version will not be able to process or understand that change in the newer version. However, there is always a chance that it will work, but it is always recommended that if you want to go this way, attempt it … [Read more...] about MySQL Interview Questions : Multi-source Replication in MySQL Server

Filed Under: Interview Questions, mysql

Linux Interview Questions – Basic File and Directory Permissions

By admin

What are Basic Linux File permissions? Linux, like UNIX, is a multi-user system, and file permissions are one way the system protects against malicious tampering. One way to gain entry when you are denied permission is to su to root. Keep in mind, whoever knows the root password has complete access. But switching to the superuser is not always convenient or recommended since it is easy to make mistakes and alter important configuration files as the superuser. All files and directories are … [Read more...] about Linux Interview Questions – Basic File and Directory Permissions

Filed Under: Interview Questions, Linux

Oracle Database Interview Questions : Redo Logs and Archiving

By Devraj

What is the Redo Log? Redo Logs consist of two or more pre-allocated files that store all changes made to the database as they occur. Every instance of an Oracle Database has associated online redo logs to protect the database in case of an instance failure. Redo log files are filled with redo records. A redo record also called a redo entry, is made up of a group of change vectors, each of which is a description of a change made to a single block in the database. Redo entries record data … [Read more...] about Oracle Database Interview Questions : Redo Logs and Archiving

Filed Under: Interview Questions, oracle

Interview Questions : Oracle 12c Multitenant Database Architecture

By admin

General CDB / PDB Concept in 12c Multitenant Architecture What is a pluggable database (PDB) in Multitenant Architecture? Pluggable Databases (PDBs) is new in Oracle Database 12c Release 1 (12.1). You can have many pluggable databases inside a single Oracle Database occurrence. Pluggable Databases are fully backwards compatible with an ordinary pre-12.1 database. Why would I consider using the Multitenant option? You should consider following Database Consolidation Goals to … [Read more...] about Interview Questions : Oracle 12c Multitenant Database Architecture

Filed Under: Interview Questions, oracle, oracle 12c

Next Page »

Primary Sidebar

Recent Posts

  • How to disable ACPI in CentOS/RHEL 7
  • How to Use real-time query to access data on a physical standby database
  • CentOS/RHEL 8: “ACPI MEMORY OR I/O RESET_REG” Server Hung after reboot
  • How to Create a Physical Standby Database by Using SQL and RMAN Commands
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary