出自:Oracle认证

Your database is configured in shared server mode. However， your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users.  What could be the reason for this（）
A:To limit the User Global Area （UGA） memory allocated to a session from the SGA
B:To limit the amount of memory to be used for the dispatcher queue of a session in SGA
C:To limit the amount of memory to be used for the request pool in System Global Area （SGA）
D:To control the amount of memory allocated in SGA for the local variables for each shared server process
ORACLE初始化参数文件的默认路径是:（）
A:对于UNIX，在$ORACLE_HOME/dbs
B:对于UNIX，在$ORACLE_HOME/dbs/admin
C:对于Linux，在%ORACLE_HOME%/database
D:对于Windows，在%ORACLE_HOME%/dbs
E:对于Windows，在%ORACLE_HOME%/database/admin
Given. Which two statements are true？（）
A:Foo.beta（） is a valid invocation of beta（）.
B:Foo.alpha（） is a valid invocation of alpha（）.
C:Method beta（） can directly call method alpha（）.
D:Method alpha（） can directly call method beta（）.
The users request that [F2], [F3], and [F4] be used to commit, rollback, and exit,respectively. How do you accomplish this?（）
A:Add the appropriate PL/SQL code for each key. 
B:Map the logical keys to the physical keys, then add the appropriate PL/SQL code for each key.
C:Create an object library to define the key triggers, then reference the object library in the form. 
D:This cannot be accomplished because other function keys provide this functionality by default.
You can back up the RMAN recovery catalog with RMAN.（）
A: True
B: False
Click the Exhibit button. Given the fully-qualified class names: com.foo.bar.Dog com.foo.bar.blatz.Book com.bar.Car com.bar.blatz.Sun Which graph represents the correct directory structure for a JAR file from which those classes can be used by the compiler and JVM?（）
A:Jar A
B:Jar B
C:Jar C
D:Jar D
E:Jar E
Which three tasks can be automatically performed by the Automatic Data Optimization feature ofInformation lifecycle Management (ILM)?（）
A:Tracking the most recent read time for a table segment in a user tablespace
B:Tracking the most recent write time for a table segment in a user tablespace
C:Tracking insert time by row for table rows
D:Tracking the most recent write time for a table block
E:Tracking the most recent read time for a table segment in the SYSAUX tablespace
F:Tracking the most recent write time for a table segment in the SYSAUX tablespace
A customer needs to ensure that the number of threads servicing an application does not exceed the number of database connections available to the application. What step must you take to address this situation?（）
A:Configure a Max Threads Constraint and add your application to the list of applications for the  Constraint.
B:Configure a Work Manager with a Maximum Threads Constraint tied to the Connection Pool and  configuration your application to use the Work Manager.
C:Configure a Work Manager with a Minimum Threads Constraint tied to the Connection Pool and  configure your application to use the Work Manager.
D:Configure a global MaxThreads constraint and target it to the server or clusters where your  application is deployed.
E:Configure the startup parameter "-Dwls-maxThreads" to be the same as the number of  database connections configured.
A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）
A: clear the redo log group
B: perform redo log file import
C: perform an incomplete recovery
D: perform a redo log recovery using Recovery Manager （RMAN）
E: shut down the database and open the database in the NOARCHIVELOG mode
While setting up the threshold for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）
A: It would result in an error because the warning threshold cannot be more than the critical threshold.
B: The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
C: The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
D: Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
You are attempting to secure a MySQL server by using SSL encryption. On starting MySQL, you get this error: 130123 10:38:02 [ERROR] mysqld: unknown option '—ssl' What is the cause of the error?（）
A:The — ssl level was not specified
B:The server was not started with the – enable–ssl-plugin option
C:— ssl is not a valid server option
D:The mysqld binary was not compiled with SSL support
E:The server's SSL certificate was invalid
RMAN provides more granular catalog security through which feature？（）
A: Virtual private database
B: Virtual private catalog
C: RMAN virtual database
D: RMAN secure catalog
E: Oracle Database Vault
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）
A:Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
B:Increase the database buffer cache size.
C:Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
D:Configure Automata Shared Memory Management.
E:Configure Automatic Memory Management
While tuning a SQL statement， the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation？（）  
A: It updates the existing SQL profiles with current statistics
B: It makes the statistics information available to GATHER_STATS_JOB
C: It initiates the statistics collection process by running GATHER_STATS_JOB
D: It logs a warning message in the alert log so that the DBA can perform statistics collection manually
Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）
A:RESTORE DATAFILE ’/DISK2/user_data01.dbf’
B:RESTORE DATAFILE ’/DISK3/user_data01.dbf’
C:SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’
D:SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’
Given： If the user types the password aiko when prompted， what is the result？（）
A:password：got
B:password：got aiko
C:password：aikogot aiko
D:An exception is thrown at runtime.
E:Compilation fails due to an error on line 8.
You are a Database Administrator with TXGlobal. You use a password file to establish remote connections to the HR database on the server located at the home office. Currently， two active remote sessions exist to this database. These sessions were established using the SYSDBA privilege from the remote machines. You accidentally deleted the password file. What will be the consequence of this action？（）
A: Both the sessions will be killed， and no new sessions will be created using the SYSDBA or SYSOPER privilege.
B: Both the sessions will remain active， but no new sessions will be created using the SYSDBA or SYSOPER privilege.
C:Both the sessions will be killed， but new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.
D: The database will crash， and no new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.
What does the SCN represent？（）  
A: The system change number， which is a point in time relative to transactions within a given database.
B: A number that represents time. Thus， at 1300 hours， the SCN is the same on all databases. 
C: The security change number， which represents the security code that is needed to access any database structure.
D: A conversion factor that converts internal database time to external clock time.
E: UTC time in the database，providing a standardized way of tracking time in Oracle.
Evaluate the following command and its output：   SQL>SELECT * FROM dba_temp_free_space；  TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE  LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）
A: FREE_SPACE indicates only the space that is currently unallocated.
B: ALLOCATED_SPACE indicates only the space currently allocated and in use.
C: FREE_SPACE indicates only the space that is currently allocated and available for reuse.
D: ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.
E: FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.
What elements of globalization can be explicitly defined using the NLS_LANG environment variable?（）
A:NLS_LANGUAGE
B:NLS_SORT
C:NLS_CALENDAR
D:NLS_CHARACTERSET
E:NLS_TERRITORY
Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）
A:The destination must be global only.
B:A maximum of five destinations can be assigned.
C:A maximum of ten different destinations can be assigned.
D:All the destinations are determined by the server automatically.
E:The destination may be local or remote for a Standby Database.
F:The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.
Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?（）
A:Implement RMAN multiplexing
B:Set the DEBUG ON in the RMAN script
C:Specify the command ID in the RMAN script
D:Use a tag with the RMAN BACKUP command
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）
A:You must shut down the database instance to perform the backups.
B:You must configure the Flash Recovery Area （FRA） for the database.
C:You can perform complete database backups without closing the database.
D:All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
What is the functionality of the "Allow modifications of customized objects" check box in the OracleWorkflow Builder dialog box that is displayed from the Help menu? （）(Choose two.)
A:Having check box selected is equivalent to Workflow Definitions Loader Upgrade mode.
B:Having check box deselected is equivalent to Workflow Definitions Loader Upload mode.
C:If the check box is not selected, you can save your edits only to protected objects that you have access to change, and cannot overwrite previously customized objects
D:If the check box is selected, you overwrite any protected objects that you have the ability (access) to modify, and also any previously customized objects.
While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
A: A primary key must have been created.
B: A mapping table must have been created.
C: An overflow tablespace must have been specified.
D: The PCTTHRESHOLD option must have been specified.
Given： What is the result？（）
A:end
B:Compilation fails
C:exception end
D:exception test end
E:A Throwable is thrown by main
Given： Which statement is true？（）
A:The equals method does NOT properly override the Object.equals method.
B:Compilation fails because the private attribute p.name cannot be accessed in line 5.
C:To work correctly with hash-based data structures,this class must also implement the hashCode method.
D:When adding Person objects to a java.util.Set collection,the equals method in line 4 will prevent duplicates.
Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?（）
A:No change is required to achieve the desired results.
B:SELECT ename, sal, 12*(sal+100) FROM emp;
C:SELECT ename, sal, (12*sal)+100 FROM emp;
D:SELECT ename, sal+100,*12 FROM emp;
View the Exhibit. Which statements are true regarding the USERS tablespace（）
A:A bitmap is used to record free extents.
B:Free extents information is managed within the tablespace.
C:Free extents information is managed in the SYSAUX tablespace.
D:The data dictionary tables are updated when extents are allocated or deallocated
A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）
A:Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. 
B:Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. 
C:Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
D:Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode. 
首页 <上一页 73 74 75 76 77 下一页> 尾页