Question 1

What does SQL stand for?

Accepted Answer

Structured Query Language

Answer

Strong Question Language

Answer

Structured Question Language

Question 2

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

Accepted Answer

SELECT

Answer

OPEN

Answer

EXTRACT

Answer

GET

Question 3

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

Accepted Answer

UPDATE

Answer

SAVE

Answer

MODIFY

Answer

SAVE AS

Question 4

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

Accepted Answer

DELETE

Answer

REMOVE

Answer

COLLAPSE

Question 5

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

Accepted Answer

INSERT INTO

Answer

ADD RECORD

Answer

INSERT NEW

Answer

ADD NEW

Question 6

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

Accepted Answer

SELECT FirstName FROM Persons

Answer

EXTRACT FirstName FROM Persons

Answer

SELECT Persons.FirstName

Question 7

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

Accepted Answer

SELECT * FROM Persons

Answer

SELECT Persons

Answer

SELECT *.Persons

Answer

SELECT [all] FROM Persons

Question 8

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

Accepted Answer

SELECT * FROM Persons WHERE FirstName='Peter'

Answer

SELECT * FROM Persons WHERE FirstName<>'Peter'

Answer

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

Answer

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

Question 9

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"?

Accepted Answer

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

Answer

SELECT * FROM Persons WHERE FirstName LIKE '%a'

Answer

SELECT * FROM Persons WHERE FirstName='a'

Answer

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

Question 10

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

Accepted Answer

True

Answer

False

Question 11

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

Accepted Answer

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

Answer

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

Answer

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

Question 12

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"?

Accepted Answer

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

Answer

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

Answer

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

Question 13

Which SQL statement is used to return only different values?

Accepted Answer

SELECT DISTINCT

Answer

SELECT UNIQUE

Answer

SELECT DIFFERENT

Question 14

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

Accepted Answer

ORDER BY

Answer

SORT

Answer

ORDER

Answer

SORT BY

Question 15

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

Accepted Answer

SELECT * FROM Persons ORDER BY FirstName DESC

Answer

SELECT * FROM Persons ORDER FirstName DESC

Answer

SELECT * FROM Persons SORT 'FirstName' DESC

Answer

SELECT * FROM Persons SORT BY 'FirstName' DESC

Question 16

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

Accepted Answer

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

Answer

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

Answer

INSERT ('Jimmy', 'Jackson') INTO Persons

Question 17

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

Accepted Answer

INSERT INTO Persons (LastName) VALUES ('Olsen')

Answer

INSERT ('Olsen') INTO Persons (LastName)

Answer

INSERT INTO Persons ('Olsen') INTO LastName

Question 18

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

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Question 19

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

Accepted Answer

DELETE FROM Persons WHERE FirstName = 'Peter'

Answer

DELETE FirstName='Peter' FROM Persons

Answer

DELETE ROW FirstName='Peter' FROM Persons

Question 20

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

Accepted Answer

SELECT COUNT(*) FROM Persons

Answer

SELECT COLUMNS() FROM Persons

Answer

SELECT COLUMNS(*) FROM Persons

Answer

SELECT COUNT() FROM Persons

Question 21

Which of the following columns is/are required in a table?

Accepted Answer

A primary key

Answer

A foreign key

Answer

An alternate key

Answer

A surrogate key

Question 22

For a number of reasons, normalizations is not often an advantage for a/an ________________ database.

Accepted Answer

Read-only

Answer

Updateable

Answer

Either a read-only or an updateable

Answer

None of the above is correct

Question 23

Each entity is represented as a/an:

Accepted Answer

Table

Answer

Tuple

Answer

Attribute

Answer

File

Question 24

Which of the following indicates the maximum number of entities that can be involved in a relationships?

Accepted Answer

Maximum cardinality

Answer

Minimum cardinality

Answer

ERD

Answer

Greater Entity Count (GEC)

Question 25

Which of the following indicates the maximum number of entities that can be involved in a relationships?

Accepted Answer

Maximum cardinality

Answer

Minimum cardinality

Answer

ERD

Answer

Greater Entity Count (GEC)

Question 26

A subquery in an SQL SELECT statement is enclosed in:

Accepted Answer

Parenthesis - (...)

Answer

Braces - {...}

Answer

CAPITAL LETTERS

Answer

Brackets - [...]

Question 27

The result of a SQL SELECT statement is a/an _______________.

Accepted Answer

Table

Answer

Report

Answer

Form

Answer

File

Question 28

Which of the following do you need to consider when you make a table in SQL?

Accepted Answer

All of the above

Answer

Data types

Answer

Primary keys

Answer

Default values

Question 29

Which of the following  query is correct for using comparison operators in SQL?

Accepted Answer

SELECT sname, coursename FROM studentinfo WHERE age>50 and age<80

Answer

SELECT sname, coursename FROM studentinfo WHERE age>50 and <80

Answer

SELECT sname, coursename FROM studentinfo WHERE age>50 and WHERE age <80

Answer

None of the above

Question 30

Which is an SQL*PLUS command?

Accepted Answer

DESCRIBE

Answer

DELETE

Answer

UPDATE

Answer

ALTER

Sin título

Crea una cuenta gratis para terminar este test

Preguntas del test (30)

Información

Escríbenos

¿Qué te parece el nuevo diseño?