|
Question |
Rating |
View Answer |
|
Explaint the nvl2 function
|
|
View Answer |
|
Choose two reasons why you would use a direct –path load instead of a conventional-path load. a. To restrict users from performing b. To perform parallel loads c. To disable the generation of redo log entries if the database is in ARCHIVELOG mode. d. The table has many indexes, and the temporary tabelspace is small.
|
|
View Answer |
|
What is a Rollback segment entry ? |
|
View Answer |
|
What is Referential Integrity ? |
|
View Answer |
|
Which NLS parameter can be specified only as an environment variable? a. NLS_LANGUAGE b. NLS_LANG c. NLS_TERRIROTY d. NLS_SORT
|
|
View Answer |
|
What is WHEN-Database-record trigger? |
|
View Answer |
|
What are materialized views? |
|
View Answer |
|
What is the process of upgrading oracle forms /reports from older version to new versions?
|
|
View Answer |
|
What is a canvas-view? |
|
View Answer |
|
What is an Extent ? |
|
View Answer |
|
Which file is used to record all changes made to the database and is used only when performing an instance recovery?
|
|
View Answer |
|
What are the database administrators utilities available ? |
|
View Answer |
|
When a server process is terminated abnormally, which background process is responsible for releasing the locks held by the user? |
|
View Answer |
|
What is use of a cursor variable? How it is defined? |
|
View Answer |
|
What is Normalisation? |
|
View Answer |
|
What are the recommended INITIAL and NEXT values for a temporary tablespace, to reduce fragmentation? |
|
View Answer |
|
What is the significance of having storage clause ? |
|
View Answer |
|
Can one rename a database user (schema)? |
|
View Answer |
|
Fill in the blank: The parameter MAXTRANS specifies the maximum number of concurrent transactions per ___________________. |
|
View Answer |
|
User SCOTT has opened a SQL * Plus session and left for lunch. When you queired the V$SESSION view, the STATUS was INACTVE. You terminated SCOTT’s session in V$SESSION?
|
|
View Answer |