Monthly Archive: March 2013

SQL Queries

SQL Queries

SQL Queries SQL Expressions: An expression is a combination of one or more values, operators, and SQL functions that evaluate to a value. SQL EXPRESSIONs are like formulas and they are written in query...

SQL Guide

SQL Guide

SQL Step Step Guide SQL Introduction (SQL History, Purpose of SQL, SQL Language Elements, and Subsets of SQL, Data Definition Language, Data Manipulation Language, and Data Control Language) Overview on Databases (Introduction to Data,...

Data Control Language

Data Control Language

Data Control Language (DCL): These SQL commands are used to implement security on database objects like table, view, stored procedure etc. DCL commands are used to enforce database security in a multiple user database...

Data Manipulation Language

Data Manipulation Language

Data Manipulation Language (DML): Data Manipulation Language is a one of the Subset of SQL. These SQL commands are used to store, modify, and delete data from database tables. In this category we have...

Data Definition Language

Data Definition Language

Data Definition Language (DDL) Data Definition Language is a one of subset of SQL. These SQL commands or statements are used to create, modify, and drop the structure of database objects like table, view,...

Overview On Databases

Overview On Databases

Overview On Databases What is a Database? : A database is a systematic collection of data. Databases support storage and manipulation of data. Databases make data management easy. They do so through the use...

SQL Introduction

SQL Introduction

SQL Introduction What is SQL? : SQL is ‘structured Query Language’ which is a computer language for storing, manipulating and retrieving data stored in relational database. SQL is a language of database, it includes...

Mainframe Application Testing  Interview Questions

Mainframe Application Testing Interview Questions

Mainframe Application Testing Interview Questions Q). What is Mainframe Computer /System? A large Electronic Data Processing System, can handle lacks of records. IBM builds Mainframe Computers. Today, Big companies; Banks, Insurance Companies, Travel and...

OpenSTA(Open System Testing Architecture)

OpenSTA(Open System Testing Architecture)

  OpenSTA(Open System Testing Architecture) Performance Testing: One or more Tests designed to investigate the efficiency of Web Application Environments (WAE). Used to identify any weaknesses or limitations of target WAEs using a series...