SQL-Database

Question 0

Relational dB

Answer 0

Use tables to store information and specify the relations between those tables

Question 1

Database (dB )

Answer 1

A storage space for content/ information (data)

An organized collection of data

Question 2

dB

Answer 2

Schema
Table
Field
Record
Query

Question 4

Schema (container)

Answer 4

A logical container for database object (tables, views, triggers) that user creates

Question 4

Field

Answer 4

Column

Simplest unit in database storage

Question 5

Table (container)

Answer 5

container for data elements and relations
Use columns(fields) and rows(records)

Question 6

Record

Answer 6

Row

Single structured data set in table

Question 7

Query

Answer 7

Your request to the database to retrieve information

Question 8

Report

Answer 8

returned information to the specified query

Question 9

DBMS (Database Management System)

Answer 9

a software that controls the organization

Question 10

What are the popular databases in the market?

Answer 10

ORACLE
Sybase
MySQL
DB2

Question 12

Primary Key (PK)

Answer 12

a unique field (column) in the table

maintain the internal integrity of a data table

Can have only 1 PK

Question 12

Foreign Key (FK)

Answer 12

a non unique field (column) that links one table to another table’s primary or FK

Can have many FK

Question 13

SQL

Answer 13

Structured Query Language
A dB computer language
Designed to retrieve and manage data
Designed to create and modify schema

Question 14

Normalization

Answer 14

the dB process of table design( organizing columns and fields) to minimize redundancy and dependency.

Divide large tables into smaller tables and defining relationships between them

Question 15

Boolean Data

Answer 15

-1(true), 0(false)

Question 16

Why we uses SQL?

Answer 16

• Getting data for testing;
• Saving data, generated during testing activity;
• Data verifications in databases:
• to find data;
• to ensure data integrity;
• to manipulate test data for specific tests;
• Testing databases;
• Grey Box testing.