Quiz
C192 Advanced SQL
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (14)
1You can join tables by using a condition in the ____ clause.
- AFROM
- BWHERE
- CSELECT
- DJOIN
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?
- Ainner
- Bouter
- Cnested
- Dproduct
3In a(n) ____ join, all rows from both tables are included regardless of whether they match rows from the other table.
- Anormal
- Binner
- Cfull outer
- Dcombined
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)
- Aleft inner join
- Bleft outer join
- Cright inner join
- Dright outer join
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.
- Aleft inner join
- Bleft outer join
- Cright inner join
- Dright outer join
6The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word _______, and then a query.
- AAC
- BSA
- CAS
- DIN
7The main mechanism for providing access to a database is the _____ command.
- APERMIT
- BACCESS
- CGRANT
- DREVOKE
8The correct command to allow user Thompson to delete rows in the CUSTOMER table would be:
GRANT ______ ON CUSTOMER TO Thompson- ADROP
- BREMOVE
- CUPDATE
- DDELETE
9The privilege ______ can be granted to retrieve data.
- ASELECT
- BUPDATE
- CRETRIEVE
- DREAD
10When you specify a foreign key, the table referenced by the foreign key is the _____.
- Asuper
- Bsibling
- Cparent
- Dchild
11The privilege _______ can be granted to change data.
- AWRITE
- BUPDATE
- CALTER
- DREAD AND WRITE
12The privilege _______ can be granted to change the table structure.
- AWRITE
- BUPDATE
- CALTER
- DMODIFY
13To create a stored procedure in Oracle, use the _____ command
- ACREATE ROUTINE
- BCREATE SCRIPT
- CCREATE PROCEDURE
- DCREATE EXECUTABLE
14A(n) _______ is a procedure that is executed automatically in response to an associated database operation.
- Acursor
- Btrigger
- Cwaypoint
- Dfetchpoint
Information
- Description
- Quiz on C192 Advanced SQL, created by Brandon Gagon on 01/12/2020.
- Author
- Brandon Gagon
- Language
- English
- Views
- 0
- Rating
- No ratings yet Rate this quiz