1.3.2 Databases

1.3.2 Databases

12th Grade

10 Qs

quiz-placeholder

Similar activities

Common Protocols

Common Protocols

10th - 12th Grade

15 Qs

Word 2016 Lesson 1

Word 2016 Lesson 1

9th - 12th Grade

10 Qs

ICT as Platform for Change

ICT as Platform for Change

11th - 12th Grade

10 Qs

emtech

emtech

12th Grade

10 Qs

Visual Basic 2010

Visual Basic 2010

8th Grade - University

10 Qs

1.2.4. Types of Programming Language

1.2.4. Types of Programming Language

12th Grade

12 Qs

Test on Python Function

Test on Python Function

11th - 12th Grade

12 Qs

Types of Mass Media

Types of Mass Media

10th Grade - Professional Development

11 Qs

1.3.2 Databases

1.3.2 Databases

Assessment

Quiz

Computers

12th Grade

Practice Problem

Medium

Created by

Phil Branson

Used 3+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

JSON

OCR

OMR

HTML

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?