System Analysis and Design - Phase IV. Part 1

System Analysis and Design - Phase IV. Part 1

University

10 Qs

quiz-placeholder

Similar activities

OOP 1 Undiksha

OOP 1 Undiksha

12th Grade - University

13 Qs

Chapter 3 Exploring Linux Filesystems

Chapter 3 Exploring Linux Filesystems

11th Grade - University

10 Qs

Computer Network Fun Review 5 - Data Link Layer

Computer Network Fun Review 5 - Data Link Layer

University

10 Qs

PYTHON LOOPING

PYTHON LOOPING

University

10 Qs

Adobe Photoshop

Adobe Photoshop

University

10 Qs

After Effect Intoduction

After Effect Intoduction

10th Grade - University

15 Qs

Google Aptitude Test

Google Aptitude Test

KG - University

10 Qs

tik kelas 7

tik kelas 7

1st Grade - University

15 Qs

System Analysis and Design - Phase IV. Part 1

System Analysis and Design - Phase IV. Part 1

Assessment

Quiz

Computers

University

Medium

Used 7+ 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

15 mins • 1 pt

Which type of testing focuses on individual functions?

User acceptance testing
Integration testing
Unit testing
System testing

2.

MULTIPLE CHOICE QUESTION

15 mins • 1 pt

Which statement is NOT true about the implementation of logical data model?

Entities on the ERD are transformed into physical tables
Attributes of entities are transformed to table columns
Attributes of entities are transformed to table rows
Entity instances are inserted into table rows

3.

MULTIPLE CHOICE QUESTION

15 mins • 1 pt

Which SQL statement is responsible for creating the database schema

CREATE TABLE
INSERT INTO
SELECT
UPDATE TABLE

4.

MULTIPLE CHOICE QUESTION

15 mins • 1 pt

Which SQL statement is responsible for inserting data instances into table rows?

INSERT INTO
CREATE TABLE
SELECT
UPDATE TABLE

5.

MULTIPLE CHOICE QUESTION

15 mins • 1 pt

Which would be the most appropriate data type for the 'number of children' attribute of a 'Family' entity, if we later need to find families with more than one children?

fixed length string using CHAR
variable string using VARCHAR
whole number using SMALLINT
decimal number using NUMERIC

6.

MULTIPLE CHOICE QUESTION

15 mins • 1 pt

What does 'CREATE TABLE' NOT do

Define table name
Define column data types
Define entity and referential constraints
Populate data in the table

7.

MULTIPLE CHOICE QUESTION

15 mins • 1 pt

Media Image

Given the statement shown in the picture below, which statement is NOT true

The table has two attributes/columns
The table has a composite primary key (x, y)
The primary key constraint can also be defined as a column integrity rule
The primary key constraint is an example of a 'table integrity rule'

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?

Discover more resources for Computers