Oracle SQL & PL/SQL

SQL, SQL Server, Tutorials, Oracle, PL/SQL, Interview Questions & Answers, Joins, Multiple Choice Questions, Quiz, Stored Procedures, Select, Insert, Update, Delete and other latest topics on SQL, SQL Server and Oracle.

RSS Feed

PL/SQL Collections

Records

PL/SQL Tables

Varrays

Nested Tables

Newer Post Older Post Home

SQL Server - Multiple Choice Questions

SQL - Multiple Choice Questions

SQL Server, Oracle, SQL & PL/SQL

If you like reading this SQL Server, Oracle, SQL / PLSQL blog, please help increase the blogs' visibility by clicking on the 'g +1' button.

SQL Server / Oracle SQL

SQL Introduction

SQL Syntax

SQL Select

SQL Insert

SQL Update

SQL Delete

SQL Joins

SQL Examples of Joins

SQL Explicit vs. Implicit Joins

SQL Group By

SQL Group By Examples

SQL Having

SQL - IN

SQL - NULLs

Functional Dependencies

Normalization

ACID Properties

SQL SubQueries

SQL - Queries With Examples

SQL Views

Insert, Update, Delete Views

SQL Join Views

SQL Inline Views

SQL - Nth Highest Salary

SQL Second Highest Salary

SQL - Difference Truncate / Delete

SQL - Difference Truncate / Drop

SQL - Difference HAVING / WHERE

SQL - Difference CAST / CONVERT

SQL - Difference NOT IN / NOT EXIST

SQL - Difference IN / EXISTS

SQL - Difference UNION / UNION ALL

SQL - Difference Nested / Correlated Subquery

SQL - REPLACE

SQL - TOP

SQL - LIKE

SQL - SELECT INTO

SQL - CREATE TABLE

SQL - CREATE TABLE (More Examples)

SQL - ALTER TABLE

SQL - Difference views / Materialized views

SQL Count

SQL Update

SQL Clustered / Non-Clustered Indexes

SQL - Delete Duplicate Records

SQL - Difference Unique/Primary Key

SQL - GETDATE()

SQL - DATEDIFF()

SQL - DATEADD()

SQL - DATEPART()

SQL - Convert()

SQL - SUM()

SQL - AVG()

SQL - MIN()

SQL - MAX()

SQL - Insert Into Select

SQL - Insert Multiple Values In Table

SQL - Referential Integrity

SQL - Not Null Constraint

SQL - Unique Constraint

SQL - Primary Key Constraint

SQL - Foreign Key Constraint

SQL - Default Constraint

SQL - Check Constraint

SQL - ROLLUP

SQL - CUBE

SQL - STUFF()

SQL - Count_Big

SQL - Binary_Checksum

SQL - Checksum_AGG

SQL - Index Include

SQL - Covered Query

SQL - Identity

SQL - sp_columns

Difference Local / Global Temporary Tables

SQL - Diff Local/Global Temporary Tables

SQL - Stored Procedure

SQL - sp_who

SQL - Session

SQL - Dynamic SQL

SQL - SQL Server Execution Plan

SQL - sp_executesql

SQL - Difference Execute/Execute()

SQL - Case Expression

SQL - XML Variable Example

SQL - Pivot

SQL - Merge

Example of SQL Merge

Example of Merge Output Clause

SQL - Compute / Compute by

SQL - Diff SCOPE_IDENTITY / IDENT_CURRENT / @@IDENTITY

SQL Coalesce

SQL - Import Data into SQL Server Table

SQL - Delete Duplicate Records in SQL Server Table

SQL - Check If a Column Exists in SQL Server Table

SQL - Has_perms_by_name

SQL - Difference between Logins / Users

SQL - Diff between Table Variable/Temp Table

SQL - SQLServer 2012 features

SQL - SERVERPROPERTY

SQL - Find Primary Key / Foreign Key in Table

SQL - Sequence

SQL - Columnstore Indexes

SQL - Difference Primary / Candidate Key

SQL - Throw - SQL Server 2012

SQL - Difference GUID / INT

SQL Server 2012 Enhancements

Difference between Cross Join / Full Outer Join

SQL - Diff between Cross Join / Full Outer Join

SQL - NTILE()

SQL - Object Dependencies

SQL - Email Reminder on Updating Table

SQL - Object Definition

SQL Server - Report Builder 3

SQL Server - User Defined Roles

SQL Server - Filetables

SQL Server - Contained Databases

SQL Server - Update from Select

SQL Server - XML Methods

SQL Server - Add a Column to Table

SQL Server - Insert Multiple Rows

SQL Server - Add Identity Column to Table

SQL Server - Indexes

Difference Functions / Stored Procedures

SQL Server - Diff Functions / Stored Procedures

SQL - Comparison Operators Any / All

SQL - Difference Primary / Foreign Key

SQL - Difference Replace / Stuff

SQL - ROW_NUMBER()

SQL - Intersect

SQL Server - Local Variables

SQL Server - Update with Join

SQL Server - Difference Merge / Hash Join

SQL Server - Difference Update / Exclusive Lock

SQL Server - Difference Instance / Database

SQL Server - Difference Datetime2 / Datetime

SQL Server - Difference Disable / Drop Indexes

SQL Server - Difference Decimal / Float

SQL Server - DATEDIFF with Examples

SQL Server - Difference Raiserror / Throw

SQL Server - Check If Column Exists in Table

SQL Server - Query Excel Using Linked Server

SQL Server - WaitFor

SQL Server - Difference Rank, Dense_Rank & Row_Number

SQL Server - PATINDEX Examples

SQL Server - COLLATE Examples

SQL Server - Difference CHAR / VARCHAR

SQL Server - Interview Questions for Testers

SQL Interview Questions

Difference GRANT / DENY / REVOKE

Subqueries in WHERE clause - Examples

How to check indexes on a table?

DATENAME examples

SQL Join Interview Questions

Oracle PL/SQL

PL/SQL Introduction

PL/SQL Procedures

PL/SQL Functions

PL/SQL Collections

PL/SQL Records

PL/SQL Table Based Records

PL/SQL Programmer Defined Records

PL/SQL Cursor Based Records

PL/SQL Tables

PL/SQL Varrays

PL/SQL Nested Tables

PL/SQL Loops

PL/SQL Triggers

PL/SQL Cursors

PL/SQL Implicit Cursors

PL/SQL Explicit Cursors

PL/SQL REF Cursors

PL/SQL Cursor For Loop

PL/SQL Cursors with Parameters

PL/SQL Where Current Of and For Update

Examples of PL/SQL Cursors

PL/SQL Exceptions

PL/SQL Interview Questions

SQL PL/SQL Sitemap

SQL Tutorials / Topics

Best Practices for Creating Indexes Collate Collate Examples Common Table Expressions Contained Databases DateDiff Examples DATENAME DATENAME Examples DATETIME DATETIME2 Dense_Rank Dense_Rank & Row_Number DENY & REVOKE difference between CHAR and VARCHAR Difference between DATETIME2 / DATETIME Difference between GRANT difference between isNull COALESCE Difference Between Rank Difference decimal / float Difference Disable and Drop Indexes Difference RAISERROR and THROW Difference Server Instance / Database Drop Indexes Dynamic Data Masking find indexes on table Hash Join how to use index in sql server isNull Vs COALESCE Join Hints know indexes on a table Merge Join Multiple Choice Multiple Choice Questions - UNION ALL Partially Contained Databases PATINDEX examples Questions & Answers Hash Join Rank Row_Number sparse columns SQL Columnstore Indexes SQL Data Types SQL DateDiff SQL decimal / float difference SQL Delete SQL Excel Linked Server SQL EXISTS & IN SQL Expressions SQL GRANT SQL HAVING / GROUP BY SQL Identity Column Questions SQL Inbuilt Functions SQL Indexes SQL Insert SQL Insert and Update SQL Interview Questions SQL Join Questions SQL Join Questions & Answers SQL Joins & Nulls SQL Keys SQL Local Variables SQL Merge SQL Normalization SQL NULL SQL ORDER BY SQL PL/SQL Interview Questions SQL Server - WAITFOR SQL Server 'Like' SQL Server Always Encrypted SQL Server Backup & Restore SQL Server Cast & Convert SQL Server Collate SQL Server Collation Examples SQL Server Contained Databases SQL Server Date / Time SQL Server DateDiff SQL Server DATENAME SQL Server Exclusive Lock SQL Server Files & Filegroups SQL Server Inbuilt Functions sql server index creation best practices SQL Server Indexed Views SQL Server Indexes SQL Server Indexes best practices SQL Server Interview SQL Server Interview Questions SQL Server Join Questions SQL Server Linked Server SQL Server Locks SQL Server Permissions SQL Server Questions SQL Server Questions Answers SQL Server Row Level Security SQL Server Sequence Objects SQL Server sparse columns SQL Server Table Columns SQL Server Update Lock SQL Server Window Functions SQL sparse columns SQL Stored Procedures Questions Answers SQL Subqueries SQL Subquery SQL Tables SQL Temp Tables SQL Truncate SQL Union SQL Views SQL Where Clause SQL Where with Wildcards SQL XML Data Type & Columns Subqueries in WHERE Clause

Powered by Blogger.