Blog

Suppose we have Sells (bar, beer, price) relation and a view is created to show all beers priced below $5:   CREATE VIEW AffordableBeers AS SELECT beer, price FROM Sells WHERE price < 5; A user attempts to insert the following record through the view:   INSERT INTO AffordableBeers (beer, price) VALUES ('Corona', 6.00); What will happen in this case?    

Given this trigger:  CREATE TRIGGER RoundPriceBEFORE INSERT ON SellsFOR EACH ROWSET NEW.price = ROUND(NEW.price);     A User attempts to execute the following statement on Sells (Bar, Beer, Price):     INSERT INTO Sells (bar, beer, price) VALUES (‘Joe”s Bar’, ‘Corona’, 4.75); What will happen to the price value inserted into the Sells table?    

Can a materialized view improve performance for queries that are run multiple times with the same data?

Suppose you have created the following view:   CREATE VIEW HighPricedBeers AS SELECT beer, price FROM Sells WHERE price > 5.00;   What does this view represent?

Consider the relation Sells (bar, beer, price) and the following view that has been created: CREATE VIEW ExpensiveBeers AS SELECT DISTINCT beer, price FROM Sells WHERE price > 5.00;   What happens when you attempt to update the ExpensiveBeers view?  

What is the angle between the OML and the IR plane for a Parietoacanthial (Waters) projection?

An AP Axial (Towne method) Skull image demonstrated the foramen magnum ‘closed off’. What was the error, if any?

A Left lateral skull projection was taken with the top of the patient’s head tilted away from the IR. What error will be demonstrated on the image?

Lateral Cervico-Thoracic Swimmers: patient’s independent shoulder could not be depressed sufficiently. How should the CR be placed?

Lateral Scapula image shows the lateral (axillary) border of the scapula next to the ribs while the medial (vertebral) border is at the external end. This error shows that the patient was ___________.