What is the purpose of the SELECT structure in SQL?
1.3.2 Databases
12th Grade
•10 Qs
Similar activities
Databases Week 2 Review
12th Grade - Professional Development
•12 Qs
ICTICT523 Session 2 - Business Priorities Quiz
12th Grade
•9 Qs
ICT Unit Test Topic : DBMS - Access
8th - 12th Grade
•15 Qs
Pre Test
12th Grade - University
•10 Qs
Cambridge Technicals Unit 2 LO3 [3.2 - 3.5]
12th Grade
•15 Qs
Midterm Quiz2 - Information Management
12th Grade
•7 Qs
Databases - Table & Entities
3rd - 12th Grade
•10 Qs
Access #1
12th Grade - University
•10 Qs
1.3.2 Databases
Quiz
•
Computers
•
12th Grade
•
Medium
Phil Branson
Used 3+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports
Microsoft
Apple
Others
Similar Resources on Quizizz
9 questions
DBMS Quiz
Quiz
•
12th Grade
15 questions
Access Vocabulary
Quiz
•
9th - 12th Grade
10 questions
DBMS-Open Office
Quiz
•
9th - 12th Grade
15 questions
BTEC unit 2 databases - key terms
Quiz
•
12th Grade
9 questions
ICTICT523 Session 2 - Business Priorities Quiz
Quiz
•
12th Grade
15 questions
Cambridge Technicals Unit 2 LO3 [3.2 - 3.5]
Quiz
•
12th Grade
15 questions
Access 2013 Lesson 1
Quiz
•
9th - 12th Grade
10 questions
Database Intro (A Level CS)
Quiz
•
11th - 12th Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts
Quiz
•
4th Grade
20 questions
Math Review - Grade 6
Quiz
•
6th Grade
20 questions
math review
Quiz
•
4th Grade
5 questions
capitalization in sentences
Quiz
•
5th - 8th Grade
10 questions
Juneteenth History and Significance
Interactive video
•
5th - 8th Grade
15 questions
Adding and Subtracting Fractions
Quiz
•
5th Grade
10 questions
R2H Day One Internship Expectation Review Guidelines
Quiz
•
Professional Development
12 questions
Dividing Fractions
Quiz
•
6th Grade