Mail us : hexainclude@gmail.com
Hexainclude

Menu

Skip to content
  • HOME
  • C/C++
    • C
    • C++
  • OS
  • RDBMS
  • JAVA
  • PHP
  • WORDPRESS
  • DOWNLOAD
    • eBOOKS

RDBMS

Hexainclude > RDBMS
31Jan/17

Index

January 31, 2017RDBMSduplicate-index, index, unique-indexDreamMaker

Some specific steps are perform by the oracle engine each time whenever user access record from the data base table. It will first search for a specific table on the hard diskRead More…

27Jan/17

VIEW

January 27, 2017RDBMSdatabase-view, readonly-view, updatable-view, viewDreamMaker

A view is a logical entity which is created from the base table. The main purpose of creating a view is to provide security over the database table. In some cases whenRead More…

27Jan/17

DUAL TABLE

January 27, 2017RDBMSdual, dual-tableDreamMaker

A dual table is oracle’s in built table. It can be used for arithmetic calculations. We can retrieve data from the dual table but cannot insert the data. It has only singleRead More…

25Jan/17

DEFAULT VALUE

January 25, 2017RDBMSdefault-value, insert_intoDreamMaker

Insert statement is used to insert record into the table but we have to specify each value for the column list. There are cases in which some value gets repeated for majorityRead More…

25Jan/17

USER CONSTRAINTS

January 25, 2017RDBMSbusiness-constraints, constraints, data-integrity-constraints, i/o-constraints, user-constraintsDreamMaker

We can use describe command to view logical structure of the table. It displays table structure including column name, data type, size & not null constant. It does not provide information aboutRead More…

Download Android App

Recent Posts

  • NESTED STRUCTURE
  • ARRAY OF STRUCTURE
  • Array Within Structure
  • SSTF Scheduling
  • FCFS Scheduling

All Posts

  • What is Java?
  • Java Virtual Machine (JVM)
  • What is RDBMS?
  • Dr.E.F.Codd’s Rules
  • Introduction of SQL
  • Introduction to Oracle
  • Basic Data Types
  • Windows 8 keyboard shortcuts
  • WordPress Introduction
  • What is PHP?
  • Installing Wamp Server
  • How to Remove BIOS Password?
  • How to recover data from device infected by virus?
  • Features of JAVA
  • Object Oriented Programming Principles
  • First Hello Word Program
  • Data Types
  • Operators
  • Arrays
  • Conditional Statements
  • Command-Line Arguments
  • Client-Server Architecture
  • CREATE TABLE
  • INSERT INTO
  • SELECT, WHERE, DISTINCT and ORDER BY
  • DELETE
  • Introduction of Classes, objects and methods
  • Constructor
  • What is Algorithm?
  • Flowchart
  • Types of programming languages
  • Interpreter and Compiler
  • History of C
  • C- Character sets
  • Structure of C Program
  • Basic Data Types
  • Procedure-Oriented Programming Language(POP)
  • Object-Oriented Programming Language (OOP)
  • Features of OOP
  • Introduction to C++
  • Structure of C++ program
  • Structure in C++
  • Method Overloading and Overriding
  • What is Android?
  • UPDATE
  • Instance Variable Hiding
  • GROUP BY
  • DROP AND TRUNCATE TABLE
  • Inheritance
  • Multilevel class Hierarchy
  • Interface
  • Creating Bootable USB drive
  • Display All Posts
  • Display all Post from Specific Category
  • Creating Menu
  • LIKE Predicate (pattern matching)
  • C-Token
  • How to add Category
  • Access Control Specifier
  • Package
  • Compilation and Linking Of C Program
  • IN / NOT IN Clause
  • Exception Handling
  • Creating new table from existing table
  • Class in C++
  • Transaction Control Language Statements (TCL)
  • What is Software?
  • What is Operating System?
  • Batch Operating System
  • Operators
  • String Handling Functions
  • Decision making statements
  • If…else statement
  • Else…If ladder
  • Nested if statement
  • Switch Statement
  • Multi Program Operating System
  • Time Sharing System
  • Real Time System
  • Distributed System
  • Conversion Function
  • Date Function
  • Numeric Function
  • Goto Statement
  • Looping Structures
  • Entry Control Loop
  • Exit Control Loop
  • Break, Continue and Exit
  • Layered System Structure
  • Aggregate Function
  • Oracle Functions
  • ALTER TABLE
  • Monolithic System Structure
  • Functions in C++
  • Default Argument
  • Object As Function Argument
  • Static Data Member and Member Function
  • Process State Diagram
  • Introduction to Array
  • Two-Dimension Array
  • Find ATM Loaded with Cash At Your City
  • Multi-Dimension Array
  • Constructor
  • Destructor
  • Process Scheduling
  • Schedulers
  • Introduction to String
  • Arrays of String
  • Context Switch
  • CPU Scheduling
  • Inline Function
  • Function Overloading
  • String Functions
  • Data Integrity Constraints
  • I/O Constraints
  • Business Constraint
  • PHP Data Types
  • PHP Variables
  • PHP Variable Scope
  • Scheduling Criteria
  • PHP Operators
  • Scheduling Scheme
  • Scheduling Algorithms
  • Shortest Job First (SJF)
  • Priority Scheduling
  • Round – Robin Scheduling
  • Interrupt Mechanism
  • Constructor Overloading
  • Creating Sitemap
  • How to Modify File Upload Limit?
  • Friend Function
  • Address Binding Schemes
  • Logical and Physical Address
  • Swapping
  • Memory Protection
  • Contiguous Memory Allocation
  • Fragmentation
  • Constraint Using ALTER TABLE
  • USER CONSTRAINTS
  • DEFAULT VALUE
  • DUAL TABLE
  • VIEW
  • Index
  • Paging
  • Segmentation
  • Virtual Memory
  • Demand Paging
  • Page Replacement
  • Operator Overloading
  • First In First Out (FIFO)
  • Overloading Unary Operator
  • Overloading Binary Operator
  • Overloading Insertion and Extraction Operators
  • Overloading Operators For String
  • Type Conversion
  • Basic to Class Type Conversion
  • Class Type to Basic Conversion
  • Class to Class Conversion
  • Optimal Algorithm
  • LRU Algorithm
  • Storage Hierarchy
  • Cache memory
  • Searching
  • Sorting
  • Introduction to Function
  • Elements of Functions
  • Types of Function
  • Call by Value v/s Call by Reference
  • Deadlock
  • Necessary Conditions for Deadlock
  • Deadlock Avoidance
  • Deadlock Detection
  • Recovery From Deadlock
  • What is File?
  • File Operations
  • Passing Array to Function
  • Matrix Operations
  • PHP Decision Making
  • PHP IF…ELSE
  • PHP ELSE…IF LADDER
  • PHP Nested IF
  • PHP Switch Statement
  • PHP Goto Statement
  • PHP Looping Structures
  • PHP Entry Control Loop
  • PHP Exit Control Loop
  • PHP Break, Continue and Exit
  • Recursion
  • What is File System?
  • I/O Hardware
  • Directory Structures
  • Facebook Like Button
  • Disk Scheduling
  • Adding Tweet Button
  • Adding LinkedIn Button
  • I/O Functions
  • Conversion Functions
  • Math Functions
  • Structure in C
  • Structure Declaration
  • FCFS Scheduling
  • SSTF Scheduling
  • Array Within Structure
  • ARRAY OF STRUCTURE
  • NESTED STRUCTURE
Copyright © Hexainclude
Developed by Hexainclude
  • TIPS &TRICKS
  • QUIZ
  • CONTACT US