:: 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                      
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)
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  
# 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

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 diff between Oracle and SQL Server   1
Does a Before form trigger fire when the parameter form is suppressed ? Oracle 1
select * from emp what happened internally when we write this query in the sql prompt?   5
I have my backup RMAN script called I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?   1
26. Display the earliest shipping date in the format: DD/MON/YYYY Wipro 5
where we have to use ON clause and where we have to use USING clause in JOINS   2
how to use sequence and what use of sequence cache   1 to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.   6
What are the types of Database Links ?   2
What is different bet native dynamic sql and Dbms_Sql? Thermotech 4
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?   3
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ? IBM 1
For more Oracle General Interview Questions Click Here 

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