DAB RECAP

Python

100

Name a type of conditional statement

if-elif-else

200

This built-in function counts the number of items in a sequence, such as the characters in a string.

len()

300

write a for loop to print 1 through 5

for i in range(5):

 print i

400

Write code to test if a variable is even or odd

if a%2 == 0:

  print even

else

  print odd

500

Rewrite the code using variables to output Hello there to the screen.

x="Hello"

y="there"

print("x","y")

x="Hello"

y="there"

print(x,y)

Bahraini Terms

100

إِشْخانته

Ishkhanateh

ما فائدته/ ما حاجته/ لا فائدة منه

What is his use? / What is the need for him? / He is useless

200

نُمُونَة

Numoona

شكل/ صنف/ نوع/ هكذا

Shape / Category (or class) / Type / Like this (or thus)

300

سَحَّجْ

Sahhaj

مَشَّط الشعر

Combed hair

400

سامَنْديگا

Samandaiga

لا يحل ولا يربط/ وجوده مثل عدمه

He is useless / His presence is like his absence

500

فَنْگَش

Fangash

مات وتوفى

He died / He passed away

Tableau

100

Indicates anumeric orquantitativevalue andapplies anaggregation onthe pill

Measures

200

This enables users to create a new column based on calculations or transformations applied to existing data

Calculated field

300

What do blue fields and green fields represent?

Blue > Discrete fields

Green > Continuous fields

400

This feautre allows users to limit the data displayed in a visualization by specifying criteria

Filter

500

This advanced calculation type allows users to perform aggregations and computations across different dimensions and granularity

A LOD Expression

SQL

100

Eliminates duplicates from a SQL query

DISTINCT

200

The GROUP BY clause is typically used with this aggregate function.

COUNT, SUM, AVG, MIN, MAX

300

What WHERE clause will select weight values between 2000 and 3000?

a) Where Weight >1999 and <3001

b) WHERE Weight between 2000 and 3000

c) WHERE Weight >= to 2000 and <=3000

400

The JOIN operation in SQL is used to combine data from multiple tables based on this.

Keys (Primary Key, Foreign Key)

500

A normalized database would ...

• Reduce data redundancy 
• Organize data into related tables
• Reduce storage space
• Eliminate duplicates
• Improve database performance

Science

100

This form of energy is produced when objects move.

Kinetic energy

200

This is the center of an atom and contains protons and neutrons.

Nucleus

300

This blood vessel carries oxygenated blood away from the heart.

Artery

400

This organ produces insulin.

Pancreas

500

This gas is the most abundant in Earth’s atmosphere.

Nitrogen (about 78%)