SQL ACID ACID properties When a transaction processing system creates a transaction, it will ensure that the transaction will have certain characteristics. The developers of the components that comprise the transaction are assured that these characteristics...
What are the Operating Modes and explain them? a. High Availability:- High-availability mode, runs synchronously. Requires a Witness Server instance. The Principal server sends the log buffer to the mirror server, and then waits for a response from the...
What is Hardening? As quickly as possible, the log buffer is written to the transaction log on disk, a process called hardening.
Prerequisites 1. Windows Server Failover Cluster (WSFC). 2. Quorum configuration using file sharing (Optional). 3. SQL Server 2012 Enterprise Edition. 4. Collation settings have to same on both the Nodes. 5. Two to Five servers acting as a Replica.
Question: I need an example of using the sqlldr (SQL*Loader) utility to load some data into my Oracle tables. Answer: The sqlldr utility has easy syntax, and here is a simple example in using SQL*Loader. Also see this sqlldr (SQL*Loader) example. Sqlldr...
1. How do you see how many instances are running? 2. How do you automate starting and shutting down of databases in Unix? 3. You have written a script to take backups. How do you make it run automatically every week? 4. What is OERR utility? 5. How do...
1. What is an Oracle Instance? 2. What information is stored in Control File? 3. When you start an Oracle DB which file is accessed first? 4. What is the Job of SMON, PMON processes? 5. What is Instance Recovery? 6. What is written in Redo Log Files?...
Oracle DBA Responsibilities (1) Creates and maintains all databases required for development, testing, education and production usage. (2) Performs the capacity planning required to create and maintain the databases. The DBA works closely with system...
How to Backup Oracle Database using RMAN (with Examples) Even if you are not an Oracle DBA, you’ll still encounter a situation where you may have to take a backup of an Oracle database. Using Oracle RMAN, you can take a hot backup for your database, which...
