O GoConqr está de visual novo! Conte para nós o que você achou.

Registre-se grátis

Quiz

C192 Advanced SQL

Brandon Gagon 14 perguntas

Fazer o quiz

Perguntas do quiz (14)

  1. 1You can join tables by using a condition in the ____ clause.
    1. AFROM
    2. BWHERE
    3. CSELECT
    4. DJOIN
  2. 2Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause?
    1. Ainner
    2. Bouter
    3. Cnested
    4. Dproduct
  3. 3In a(n) ____ join, all rows from both tables are included regardless of whether they match rows from the other table.
    1. Anormal
    2. Binner
    3. Cfull outer
    4. Dcombined
  4. 4In a _______, all rows from the table on the left (the table listed first in the query) will be included regardless of whether they match rows from the table on the right (the table listed second in the query)
    1. Aleft inner join
    2. Bleft outer join
    3. Cright inner join
    4. Dright outer join
  5. 5In a ______, all rows from the table on the right will be included regardless of whether they match rows from the table on the left.
    1. Aleft inner join
    2. Bleft outer join
    3. Cright inner join
    4. Dright outer join
  6. 6The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word _______, and then a query.
    1. AAC
    2. BSA
    3. CAS
    4. DIN
  7. 7The main mechanism for providing access to a database is the _____ command.
    1. APERMIT
    2. BACCESS
    3. CGRANT
    4. DREVOKE
  8. 8The correct command to allow user Thompson to delete rows in the CUSTOMER table would be:

    GRANT ______ ON CUSTOMER TO Thompson
    1. ADROP
    2. BREMOVE
    3. CUPDATE
    4. DDELETE
  9. 9The privilege ______ can be granted to retrieve data.
    1. ASELECT
    2. BUPDATE
    3. CRETRIEVE
    4. DREAD
  10. 10When you specify a foreign key, the table referenced by the foreign key is the _____.
    1. Asuper
    2. Bsibling
    3. Cparent
    4. Dchild

Informações

Descrição
Quiz sobre C192 Advanced SQL, criado por Brandon Gagon em 01-12-2020.
Idioma
English
Visualizações
0
Avaliação
Ainda sem avaliações
Avalie este quiz
Avalie este quiz

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?