Questions from Database Systems

Q: Write the SQL statements that might be used in transaction management and

Write the SQL statements that might be used in transaction management and explain how they work.

Q: Why does a multi-user database environment give us a special

Why does a multi-user database environment give us a special interest in transaction management and concurrency control?

Q: Write the SQL command to change the price code for all Action

Write the SQL command to change the price code for all Action movies to price code 3.

Q: Write a single SQL command to increase all price rental fee values

Write a single SQL command to increase all price rental fee values in the PRICE table by $0.50.

Q: Write the SQL command to save the changes made to the PRICE

Write the SQL command to save the changes made to the PRICE and MOVIE tables in Problems 98 – 101.

Q: Write a query to display the movie title, movie year,

Write a query to display the movie title, movie year, and movie genre for all movies (result shown in Figure P7.103). Figure P7.103 All Movies

Q: Write a query to display the movie year, movie title,

Write a query to display the movie year, movie title, and movie cost sorted by movie year in descending order (result shown in Figure P7.104). Figure P7.104 Movies by year

Q: Write a query to display the movie title, movie year,

Write a query to display the movie title, movie year, and movie genre for all movies sorted by movie genre in ascending order, then sorted by movie year in descending order within genre (result shown...

Q: Write a query to display the movie number, movie title,

Write a query to display the movie number, movie title, and price code for all movies with a title that starts with the letter “R” (result shown in Figure P7.106)....

Q: Write a query to display the movie title, movie year,

Write a query to display the movie title, movie year, and movie cost for all movies that contain the word “hope” anywhere in the title. Sort the results in ascendi...