Which two statements are true about initialization parameter files? (Choose two)
A.
A lost or damaged SPFILE can be re-created by using the parameter values listed in the alert log.
B.
A PFILE must exist for an SPFILE to be created.
C.
The ALTER SYSTEM command cannot be used to change the value of any parameter if a database instance has started using a PFILE.
D.
Both the SPFILE and PFILE must always reside on a file system accessible from the database host server.
E.
On startup, by default a database instance always first searches for an SPFILE, and if it does not find any, searches for a PFILE.
Explanation:
I think c e
Sorry – Correct answer is: A & E.
Explain:
A — Alert log => create pfile => create spfile
E — This in Oracle workshop or Google.
B wrong beacause you can create spfile from memory (sql> create spfile from memory).
C wrong beacause you can still change dynamic parameter when start from pfile (it just applies to current session – lost when restart). P/s pfile just can be read by Instance – not write.
D wrong beacause you can start Instance using either spfile or pfile.
I agree with this.
I also choose AE.
I do not agree with A.
Alert log could help to create a pfile, not a spfile.
“can be re-created”: alert log => create pfile => create spfile.
A is correct.
BE
https://docs.oracle.com/database/121/SQLRF/statements_6018.htm#SQLRF01315
According to Oracle, spfile can be created by 2 methods: from pfile or from memory.
So I think the word “must” is wrong.
CE are correct. “pfile can be read by the database server, but is not written to by the server. pfile must be set and changed manually by using text editor…”
Please correct me if I’m wrong 🙂
It will change it for the current instance in memory…..but will go away after restart.
spfile can be created by using pfile or memory (if instance is still running).
That’s reason why we have:
sql> create spfile from memory;
or
sql> create spfile from pfile;
=> B is not correct
BE
DE
CE are correct
B: is wrong “Specify MEMORY to create an spfile using the current system-wide parameter settings. In an Oracle RAC environment, the created file will contain the parameter settings from each instance”
C: correct “The SPFILE is different from the PFILE in that it can not be directly edited. This is because it has a header and footer that contains binary values. Since you can not change a SPFILE directly, Oracle allows you to manage the SPFILE via the alter system command.”
Hey Younes,
Could you please answer other questions too ? Your answers are very helpfull
another answer to confirm that CE are correct :
C: Changes to initialization parameter values by ALTER SYSTEM are only in effect for the current instance. You must manually update the text initialization parameter file and restart the instance for the changes to be known.
E : Searches for a server parameter file in a platform-specific default location and, if not found, for a text initialization parameter file (specifying STARTUP with the SPFILE or PFILE parameters overrides the default behavior)
https://docs.oracle.com/cd/E11882_01/server.112/e40540/startup.htm#CNCPT955
https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#SQLRF00902
You can change the value of many initialization parameters for the current instance, whether you have started the database with a traditional plain-text parameter file (pfile) or with a server parameter file (spfile). Oracle Database Reference indicates these parameters in the “Modifiable” category of each parameter description. If you are using a pfile, then the change will persist only for the duration of the instance. However, if you have started the database with an spfile, then you can change the value of the parameter in the spfile itself, so that the new value will occur in subsequent instances.
correct answer (verified in the exam)
DE
D.
Both the SPFILE and PFILE must always reside on a file system accessible from the database host server.
E.
On startup, by default a database instance always first searches for an SPFILE, and if it does not find any, searches for a PFILE.
D seems not correct please see below :
SPFILE : Only one server parameter file exists for a database. This file must reside on the database host.
PFILE : When starting up or shutting down a database, the text initialization parameter file must reside on the same host as the client application that connects to the database.
https://docs.oracle.com/cd/E11882_01/server.112/e40540/startup.htm#CNCPT89056
I think its A and E.
Loss of PFILE/SPFILE while the database is DOWN
Open alert.log of the database and look for messages related to database startup from the bottom. Oracle lists all the non-default parameters when it first starts the database.
New 1Z0-062 Exam Questions Updated Recently (2/Sep/2017):
NEW QUESTION 317
Identify the access that is initially available to connect to your Database as a Service (DBaaS) environment.
A. Enterprise Manager on port 1158
B. telnet on port 23
C. Cloud Control on port 7799
D. SSH on port 22
E. SSL/TLS on port 443
Answer: D
NEW QUESTION 318
Which statement is true about profiles?
A. Resource limits specified in a profile assigned to a user are always enabled.
B. A user can exist without any profile.
C. A profile can be assigned only to one user.
D. Password management using profiles is always enabled.
Answer: D
NEW QUESTION 319
Which three statements are true about naming methods? (Choose three.)
A. Local naming supports multiple protocols, but for any one connection, the client and server must use the same protocol.
B. In the Easy Connect method, clients can connect to a database server by using the host name of the database with an optional port and service name.
C. In the Easy Connect method, the listener port and IP address must be provided for the connection to be successful.
D. The local naming method does not support connect-time failover and load-balancing options.
E. The directory naming method supports connect-time failover and load-balancing options.
Answer: ABE
NEW QUESTION 320
Which task is performed by a background process in a database instance?
A. Connecting between a client process and a dispatcher
B. Executing PL/SQL code
C. Creating dedicated server connections
D. Copying online redo log files to offline storage
Answer: D
NEW QUESTION 321
Your database instance is started with a PFILE. You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache. You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
Which is the outcome?
A. Change is applied to the current instance, but does not persist after instance restart.
B. The value is changed only in the PFILE and takes effect at the next instance startup.
C. The value is changed for the current instance and in the PFILE.
D. It fails because the SCOPE clause is missing.
Answer: A
NEW QUESTION 322
Which statement is true redo log files during instance recovery?
A. All redo log entries in the current log are applied to data files until the checkpoint position is reached.
B. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint.
C. All current, active, and inactive redo logs are required to complete instance recovery.
D. All current, online, and archived redo logs are required to complete instance recovery.
Answer: B
NEW QUESTION 323
Examine the command:
SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true in this scenario? (Choose two.)
A. All data definition language (DDL) commands ae logged in to the alert log file.
B. All DDL commands are logged in to a text file in Automatic Diagnostic Repository (ADR) home.
C. A subset of executed DDL statements is written into an XML file in ADR home.
D. A subset of executed DDL statements is written to the DDL log in ADR home.
E. All DDL commands are logged in to a trace file in ADR home.
Answer: CD
NEW QUESTION 324
What is the outcome of the SHUTDOWN ABORT command?
A. Pending transactions are committed and the database is closed.
B. Dirty buffers in the buffer cache and unwritten redo are not written to the data files and redo log files respectively.
C. Uncommitted transactions are rolled back.
D. Instance recovery must be requested by the DBA at the next startup.
Answer: B
NEW QUESTION 325
Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?
A. User Global Area
B. Programs Global Area
C. SQL Query Result Cache
D. PL/SQL Function Result Cache
Answer: A
NEW QUESTION 326
Identify three situations in which messages are written to the alert log file. (Choose three.)
A. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50)”
B. Creating a table returns “ORA-00955: name is already in used by an existing object”
C. Inserting a value into a table returns “ORA-01722: invalid number”
D. Updating a record in a table returns “ORA-00060: deadlock detected while waiting for resource”
E. Inserting a value into a table returns “ORA-00001: unique constraint (SYS.PK_XXXX) violated”
F. Running a query on a table returns “ORA-01578: ORACLE data block corrupted (file # 4, block # 131)”
Answer: ADF
NEW QUESTION 327
Which three statements are true about Enterprise Manager Database Express? (Choose three.)
A. It can be used to perform database backup operations.
B. It can use the HTTP protocol.
C. The same port number is used for multiple Database Express configurations on the same host.
D. It can use the HTTPS protocol.
E. It is available only when the database is open.
Answer: BDE
NEW QUESTION 328
When does a database checkpoint occur?
A. When there is an online redo log switch.
B. When a user session terminates abnormally.
C. When a server process terminates abnormally.
D. When the SHUTDOWN ABORT command is issued.
Answer: A
NEW QUESTION 329
What action must you take to ensure complete database recovery till the point of failure?
A. Multiplex the control files.
B. Duplex the RMAN backup sets.
C. Multiplex the online redo log files.
D. Configure the database to run in ARCHIVELOG mode.
Answer: D
NEW QUESTION 330
You want to create a table, DAILY_ORDERS, for an OLTP application, where data should be compressed during both direct path INSERT and conventional DML. The table will also be used for queries. Which compression option should be used?
A. ROW STORE COMPRESS
B. COLUMN STORE COMPRESS FOR QUERY
C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
D. ROW STORE COMPRESS ADVANCED
Answer: D
NEW QUESTION 331
An application repeatedly accesses small lookup tables, causing a lot of physical I/O operations. What do you recommend to minimize this?
A. Configure the nonstandard buffer cache with a buffer size greater than the size of the default buffer cache.
B. Increase the size of the shared pool.
C. Configure the KEEP buffer cache and alter the tables to use the KEEP cache.
D. Configure the RECYCLE buffer cache and alter the tables to use the RECYCLE cache.
Answer: C
NEW QUESTION 332
Examine the command:
SQL> CREATE TABLESPACE test1
DATAFILE ‘/u01/app/oracle/oradata/orc1/test01.dbf’ SIZE 5M AUTOEXTEND ON UNIFORM;
Which statement is true?
A. The data file, TEST01.DBF, can be auto extended to a maximum size of 5M.
B. The tablespace, TEST1, can contain a maximum of one data file.
C. Allocated and free extents are tracked using bitmaps.
D. Segment free space is tracked in the data dictionary.
Answer: C
NEW QUESTION 333
Your database is open in read/write mode and multiple users are connected to the database instance. You execute the following command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
What would be the effect on current sessions?
A. They are not terminated but may only issue queries.
B. They are not affected.
C. They are terminated immediately.
D. They are terminated after completing the transaction.
Answer: B
NEW QUESTION 334
You want to distribute a set of structured data to your customers who can integrate this data into their existing databases irrespective of the platform. Which method provides the fastest way of achieving this?
A. using the DBVERIFY utility
B. using direct-path INSERT SQL statements
C. using SQL*Loader
D. using RMAN transportable tablespace operation
Answer: B
NEW QUESTION 335
You create a locally managed tablespace ORDERS_TBS with automatic segment management. You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command:
CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20;
How does the PCTFREE storage parameter influence data storage for this table?
A. It allows only 80% of space to be occupied in all data blocks of this table.
B. It minimizes row chaining during row insertion.
C. It minimizes row migration during existing row data updation.
D. It automatically coalesces free space of a data block when it reaches 20% of available space.
Answer: A
NEW QUESTION 336
……
P.S. These New 1Z0-062 Exam Questions Were Just Updated From The Real 1Z0-062 Exam, You Can Get The Newest 1Z0-062 Dumps In PDF And VCE From — https://www.passleader.com/1z0-062.html (354q VCE and PDF)
Good Luck!
BTW, part of the new 354Q 1Z0-062 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpZVhqd2dmaHZoZlE
Best Regards!
AE
Not C: alter system changes the parameter value in memory.
https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#i2061284
You can change the value of many initialization parameters for the current instance, whether you have started the database with a traditional plain-text parameter file (pfile) or with a server parameter file (spfile).
BE
Without spfile, You will need pfile to start instance. To create spfile from this point, you will need pfile to begin with.
This question appears on my real Test PeasonVue on Oct 6 2017.
A & E are correct!
This question appears on my real Test PeasonVue on Oct 6 2017.
NEW QUESTION 317
Identify the access that is initially available to connect to your Database as a Service (DBaaS) environment.
A. Enterprise Manager on port 1158
B. telnet on port 23
C. Cloud Control on port 7799
D. SSH on port 22
E. SSL/TLS on port 443
Answer: D