Blog

What is the role of histone acetyltransferase (HAT) in chromatin remodeling? (a) Removes acetyl groups to silence genes.  (b) Adds acetyl groups to activate gene expression.  (c) Breaks DNA strands to enable transcription.  (d) Binds transcription factors to recruit RNA polymerase.

Consider the chemical reaction shown below and the experimental data obtained for this reaction to answer parts A-E below. Part A: calculate the order with respect to S [blank1] Part B: calculate the order with respect to O2 [blank2] Part C: calculate the overall reaction order [blank3] Part D: calculate the specific rate constant for this reaction. Round your answer to 1 decimal place and do not include units in your answer.  [blank4] Part E: which of the below options (a-e) are the correct units for the rate constant in part D? Type your letter answer (lowercase) in the box below. [blank5] a. 1/Ms b. 1/Ms2 c. 1/M2s d. M/s e. M2s

What is this query doing:SELECT *, CASE WHEN default_account_number = 172 THEN “good”   WHEN default_account_number = 145 THEN “defaulted”     WHEN default_account_number = 307 THEN “defaulted”     WHEN default_account_number = 367 THEN “good”     WHEN default_account_number = 456 THEN “good”  END AS delays_goodFROM vendors; 

The statement CREATE VIEW view_sa3ASSELECT *FROM vendorsWHERE vendor_state NOT IN (“CA”,”MI”,”WI”,”AZ”);

What is the result of this query? SELECT *, IF(vendor_state regexp “IL” and vendor_contact_last_name regexp “John”, “Yes”, “No”) AS il_to_trackFROM vendors;

How many groups will this statement create and what is the group size for 101 customers?NTILE(5) OVER (ORDER BY Avg(TotalAmount) DESC) AS AvgGroup  

When this query is executed, the result set will contain SELECT vendor_name, COUNT(*) AS number_of_invoices,        AVG(invoice_total – payment_total – credit_total) AS balance_due FROM vendors v   JOIN invoices i   ON v.vendor_id = i.vendor_id  WHERE (invoice_total – payment_total – credit_total) >=     (SELECT AVG(invoice_total – payment_total – credit_total)     FROM invoices) GROUP BY vendor_name ORDER BY balance_due DESC;

Which query would run on the following view and will get the count of all vendors not from “CA” and not from “MI”:create view view_SA3 ASSELECT *FROM vendorsWHERE vendor_state NOT IN (“CA”,”MI”);

  What is the number for tooth “M” according to the triadan numbering system?

  What is the name of the fleshy membranous structure indicated by the arrow?