Flashcards: SQL Queries, Dosimetry and Rational Numbers — 26 cards

How to find users missing from the latest report in SQL?

Select users whose UserID is not in the report with the maximum ReportDate.

How to find currently active users in SQL?

Select UserID and UserName from Users where UserStatus equals 'Active'.

How to find users with specific roles in SQL?

Select UserID, UserName and UserRole where UserRole is in 'Administrator', 'Manager' or 'Analyst'.

How to find users who joined in the current year in SQL?

Select users where YEAR(JoinDate) equals YEAR(CURDATE()).

How to find users without an assigned department in SQL?

Select users where DepartmentID IS NULL.

How to find users with salary greater than 50000 in SQL?

Select UserID, UserName and Salary where Salary > 50000.

What is the mean dose of the whole lesion?

55.6 Gy

How is the dose delivered during a 4-to-7-minute session calculated?

By multiplying 5.556 by 2 to get 11.11 Gy

What is the dose per session during a 4-to-7-minute treatment?

11.11 Gy

How is the dose of the plan by fraction calculated?

By multiplying 5.556 by 10 to get 55.56 Gy

What doses does the dosimetry plan compare?

Doses at 60% and 62% with compensation at 60% and 62%

What is the prime decomposition of 60?

$60 = 2^2 \cdot 3 \cdot 5$

What is the prime decomposition of 84?

$84 = 2^2 \cdot 3 \cdot 7$

How is the Greatest Common Divisor (GCD) obtained?

By taking common prime factors with the smallest exponents.

What is the GCD of 60 and 84?

12

How is the Least Common Multiple (LCM) obtained?

By taking all prime factors with the largest exponents.

What is the LCM of 60 and 84?

420

What is the value of $a^0$ for any number $a$?

$a^0 = 1$

What is the value of $a^{-1}$ for any number $a$?

$a^{-1} = \frac{1}{a}$

How do you reduce a fraction to irreducible form?

Divide numerator and denominator by their greatest common divisor.

What is the irreducible form of the fraction 20/30?

2/3

Is the fraction 35/39 reducible?

No, it is already irreducible.

What is the simplified form of the fraction 18/24?

3/4

Are the fractions 33/40 and 53/55 reducible?

No, both are already irreducible.

Which operations are included in calculating with relative numbers?

Addition, subtraction, multiplication, and division.

What type of problems does the course aim to solve involving rational numbers?

Problems involving rational numbers.