Lista completa de Questões de Língua Inglesa da CONESUL Fundação de Desenvolvimento para resolução totalmente grátis. Selecione os assuntos no filtro de questões e comece a resolver exercícios.
Choose the alternative that best and respectively completes the blanks in the text.
GROUP BY -OPEN -WHERE
SELECT -GROUP BY -OPEN
JOIN -SELECT -GROUP BY
OPEN -WHERE -GROUP BY
HAVING is a keyword related to SELECT that
indicates which rows to keep after WHERE has produced its rows.
typically uses an aggregate function.
acts exactly like a WHERE.
is used to identify which rows to be retrieved.
From the sentence "SQL acts as a declarative language": (first paragraph), one can deduce that
I. it is a nonprocedural language.
II. it results in many lines of code.
III. users concentrate on defining the input and output.
Which of them is correct?
Only I.
Only II.
Only I and II.
Only I and III.
According to the text, one can say that
the user access the query optimizer directly.
queries are submitted to database server, and after passed to the query optimizer where optimization occurs.
the user has to specify the procedures needed to produce a result set.
the database system changes the left query into an efficient query plan.
In order to return the database to some previous state, I use the command ________. Choose the right alterna-tive to complete the blank in the sentence.
ORDER BY.
COMMIT.
SELECT.
ROLLBACK.
Match the first column to the second column.
( ) SELECT
( ) Transaction
( ) UPDATE
( ) GROUP BY
1. Used to wrap around the DML operations
2. The FROM clause is followed by a JOIN clause
3. Used for data retrieval
4. Used for data manipulation
5. Used to group the retrieved data
The correct sequence, from the top to the bottom is
2 -3 -1 -5
1 -2 -3 -4
3 -1 -4 -5
5 -3 -4 -1
The text is not about?
DML.
Most commonly used DML commands.
The difference between declarative and imperative language.
Acording to the text, ROLLBACK is an operation that
returns the database to some previous state.
copies all the information avaliable.
causes failure to the system.
repeats the information to the user.
The expression "which either completes completely or not at all" , underlined in the text, means
that does not complete at all.
which either entirely completes or aborts.
what sometimes completes or rot at all.
which Cannot be completed at all.
About retaining walls , it is not correct to say that
they provide lateral support to vertical slopes of soil.
they stabilize soil and/or rock from down slope movement.
they are structures sometimes referred to as backfill.
they provide support for vertical or non-vertical grade changes.
{TITLE}
{CONTENT}
{TITLE}
Aguarde, enviando solicitação...