¡GoConqr estrena diseño! Cuéntanos qué te parece.

Regístrate gratis

Test

C192 Advanced SQL

Brandon Gagon 14 preguntas

Hacer el test

Preguntas del test (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

Información

Descripción
Test sobre C192 Advanced SQL, creado por Brandon Gagon el 01/12/2020.
Idioma
English
Visitas
0
Valoración
Aún sin valoraciones
Valora este test
Valora este test

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué te parece el nuevo diseño?

¿Te gusta?