You have changed a database parameter stored in spfile to an incorrect value. When you try to restart the database, the database only gets as far as startup. How can you correct this error? A. Edit the pfile to correct the parameter B. Execute the Oracle command – a. Create pfile=’pfile’ from spfile b. Reset the parameter in file pfile c. Execute the Oracle command – Create spfile from pfile=’pfile’ B. C.Edit the spfile to correct the parameter C. Execute the Oracle command – a. Create spfile=’spfile’ from pfile b. Reset the parameter in file spfile

You have changed a database parameter stored in spfile to an incorrect value. When you try to restart the database, the database only gets as far as startup. How  can you correct this error?
A. Edit the pfile to correct the parameter
B. Execute the Oracle command –
a. Create pfile=’pfile’ from spfile
b. Reset the parameter in file pfile
by

1 Answer

Answer :

b. Reset the parameter in file pfile
by

Related questions

How can you increase the capacity of an Oracle tablespace? Note: there are 2 correct answers in this question A. Resize the existing data file B. Add a new data file to the existing tablespace C. Enable compression of backup data using Oracle advanced compression D. Increase the value of the database parameter DB_BLOCK_SIZE

Description : How can you increase the capacity of an Oracle tablespace? Note: there are 2 correct answers in this question A. Resize the existing data file B. Add a new data file to ... compression of backup data using Oracle advanced compression D. Increase the value of the database parameter DB_BLOCK_SIZE

Last Answer : B. Add a new data file to the existing tablespace

Which instances of an SAP system require a running database during their startup? Note: there are 2 correct answered to this question. ? A. Java Central Services Instance B. Additional Application Server Instance C.ABAP Central Services Instance D. Primary Application Server Instance

Description : Which instances of an SAP system require a running database during their startup? Note: there are 2 correct answered to this question. ? A. Java Central Services Instance B. Additional Application Server Instance C.ABAP Central Services Instance D. Primary Application Server Instance

Last Answer : B. Additional Application Server Instance

What are the advantages of activating the automatic Program Global Area (PGA) inSAP system that have an Oracle database? Note: there are 2 correct answered to this question A. Higher system performance is gained B. Shorter response time for queries is achieved C. Large sort processes will use more memory for efficient sorting D. Less PGA memory is allocated in advance

Description : What are the advantages of activating the automatic Program Global Area (PGA) inSAP system that have an Oracle database? Note: there are 2 correct answered to this question A. Higher system ... sort processes will use more memory for efficient sorting D. Less PGA memory is allocated in advance

Last Answer : A. Higher system performance is gained

You have changed parameters for AS Java of your SAP system based on AS ABAP+ Java. A restart of AS Java is requiredHow can you stop and start the Java stack without restarting the ABAP stack? A. Use the Config tool B. Use transaction, SAP Servers (SM51) C. Use transaction, ICM Monitors (SMICM) D. Use transaction CCMS Control panel: Display Statuses and alerts (RZ03)

Description : You have changed parameters for AS Java of your SAP system based on AS ABAP+ Java. A restart of AS Java is requiredHow can you stop and start the Java stack without restarting the ABAP ... transaction, ICM Monitors (SMICM) D. Use transaction CCMS Control panel: Display Statuses and alerts (RZ03)

Last Answer : C. Use transaction, ICM Monitors (SMICM)

Which post-installations activities are recommended by SAP after the installation of an SAP ECC 6.06 system? Note: there are 2 correct answered to this question A. Restart your SAP system and check logs for errors B. Install a valid license key C. Copy the user SAP* in client 000 for the number of users involved in the implementation project D. Confirm the installation in an SAP Support ticket

Description : Which post-installations activities are recommended by SAP after the installation of an SAP ECC 6.06 system? Note: there are 2 correct answered to this question A. Restart your SAP system ... of users involved in the implementation project D. Confirm the installation in an SAP Support ticket

Last Answer : A. Restart your SAP system and check logs for errors B. Install a valid license key

What are the options to directly raise an event to trigger an event-dependent job? Note: there are 2 correct answered to this question A. Execute program sapxpg on operating system level B. Execute program sapevt on operating system level C. Execute transaction CCMS Control Panel (RZ03) D. Execute the ABAP program BTC_EV,NT_RAISE

Description : What are the options to directly raise an event to trigger an event-dependent job? Note: there are 2 correct answered to this question A. Execute program sapxpg on operating system level B. ... level C. Execute transaction CCMS Control Panel (RZ03) D. Execute the ABAP program BTC_EV,NT_RAISE

Last Answer : D. Execute the ABAP program BTC_EV,NT_RAISE

What is difference between PFile and SPFile?

Description : What is difference between PFile and SPFile?

Last Answer : A PFILE is a static, text file located in $ORACLE_HOME/dbs - UNIX An SPFILE (Server Parameter File) is a persistent server-side binary file that can only be modified with the "ALTER SYSTEM SET" command.

Explain the differences between PFILE and SPFILE

Description : Explain the differences between PFILE and SPFILE

Last Answer : A PFILE is a Static, text file that initializes the database parameter in the moment that it's started. If you want to modify parameters in PFILE, you have to restart the database. ... binary file that allows you to overwrite parameters while the database is already started (with some exceptions)

Consider an SAP system based on AS ABAP How many monitoring segments are used for the CCMS Monitoring Infrastructure? A. There is one monitoring segment for each host B. There is one monitoring segment for each database used by an SAP system C. There is one monitoring segment for each application server D. There is one monitoring segment for each central services instance

Description : Consider an SAP system based on AS ABAP How many monitoring segments are used for the CCMS Monitoring Infrastructure? A. There is one monitoring segment for each host B. There is ... segment for each application server D. There is one monitoring segment for each central services instance

Last Answer : A. There is one monitoring segment for each host

What are the advantages of using logical spool servers? Note: there are 2 correct answered to this question A. You can create more output devices B. You can balance the load across multiple physical spool servers C. You can minimize the load on physical devices D. You can minimize the manual adjustment of output device definitions after the transport

Description : What are the advantages of using logical spool servers? Note: there are 2 correct answered to this question A. You can create more output devices B. You can balance the load across ... on physical devices D. You can minimize the manual adjustment of output device definitions after the transport

Last Answer : B. You can balance the load across multiple physical spool servers C. You can minimize the load on physical devices

Which information is stored in a monitoring segment of the alert monitoring infrastructure within the Computing Center Management System (CCMS)? Note: there are 2 corrects answered to this questions A. Current monitoring data of monitored components B. The coding of data collectors C. Open alerts within CCMS D. Monitoring definitions

Description : Which information is stored in a monitoring segment of the alert monitoring infrastructure within the Computing Center Management System (CCMS)? Note: there are 2 corrects answered to this questions A. ... B. The coding of data collectors C. Open alerts within CCMS D. Monitoring definitions

Last Answer : A. Current monitoring data of monitored components B. The coding of data collectors

On operating system level in the log subdirectory of the transport directory, you find the file DEVI990123 QAS What is this file? A. This is the log for the export of transport request DEVK990123 from system QAS B. This is the tp system log of the QAS system from January 23, 1999 C. This is the log file for the main import of transport request DEVI990123into system SAP D. This is the data file of transport request DEVI990123 which is to be imported into QAS system

Description : On operating system level in the log subdirectory of the transport directory, you find the file DEVI990123 QAS What is this file? A. This is the log for the export of transport request DEVK990123 ... D. This is the data file of transport request DEVI990123 which is to be imported into QAS system

Last Answer : C. This is the log file for the main import of transport request DEVI990123into system SAP

What are the prerequisites to assigning Printing Assistant for Landscapes (PAL) printers to a printer group? A. Distribute the printer group to a target system group. B. Check the distribution log C. Create a target system. D. Assign the target system to a target system group E. Create a system user. F. Create an RFC connection G. Create the output device using transaction Spool Administration(SPAD) H. Create the output device as a PAL printer

Description : What are the prerequisites to assigning Printing Assistant for Landscapes (PAL) printers to a printer group? A. Distribute the printer group to a target system group. B. Check the ... output device using transaction Spool Administration(SPAD) H. Create the output device as a PAL printer

Last Answer : D. Assign the target system to a target system group

Which of the following settings can you make during the installation of an AS ABAP-based SAP ECC 6.06 system? Note: there are 2 correct answered to this question A. The number of clients in the SAP system B. The number and types of work processes C. The master password for some default users in this SAP system D. The ABAP message server port

Description : Which of the following settings can you make during the installation of an AS ABAP-based SAP ECC 6.06 system? Note: there are 2 correct answered to this question A. The number of clients in the ... C. The master password for some default users in this SAP system D. The ABAP message server port

Last Answer : C. The master password for some default users in this SAP system D. The ABAP message server port

During the installation of SAP XSS you have to select the Usage Types that should be installedWhich Usage Types are necessary for the installation of SAP XSS? Note: there are 2 correct answered to this question A. Utilities Customer E-Services B. Enterprise Portal C. Adobe Document Services D. Self Services

Description : During the installation of SAP XSS you have to select the Usage Types that should be installedWhich Usage Types are necessary for the installation of SAP XSS? Note: there are 2 correct answered ... . Utilities Customer E-Services B. Enterprise Portal C. Adobe Document Services D. Self Services

Last Answer : D. Self Services

You want to provide authorizations to a new user in an SAP system based on ASJava 7.10 or higherHow can you do this with the user management engine (UME)? Note: there are 2 correct answered to this question A. Add some actions to the user directly B. Add some actions to a role, then assign this role to the user C. Add some actions to a role, assign this role to a group, then assign thisgroup to the user D. Add some actions to a group, then assign this group to the use

Description : You want to provide authorizations to a new user in an SAP system based on ASJava 7.10 or higherHow can you do this with the user management engine (UME)? Note: there are 2 correct answered to this ... assign thisgroup to the user D. Add some actions to a group, then assign this group to the use

Last Answer : B. Add some actions to a role, then assign this role to the user C. Add some actions to a role, assign this role to a group, then assign thisgroup to the user

Which services build the SAP Java Central Services Instance for AS Java 7.10 and higher? A. Message Server and EnqueueServer B. Message Server, Enqueue Server and Gateway Service C. Message Server, Enqueue Server and ICM D. Message Server, Enqueue replicated Server and Gateway Service E.

Description : Which services build the SAP Java Central Services Instance for AS Java 7.10 and higher? A. Message Server and EnqueueServer B. Message Server, Enqueue Server and Gateway Service C. Message Server, Enqueue Server and ICM D. Message Server, Enqueue replicated Server and Gateway Service E.

Last Answer : B. Message Server, Enqueue Server and Gateway Service

A company wants to manage job scheduling centrally and has the requirements toexecute job chains across different SAP systems. Which batch scheduling tool do you recommend? A. SAP Central Process Scheduling (basic version) B. CCMS Batch Job Scheduling C. SAP Central Process Scheduling (full version) D. The Job Management work center in SAP Solution Manager

Description : A company wants to manage job scheduling centrally and has the requirements toexecute job chains across different SAP systems. Which batch scheduling tool do you recommend? A. SAP Central Process ... Process Scheduling (full version) D. The Job Management work center in SAP Solution Manager

Last Answer : C. SAP Central Process Scheduling (full version)

Your task is to install an additional application server for an SAP system Which rule applies for the installation work? A. The additional application server has to be installed on a separated host from the primary application server B. The additional application server can be installed using the user sapadm C. The additional application server can be installed using an instance number proposed y the installation tool D. The additional number of the additional application server has to be identical to the instance number of the primary application server.

Description : Your task is to install an additional application server for an SAP system Which rule applies for the installation work? A. The additional application server has to be installed on a ... additional application server has to be identical to the instance number of the primary application server.

Last Answer : A. The additional application server has to be installed on a separated host from the primary application server

A developer wants to process all transactions in the sequence specified by the application. Which type of Remote Function Call (RFC) implementation do you recommend? A. Background RFC (bgRFC) B. Asynchronous RFC (aRFC) C. Synchronous RFC (sRFC) D. Transactional RFC (tRFC)

Description : A developer wants to process all transactions in the sequence specified by the application. Which type of Remote Function Call (RFC) implementation do you recommend? A. Background RFC (bgRFC) B. Asynchronous RFC (aRFC) C. Synchronous RFC (sRFC) D. Transactional RFC (tRFC)

Last Answer : D. Transactional RFC (tRFC)

Assuming that you have all required authorizations, which functions can you access in SAP GUI for Java? A. Functions provided by SAP business One B. Functions provided by transactions in AS ABAP based SAP system C. Functions provided by SAP NetWeaver Developer Studio D. Functions provided by AS Java SAP systems

Description : Assuming that you have all required authorizations, which functions can you access in SAP GUI for Java? A. Functions provided by SAP business One B. Functions provided by transactions in AS ... C. Functions provided by SAP NetWeaver Developer Studio D. Functions provided by AS Java SAP systems

Last Answer : B. Functions provided by transactions in AS ABAP based SAP system

Which interface is used to connect SAP Central Process Scheduling in an SAP ECC system? A. Platform Agent B. XBP C. JXBP D. BW-SCH

Description : Which interface is used to connect SAP Central Process Scheduling in an SAP ECC system? A. Platform Agent B. XBP C. JXBP D. BW-SCH

Last Answer : B. XBP

Which user with administration authorizations is available right after the installation of SAP Solution Manager 7.1 to log A. DDIC B. Administrator C. J2EE_ADMIN D. EARLYWATCH

Description : Which user with administration authorizations is available right after the installation of SAP Solution Manager 7.1 to log A. DDIC B. Administrator C. J2EE_ADMIN D. EARLYWATCH

Last Answer : C. J2EE_ADMIN

What does an authorization profile in an AS ABAP based SAP system contains? A. collection of authorizations B. The user menu C. Profile parameters, such as the password expiration time(login/password_expiration_time) D. The collection of the authorizations checks that a user has passed successfully

Description : What does an authorization profile in an AS ABAP based SAP system contains? A. collection of authorizations B. The user menu C. Profile parameters, such as the password ... (login/password_expiration_time) D. The collection of the authorizations checks that a user has passed successfully

Last Answer : A. collection of authorizations

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.

How do you switch from an init.ora file to a spfile?

Description : How do you switch from an init.ora file to a spfile?

Last Answer : Issue the create spfile from pfile command.

How could you execute DDL commands, such as ALTER or CREATE TABLE, against a database with ADO.NET?

Description : How could you execute DDL commands, such as ALTER or CREATE TABLE, against a database with ADO.NET?

Last Answer : You must use a Command object to execute DDL commands. You can set the CommandType property to Text and enter the appropriate DDL command in the CommandText property. Then call Command.ExecuteNonQuery to execute the command.

What use of command line parameter cmd file?

Description : What use of command line parameter cmd file?

Last Answer : It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.

Diesel generators #1 and #2 are operating in parallel at near full load capacity. Diesel generator #1 suddenly trips out mechanically due to low lube oil pressure. The reverse power relay functions properly and trips generator #1 electrically off the bo A. Start the emergency generator. B. Ascertain cause of the low lube oil pressure. C. Strip the board of all nonvital circuits. D. Secure alarms, reset reverse power relay, and restart #1 engine.

Description : Diesel generators #1 and #2 are operating in parallel at near full load capacity. Diesel generator #1 suddenly trips out mechanically due to low lube oil pressure. The reverse power relay functions ... all nonvital circuits. D. Secure alarms, reset reverse power relay, and restart #1 engine.

Last Answer : Answer: C

When power is restored after a complete power failure, a steering gear pump motor will ____________. A. have to be restarted B. have to be reset C. restart automatically D. trip its overload relays

Description : When power is restored after a complete power failure, a steering gear pump motor will ____________. A. have to be restarted B. have to be reset C. restart automatically D. trip its overload relays

Last Answer : Answer: C

The kernel configuration file is normally changed only when you wish to: A. Produce a smaller, more efficient kernel by removing unneeded items. B. Add a new device C. Modify a system parameter D. all of the above.

Description : The kernel configuration file is normally changed only when you wish to: A. Produce a smaller, more efficient kernel by removing unneeded items. B. Add a new device C. Modify a system parameter D. all of the above.

Last Answer : D. all of the above.

I keep getting redirected to an error page when I try to edit my empty picture profile hep?

Description : I keep getting redirected to an error page when I try to edit my empty picture profile hep?

Last Answer : Me too, getting re-directed mean, It’ll be a temporary thing. Not to worry.

Which among the following is correct about ROM: a) ROM is non volatile memory because any data stored in ROM remains there, even if the power is turned off b) ROM is an ideal place to put the PC's startup instructions - that is, the software that boosts the system. c) Both of Above d) None of These

Description : Which among the following is correct about ROM: a) ROM is non volatile memory because any data stored in ROM remains there, even if the power is turned off b) ROM is an ideal place to put the PC's startup instructions - that is, the software that boosts the system. c) Both of Above d) None of These

Last Answer : c) Both of Above

What is the command to restart IIS?

Description : What is the command to restart IIS?

Last Answer : answer:Two ways: 1. Using the “net” command: http://support.microsoft.com/kb/236166 2. Using the IISReset command-line utility: http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/003ed2fe-6339-4919-b577-6aa965994a9b.mspx?mfr=true

When an array is passed as parameter to a function, which of the following statements is correct ? (A) The function can change values in the original array. (B) In C, parameters are passed by value, the function cannot change the original value in the array. (C) It results in compilation error when the function tries to access the elements in the array. (D) Results in a run time error when the function tries to access the elements in the array.

Description : When an array is passed as parameter to a function, which of the following statements is correct ? (A) The function can change values in the original array. (B) In C, parameters are passed by value, ... . (D) Results in a run time error when the function tries to access the elements in the array.

Last Answer : (A) The function can change values in the original array.

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Description : What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Last Answer : The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Description : What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Last Answer : Answer The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.

What is the effect of setting the value “CHOOSE” for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?

Description : What is the effect of setting the value “CHOOSE” for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?

Last Answer : The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

What is the effect of setting the value “ALL_ROWS” for OPTIMIZER_GOAL parameter of the ALTER SESSION command? –

Description : What is the effect of setting the value “ALL_ROWS” for OPTIMIZER_GOAL parameter of the ALTER SESSION command? –

Last Answer : What are the factors that affect OPTIMIZER in choosing an Optimization approach? – Answer The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.

What are the steps involved in Database Startup ?

Description : What are the steps involved in Database Startup ?

Last Answer : Start an instance, Mount the Database and Open the Database. Rolling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo ... Resolving any pending distributed transactions undergoing a two- phase commit at the time of the instance failure.

This first step inthe transaction processing cycle captures businessdata throughvarious modes suchas optical scanning orat an electronic commerce website– (A) Document and report generation (B) Database maintenance (C) Transaction processing startup (D) Data Entry

Description : This first step inthe transaction processing cycle captures businessdata throughvarious modes suchas optical scanning orat an electronic commerce website– (A) Document and report generation (B) Database maintenance (C) Transaction processing startup (D) Data Entry

Last Answer : Data Entry

What are the steps involved in Database Startup?

Description : What are the steps involved in Database Startup?

Last Answer : Start an instance, Mount the Database andOpen the Database.

The command javac is used to A) debug a java program B) compile a java program C) interpret a java program D) execute a java program

Description : The command javac is used to A) debug a java program B) compile a java program C) interpret a java program D) execute a java program

Last Answer : B) compile a java program

The type(s) of auto executing macros, in Microsoft word is/are A) Auto execute B) Auto macro C) Command macro D) All of the above

Description : The type(s) of auto executing macros, in Microsoft word is/are A) Auto execute B) Auto macro C) Command macro D) All of the above

Last Answer : D) All of the above

The Xperia E3 mobile phone is gone, after the restart and charging it writes an SIm error and it doesn't work, please ....

Description : Unable to call, internet .... send messages

Last Answer : Need Answer

Some Basics command of ORACLE 10g on Windows Operating System:

Description : Some Basics command of ORACLE 10g on Windows Operating System:

Last Answer : SQL> show parameter db_name SQL> show parameter instance_name SQL> show parameterdb_block_size (it will show the default block size which is 8KB)

What command will you start to run the installation of Oracle software on Linux?

Description : What command will you start to run the installation of Oracle software on Linux?

Last Answer : runInstaller

The sims 4 initialization error at startup

Description : Please don't know what to do with it?

Last Answer : Did you try to reinstall them? ☠ ☠ ☣ ☠ ☣ ☠ ☣ ☠ ☢

When an array is passed as a parameter to a function which of the following statements is correct? (A) The function can change values in the original array. (B) The function cannot change values in the original array. (C) Results in compilation error. (D) Results in runtime error.

Description : When an array is passed as a parameter to a function which of the following statements is correct? (A) The function can change values in the original array. (B) The function cannot change values in the original array. (C) Results in compilation error. (D) Results in runtime error.

Last Answer : (A) The function can change values in the original array.