ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Databases >> Oracle >> Oracle General
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions (718)
 OCI interview questions  OCI Interview Questions (10)
 Architecture interview questions  Architecture Interview Questions (75)
 Oracle Security interview questions  Oracle Security Interview Questions (37)
 Database Management interview questions  Database Management Interview Questions (264)
 Forms Reports interview questions  Forms Reports Interview Questions (466)
 Oracle AllOther interview questions  Oracle AllOther Interview Questions (181)
Question
What are the differences between a sys and system user and
what are the extra privileges available to the sys user?
 Question Submitted By :: Oracle-General
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
SYS is the owner of the oracle dictionary.
THE DEFAULT superuser or like a 'root' in a oracle database.
Oracle strongly recomends NOT TO use SYS for any regular
adminstration tasks.

please have a look here

http://www.orafaq.com/usenet/comp.databases.oracle.server/20
03/08/06/0511.htm

system is just another account with administrative privs (
by default cannot start/shut databases)

quoting docs
"The Oracle user SYS owns all base tables and user-
accessible views of the data dictionary. Therefore, no
Oracle user should ever alter (update, delete, or insert)
any rows or schema objects contained in the SYS schema,
because such activity can compromise data integrity. The
security administrator should keep strict control of this
central account."

"When a database is created, the user SYSTEM is also
automatically created and granted the DBA role.

The SYSTEM username is used to create additional tables and
views that display administrative information, and internal
tables and views used by various Oracle options and tools.
Never create in the SYSTEM schema tables of interest to
individual users."
 
Is This Answer Correct ?    1 Yes 1 No
Sandip Patil
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?   1
Explain the relationship among Database, Tablespace and Data file?   2
what are the database links ?   2
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views? IBM 1
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?   3
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately   1
1.display list of all users from ur data base.what is the query? IBM 3
Which database is better for os platform dependency?   1
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit Polaris 2
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)? ESS 1
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000 tcs 3
can we pass two out parameters at a time in function?please answer to my question Wipro 3
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com