![]() Related Questions Latest Answer : Dear, Oracle Physical Database Structure consist of Datafiles, Controlfile & Online Redo Log files. Logical Structure ... Latest Answer : Oracle Database comprises of Physical and Logical Structure.Logical structures are intangible.....and it includes: - 1) Tablsespace2) Segments3) Extents4) Data blocks.Remember Tables are also logical only..RegardsDharmendra Jaiswal ... Latest Answer : The datafiles in an Oracle database are grouped together into one or more tablespaces. An Oracle tablespace consists of one or more datafiles; a datafile can be a part of one and only one tablespace.Schema can own any type of object in the database: ... Latest Answer : A database link (same as linked servers in SQL Server) is an object in one Oracle database that defines a path to another database. They allow you to query remote tables and execute remote procedures residing in an Oracle User on that remote Oracle database. ... Latest Answer : Oracle allows you to create private, public, and global database links. Private Database Link: You can create a private database link in a specific schema of a database. Only the owner of a private database link or PL/SQL subprograms ... Latest Answer : PUBLIC DATABASE LINKPRIVATE DATABASE LINK ... Latest Answer : Database link is a schema object in one database to access objects in another database. When you create database link with Public clause, it is available for access to all the users, and if you omit this clause, then database link is privat and available ... Latest Answer : When an Oracle network uses Oracle Names, the names servers in the system automatically create and manage global database links for every Oracle database in the network. All users and PL/SQL subprograms in any database can use a global database link to ... Latest Answer : SGA+Background Process = InstanceAs soon as user process starts and server process takes control from user process, instance created with help of background processes and most important background processes are dbwriter, logwriter, checkpoint, SMON, PMON ... Latest Answer : Index is an object in the oracle database used to speed up the performance of the queries ie. it improves the access speed and response of query will be good when the query makes use of Index.ThanksHarsha ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||