Halaman

Friday, August 9, 2019

Answer Sections 17 Quiz Database Programming with SQL 2019 Learner - English


Section 17


Regular expressions are a method of describing both simple and complex patterns for searching and manipulating. True or False? 
                                                                               
                                               
                True (*)


                                              
                False

                                                                               
Parentheses are not used to identify the sub expressions within the expression. True or False?   

                                               
                True

                                               
                False (*)

                                                                               
REGULAR EXPRESSIONS can be used on CHAR, CLOB, and VARCHAR2 datatypes? (True or False)                                                     
                                               
                True (*)

                                               
                False

                                                                               
If you are granted privileges to your friend's object, by default you may also grant access to this same object to other users. True or False? 
                 
                                               
                True

                                               
                False (*)

                                                                               
When a user is logged into one database, he is restricted to working with objects found in that database. True or False?
                                                                               
                                               
                True

                                               
                False (*)

You need to grant user BOB SELECT privileges on the EMPLOYEES table. You want to allow BOB to grant this privileges to other users. Which statement should you use?  
                                                                               
                                               
                GRANT SELECT ON employees TO bob WITH GRANT OPTION; (*)

                                               
                GRANT SELECT ON employees TO bob;

                                               
                GRANT SELECT ON employees TO bob WITH ADMIN OPTION;

                                               
                GRANT SELECT ON employees TO PUBLIC WITH GRANT OPTION;

                                                                               
To take away a privilege from a user, you use which command? 

                                               
                ALTER

                                               
                REMOVE

                                               
                REVOKE (*)

                                               
                DELETE

                                                                               
Which statement would you use to remove an object privilege granted to a user?    
                                                                               
                                               
                REMOVE

                                               
                REVOKE (*)

                                               
                DROP

                                               
                ALTER USER

                                                                               
User CRAIG creates a view named INVENTORY_V, which is based on the INVENTORY table. CRAIG wants to make this view available for querying to all database users. Which of the following actions should CRAIG perform?            
          
                                               
                He should assign the SELECT privilege to all database users for INVENTORY_V view. (*)

                                               
                He should assign the SELECT privilege to all database users for the INVENTORY table.

                                               
                He must grant each user the SELECT privilege on both the INVENTORY table and INVENTORY_V view.

                                               
                He is not required to take any action because, by default, all database users can automatically access views.

                                                                               
Which of the following are object privileges? (Choose two)      
                                                                               
                                               
                CREATE TABLE

                                               
                SELECT (*)

                                               
                DROP TABLE

                                               
                INSERT (*)

System privileges are:   
                                                                               
                                               
                A collection of objects, such as tables, views, and sequences.

                                               
                Required to gain access to the database. (*)

                                               
                Required to manipulate the content of objects in the database.

                                               
                Named groups of related privileges given to a user.

                                                                               
User ADAM has successfully logged on to the database in the past, but today he receives an error message stating that (although he has entered his password correctly) he cannot log on. What is the most likely cause of the problem?   
              
                                               
                ADAM's user account has been removed from the database.

                                               
                ADAM's CREATE USER privilege has been revoked.

                                               
                ADAM's CREATE SESSION privilege has been revoked. (*)

                                               
                One or more object privileges have been REVOKEd from Adam.

                                                                               
Which of these is NOT a System Privilege granted by the DBA?   

                                               
                Create Index (*)

                                               
                Create Session

                                               
                Create Procedure

                                               
                Create Sequence

                                                                               
What system privilege must be held in order to login to an Oracle database?      

                                               
                CREATE LOGIN

                                               
                CREATE SESSION (*)

                                               
                CREATE LOGON

                                               
                No special privilege is needed; if your username exists in the database, you can login.

                                                                               
Which of the following is NOT a database object?       

                                               
                Subquery (*)

                                               
                Sequence

                                               
                View

                                               
                Table

No comments:

Post a Comment

Final Exam Java Programming 2019 Learner - English

Final Exam