Topics

Interview Q&A

• Interview Q&A for SQL Part-I
• Interview Q&A for SQL Part-II
• Interview Q&A for SQL Part-III
• Interview Q&A for SQL*Loader
• Interview Q&A for PLSQL
• Interview Q&A for Shell Script Part-I
• Interview Q&A for Shell Script Part-II
• Interview Q&A for Shell Script Part-III
• Interview Q&A for Apache Web Server Part-I
• Interview Q&A for Apache Web Server Part-II

Oracle SQL

• SQL Introduction
• SQL Sub Languages
• SQL Data Type
• SQL Create Table
• SQL Alter Table
• SQL Constraint
• SQL Update Statement
• SQL Delete Statement
• SQL Insert Statement
• SQL Dual Table
• SQL Numeric Functions
• SQL String Functions
• SQL Date Functions
• SQL NVL and NVL2 Functions
• SQL Case Function
• SQL Group by Clause
• SQL Having Clause
• SQL Order by Clause
• SQL Null Operations
• SQL Rownum Pseudo Column
• SQL Set Operator
• SQL Synonym
• SQL View
• SQL Inline View
• SQL Sequence
• SQL Database Link
• SQL Join
• SQL Sub-Query
• SQL Cluster Table
• SQL Index
• SQL Sub Language
• SQL Create table from another table
• SQL sysdate
• SQL*Plus Desc Command

Advance SQL

• SQL Analytical Functions
• SQL Merge Statement
• SQL Query Optimization Rules
• SQL Virtual Column
• SQL Global Temporary Table
• Execute SQL file
• Generate HTML report for SQL Query
• SQL Database Link
• SQL Query Processing steps
• SQL*Loader

Oracle PLSQL

• PLSQL Introduction
• PLSQL Data Types
• PLSQL Lexical Unit
• PLSQL Local and Global Variable
• PLSQL Loops
• PLSQL Cursor
• PLSQL Cursor Attribute
• PLSQL Parameterized Cursor
• PLSQL For Loop Cursor
• PLSQL Ref Cursor
• PLSQL Function
• PLSQL Procedure
• PLSQL Bulk collect and Forall
• PLSQL Trigger
• PLSQL Autonomous Transaction
• PLSQL Exception
• PLSQL Package
• PLSQL Utl_File Package
• PLSQL Collection
• PLSQL Collection Examples
• PLSQL Collection Methods
• PLSQL Program Examples

Differences Between 

Primary Key and Unique Key                    Primary Key and Foreign Key

Delete and Truncate                                   Decode and Case

Count(*) and Count(column)

Oracle DBA  

• Oracle Architecture
• Pfile and Spfile
• Shutdown Database
• Startup Database
• RMAN Catalog creation
• RMAN Commands
• RMAN Scripts
• Cloning database with RMAN
• Cloning Database without RMAN
• DBMS_STATS Package
• DBMS_METADATA Package
• User Management
• Tablespace Management
• Recyclebin
• DBA Queries
• Partitioning
• Partition Management
• Adding Datafile in ASM Database
• Oracle 11g Installation on Linux (Silent Mode)
• Oracle 11g installation on Linux
• exp Utility
• imp Utility
• Datapump
• Grant and Revoke of Privileges
• Oracle Audit
• Enable Archive log mode
• Disable Archive log mode
• Flashback
• AWR Report Extraction
• Upgrade Oracle 10g to 11g
• Upgrade 11g to 12c
• Oracle 11g Database with ASM grid installation in ...

Linux Command 

cp                  mv                     ps                       find                              grep

xargs             touch                 scp                      crontab

Shell Scripting