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

University

•

33 Qs

Similar activities

Cybersecurity I: Unit 1 - Foundations & Threats Exam Review

9th Grade - University

•

37 Qs

Вопросы по SQL

University

•

34 Qs

Python Básico

University

•

30 Qs

Phishing Awareness Quiz

University

•

30 Qs

Asesmen Akhir Informatika Kelas VII Semester Ganjil

7th Grade - University

•

32 Qs

Kuis Algoritma dan Pemrograman

University

•

37 Qs

Kuis Basis Data

University

•

30 Qs

C-Volution (Easy 1)

University

•

30 Qs

ADVANCED DATABASE SYSTEMS EXAM

Quiz

•

Information Technology (IT)

•

University

•

Practice Problem

•

Medium

ARLENE QUICAY

Used 8+ times

FREE Resource

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

Ms. Excel

Quiz

•

10th Grade - University

36 questions

Đề Cương HKII Tin 10

Quiz

•

10th Grade - University

28 questions

Quiz – Google Sheets Functions & Charts

Quiz

•

University

30 questions

180-210

Quiz

•

University

34 questions

52355429-a189-4d5f-8ac0-0994b9be5411

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Information Technology (IT)

7 questions

How James Brown Invented Funk

Interactive video

•

10th Grade - University

5 questions

Helping Build the Internet: Valerie Thomas | Great Minds

Interactive video

•

11th Grade - University

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

19 questions

Review2-TEACHER

Quiz

•

University

15 questions

Pre2_STUDENT

Quiz

•

University

20 questions

Ch. 7 Quadrilateral Quiz Review

Quiz

•

KG - University

ADVANCED DATABASE SYSTEMS EXAM

33 questions

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)