Archives from the Category Oracle - 1

Archived Articles from the Category Oracle

• Role of MERGE command? What's Upsert Functionality?
• DDL, DML, DCL, and TCL - what are they used for?
• SQL Query to find the lowest/top N records based on a column
• Difference between RANK() and DENSE_RANK() functions
• Difference between VARCHAR and VARCHAR2
• SQL Query to find every Nth row from a table
• SQL Query to remove duplicate records from a table
• Difference between DELETE, DROP, and TRUNCATE
• What is a Database Transaction?
• What's a relational DB? What are Integrity Rules?
• Difference between Server-side and Client-side DB Cursor
• Oracle Database - How to tune it for better performance?
• All types of Database Files used in Oracle Database
• Library Cache vs Data Dictionary Cache in Oracle DB
• SGA Memory Structure of the Oracle Database
• Oracle Server Architecture - Primary Components

Newer Articles >>