Chapter 4: Database Design Using Normalization

Chapter 4: Database Design Using Normalization

12th Grade

33 Qs

quiz-placeholder

Similar activities

PAS PRAKARYA & KEWIRAUSAHAAN KELAS XII IPA  IPS

PAS PRAKARYA & KEWIRAUSAHAAN KELAS XII IPA IPS

12th Grade

30 Qs

Principles of Marketing: Chapter 7 Test Review

Principles of Marketing: Chapter 7 Test Review

9th - 12th Grade

30 Qs

Principles of Business- Unit 1

Principles of Business- Unit 1

9th - 12th Grade

28 Qs

IGCSE Business Studies - 2.2.2 Leadership and Management Quiz

IGCSE Business Studies - 2.2.2 Leadership and Management Quiz

9th Grade - University

28 Qs

Ch8 Entrepreneurship Locate and Set up your Business

Ch8 Entrepreneurship Locate and Set up your Business

9th - 12th Grade

28 Qs

Excel Projects 1-5 Review

Excel Projects 1-5 Review

9th - 12th Grade

30 Qs

Sports and Entertainment Marketing Chapter 3

Sports and Entertainment Marketing Chapter 3

9th - 12th Grade

30 Qs

Test Business Essentials 1.02 Key Terms

Test Business Essentials 1.02 Key Terms

9th - 12th Grade

37 Qs

Chapter 4: Database Design Using Normalization

Chapter 4: Database Design Using Normalization

Assessment

Quiz

Business

12th Grade

Practice Problem

Medium

Created by

Thanagid Chaichayanon

Used 2+ times

FREE Resource

AI

Enhance your content in a minute

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

33 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When you are given a set of tables and asked to create a database to store their data, the first step is to ________.

assess the existing tables' structure and content

design the database structure

create one or more new tables

move the data into the new database

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The first step in assessing table structure includes ________.

counting rows

examining columns

examining data values

Both A and B are correct

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The second step in assessing table structure includes ________.

counting rows

examining columns

examining data values

A and B

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

During the second step of assessing table structure, you are trying to determine ________.

multivalued dependencies

data types

missing values

subqueries

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

During the second step of assessing table structure, you are trying to determine ________.

relationships

candidate keys

updatability

efficiency

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To count the number of rows in a table, use the SQL construct ________.

SELECT *

SELECT TOP n *

SELECT COUNT(TOP n)

SELECT COUNT(*)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The SQL function COUNT ________.

counts the number of columns in a table

counts the number of rows in a table

counts the number of tables in a database

counts the number of updates to a database

Create a free account and access millions of resources

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?