A.An SPFILE is a binary file.
B.An SPFILE cannot reside on a client.
C.An SPFILE cannot contain static parameters.
D.An SPFILE can store changes persistently across instance restarts.
E.An SPFILE can be read by the database server, but it is not written to by the server.
F.An SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database.
您可能感兴趣的试卷
你可能感兴趣的试题
View the Exhibit and examine the initialization parameter settings.
Which three initialization parameters are to be set manually as they are not automatically tuned()
A.LOG_BUFFER
B.SORT_AREA_SIZE
C.JAVA_POOL_SIZE
D.STREAMS_POOL_SIZE
E.DB_16K_CACHE_SIZE
F.DB_KEEP_CACHE_SIZE
Your database instance is started using the server parameter file (SPFILE). You executed acommand to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;
What would be the outcome of this command()
A.The command succeeds only if Automatic Memory Management is not enabled.
B.The command succeeds, but you need to restart the database for changes to take effect.
C.The command returns an error because the size of the redo log buffer cannot be changed dynamically.
D.The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).
View the Exhibit.
You are creating an additional database by using the Database Configuration Assistant (DBCA). Youopted to create a General Purpose database and during the database creation realize that the Block Sizefield is not enabled.
What could be the reason for this()
A.You have chosen the File System option as the storage option.
B.You have chosen the Automatic Storage Management (ASM) as the storage option.
C.The data block size can be increased only when DBCA is invoked from Oracle Universal Installer (OUI).
D.You are using General Purpose template and not the Custom Database template to create the database.
View the Exhibit.
What would happen if Oracle Home is not empty()
A.The installation will not be continued until the location is empty.
B.The installation will proceed without overwriting the existing files.
C.The installation can be continued, but the existing files will be overwritten.
D.The installation terminates automatically after showing an error message
You are installing Oracle Database 11g on a machine. When you run the installer, the OracleUniversal Installer (OUI) shows the message that says one of the product-specific prerequisite checkshas failed: Checking available swap space requirements ... Expected result: 1512MB Actual Result: 1018MB
Check complete. The overall result of this check is: Failed <<<< Problem: The system does not have the required swap space.
What happens to the installation in this situation()
A.It can be continued.
B.It resizes the swap space automatically when you proceed further.
C.It can be continued, but the instance cannot be started without increasing the swap space.
D.It shows a message saying one or more prerequisite checks have failed and the installation cannotproceed.
A.Run the root.sh script.
B.Create the oraInst.loc file.
C.Create the tnsnames.ora file.
D.Run the oraintRoot.sh script.
In a new installation of Oracle Database 11g, you perform these activities:
1:Organize software and data on different subdirectories to avoid poor performance.
2:Use consistent naming conventions for database files.
3:Separate administrative information pertaining to the database in different directories.
Which option corresponds to the type of activities you performed()
A.Oracle Managed Files
B.Oracle Grid Architecture
C.Optimal Flexible Architecture
D.Oracle database architecture
E.Automatic Storage Management
You are installing Oracle Database 11g on your server. During the installation Oracle UniversalInstaller (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify anoperating system group name.
Which statement is true in this case()
A.The ORACLE_BASE parameter is not set.
B.The installation is being performed by the root user.
C.The operating system group that will be specified should have root user as its member.
D.The installation is being performed without the "Create Starter Database" option selected.
E.The operating system group that will be specified must have permission to write to the inventorydirectory.
最新试题
Which statements are true about checkpointing()
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database()
Examine the command that is used to create a table:SQL> CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER (6), oamtNUMBER(10,2)) TABLESPACE users;Which two statements are true about the effect of the above command()
Which statements are true regarding a tablespace()
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task()
Which statements regarding the server parameter file (SPFILE) are true()
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN;Which two statements are true()
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, orany data definition language (DDL) command:SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session()
You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE;Which statements describe the effect of the command()
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, youexecuted the following command:SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE------------------------------ ---------------------- Tablespace [TEST] is [28 perce 28.125 nt] fullWhat could be the reason for the elimination of the other rows in the output()