What is a primary key in a database?

Database Concepts and SQL Quiz

Quiz
•
English
•
12th Grade
•
Hard
Sandisiwe Mjuleni
Used 1+ times
FREE Resource
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A type of foreign key
A method of data validation
A type of data type
A unique identifier for a record in a table
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL statement is used to retrieve data from a database?
INSERT
SELECT
UPDATE
DELETE
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the WHERE clause do in an SQL query?
Sorts the results
Joins tables
Filters records based on a condition
Groups records
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of data validation?
To ensure data integrity
To create tables
To delete records
To sort data
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a data type check?
Ensuring age is between 0 and 120
Verifying a name is less than 50 characters
Ensuring a number is entered in a numeric field
Checking if a field is not blank
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the DISTINCT keyword do in SQL?
Returns all records
Filters records
Returns unique values
Sorts records
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL command is used to add new rows to a table?
DELETE
INSERT
UPDATE
SELECT
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
Microsoft Word

Quiz
•
10th Grade - University
20 questions
13.2Tables

Quiz
•
8th Grade - University
20 questions
SQL and Database_1

Quiz
•
12th Grade
20 questions
Databases - Multiple Choice Questions ( CHAPTER 3)

Quiz
•
12th Grade
15 questions
13.1 Create a new document or edit an existing one

Quiz
•
8th Grade - University
20 questions
Typing Skills Final Exam

Quiz
•
6th - 12th Grade
15 questions
SQL and Database Quiz

Quiz
•
12th Grade
15 questions
sql quiz

Quiz
•
12th Grade
Popular Resources on Wayground
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade