What is the relation of a user account and a schema in oracle?



What is the relation of a user account and a schema in oracle?..

Answer / Ankit Kumar Gahlaut

"A user account and a schema are closely related in Oracle. A schema is a collection of database objects owned by a user. When you create a new user, a new schema with the same name as the user is also created."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

How to create a new view in oracle?

1 Answers  


How much memory your 10g xe server is using?

1 Answers  


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  


Explain the difference between sap and oracle?

1 Answers  


What is an oracle and why it is used?

1 Answers  


What is bulk load in oracle?

1 Answers  


Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  


What is the difference between truncate & delete command?

1 Answers  


What is the quickest way to fetch the data from a table?

1 Answers  


What is blob datatype?

1 Answers  


how will I find the first 5 highest salaried employees in each dept in oracle.

22 Answers   IBM,


What do you mean by a deadlock?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)