Question 1

What will be the output of the SQL Statement: SELECT Gender, Lastname FROM Prefinals WHERE Gender LIKE '_ale' AND Lastname LIKE '%h%'

Accepted Answer

no output/error

Answer

Abaho, Female

Answer

Female, Abaho

Answer

Male, Harvey

Question 2

What will be the output of the SQL Statement: SELECT Firstname, StudentNo FROM Prefinals WHERE StudentNo = '21-0007' OR Birthdate between '1981-01-01' AND '1990-12-31'

Accepted Answer

Harvey, 21-0007

Answer

no output/error

Answer

Magiba, 21-0005, Harvey, 21-0007

Answer

21-0007, Harvey, 21-0005, Magiba

Question 3

Choose the correct SQL Statement: Update 'Philip' in Firstname attribute and change it to 'Glenn'.

Accepted Answer

Update Prefinals Set Firstname='Glenn' WHERE StudentNo='21-0004'

Answer

Update Firstname = 'Glenn' TO Prefinals WHERE Firstname='Philip'

Answer

Update Prefinals Set Firstname='Philip' WHERE Firstname='Glenn'

Answer

Update Prefinals Set Firstname='Glenn' WHERE Gender='Male'

Question 4

Choose the correct SQL Statement: Insert 1 new record in Prefinals table.

Accepted Answer

Insert into Prefinals (StudentNo, Lastname, Firstname, Gender, Birthdate, Address)values ('20-0009', 'New', 'Value', 'Male', '2021-06-09', 'EPCST')

Answer

Insert into (StudentNo, Lastname, Firstname, Gender, Birthdate, Address)with ('20-0009', 'New', 'Value', 'Male', '2021-06-09', 'EPCST')

Answer

Insert into Prefinals ('20-0009', 'New', 'Value', 'Male', '2021-06-09', 'EPCST') WHERE (StudentNo, Lastname, Firstname, Gender, Birthdate, Address)

Answer

Insert values ('20-0009', 'New', 'Value', 'Male', '2021-06-09', 'EPCST') into Prefinals (StudentNo, Lastname, Firstname, Gender, Birthdate, Address)

Question 5

Choose the correct SQL Statement: Delete a record in the table Prefinals

Accepted Answer

Delete from Prefinals WHERE address = 'Nalvo'

Answer

Delete from Prefinals

Answer

Delete from Prefinals WHERE  gender ='Male'

Answer

Delete Prefinals WHERE address = 'Pasuquin'

Question 6

Choose the correct SQL Statement syntax in creating a table.

Accepted Answer

CREATE TABLE NewTable (PersonID int primary key, LastName varchar(255), FirstName varchar(255))

Answer

CREATE  NewTable (PersonID int primary key, LastName varchar(255), FirstName varchar(255))

Answer

CREATE TABLE NewTable (PersonID int primary key, LastName varchar(255), FirstName varchar(255)) values (1, 'Last', 'First')

Answer

CREATE TABLE NewTable (PersonID, LastName, FirstName)

Question 7

What will be the output of the SQL Statement: SELECT Lastname, Firstname WHERE Address = 'Pragata' OR StudentNo='21-0005'

Accepted Answer

no output/error

Answer

Gaspar, Magiba

Answer

Magiba, Gaspar, 21-0005

Answer

Magiba, Gaspar

Question 8

What SQL Statement would output the following:
Go, Lina, 21-0002
Ross, Michael, 21-0008

Accepted Answer

SELECT Lastname, Firstname, StudentNo FROM Prefinals WHERE Birthdate BETWEEN '1995-01-01' AND '1995-12-31'

Answer

SELECT Lastname, Firstname, StudentNo FROM Prefinals WHERE Gender='Male' OR Address = 'New York'

Answer

SELECT Lastname, Firstname FROM Prefinals WHERE Studentno='21-0002' OR Gender='Male' AND Studentno='21-0008'

Answer

SELECT Lastname, Firstname, Studentno FROM Prefinals WHERE Studentno='21-0002' AND Studentno='21-0008'

Question 9

What SQL Statement would output the following:
21-0002, Go
21-0003, Igo

Accepted Answer

SELECT Studentno, Lastname FROM Prefinals WHERE Gender LIKE 'F%ale' AND NOT Lastname ='Abaho'

Answer

SELECT Studentno, Lastname FROM Prefinals WHERE Firstname LIKE '%i%' AND Gender='Female'

Answer

SELECT Studentno, Lastname FROM Prefinals WHERE Gender='Fe%' AND Studentno Between '21-0002' AND '21-0003'

Answer

SELECT Studentno, Lastname  WHERE Lastname LIKE '%i%' AND Gender='Female'

Question 10

What SQL Statement would output the following:
Male, Gaspar, 21-0005

Accepted Answer

SELECT Gender, Firstname, Studentno FROM Prefinals WHERE address='Pragata' AND Gender='Male' OR Studentno='21-0005'

Answer

SELECT Gender, Firstname, Studentno FROM Prefinals WHERE Gender='Male' OR Studentno='21-0005'

Answer

SELECT Gender, Lastname, Studentno FROM Prefinals WHERE Studentno='21-0005' OR Birthdate between '1991-01-01' AND '1991-12-31'

Answer

SELECT Gender, Lastname, Studentno FROM Prefinals WHERE Birthdate='1991-09-17' AND Gender='Male'

Question 11

What SQL Statement would output the following:
Ben, Male
Harvey, Male
Michael, Male

Accepted Answer

SELECT Firstname, Gender FROM Prefinals WHERE Firstname LIKE '%e%' AND Gender='Male'

Answer

SELECT Firstname, Gender WHERE Gender='Male' AND Studentno='21-0001' OR Studentno='21-0007' OR Studentno='21-0008' ORDER BY Studentno ASC

Answer

SELECT Gender, Firstname FROM Prefinals WHERE Firstname LIKE '%e%'

Answer

SELECT Firstname, Gender FROM Prefinals WHERE Address='Pasuquin' AND Address='USA' AND Address='New York'

Question 12

What SQL Statement would output the following:
Ines
Spectre
Ross

Accepted Answer

SELECT Lastname FROM Prefinals WHERE StudentNo NOt IN('21-0005','21-0006') AND StudentNo BETWEEN '21-0004' AND '21-0008'

Answer

SELECT lastname FROM Prefinals WHERE Gender = 'Male'

Answer

SELECT firstname FROM Prefinals WHERE Gender = 'Male' AND Lastname Not In ('Magiba', 'Ben')

Answer

SELECT Lastname FROM Prefinals WHERE Address='New York' OR Address='USA' OR Address='Nalvo'

Question 13

What will be the output of the SQL Statement: SELECT Gender, Address FROM Prefinals WHERE Birthdate='2020-01-29' OR Gender='Male' AND Firstname LIKE '%e%' AND Lastname LIKE '%i%'

Accepted Answer

Male, Nalvo

Answer

no output/error

Answer

Male, Pasuquin - Male, Nalvo - Male, Pragata - Male, USA - Male, New York

Answer

Male, USA

Question 14

What will be the output of the SQL Statement: SELECT Lastname, Firstname, Gender, Address FROM Prefinals WHERE Firstname='%e%' OR StudentNo='21-0008'

Accepted Answer

Ross, Michael, Male, New York

Answer

Spectre, Harvey, Male, USA

Answer

no output/error

Answer

Lador, Ben, Male, Pasuquin - Spectre, Harvey, Male, USA - Ross, Michael, Male, New York

Question 15

What will be the output of the SQL Statement: SELECT Firstname FROM Prefinals WHERE Gender ='Female' AND Firstname LIKE '%i%'

Accepted Answer

Lina - Dina - Indi

Answer

Lina - Dina - Philip - Indi - Michael

Answer

No output/error

Answer

Igo - Ines - Magiba

Related quizzes

Related quizzes