RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Managing Roles
«Prev
Next»
User Connectivity
Configuring Oracle
NetClient PC Database
Oracle Net Basic Concepts
Finding Listener Service
Listener Control Program
Configuring Listener
Stop Restart Listener
Configuring OracleNet Client
Testing Client Connectivity
Testing OracleNet Connectivity
Check Default Domain
Connecting from Client
Oracle Net Conclusion
Password Files
Necessary Password Files
Password Creation Process
Placing | Naming PW File
Creating Password File
Remote Login Password
Connecting Internal Password
DBA Privileges
Different DBA Roles
Oracle DBA Roles
Connect Database
PW Files Data Dictionary
Rebuilding Password File
Manage PW Conclusion
Enterprise Manager
OEM Architecture
OEM Architecture
Install OEM
DBA Management Pack
Using Instance Manager
View Information
Using Security Manager
Examine Objects Schema Manager
Using SQL Plus
SQL* Plus CLI
SQL Plus Reports
SQL Plus Column
SQL Plus Formatting
Formatting Numeric Columns
Oracle Date Columns
SQL Plus Scripting
SQL Plus Command
Suppress Repeating Columns
Line Page Break Reports
Report Headers Footers
Spooling Printing Report
Substitution Variables
Accept Prompt Commands
SQL Plus Editing Commands
SQL Plus Settings
SQL Plus Script
SQL Plus Conclusion
Creating Users
Manage Users
Before Creating User
Default Tablespaces
Temporary Tablespaces
Assign Disk Quotas
Creating Database User
OS Authentication
Granting Session Privileges
altering Database User
Changing User Password
Locking Users Account
Drop User
Data Dictionary User Info
Create manage Users
Managing User Roles
Types System Privileges
Granting System Privileges
With Admin Option Clause
session_privs View
Revoke Privileges Oracle
Managing System Privileges
Oracle System Privileges - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
When you grant a user an object privilege such as
CREATE TABLE
or
CREATE INDEX
, what does that privilege allow the user to do?
Please select the best answer.
A.
Create, alter, or drop the object in all schemas
B.
Create the object in any schema in the database
C.
Create, alter, and drop the object in the user's schema only
D.
Create the object, but not alter or drop it, in the user's schema only
2.
What do the
ANY
privileges allow you to do?
Please select the best answer.
A.
Create any type of database object in any schema
B.
Create any type of database object in your own schema
C.
Create a specific type of database object in any schema
D.
Create a specific type of database object in your own schema
3.
You need to give a user the ability to modify tables for other users in the database. Which privilege should you grant?
Please select the best answer.
A.
CREATE TABLE
B.
ALTER ANY TABLE
C.
CREATE ANY TABLE
D.
ALTER TABLE
4.
You need to give a user the ability to alter the user's own tables. What privilege should you grant?
Please select the best answer.
A.
ALTER ANY TABLE
B.
ALTER TABLE
C.
ALTER OWN TABLE
D.
CREATE TABLE
Correct answers:
Your Score: 0
Submit
Quiz Explanation