1.3.2 Databases

What is the purpose of the SELECT structure in SQL?

• To define which fields will be returned

• To define which tables will be used

• To define the criteria of the records returned

• To select a table to delete

Which normal form can be described as, 'all non-key elements are independent of all other non-key elements'?

• Third Normal Form (3NF)

• Second Normal Form (2NF)

• First Normal Form (1NF)

• Un-normalised (0NF / UNF)

A database has one table named 'Students' and another named 'Courses'. A record in the student table can relate to more than one entry in the courses table and vice versa. What type of relationship is this?

• Many-to-Many

• One-to-Many

• One-to-None

• One-to-One

What is the purpose of the LIKE structure in SQL?

• To enable the use of wildcards in WHERE statements

• To define which tables will be used

• To return only preferred records

• To define which fields will be returned

Which is best definition of a flat file database?

• A database with multiple independent tables with no links between them

• A group of separate databases with no links between them

• A database with little design or structure

• A database with multiple tables and defined relationship between those tables

Which of these is a method of data exchange between systems?

• JSON

• OCR

• OMR

• HTML

What is the purpose of the FROM structure in SQL?

• To define which tables will be used

• To define which fields will be returned

• To define the criteria of the records returned

• To enable field matches with wildcards

A teacher wants to export data from a spreadsheet into a plain text file for later importing to a database. Which method of data exchange are they most likely to use?

• CSV

• HTML

• FTP

• OCR

Which normal form can be described as, 'a relationship with repeating groups removed'?

• First Normal Form (1NF)

• Third Normal Form (3NF)

• Un-normalised (0NF / UNF)

• Second Normal Form (2NF)

Which of these is a method of data exchange between systems?

• CSV

• HTML

• OCR

• OMR