-
Repair TNSnames.ora File
How to repair the tnsnames.ora file.
File is completely corrupted and you get network adapter errors and TNS resolve error after restarting the machine.dbxplorer
- Jul 21st, 2011
Delete or rename the older file and try to recreate it using "netmgr" using proper information of your database.
-
Private,Public database link
How to give private and public database links ?What is syntax for that ?What means mutation in oracle??
dbxplorer
- Jul 21st, 2011
Database link is the pointer that allow users to access other user's object in remote database. This is one way communication path using database links. Private db links: CREATE DATABASE LINK link_na...
-
What is the advantage of specifying WITH GRANT OPTION in the GRANT command?
vinoth
- Jul 15th, 2011
Giving privilege to the user
sreekanth.g
- Jun 22nd, 2011
Assume that table 'emp' is created by user scott.by using grant command he can grant privileges to other users.If he want to provide a privileges to grant the privileges to other usershe has to grant a privileges with grant option.
-
RMAN Backup
-
Archive Files
What are archive files? What are the uses with archive files?
pardhudb
- Mar 23rd, 2011
Before discussing ?about archive files we will be discuss about redolog files ,these redologfiles records every operation done on the database, ?so when the datafiles are damaged, we can get complet...
GAUTAMJANGRA
- Mar 16th, 2011
Archives files are files which are placed together in a bunch for any particular work. Benefit of this is there is no chance of missing of files while transfer from one place to another, also you...
-
RAC Database
What difference does it make to a Oracle developer while using RAC ? Would/Should he realise that it is a RAC Database ?
suji
- Mar 21st, 2011
It makes no difference for the developer and RAC technology is server side and affects the way DBA do they day to day job. Thanks, Suji
-
Distribution Table
In the hint, pq_distribute, which is the outer distribution table and which is the inner distribution table?
-
Run Tme Database Decision
How we can decide at run time that which database is going to use among Oracle, SQL Server, MS Access and so on available databases?
-
DBMS Relation
In DBMS, What is a relation?
-
TableSpaces and PCTIncrease
What is PCTIncrease in Oracle? How the memory is allocated, reallocated and autoextended while creating tablespaces? What is meant by initial and default in tablespaces and How the next is a multiple of five times DB_BLOCK_SIZE?
-
Dump Destination
What is dump destination?
-
-
Oracle Catlog & Oracle Archive Log
What are Oracle Catlog & Oracle Archive Log?
-
What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?
mrrichardson
- Jul 12th, 2010
Structured Query LanguageSQL- Is a languagekeywords cannot be abbreviatedSQL *PLUS - More complex than SQLIs a command line tool propietary to Oracle where you can run both SQL and PL/SQL stateme...
Jeremy
- Aug 24th, 2007
SQL*Plus is a client program and interactive interpreter designed for interacting with Oracle databases. SQL is a standard data access language used to describe data access to a variety of databases. ...
-
Constraints and Validations
What is the difference between Constraints and Validations?
-
Drop a Datafile
How to drop or delete a datafile which has been miskenly added to a tablespace?
aravindhreturns
- Apr 23rd, 2010
In most environments, this is done using Oracle Import/Export utility since certain privileges are restricted to the DBAs. Steps are below:- 1) Export the data 2) Drop the Tablespace, 3) Import the da...
-
Database size
How to see the Database size and version and RMAN size and version?
aravindhreturns
- Apr 23rd, 2010
To find the ORACLE database size, you need to make a small calculation. The result of these two syntaxes below can be used to find the total allocated size of the database:- select sum(bytes)/10737418...
-
TableSpace Space
How to find out how much space a tablespace has remaining?
aravindhreturns
- Apr 22nd, 2010
The total size of the tablespace can be determined through DBA_DATA_FILES. Likewise, free size of the tablespace can be determined through DBA_FREE_SPACE. So you can simply do this, Subract you can si...
-
Start Up Information
In which file we can see start up information?
aravindhreturns
- Apr 22nd, 2010
I will give you three options as im unsure of what your requirement is:-If you're talking about a flatfile which contains the startup information, Well it is obviously the alert logfile. It can be fou...
-
Control File Restore
How to restore the control file by using RMAN backup?
aravindhreturns
- Apr 22nd, 2010
Use these two methods to get the control file from autobackup:- (This applies only if you have configured AUTOBACKUP ON)One:-First, Login to RMAN (RMAN Target /)Set the DBID by querying v$database (SE...
Oracle Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans