-
Manual Backup
You have taken a manual backup of a datafile using o/s. How RMAN will know about it?
-
RMAN without Catalog
Where RMAN keeps information of backups if you are using RMAN without Catalog?
-
RMAN Backup Information
How do you see information about backups in RMAN?
-
RMAN Backup Time
How RMAN improves backup time?
-
RMAN Utility
What is the advantage of RMAN utility?
-
ARCHIVELOG mode
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
-
logical online backup
Can you take online backup of a Control file if yes, how? Explain about Logical Backup?
-
-
Familar Unix Files for DBA
As a Oracle DBA what are all the UNIX file you should be familar with?
-
Database hangs during Package Compile
When the developer trying to compile the package. But the database gets hanged? What will you check?
-
Changed Performance
When yesterday developer gives the following command: select count(*) from [table name]it gives the output within minutes, today the same command takes hours? What will you check?
-
Corrupted Rollback Segment
How will you rectify if one of the rollback segments gets corrupted
-
Naming exported files
When exporting using filesize parameter, if three files is generated. How the Oracle name this three files?
-
Differentiate file using filename
Three users at a time giving the following command: alter database backup controlfile to trace; How can you differentiate the file using the filename itself?
-
Identify Datafile in Backkup Mode
When you execute: alter tablespace begin backup; How can Oracle engine can identify that the corresponding datafiles are in backupmode?
-
Database Designing and Modeling
What are the differences between database designing and database modeling?
-
Search Method
If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan?
-
Execute Analyze Table Command
In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why?
-
Restricted Mode Memory Gap
How to check to memory gap once the SGA is started in Restricted mode?
-
OLTP Hanging Application
All the users are complaining that their application is hanging. How you will resolve this situation in OLTP?
-
Troubleshoot SQL * Plus
If the SQL * Plus hangs for a long time, what is the reason?
-
Increase %LIKE Operator Performance
How do you increase the performance of %LIKE operator?
-
Accessing Dual Table
Explain Dual table. Is any data internally stored in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get. Why?
-
Layer Exception Handling
In exception handling we have some NOT_FOUND and OTHERS. In inner layer we have some NOT_FOUND and OTHERS. While executing which one whether outer layer or inner layer will check first?
-
Mutated Trigger
What is mutated trigger? In single user mode we got mutated error, as a DBA how you will resolve it?
-
Schema Procedure and Data
Schema A has some objects and created one procedure and granted to Schema B. Schema B has the same objects like Schema A. Schema B executed the procedure like inserting some records. In this case where the data will be stored whether in Schema A or Schema B?
-
Recover corrupted database
If the entire disk is corrupted how will you recover the database and what are the steps to recover the database?
-
Full Table Scan
There are about a 10,000 records in a table. A user 1 runs a query which is doing a full table scan. While doing the full table scan, user 2 changes some value x to y using a DML statement in record. What does the the 1st user see ( x or y ) ? If x, then where is the value stored?
-
Tablespace Quota
A user has connect and resource privileges allocated by the DBA. He is been allocated quota on three tablespaces by the DBA - Default Tablespace Quota 500 M - Tablespace 1 Quota 100 M - Tablespace 2 Quota 200 M Now the user tries to make a table which uses 300 M in tablespace 2. Will he be successful?
-
Corrupted Archieve Logs
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
-
Recover Database
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in No-Archive log mode. How can the database be recovered?
-
Estimate SGA Size
How to estimate the size of SGA?
-
Corrupt Master Database
What do you do when the server cannot start due to a corrupt master database?
-
ASE Server Performance
What will you do when the ASE server's performance is bad?
-
Replication Server
Explain how will you setup Replication Server & sync it?
-
Temp DB Full
What do you do when tempdb is full?
-
Load Data into Multiple Tables
How to load data into multiple tables at once?
-
Stacktrace Server Error Log
What should you do when you find a stacktrace in the server errorlog?
-
Resize Tablespaces
Is it possible to resize tablespaces and data files? If yes, how?
-
Monitor and Modify Data during Loading
How to monitor how fast a table is imported? How to modify data as it loads into the database?
-
BCP Set of Rows
How do you BCP only a certain set of rows out of a large table?
-
Import Export Utilities
How does one use the import/export utilities?
-
Tuning Indicators
What tuning indicators can one use?
-
Configure Command
What is configure command? When do you use this?
-
Recovery Catalog
What is recovery catalog? Why do you need this?
-
Oracle Wallet
What is Oracle Wallet?
-
RMAN Encryption Option
List the encryption options available with RMAN?
-
Physical Standby Database
Outline the steps required for physical standby database creation?
-
RMAN with NetBackup, TSM Type Library
What are the steps required to perform in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library software?
-
DBID in Cloned Environment
Outline the steps for changing the DBID in a cloned environment?
-
DBID and Incarnation
What is the significance of incarnation and DBID in the RMAN backups?
-
RMAN Backup Advantages
List atleast 6 advantages of RMAN backups compare to traditional hot backups?
-
Identify Expired, Active, Obsolete Backups
How do you identify the expired, active, obsolete backups? Which RMAN command you use?
-
Control File Auto Backup
How do you enable the autobackup for the controlfile using RMAN?
-
Identify target database
How do you identify what are the all the target databases that are being backed-up with RMAN database?
-
Cumulative and Differential Incremental Backups
What is the difference between cumulative incremental and differential incremental backups?
-
RMAN Physical Standby database
Explain how to setup the physical stand by database with RMAN?
-
Target Database RMAN Backup
List the steps required to enable the RMAN backup for a target database?
-
Verify integrity of image copy
How do you verify the integrity of the image copy in RMAN environment?
-
SCN based hot backup recovery
Outline the steps involved in SCN based recovery from the full database from hot backup?
-
Cancel based hot backup recovery
Outline the steps involved in CANCEL based recovery from the full database from hot backup?
-
TIME based hot backup recovery
Outline the steps involved in TIME based recovery from the full database from hot backup?
-
RMAN Block Corruption
How do you identify the block corruption in RMAN database? How do you fix it?
-
Clone database using RMAN
How do you clone the database using RMAN software? Give brief steps? When do you use crosscheck command?
-
RMAN Duplicate
Is it possible to specific tables when using RMAN DUPLICATE feature? If yes, how?
-
Point in Time Recovery
Explain the steps to perform the point in time recovery with a backup which is taken before the resetlogs of the db?
-
Recover Full Database from Cold Backup
Outline the steps for recovering the full database from cold backup?
-
Obsolete and Expired RMAN backups
What is the difference between obsolete RMAN backups and expired RMAN backups?
-
RMAN Catalog View
List some of the RMAN catalog view names which contains the catalog information ?
-
Missing data file
Outline the steps for recovery of missing data file?
-
Online Redo Logs
Outline the steps for recovery with missing online redo logs?
-
DB Recovery File Dest
What is db_recovery_file_dest ? When do you need to set this value?
-
Missing archived redo logs
Outline steps for recovery with missing archived redo logs?
-
RMAN Auxiliary Channel
What is auxiliary channel in RMAN? When do you need this?
-
RMAN Parallel Backups
What is Channel? How do you enable the parallel backups with RMAN?
-
RMAN Backup Encryption
How do you enable the encryption for RMAN backups?
-
Backup Set
What is backup set?
-
RMAN Tape Backups
How do you setup the RMAN tape backups?
-
RMAN Recovery Catalog
How do you install the RMAN recovery catalog?
-
What is FRA
What is FRA ? When do you use this ?
-
Begin Backup Script
How do you generate the begin backup script?
-
Hot Backup Pre-requirements
When do you recommend hot backup? What are the pre-reqs?
-
Hot Backup Cold Backup
What is hot backup and what is cold backup?
-
Physical and Logical Backups
What is the difference between physical and logical backups?
-
RAID, RAID0, RAID1 and RAID10
What is RAID? What is RAID0? What is RAID1? What is RAID 10?
-
Tape Backup Solutions
What are the various tape backup solutions available in the market?
-
RTO MTBF and MTTR
What are RTO, MTBF, and MTTR?
-
Backup Strategy
What are things which play major role in designing the backup strategy?
-
Linux Interview Questions
== Users and permissions practicum == * Rig it so everything in the folder gets deleted tonight at 10pm. Every night at 10pm.== Local security == * How do you feel about `sudo`? * What's the difference between `telnet` and `ssh`? What's a good use for each? * How do you ensure your users have hard-to-guess passwords?== Filesystem == * What is the difference between a symbolic and hard link? When...