Databases - Exam questions

Question 1

Describe what is meant by a primary key

Answer 1

A unique identifier for every record in a tbale

Question 2

Write an SQL query that finds the name and presenter from all videos on the topic “the CPU”

Answer 2

Select Name, Presenter From Video Where Topic = The CPU

Question 3

Give an advantage and a disadvantage of indexing a field

Answer 3

ADV: Searches in that field can be preformed more quickly
DIS: The index takes up more space in the database

Question 4

Write an SQL statement that will remove all songs by an artist from the table Song

Answer 4

Delete From Song Where Artist = “Example”