Database Mang. Sys

Question 1

Which operator is used to select values within a range?

Answer 1

BETWEEN

Question 2

With SQL, how do you select all the columns from a table named “Persons”?

SELECT [all] FROM Persons

SELECT *.Persons

SELECT Persons

SELECT * FROM Persons

Answer 2

SELECT * FROM Persons

Question 3

Which SQL statement is used to delete data from a database?

Answer 3

DELETE

Question 4

Which SQL statement is used to update data in a database?

Answer 4

UPDATE

Question 5

With SQL, how do you select all the records from a table named “Persons” where the “FirstName” is “Peter” and the “LastName” is “Jackson”?

SELECT FirstName=’Peter’, LastName=’Jackson’ FROM Persons

SELECT * FROM Persons WHERE FirstName=’Peter’ AND LastName=’Jackson’

SELECT * FROM Persons WHERE FirstName<>’Peter’ AND LastName<>’Jackson

Answer 5

SELECT * FROM Persons WHERE FirstName=’Peter’ AND LastName=’Jackson’

Question 6

Which SQL statement is used to create a database table called ‘Customers’?

CREATE DATABASE TABLE Customers

CREATE DB Customers

CREATE DATABASE TAB Customers
CREATE TABLE Customers

Answer 6

CREATE TABLE Customers

Question 7

How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen

MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

Answer 7

UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

Question 8

Which SQL statement is used to extract data from a database?

GET

OPEN

SELECT

Answer 8

SELECT

Question 9

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” is “Peter”?
Correct answer:

SELECT * FROM Persons WHERE FirstName=’Peter’

SELECT [all] FROM Persons WHERE FirstName=’Peter’

SELECT * FROM Persons WHERE FirstName<>’Peter’

SELECT [all] FROM Persons WHERE FirstName LIKE ‘Peter’

Answer 9

SELECT * FROM Persons WHERE FirstName=’Peter’

Question 10

With SQL, how can you insert “Olsen” as the “LastName” in the “Persons” table?

INSERT INTO Persons (‘Olsen’) INTO LastName

INSERT INTO Persons (LastName) VALUES (‘Olsen’)

INSERT (‘Olsen’) INTO Persons (LastName)

Answer 10

INSERT INTO Persons (LastName) VALUES (‘Olsen’)

Question 11

With SQL, how can you delete the records where the “FirstName” is “Peter” in the Persons Table?

DELETE ROW FirstName=’Peter’ FROM Persons
, Not Selected

DELETE FROM Persons WHERE FirstName = ‘Peter’

DELETE FirstName=’Peter’ FROM Persons

Answer 11

DELETE FROM Persons WHERE FirstName = ‘Peter’

Question 12

With SQL, how can you return the number of records in the “Persons” table?

SELECT LEN(*) FROM Persons

SELECT NO(*) FROM Persons

SELECT COUNT(*) FROM Persons

SELECT COLUMNS(*) FROM Persons

Answer 12

SELECT COUNT(*) FROM Persons

Question 13

What is the most common type of join?

JOINED

INSIDE JOIN

INNER JOIN

JOINED TABLE

Answer 13

INNER JOIN

Question 14

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

True

False

Answer 14

TRUE

Question 15

With SQL, how can you insert a new record into the “Persons” table?

INSERT INTO Persons VALUES (‘Jimmy’, ‘Jackson’)

INSERT (‘Jimmy’, ‘Jackson’) INTO Persons

INSERT VALUES (‘Jimmy’, ‘Jackson’) INTO Persons

Answer 15

INSERT INTO Persons VALUES (‘Jimmy’, ‘Jackson’)

Question 16

Which SQL statement is used to return only different values?

SELECT UNIQUE

SELECT DIFFERENT

SELECT DISTINCT

Answer 16

SELECT DISTINCT

Question 17

Which operator is used to search for a specified pattern in a column?

GET

LIKE

FROM

Answer 17

LIKE

Question 18

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” starts with an “a”?

SELECT * FROM Persons WHERE FirstName=’a’

SELECT * FROM Persons WHERE FirstName=’%a%’

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

Answer 18

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

Question 19

With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?

SELECT * FROM Persons SORT BY ‘FirstName’ DESC

SELECT * FROM Persons ORDER FirstName DESC

SELECT * FROM Persons SORT ‘FirstName’ DESC

SELECT * FROM Persons ORDER BY FirstName DESC

Answer 19

SELECT * FROM Persons ORDER BY FirstName DESC

Question 20

With SQL, how do you select a column named “FirstName” from a table named “Persons”?

SELECT Persons.FirstName

SELECT FirstName FROM Persons

EXTRACT FirstName FROM Persons

Answer 20

SELECT FirstName FROM Persons

Question 21

What does SQL stand for?

Structured Question Language

Structured Query Language

Strong Question Language

Answer 21

Structured Query Language

Question 22

With SQL, how do you select all the records from a table named “Persons” where the “LastName” is alphabetically between (and including) “Hansen” and “Pettersen”?

SELECT * FROM Persons WHERE LastName BETWEEN ‘Hansen’ AND ‘Pettersen’

SELECT LastName>’Hansen’ AND LastName<’Pettersen’ FROM Persons

SELECT * FROM Persons WHERE LastName>’Hansen’ AND LastName<’Pettersen’

Answer 22

SELECT * FROM Persons WHERE LastName BETWEEN ‘Hansen’ AND ‘Pettersen’

Question 23

Which SQL statement is used to insert new data in a database?

INSERT INTO

ADD NEW

INSERT NEW

ADD RECORD

Answer 23

INSERT INTO

Question 24

Which SQL keyword is used to sort the result-set?

ORDER

SORT BY

SORT

ORDER BY

Answer 24

ORDER BY

Question 25

The NOT NULL constraint enforces a column to not accept NULL values.

True

False

Answer 25

True

Question 26

How to display all data from table

Answer 26

Select * From table_name

Question 27

how to display specific column from table

Answer 27

Select column_name from table_name

Question 28

How to display all data that meets where criteria. text is “ “ For example where star sign is “Capricorn”. This would display all records that meet this criteria

Answer 28

Select * From table_name Where column_name = “ “

Question 29

How to displays specific column that does not meet where criteria. Numbers without “ “ Text must have “ “

Answer 29

Select column_name From table_name Where column_name != “ “

Question 30

How to displays specific column that meets where criteria. Numbers without “ Text must have “ “

Answer 30

Select column_name From table_name Where column_name <= x

Question 31

How to display specific column that meets where criteria, less than or equal to a number

Answer 31

Select column_name From table_name Where column_name <= x

Question 32

How to display specific column that meets one of the where criteria

Answer 32

Select column_name From table_name Where column_name = “ “ OR column_name > x

Question 33

How to display all data from table and orders the data by column specified in ascending order

Answer 33

Select * from table_name Order By column_name

Question 34

How to display all records where a specific column data starts with letter T. Not LIKE does not need an = it uses ‘ ‘

Answer 34

Select * From table_name Where column_name Like ‘T%’

Question 35

Permanently updates Margot Robbies age to 30 in the celebrities table. Note if updating a number does not use “ “

Answer 35

Update Celebrities Set Age = 30 Where Name = “Margot Robbie”