View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instanceis already running. You used the following steps to start the database instance and open the database:
Which file is used to start the instance in this case()
A.init.ora
B.spfile.ora
C.initorcl.ora
D.spfile+ASM.ora
您可能感兴趣的试卷
你可能感兴趣的试题
After performing a clean shut down of the database instance for maintenance, you mount thedatabase and then execute a command to open the database: SQL> ALTER DATABASE OPEN;
Which two statements are true()
A.The online redo log files and online data files are opened.
B.All the online data file headers are checked for consistency.
C.Instance recovery is performed before opening the database.
D.The path and existence of all the log file members are checked
A.renaming the control files
B.re-creating the control files
C.dropping a user in your database
D.dropping a tablespace in your database
E.configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
View the Exhibit and examine the output of the query.
What do you infer from this()
A.The SGA_TARGET is a static parameter.
B.The instance is started, but the database is not yet open.
C.The server parameter file (SPFILE) was used to start the instance.
D.The SGA_TARGET parameter does not have any effect onthe databaseinstance untiltheSGA_MAX_SIZE parameter is specified.
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.
最新试题
All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions:SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’; 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’;3 rows deleted.The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands()
Which statements regarding the server parameter file (SPFILE) are true()
The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable:ERROR at line 1:ORA-00060: deadlock detected while waiting for resource On investigation, you find that a session opened byuser JIM has a transaction that caused the deadlock. Which two statements are true regarding the session ofSCOTT in this scenario()
Which statements are true regarding a tablespace()
Which statement is true about loading data using the conventional path of SQL*Loader()
Which statements are true regarding the Oracle Data Pump export and import operations()
You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this()
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()
You configured the Flash Recovery Area (FRA) for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy()
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace.Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()