Case-Based Critical Thinking Questions
?
Case 8-1
Evaluate the formula =AND(G2="FT",M2>=1) based upon the information provided.
?
?
What value is returned assuming that G2 contains the value FT and M2 contains the value 2?

A. TRUE
B. FALSE
C. PT
D. PT, 2

Answer: A

Computer Science & Information Technology

You might also like to view...

Give serially equivalent interleaving of T and U with the following properties:

(i) that is strict; (ii) that is not strict but could not produce cascading aborts; (iii) that could produce cascading aborts.

View
Computer Science & Information Technology

Assume the following tables, describing employees and the departments in which they work, for all the parts of this question.

Emp(eid: integer, ename: string, salary: real)
Works(eid: integer, did: integer)
Dept(did: integer, dname:string)
(a) Write a SELECT statement that outputs the employee id (eid) of all employees that work in the department with department id (did) equal to 5. (b) Write a SELECT statement that outputs the names (ename) and salaries (salary) of all employees that work in the department with department name (dname) ?accounting?. (c) Write a SELECT statement that for each department outputs the department name (dname) and the number of employees that work in that department. (d) Write the declaration of a view that gives the name of each employee who works in more than one department.

View
Computer Science & Information Technology

A macro can be created to send reports via e-mail

Indicate whether the statement is true or false

View
Computer Science & Information Technology

Two computers connected by a wire cable form a network.

Answer the following statement true (T) or false (F)

View
Computer Science & Information Technology