|
|
Authorized user can see question and answers.
Please log in or sign up. 
|
#362. Your test database has a server parameter file (SPFILE) created for it. You executed the following command to create a text initilization parameter file (PFILE) when the database is shut down: SQL> CREATE PFILE FROM SPFILE;
What would be the result of this command?
Show comments for this question (0)
Add comments
Link to this question
|
|
#367. You received the following error when you executed the STARTUP command to open the database:
ORA-01990: error opening password file ‘D:\oracle\ora92\DATABASE\PWDmydb.ORA’
ORA-27041: unable to open file
OSD-04002: unable to open tile
O/S-Error (OS 2)
The system cannot find the file specified.
When is this error encountered?
Show comments for this question (0)
Add comments
Link to this question
|
|
#368. You executed the following command to create an index on the SALARY column of the EMPLOYEES table: SQL> CREATE INDEX saL INDEX ON employees (salary) STORAGE (INITIAL 16K NEXT 16KMAXEXTENTS 100 MINEXTENTS 5) INITRANS 3 MAXTRANS 10 PCTFREE 10 PCTUSED 40;
The command fails, displaying the following error:
ORA-021 58: invalid CREATE INDEX option
Which parameter could have caused the statement to fail?
Show comments for this question (0)
Add comments
Link to this question
|
|
|
|
 gen. 0.163
|
Server date 09:13 22-11-2008
|
Developed by Zip © 2006
|
|
|
|
|
Forum
Master braindump