
ADVANCED DATABASE SYSTEMS EXAM
Quiz
•
Information Technology (IT)
•
University
•
Practice Problem
•
Medium
ARLENE QUICAY
Used 8+ times
FREE Resource
Enhance your content in a minute
33 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Which SQL command is used to update a student's email address in the Students table?
UPDATE Students SET Email = 'new@uni.edu' WHERE StudentID = 1;
SELECT Email FROM Students WHERE StudentID = 1;
ALTER Students SET Email = 'new@uni.edu' WHERE StudentID = 1;
INSERT INTO Students (Email) VALUES ('new@uni.edu');
2.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
You want to create a table for courses offered in the current semester. Which is correct?
CREATE TABLE Courses (CourseID INT, CourseName VARCHAR(100), Credits INT);
CREATE TABLE Courses (CourseID INT, CourseName VARCHAR(100), Credits INT(5,2));
CREATE TABLE Courses (CourseID, CourseName, Credits);
CREATE TABLE Courses (CourseID INT, CourseName TEXT(100), Credits INT);
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To ensure each enrolled student is a valid student, which constraint is appropriate?
CHECK
PRIMARY KEY
FOREIGN KEY
NOT NULL
4.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
You want to count students per course and display those with more than 10. What query should you use?
SELECT CourseID, COUNT(StudentID) FROM Enrollments GROUP BY CourseID HAVING COUNT(StudentID) > 10;
SELECT COUNT(StudentID), CourseID FROM Enrollments GROUP HAVING COUNT > 10;
SELECT CourseID, COUNT(StudentID) FROM Enrollments WHERE COUNT(StudentID) > 10;
SELECT CourseID FROM Enrollments GROUP BY CourseID WHERE COUNT(StudentID) > 10;
5.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
Which function would format the EnrollmentDate as "April 05, 2023"?
FORMAT(EnrollmentDate, 'MMMM dd, yyyy')
FORMAT(EnrollmentDate, 'mmmm dd, yyyy')
FORMAT(EnrollmentDate, 'yyyy/MM/dd')
FORMAT(EnrollmentDate, ' MMMM dddd, yyyy')
6.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
How do you find students enrolled in the last 30 days?
SELECT * FROM Students WHERE EnrollmentDate <= DATEADD(DAY, -30, GETDATE());
SELECT * FROM Students WHERE EnrollmentDate >= DATEADD(DAY, -30, GETDATE());
SELECT * FROM Students WHERE EnrollmentDate = GETDATE();
SELECT * FROM Students WHERE EnrollmentDate < GETDATE();
7.
MULTIPLE CHOICE QUESTION
30 sec • 2 pts
A database administrator needs to update the status of one specific student record. However, the UPDATE statement is written without a WHERE clause. What is the most likely outcome of executing this command?
No rows in the table will be affected
An error will occur because a condition is required
All records in the Students table will have their values updated
Only records with NULL values in the updated column will be changed
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?
Similar Resources on Wayground
30 questions
Year 5 ICT Revision Quiz
Quiz
•
5th Grade - University
30 questions
Revision Quiz 3
Quiz
•
9th Grade - University
29 questions
Web Development Quiz
Quiz
•
University
29 questions
Prelims Reviewer 3 Operating Systems
Quiz
•
University
30 questions
DBMS MIDTERM EXAM MCQ (2024-25)
Quiz
•
University
30 questions
Câu hỏi về mạng máy tính
Quiz
•
University
30 questions
Quiz Analisis Data kelas 8 24/25
Quiz
•
8th Grade - University
35 questions
Chapter 3 Mastering Significant Figures and Estimation
Quiz
•
7th Grade - University
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
Discover more resources for Information Technology (IT)
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
20 questions
christmas songs
Quiz
•
KG - University
20 questions
Holiday Trivia
Quiz
•
9th Grade - University
15 questions
Holiday Movies
Quiz
•
University
14 questions
Christmas Trivia
Quiz
•
3rd Grade - University
20 questions
Christmas Trivia
Quiz
•
University
8 questions
5th, Unit 4, Lesson 8
Lesson
•
KG - Professional Dev...
20 questions
Disney Trivia
Quiz
•
University
