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

Assisting Tutor

Related Homework Solutions

E-R Diagram
Homework Solution
$25.00
Computer
Science
E-R Diagram
Database
Development
Customer
Service
Installation
Movie Database Project Using SQL & Java
Homework Solution
$240.00
Java
Programming
Codes
Algorithms
Computer Science
Statements
Variables
Loops
Input
Output
Integers
Strings
Database Management
SQL
Movies
Advertisements
Queries
File Management
Operations
Command Line
JDBC
Database Development Questions
Homework Solution
$40.00
Computer Science
Database Development
SQL Queries
Models
Tables
Relational Calculus
Relational Algebra
Flights
Employees
Airline Information
Foreign Key
Primary Key
Constraints
Unsafe Queries
Questions about Oracle 11g
Homework Solution
$18.00
Computer Science
Oracle 11g
Database
System Privilege
Block Size
SQL
Tunning
SYSAUX
PFILE
SPFILE
Get help from a qualified tutor
Live Chats