System Analysis and Design - Phase IV. Part 1

System Analysis and Design - Phase IV. Part 1

University

10 Qs

quiz-placeholder

Similar activities

The AI Shield

The AI Shield

University

15 Qs

Unit 28 - Quiz #1

Unit 28 - Quiz #1

University

15 Qs

Quiz CodeIgniter 4

Quiz CodeIgniter 4

University

10 Qs

PROBLEM SOLVING USING R  UNIT I  MCQS

PROBLEM SOLVING USING R UNIT I MCQS

University

15 Qs

Quiz on Basics of C

Quiz on Basics of C

University

10 Qs

استعني علي الشقا بالله

استعني علي الشقا بالله

University

10 Qs

PYTHON_CHAPTER 6

PYTHON_CHAPTER 6

University

10 Qs

CHAPTER 5 ONLINE QUIZ

CHAPTER 5 ONLINE QUIZ

University

9 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?