Latest Answer : datafile,control file and redo logs ...
Latest Answer : Data objects are used to stored data when needs to grow take chunks of space that is called extents and an data objects multiple extents are stored in segment. ...
Latest Answer : Table Space : The table space is useful for storing the data in the
database. When a database is created two table spaces are created.
a) System Table Space : This data file stores
all the tables related to the system and ...
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 : An Oracle instance is a combination of background processes and memory structures (SGA) ...
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 ...