RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Creating Users
«Prev
Next»
User Connectivity
Configuring Oracle
SID List Listener
Configuring Listener
Oracle Net Basic Concepts
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
Connect Database
PW Files Data Dictionary
Rebuilding Password File
Manage PW Conclusion
Enterprise Manager
SQL Plus Worksheet
OEM Architecture
SQL* Plus CLI
Accept Prompt Commands
Spooling Printing Report
SQL Plus Line Editing Commands
Creating Users
Steps To Change Security Manager
Default Tablespaces
Drop User
What Objects does User Own
Managing User Roles
Types System Privileges
Granting System Privileges
With Admin Option Clause
session_privs View
Revoke Privileges Oracle
Managing System Privileges
Tablespaces and Quotas - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
When you create an object without specifying a tablespace, how does Oracle decide where to put it?
Please select the best answer.
A.
Oracle will always place the object in the
SYSTEM
tablespace.
B.
Oracle will use your default tablespace, if one exists, otherwise it will use the
SYSTEM
tablespace.
C.
Oracle will use your default tablespace, if one exists, otherwise it will use your temporary tablespace.
D.
Oracle will use your temporary tablespace, if one exists, otherwise it will use the
SYSTEM
tablespace.
2.
What is a quota?
Please select the best answer.
A.
A special type of quotation mark that Oracle recognizes in order to allow quoted strings to be nested
B.
The amount of disk space that all users together are allowed to use within a database
C.
The amount of CPU time that a user may use while reading data from one specific tablespace
D.
The amount of disk space a user may use in one specific tablespace
3.
How many quotas may a user have?
Please select the best answer.
A.
It depends on the
DB_MAX_QUOTAS
parameter
B.
A user may have an unlimited number of quotas
C.
A user may have one quota per tablespace
D.
Users are limited to one quota
4.
What is the major advantage to specifying a temporary tablespace for a user?
Please select the best answer.
A.
Disk activity for sorts can be isolated from the rest of the database
B.
Disk space is conserved because sorted data do not need to be kept permanently
C.
The user does not need to specify a temporary tablespace in his queries
D.
Having a temporary tablespace assignment allows the user to use
ORDER BY
to sort query results
Correct answers:
Your Score: 0
Submit
Quiz Explanation