How do we switch from init.ora file to asp file?
Answers were Sorted based on User's Feedback
Answer / sachin
we can switch from init.ora file to a sp file with the help
of the command
create spfile from
pfile='c:\oracle\database_name\pfile\init.ora'
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sachin
we can switch from init.ora file to a sp file with the help
of the command
create spfile from
pfile='c:\oracle\database_name\pfile\init.ora'
Is This Answer Correct ? | 2 Yes | 0 No |
Describe an oracle table?
Why do we use bulk collect in oracle?
What are the execution control statements?
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Explain an index segment?
What are the type of Synonyms?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
Explain about the analyze command in oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
interview questions with answer for cts
DBMS vs. RDBMS