 Related Questions Latest Answer : Components of Physical database are:-1. Datafile - One or more2. Redo log file - Two or more3. Control File - Two or more ... Latest Answer : Oracle logical structure follows the order likeTablespaceSegments
ExtentsDatablocksOracle database consists of tablesapces (one or more tablespace forms database)
Segments is the area in which on oracle object sores in a tablespace.One Oracle object ... Latest Answer : The database is actually a collection of objects, which are made up of tablespaces and each tablespace must have datafile associate with it. The tablespace cannot be created without datafile. The tablespaces are two kind physical and logical.The logical ... 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
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
