The Relational Model and SQL DDL
Authored by Tomer Sagi
Computers
University - Professional Development
Used 16+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
5 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
2 mins • 1 pt
למה מקבילה קבוצת ישויות במודל הקונספטואלי -במודל הרלציוני ובמסד נתונים רלציוני
רלציה
יישות
טבלה
מפתח על
קשר
2.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
מה הדרך הכונה להמרת התרשים לטבלאות
ARTIST(ANR, aname);SINGER(ANR,music_style),ACTOR(ANR)
ARTIST(ANR, aname);SINGER(ANR,music_style),ACTOR(ANR)
SINGER(ANR, aname, music_style),ACTOR(ANR, aname)
ARTIST(ANR, aname);SINGER(ANR,music_style),
3.
MULTIPLE SELECT QUESTION
2 mins • 1 pt
Which of the following are SQL-DDL statements
CREATE TABLE...
CREATE RELATION...
DROP SCHEMA...
DROP RELATIONSHIP...
SELECT fieldName1 FROM table1...
4.
MULTIPLE SELECT QUESTION
2 mins • 1 pt
Which of the following can be done with ALTER TABLE?
Delete a column
Delete a constraint
Delete a table
Delete a schema
Add a default value
5.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
What type of diagram is this?
ER Diagram
EER Diagram
Class Diagram
Schema Diagram
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
