Questão 1
Questão
Microsoft SQL Server uses:
Questão 2
Questão
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.
Questão 3
Questão
With the exception of the database creation process, most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.
Questão 4
Questão
Which clause is specifically used with aggregate functions?
Responda
-
WHERE
-
DISTINCT
-
HAVING
-
ORDER BY
Questão 5
Questão
The underscore wildcard is used just like % but instead of matching multiple characters, the underscore matches just a single character.
Questão 6
Questão
Which SQL statement is used to return only different values?
Responda
-
SELECT UNIQUE
-
SELECT DIFFERENT
-
SELECT DISTINCT
-
All of the above
Questão 7
Questão
Which SQL keyword is used to sort the result-set?
Responda
-
SORT
-
SORT BY
-
ORDER
-
ORDER BY
Questão 8
Questão
Which one of the following is NOT part of DDL?
Responda
-
SELECT INTO
-
CREATE
-
ALTER
-
TRUNCATE
Questão 9
Questão
CAST is unique to T-SQL.
Questão 10
Questão
Which one of the following JOIN includes all rows from the second table and matching rows from the first table?
Responda
-
Inner Join
-
Left Outer Join
-
Right Outer Join
-
Full Outer Join
Questão 11
Questão
What is the most common type of join?
Responda
-
Inner Join
-
Left Outer Join
-
Right Outer Join
-
Full Outer Join
-
Self Join
Questão 12
Questão
Which SQL statement is used to create a table in a database?
Responda
-
CREATE TABLE
-
CREATE DB
-
CREATE DATABASE TABLE
-
CREATE DATABASE TAB
Questão 13
Questão
Which SQL statements uses the keyword SET?
Responda
-
SELECT
-
UPDATE
-
MODIFY
-
DELETE
Questão 14
Questão
A table may be joined to itself.
Questão 15
Questão
The FULL OUTER JOIN syntax is not supported by Microsoft Access.
Questão 16
Questão
A set of SQL statements (one or more) typically grouped together to perform a specific routine is called ____________.
Responda
-
Views
-
Cursors
-
Stored Procedures
-
Indexes
Questão 17
Questão
According to the rules of precedence, which of the following computations should be completed first?
Responda
-
performing additions and subtractions
-
performing multiplications and divisions
-
performing operations within parentheses
-
performing power operations
Questão 18
Questão
The special operator used to check whether an attribute is within a range of values is ___________.
Questão 19
Questão
To list the contents of a table, you must use the DISPLAY command.
Questão 20
Questão
The SQL data manipulation command HAVING:
Responda
-
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.
Questão 21
Questão
You can call a stored procedure from within itself.
Questão 22
Questão
A temporary stored procedure with global scope has the following prefix:
Questão 23
Questão
Which one of the following is used to prevent SQL injection attacks?
Responda
-
Stored Procedures
-
Triggers
-
User-Defined Functions
-
Views
Questão 24
Questão
-- 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.
Questão 25
Questão
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.
Responda
-
INNER JOIN
-
LEFT OUTER JOIN
-
FULL OUTER JOIN
-
RIGHT OUTER JOIN
-
MERGE