GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Quiz

C192 Advanced SQL

Brandon Gagon 14 Fragen

Quiz starten

Fragen in diesem 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

Informationen

Beschreibung
Quiz am C192 Advanced SQL, erstellt von Brandon Gagon am 01/12/2020.
Sprache
English
Aufrufe
0
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck