Question

You need to connect to Oracle as one of the users to simulate a problem. Since you don't know the password of the user, how would you connect as that user?

You are a database administrator managing a set of users on your Oracle database. You notice that some tables created by non-system users are being stored in the SYSTEM tablespace of your database. You understand that non-system user objects should not be stored in the SYSTEM tablespace. You want to ensure that future tables created by non-system users are not stored in the SYSTEM tablespace. You want to accomplish this with the least administrative effort. Which action should you take?

What does it mean when Oracle says, 'Multiplexing control files?' Explain indicating which file lists the control files in Oracle 11g.
   
You have a user requesting that their password be changed. They will not be in the office until the next Monday but they request that you do this right away, what could you do as a DBA?

You notice that users have been requesting the same query but it appears that it's taking longer to give the results, what could possibly be the problem and how could you resolve it? Explain giving all possibilities.

Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

You need to connect to Oracle as one of the users to simulate a problem. Since you don't know the password of the user, how would you connect as that user?
Answer:
It works by connecting to the database as SYSDBA and switching from an user to another without being required a password.
SQL> CONNECT / as sysdba...

This is only a preview of the solution. Please use the purchase button to see the entire solution

$20.00

or $1 if you
register a new account!

Assisting Tutor

Related Homework Solutions

Transparent Data Encryption (2780 words)
Homework Solution
$100.00
TDE
Data
Transparent
Encryption
Database
Oracle
Technology
Tablespace
Two-tier
Architecture
Network
Authentication
Advanced
Security
Cryptographic
Overhead
Metric
PKCS
Standard
Compliance
Database: SQL DDL Query
Homework Solution
$28.00
Database
Computer
Science
DDL
Query
SQL
Retrieve
Total
Sum
Count
Select
Group
Development
Get help from a qualified tutor
Live Chats