27878529
Descripción
Test por Kyle Peterson, actualizado hace más de 1 año
|
Creado por Kyle Peterson
hace más de 3 años
|
|
Pregunta 1
Pregunta
Microsoft SQL Server uses:
Respuesta
-
T-SQL
-
PL/SQL
-
DDL
-
DML
Pregunta 2
Pregunta
The COUNT function is designed to tally the number of non-null "values" of an attribute and is often used in conjunction with the DISTINCT clause.
Respuesta
- True
- False
Pregunta 3
Pregunta
With the exception of the database creation process, most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.
Respuesta
- True
- False
Pregunta 4
Pregunta
Which clause is specifically used with aggregate functions?
Respuesta
-
WHERE
-
DISTINCT
-
HAVING
-
ORDER BY
Pregunta 5
Pregunta
The underscore wildcard is used just like % but instead of matching multiple characters, the underscore matches just a single character.
Respuesta
- True
- False
Pregunta 6
Pregunta
Which SQL statement is used to return only different values?
Respuesta
-
SELECT UNIQUE
-
SELECT DIFFERENT
-
SELECT DISTINCT
-
All of the above
Pregunta 7
Pregunta
Which SQL keyword is used to sort the result-set?
Respuesta
-
SORT
-
SORT BY
-
ORDER
-
ORDER BY
Pregunta 8
Pregunta
Which one of the following is NOT part of DDL?
Respuesta
-
SELECT INTO
-
CREATE
-
ALTER
-
TRUNCATE
Pregunta 9
Pregunta
CAST is unique to T-SQL.
Respuesta
- True
- False
Pregunta 10
Pregunta
Which one of the following JOIN includes all rows from the second table and matching rows from the first table?
Respuesta
-
Inner Join
-
Left Outer Join
-
Right Outer Join
-
Full Outer Join
Pregunta 11
Pregunta
What is the most common type of join?
Respuesta
-
Inner Join
-
Left Outer Join
-
Right Outer Join
-
Full Outer Join
-
Self Join
Pregunta 12
Pregunta
Which SQL statement is used to create a table in a database?
Respuesta
-
CREATE TABLE
-
CREATE DB
-
CREATE DATABASE TABLE
-
CREATE DATABASE TAB
Pregunta 13
Pregunta
Which SQL statements uses the keyword SET?
Respuesta
-
SELECT
-
UPDATE
-
MODIFY
-
DELETE
Pregunta 14
Pregunta
A table may be joined to itself.
Respuesta
- True
- False
Pregunta 15
Pregunta
The FULL OUTER JOIN syntax is not supported by Microsoft Access.
Respuesta
- True
- False
Pregunta 16
Pregunta
A set of SQL statements (one or more) typically grouped together to perform a specific routine is called ____________.
Respuesta
-
Views
-
Cursors
-
Stored Procedures
-
Indexes
Pregunta 17
Pregunta
According to the rules of precedence, which of the following computations should be completed first?
Respuesta
-
performing additions and subtractions
-
performing multiplications and divisions
-
performing operations within parentheses
-
performing power operations
Pregunta 18
Pregunta
The special operator used to check whether an attribute is within a range of values is ___________.
Respuesta
-
BETWEEN
-
LIKE
-
IN
-
NULL
Pregunta 19
Pregunta
To list the contents of a table, you must use the DISPLAY command.
Respuesta
- True
- False
Pregunta 20
Pregunta
The SQL data manipulation command HAVING:
Respuesta
-
restricts the selection of rows based on a conditional expression.
-
restricts the selection of grouped rows based on a condition.
-
modifies an attribute's value in one or more table's rows.
-
groups the selected rows based on one or more attributes.
Pregunta 21
Pregunta
You can call a stored procedure from within itself.
Respuesta
- True
- False
Pregunta 22
Pregunta
A temporary stored procedure with global scope has the following prefix:
Respuesta
-
#
-
##
-
!
-
EXECUTE_AS
Pregunta 23
Pregunta
Which one of the following is used to prevent SQL injection attacks?
Respuesta
-
Stored Procedures
-
Triggers
-
User-Defined Functions
-
Views
Pregunta 24
Pregunta
-- Using a variable with CONCAT
DECLARE @a VARCHAR(30) = 'My birthday is on '
DECLARE @b DATE = '1980/08/25'
SELECT CONCAT (@a, @b) AS RESULT;
The above query will yield an error.
Respuesta
- True
- False
Pregunta 25
Pregunta
Which type of JOIN reflects is the following statement:
All rows from the left side of the join, even if there is not a match, and all rows from the right side, even if there is not a match, show up in the results.
Respuesta
-
INNER JOIN
-
LEFT OUTER JOIN
-
FULL OUTER JOIN
-
RIGHT OUTER JOIN
-
MERGE
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.