Activity 1 - Database Management System

Activity 1 - Database Management System

University

15 Qs

quiz-placeholder

Similar activities

Engineering Design Experience Quiz

Engineering Design Experience Quiz

8th Grade - University

15 Qs

Quiz Counter, FSM 2024

Quiz Counter, FSM 2024

University

15 Qs

Alpro 2 Mg 1 - Understanding C++ Basics

Alpro 2 Mg 1 - Understanding C++ Basics

University

10 Qs

Quiz Round For Group 1

Quiz Round For Group 1

University

20 Qs

MechnoSpell Challenge-002

MechnoSpell Challenge-002

University

10 Qs

Input & Output Interfacing Raspberry Pi Pico

Input & Output Interfacing Raspberry Pi Pico

University

10 Qs

Embedded Systems

Embedded Systems

University

10 Qs

Bioenergy

Bioenergy

University

15 Qs

Activity 1 - Database Management System

Activity 1 - Database Management System

Assessment

Quiz

Engineering

University

Practice Problem

Easy

Created by

Ms. Janani

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

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

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is rows of a relation known as?


Degree

Entity

Tuple

None

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is the name of the query that is placed within a WHERE or HAVING clause of another query?

Subquery
Join Query
Aggregate Query
Filter Query

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is the use of COUNT in SQL?

COUNT is used to delete rows from a table.
COUNT is used to update existing records.
COUNT is used to count the number of rows in a result set.
COUNT is used to create new tables.

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which data structure is used in Hierarchical model records?

Tree
List
Array
Graph

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which normal form deals with multivalued dependency?

Second Normal Form (2NF)
Third Normal Form (3NF)
Fourth Normal Form (4NF)
Fifth Normal Form (5NF)

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which of the following allows to uniquely identify a tuple?


Primary key
Unique constraint
Foreign key
Composite key

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt


Select the correct command to modify a column in a table.

ALTER TABLE table_name MODIFY COLUMN column_name new_data_type;
MODIFY TABLE table_name CHANGE column_name new_data_type;
CHANGE TABLE table_name ALTER COLUMN column_name TYPE new_data_type;
UPDATE table_name SET column_name = new_data_type;

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?