ORACLE DBA INTERVIEW QUESTIONS AND ANSWERS
Page – 6
A function always returns a value, while a procedure does not. When you call a function you must always assign its value to a variable.
52. What is different between NO DATA FOUND and %NOTFOUND
NO DATA FOUND is an exception which is raised when either an implicit query returns no data, or you attempt to reference a row in the PL/SQL table which is not yet defined. SQL%NOTFOUND, is a BOOLEAN attribute indicating whether the recent SQL statement does not match to any row
53. What is GWYUID ?
GWYUID , stands for Gateway User ID and password. Usually like APPLSYSPUB/PUB
54. Where GWYUID defined and what is its used in Oracle Applications ?
GWYUID is defined in dbc
i.e. Database Connect Descriptor file . It is used to connect to database by
think clients.
55. What is difference between UNIQUE and PRIMARY KEY constraints?
An UNIQUE key can have NULL whereas PRIMARY key is always not NOT NULL. Both bears unique values.
56. What is difference between ADPATCH and OPATCH ?
# ADPATCH is utility to apply ORACLE application Patches whereas
# OPATCH is utility to apply database patches
57. What is Partial Backup?
A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down
58. What is Full Backup?
A full backup is an operating system backup of all data files, on-line redo log files and control file that constitute ORACLE database and the parameter
59. What is the use of Control file?
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery
60. What are the type of Synonyms?
There are two types of Synonyms Private and Public
No comments:
Post a Comment