RelationalDBDesignRelationalDBDesign


User Profiles  «Prev 

SQL Wildcard Characters

You begin with a list of database users and the commands they can use in SQL *Plus
1) You begin with a list of database users and the commands they can use in SQL *Plus

The INSERT statement restricts access to the SQL command INSERT to users whose username begins with the character 'B'
2) The INSERT statement restricts access to the SQL command INSERT to users whose username begins with the character 'B'

The result of this restriction is the that BOB, BRIAN and BRUCE cannot use the INSERT command when they use SQL * PLUS.
3) The result of this restriction is the that BOB, BRIAN and BRUCE cannot use the INSERT command when they use SQL * PLUS.

If you were to issue this INSERT statement, you would prevent all users from accessing the HOST command in SQL * Plus.
4) If you were to issue this INSERT statement, you would prevent all users from accessing the HOST command in SQL * Plus.

This action has the effect of removing the HOST command from the SQL *Plus environment.
5) This action has the effect of removing the HOST command from the SQL *Plus environment.

This action has the effect of removing the HOST command from the SQL *Plus environment.
6) This action has the effect of removing the HOST command from the SQL *Plus environment.