How would you delete enrollments before Jan 1, 2024?

DELETE FROM Enrollments WHERE EnrollmentDate

DELETE * FROM Enrollments WHERE EnrollmentDate

DELETE Enrollments WHERE EnrollmentDate

REMOVE FROM Enrollments WHERE EnrollmentDate

Which query displays course titles with their credit units in the format "Title (3 units)"?

SELECT CONCAT(CourseName, ' (', Credits, ' units)') FROM Courses;

SELECT CONCAT(CourseName, ' units: ', Credits) FROM Courses;

SELECT CourseName + Credits + ' units' FROM Courses;

SELECT CONCAT('Course: ', Credits, CourseName) FROM Courses;

What happens when you insert a NULL value into a NOT NULL column?

NULL is automatically converted

A university administrator needs to identify students who have been enrolled for at least 1460 days (4 years) as part of a graduation eligibility check. Which SQL Server query correctly retrieves these students?

SELECT * FROM Students WHERE DATEDIFF(DAY, EnrollmentDate, GETDATE()) >= 1460;

SELECT * FROM Students WHERE EnrollmentDate <= DATEADD(DAY, -1460, GETDATE());

SELECT * FROM Students WHERE DATEDIFF(DAY, GETDATE(), EnrollmentDate) >= 1460;

SELECT * FROM Students WHERE EnrollmentDate >= DATEADD(DAY, 1460, GETDATE());

The purpose of the PRIMARY KEY constraint is to:

Prevent duplicate values in one or more columns

Create a table with auto-delete

Automatically encrypt sensitive data

You want to display each student's ID, GPA, and the equivalent percentage score (computed as GPA * 20), labeling the computed column as EquivalentScore. Which SQL query is correct?

SELECT StudentID, GPA, GPA * 20 AS EquivalentScore FROM Students;

SELECT StudentID, GPA, GPA * 20 AS 'Equivalent Score' FROM Students;

SELECT StudentID, GPA, GPA * 20 AS (EquivalentScore) FROM Students;

SELECT StudentID, GPA, GPA * 20 ALIAS EquivalentScore FROM Students;

You want to ensure that EnrollmentDate has a default of the current date. Which definition is correct?

EnrollmentDate DATE DEFAULT GETDATE()

DEFAULT EnrollmentDate = CURRENT_DATE

EnrollmentDate DATE SET DEFAULT TODAY()

SET DEFAULT DATE EnrollmentDate

Which command would change a column's name from GPA to FinalGPA?

sp_rename 'Students.GPA', 'FinalGPA', 'COLUMN';

ALTER TABLE Students RENAME COLUMN GPA TO FinalGPA;

RENAME Students.GPA TO FinalGPA;

What is the result of using DECIMAL(4,2) for a grade value?

Causes overflow for any decimal

Converts values to text automatically

Which statement will cause a datatype error?

INSERT INTO Students (GPA) VALUES ('Excellent');

INSERT INTO Students (FirstName) VALUES ('Jane');

DELETE FROM Students WHERE GPA IS NULL;

UPDATE Students SET Email = 'user@domain.com';

You want to format a report showing "John Doe - Enrolled on May 10, 2024". Which query is correct?

SELECT CONCAT(FirstName, ' ', LastName, ' - Enrolled on ', FORMAT(EnrollmentDate, 'MMMM dd, yyyy')) FROM Students;

SELECT FORMAT(EnrollmentDate, 'dd MMM yyyy') + FirstName + LastName FROM Students;

SELECT CONCAT(FirstName, + , LastName, + - Enrolled on + , FORMAT(EnrollmentDate, 'MMMM dd, yyyy')) FROM Students;

SELECT FirstName + LastName + FORMAT(EnrollmentDate, 'mm/dd/yyyy') FROM Students;

You want to compute how long students have been enrolled. Which is correct?

SELECT StudentID, DATEDIFF(DAY, EnrollmentDate, GETDATE()) AS DaysEnrolled FROM Students;

SELECT TIMESPAN(GETDATE(), EnrollmentDate) FROM Students;

SELECT DURATION(EnrollmentDate) FROM Students;

SELECT GETDATE() - EnrollmentDate AS Days FROM Students;

You want to update students who have been enrolled for over 1000 days to set Status = 'Alumni'. Which SQL command is correct?

UPDATE Students SET Status = 'Alumni' WHERE DATEDIFF(DAY, EnrollmentDate, GETDATE()) > 1000;

UPDATE Students SET Status = 'Alumni' IF DATEDIFF(DAY, EnrollmentDate, GETDATE()) > 1000;

UPDATE Students SET Alumni = 'Yes' WHERE DATEDIFF(DAY, EnrollmentDate, GETDATE()) > 1000;

UPDATE Students SET Status = 'Alumni' WHEN DATEDIFF(DAY, EnrollmentDate, GETDATE()) > 1000;

What happens if you declare GPA as DECIMAL(2,2)?

You can only store values up to 0.99

Allows 2 digits after but no digits before decimal

Which statement returns course IDs with more than 3 enrollments?

SELECT CourseID FROM Enrollments GROUP BY CourseID HAVING COUNT() > 3;

SELECT COUNT(CourseID) > 3 FROM Enrollments;

SELECT * FROM Enrollments WHERE COUNT(CourseID) > 3;

SELECT CourseID GROUP HAVING COUNT() > 3 FROM Enrollments;

When using the FORMAT() function in SQL Server to display dates or numbers, what is the purpose of specifying a culture like 'en-US' or 'en-PH'?

To format the output value using regional conventions for dates and numbers

To set the database's default system language settings for the session

To convert all column values in the table into uppercase text format

To filter query results to records from a specified country location and for dates and numbers

How would you increase the GPA scale to accept maximum 3 digits before and 2 after the decimal?

ALTER TABLE Students ALTER COLUMN GPA DECIMAL(5,2);

ALTER TABLE Students SET COLUMN GPA TYPE DECIMAL(3,2);

ALTER TABLE Students SET GPA DECIMAL(5,2);

ALTER Students CHANGE GPA DECIMAL(5,2);

You want to mark students as 'Inactive' who enrolled more than 4 years ago. Which SQL command is correct?

UPDATE Students SET Status = 'Inactive' WHERE DATEDIFF(YEAR, EnrollmentDate, GETDATE()) > 4;

UPDATE Students SET Status = 'Inactive' IF DATEDIFF(YEAR, EnrollmentDate, GETDATE()) > 4;

ALTER Students SET Status = 'Inactive' WHERE DATEDIFF(YEAR, EnrollmentDate, GETDATE()) > 4;

UPDATE Students IF DATEDIFF(YEAR, EnrollmentDate, GETDATE()) > 4 SET Status = 'Inactive';

Which query shows students per instructor if student count is above 10?

SELECT InstructorID, COUNT(StudentID) AS Total FROM Enrollments GROUP BY InstructorID HAVING COUNT(StudentID) > 10;

SELECT InstructorID FROM Enrollments GROUP BY InstructorID WHERE COUNT(StudentID) > 10;

SELECT InstructorID, COUNT(StudentID) FROM Enrollments GROUP BY InstructorID WHERE COUNT(StudentID) > 10;

SELECT InstructorID, COUNT(StudentID) FROM Enrollments GROUP InstructorID HAVING COUNT(StudentID) > 10;

The dean wants to identify the highest GPA awarded among all graduating students in 2024. Which SQL query will correctly retrieve the highest GPA value for those students?

SELECT MAX(GPA) FROM Students WHERE GraduationYear = 2024

SELECT GPA FROM Students WHERE GPA = MAX(GPA) AND GraduationYear = 2024;

SELECT TOP 1 GPA FROM Students WHERE GraduationYear = 2024;

SELECT GPA FROM Students WHERE GraduationYear = 2024 ORDER BY GPA DESC;

The admissions officer needs a report showing the number of students per year level who enrolled between June 1, 2023 and May 31, 2024. Which SQL query is correct?

SELECT YearLevel, COUNT(*) FROM Students WHERE EnrollmentDate BETWEEN '2023-06-01' AND '2024-05-31' GROUP BY YearLevel;

SELECT YearLevel, COUNT(*) FROM Students WHERE EnrollmentDate BETWEEN '2023-06-01' ' OR '2024-05-31' GROUP BY YearLevel;

SELECT YearLevel, COUNT(*) FROM Students WHERE EnrollmentDate >= '2023-06-01' OR EnrollmentDate <= '2024-05-31' GROUP BY YearLevel;

SELECT YearLevel, COUNT(*) FROM Students GROUP BY YearLevel WHERE EnrollmentDate BETWEEN '2023-06-01' AND '2024-05-31';

The registrar needs to quickly display the name and GPA of the top-performing student in the entire university regardless of year. Which query achieves this in SQL Server?

SELECT TOP 1 StudentName, GPA FROM Students ORDER BY GPA DESC

SELECT TOP 1 StudentName, GPA FROM Students ORDER BY GPA ASC;

SELECT StudentName, GPA FROM Students WHERE GPA = (SELECT MAX(GPA) FROM Students);

SELECT MAX(GPA), StudentName FROM Students;

ADVANCED DATABASE SYSTEMS EXAM

Authored by ARLENE QUICAY

Information Technology (IT)

University

Used 8+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

33 questions

Show all answers

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');

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);

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

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;

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')

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();

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

Apple

Others

Already have an account?

Similar Resources on Wayground

35 questions

DSA Quiz - C

Quiz

•

University

30 questions

Модели 1 вариант

Quiz

•

University

30 questions

Enterprise Integration and JSON Quiz

Quiz

•

University

30 questions

Hawkin's hunt ROUND-2

Quiz

•

University

30 questions

ITPC 108 - Physical Security Control

Quiz

•

University

35 questions

Midterm Examination-ICSC0113- OS

Quiz

•

University

31 questions

CBS1153_Revision

Quiz

•

University

30 questions

MDM, ETL and Data Security - QUIZ 3

Quiz

•

University

Popular Resources on Wayground

7 questions

History of Valentine's Day

Interactive video

•

4th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Information Technology (IT)

18 questions

Valentines Day Trivia

Quiz

•

3rd Grade - University

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

5 questions

What is Presidents' Day?

Interactive video

•

10th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

20 questions

Mardi Gras History

Quiz

•

6th Grade - University

10 questions

The Roaring 20's Crash Course US History

Interactive video

•

11th Grade - University

17 questions

Review9_TEACHER

Quiz

•

University

ADVANCED DATABASE SYSTEMS EXAM

Which SQL command is used to update a student's email address in the Students table?

You want to create a table for courses offered in the current semester. Which is correct?

To ensure each enrolled student is a valid student, which constraint is appropriate?

You want to count students per course and display those with more than 10. What query should you use?

Which function would format the EnrollmentDate as "April 05, 2023"?

How do you find students enrolled in the last 30 days?

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?

How would you delete enrollments before Jan 1, 2024?

To restrict the Grade column to values between 0 and 100, use:

Which query displays course titles with their credit units in the format "Title (3 units)"?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Information Technology (IT)