DBMS and SQL

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

• SELECT * FROM Items ORDER BY Price ASCENDING

• SELECT * FROM Items ORDER BY Price ASC

• SELECT * FROM Items BY Price LOWEST TO HIGHEST

• SELECT * FROM Items ORDER BY Price DESC

How would you DELETE records from the Items table with a "Chair" Type?

• DELETE 'Chair' FROM Items

• DELETE Type FROM Items WHERE Type = 'Chair'

• DELETE FROM Items WHERE Type = 'Chair'

• DELETE ITEMS WHERE Type = 'Chair'

Which SQL statement would add a record to the database?

• INSERT INTO Designer VALUES ('SMI01', 'M Smith', '[e-mail]', '01224123456')

• INSERT VALUES ('SMI01', 'M Smith', '[e-mail]', 01224123456') INTO Designer

• INSERT ('SMI01', 'M Smith', '[e-mail]', '01224123456') INTO Designer

• INSERT Designer INTO VALUES (''SMI01', 'M Smith', '[e-mail]', '01224123456')

Return the names and imdb_ratings of all movies with ‘day’ in the name.

• SELECT * FROM movies WHERE name LIKE ‘day’;

• SELECT name, imdb_rating FROM movies WHERE name LIKE '%day%';

• SELECT * FROM movies WHERE imdb_rating AND name LIKE ‘%day%’;

• RETURN name, imdb_rating FROM movies WHERE name LIKE '%day%';

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

• SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70

• SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70

• SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70

• SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70

A function that has no partial functional dependencies is in _______ form

• 3NF

• 2NF

• 4NF

• BCNF

Which command is used for removing a table and all its data from the database:

• Create command

• Drop table command

• Alter table command

• All of the mentioned

Write a code for the following: Return the names and imdb_ratings of all movies with ‘day’ in the name.

• SELECT * FROM movies WHERE name LIKE ‘day’;
• RETURN  name, imdb_rating FROM movies WHERE name LIKE '%day%';
• SELECT name, imdb_rating FROM movies WHERE name LIKE '%day%';
• SELECT * FROM movies WHERE imdb_rating AND name LIKE ‘%day%’;

Return all dramas made after 2004.

• SELECT * FROM movies WHERE genre = 'drama';
• SELECT * FROM movies WHERE genre = 'drama' AND year > 2004;
• SELECT * FROM movies WHERE genre = "drama' AND year < 2004;
• SELECT * FROM movies WHERE imdb_rating = 7 AND LIMIT = 7

Write the code for the following : Return all movies with the word love.

• SELECT * FROM movies WHERE name LIKE %love%;
• SELECT * FROM movies WHERE name LIKE ‘love’;
• SELECT * FROM movies WHERE name LIKE %love;
• SELECT * FROM movies WHERE name LIKE ‘%love%’;