|
Question |
Rating |
View Answer |
|
What is difference between Rename and Alias? |
|
View Answer |
|
What is the default value of PCTFREE? |
|
View Answer |
|
What is a Transaction in Oracle |
|
View Answer |
|
What are disadvantages of having raw devices ? |
|
View Answer |
|
Explain about stacked canvas views? |
|
View Answer |
|
Difference between varchar and varchar2 data types ? |
|
View Answer |
|
19. If you issue ALTER TABLESPACE USERS OFFLINE IMMEDIATE, which of the following statements is true? A. All data files belonging to the tablespace must be online. B. Does not ensure that the data files are available. C. Need not doe media recovery when bringing the tablespace online. D. Need to do media recovery when bringing the tablespace online.
|
|
View Answer |
|
What is path setting for DLL? |
|
View Answer |
|
15. Which keyword should be used in the CREATE INDEX command to create a function –based index? A. CREATE FUNCTION INDEX… B. CREATE INDEX … ORGANIZATION INDEX C. CREATE INDEX… FUNCTION BASED … D. None of the above
|
|
View Answer |
|
Which parameter is used to limit the number of dirty buffers in the buffer cache, thereby limiting the time required for instance recovery? |
|
View Answer |
|
What is an administrative (privileged) user? |
|
View Answer |
|
Explain truncate with restore option with example
|
|
View Answer |
|
Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?
|
|
View Answer |
|
What are referenced objects? |
|
View Answer |
|
Describe a parallel server configuration. |
|
View Answer |
|
What are the two phases of block coordination? |
|
View Answer |
|
What happens next when a server process is not able to find enough free buffers to copy the blocks from disk? |
|
View Answer |
|
Which of the following statements may require a temporary segment?
a. CREATE TABLE b. CREATE INDEX c. UPDATE d. CREATE TABLESPACE
|
|
View Answer |
|
How will you delete duplicating rows from a base table? |
|
View Answer |
|
What are the valid status codes in the V$LOGFILE view? |
|
View Answer |