Show Menu
Cheatography
  1. Home >
  2. Programming >

Interview Preparation Cheat Sheet (DRAFT) by

Testing contract interview Prep

This is a draft cheat sheet. It is a work in progress and is not finished yet.

SQL

Structured Query Language (SQL) is a standa­rdized progra­mming language that is used to manage relational databases and perform various operations on the data in them.
Types of SQL Statements
• Data Definition Language (DDL) Statem­ents.
• Data Manipu­lation Language (DML) Statem­ents.
• Transa­ction Control Statem­ents.
• Session Control Statem­ents.
• System Control Statement.
• Embedded SQL Statem­ents.

SQL

Some of The Most Important SQL Commands

• SELECT - extracts data from a database.
• UPDATE - updates data in a database.
• DELETE - deletes data from a database.
• INSERT INTO - inserts new data into a database.
• CREATE DATABASE - creates a new database.
• ALTER DATABASE - modifies a database.
• CREATE TABLE - creates a new table.
 

Testing Types

UI - User Inderface Testing
UI refers to the screens, buttons, toggles, icons, and other visual elements that you interact with when using a website, app, or other electronic device.

UX - User Experience
UX refers to the entire intera­ction you have with a product, including how you feel about the intera­ction
End-to-end testing
End-to-end testing is a method­ology that assesses the working order of a complex product in a start-­to-­finish process. End-to-end testing verifies that all components of a system are able to run and perform optimally under real-world scenarios.

End TO End Testing

End-to-end testing is a method­ology that assesses the working order of a complex product in a start-­to-­finish process. End-to-end testing verifies that all components of a system are able to run and perform optimally under real-world scenarios.

Difference between end to end testing and system testing

In system testing, whole software or applic­ation is tested at a time.

In end-to-end testing, behavioral flow of the software is tested.

System testing only tests the specific software system. end-to-end tests the software system and the connected systems both.
Difference between end to end testing and integr­ation testing

End to End: A helper robot that behaves like a user to click around the app and verify that it functions correctly. Sometimes called "­fun­ctional testin­g" or e2e.

Integr­ation: Verify that several units work together in harmony.

Unit: Verify that indivi­dual, isolated parts work as expected.