Questões de Língua Inglesa da CONESUL Fundação de Desenvolvimento

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.

  • A.

    GROUP BY -OPEN -WHERE

  • B.

    SELECT -GROUP BY -OPEN

  • C.

    JOIN -SELECT -GROUP BY

  • D.

    OPEN -WHERE -GROUP BY

HAVING is a keyword related to SELECT that

  • A.

    indicates which rows to keep after WHERE has produced its rows.

  • B.

    typically uses an aggregate function.

  • C.

    acts exactly like a WHERE.

  • D.

    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?

  • A.

    Only I.

  • B.

    Only II.

  • C.

    Only I and II.

  • D.

    Only I and III.

According to the text, one can say that

  • A.

    the user access the query optimizer directly.

  • B.

    queries are submitted to database server, and after passed to the query optimizer where optimization occurs.

  • C.

    the user has to specify the procedures needed to produce a result set.

  • D.

    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.

  • A.

    ORDER BY.

  • B.

    COMMIT.

  • C.

    SELECT.

  • D.

    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

  • A.

    2 -3 -1 -5

  • B.

    1 -2 -3 -4

  • C.

    3 -1 -4 -5

  • D.

    5 -3 -4 -1

The text is not about?

  • A. SQL keywords.
  • B.

    DML.

  • C.

    Most commonly used DML commands.

  • D.

    The difference between declarative and imperative language.

Acording to the text, ROLLBACK is an operation that

  • A.

    returns the database to some previous state.

  • B.

    copies all the information avaliable.

  • C.

    causes failure to the system.

  • D.

    repeats the information to the user.

The expression "which either completes completely or not at all" , underlined in the text, means

  • A.

    that does not complete at all.

  • B.

    which either entirely completes or aborts.

  • C.

    what sometimes completes or rot at all.

  • D.

    which Cannot be completed at all.

About retaining walls , it is not correct to say that

  • A.

    they provide lateral support to vertical slopes of soil.

  • B.

    they stabilize soil and/or rock from down slope movement.

  • C.

    they are structures sometimes referred to as backfill.

  • D.

    they provide support for vertical or non-vertical grade changes.

Provas e Concursos

O Provas e Concursos é um banco de dados de questões de concursos públicos organizadas por matéria, assunto, ano, banca organizadora, etc

{TITLE}

{CONTENT}

{TITLE}

{CONTENT}
Provas e Concursos
0%
Aguarde, enviando solicitação!

Aguarde, enviando solicitação...