9635425
Descripción
Test por Hawerth Castro, actualizado hace más de 1 año
|
Creado por Hawerth Castro
hace más de 7 años
|
|
Pregunta 1
Pregunta
What command do you use to perform a query in SQL?
Respuesta
-
USE
-
SELECT
-
QUERY
-
CHOSE
Pregunta 2
Pregunta
What wildcard character retrieves all records with the SELECT command?
Respuesta
-
*
-
%
-
$
-
?
Pregunta 3
Pregunta
What would you use to combine two parameters in a query in SQL?
Respuesta
-
PLUS
-
BOTH
-
COMBINE
-
AND
Pregunta 4
Pregunta
What clause would you use with the SELECT command that would pull records based on a range?
Respuesta
-
COMBO
-
BETWEEN
-
OR
-
COMBINE
Pregunta 5
Pregunta
What keyword used with the SELECT statement is used to not output specified records?
Respuesta
-
OR
-
DISALLOW
-
DISREGARD
-
NOT
Pregunta 6
Pregunta
What would you use to combine columns from two different tables?
Respuesta
-
AND
-
BETWEEN
-
JOIN
-
COMBINE
Pregunta 7
Pregunta
Which clause used with the SELECT command will return values that you want to exclude from the normal parameters?
Respuesta
-
EXCEPT
-
INTERSECT
-
SEARCH
-
EXCLUDE
Pregunta 8
Pregunta
What clause is used to combine related data from multiple table sources?
Respuesta
-
COMBINE
-
AND
-
JOIN
-
PLUS
Pregunta 9
Pregunta
What statement would you use to add data to a table?
Respuesta
-
ADD
-
INSERT
-
JOIN
-
PRESENT
Pregunta 10
Pregunta
What statement would you use to change data in a table?
Respuesta
-
CHANGE
-
MODIFY
-
INSERT
-
UPDATE
Pregunta 11
Pregunta
What statement is used to delete one or more rows in a table?
Respuesta
-
DELETE
-
REMOVE
-
TRUNCATE
-
CHANGE
Pregunta 12
Pregunta
What statement is used to delete a table from a database?
Respuesta
-
DELETE
-
DROP
-
REMOVE
-
TRUNCATE
Pregunta 13
Pregunta
How can you prevent the accidental loss of an entire table?
Respuesta
-
Use the DELETE TRANS command.
-
Use the LOOPBACK command.
-
Use the SAFEDELETE command.
-
Use referential integrity.
Pregunta 14
Pregunta
What do you perform when you want to recall specific records from a database?
Respuesta
-
recall
-
virtual extraction
-
reach
-
query
Pregunta 15
Pregunta
What command would you use to delete a table while leaving the table structure in place for future use?
Respuesta
-
DELETE TABLE
-
TRUNCATE TABLE
-
REMOVE TABLE
-
STOP TABLE
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.