RelationalDBDesign
SiteMap
Database Analysis
Database Design
Extended DB Features
Oracle SQL Extensions
User Profiles
«Prev
Next»
Extended Features
Partitioned Tables
Oracle Partitioning Explained
Partitioning Advantages
Table Range Partitioning
Index Partitioned Table
Local Index Partition
Global Index Partition
Modifying Partition Features
Dropping Oracle Partitions
Splitting Merging Partitions
Clustering Tables
Clustered Tables Advantages
Clustered vs Non-Clustered
Oracle Clustering Advantages
Creating Oracle Cluster
Size Cluster Properly
Creating Cluster Key
Oracle Hash Cluster
Creating Hash Cluster
Deleting Hash Cluster
Clustering Conclusion
Index Organized
Index Organized Tables
Advantages Disadvantages IOT
Creating Table Index
Allocate Overflow Space
Deleting Altering IOT
Reorganize IOT
IOT Conclusion
Auditing Features
Auditing Oracle Entities
Enable Audit Feature
Audit SQL Statement
Access Audit Trail
Oracle System Privileges
Auditing Database Objects
Purge Audit Trail
Language Support
National Character Set
Using Profiles
Product Profile
Profile Table
Limit Command Access
Security Scheme
SQL WildCards
SQL Wildcard Characters
Removing Restriction
Target Profile
SqlPlus Utility
Wildcards Profile[SQL] - Quiz
Wildcards, Deleting, and Reporting on Product Profile
Each question is worth one point. Select the best answer or answers for each question.
1.
Which wildcard characters can be used when specifying usernames in the product profile?
Please select all the correct answers.
A.
_
B.
*
C.
%
D.
You cannot use wildcards.
2.
You have added a restriction to the product profile that prevents all users from using the
HOST
command in SQL*Plus. How would you allow the user named
BRIAN
to use this command?
Please select the best answer.
A.
Delete all restrictions for all users.
B.
Delete all restrictions for the user
BRIAN
.
C.
Delete the row with the restriction for
BRIAN
for the
HOST
command.
D.
Delete the row with the restriction for all users for the
HOST
command.
