出自:Oracle认证

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2’ How should the DB_FLASH_CACHE_SIZE be configured to use both devices?（）
A:Set DB_FLASH_CACHE_SIZE=64G
B:Set D3_FLASH_CACHE_SIZE=64G, 64G
C:Set D3_FLASK_CACKE_SI2E=128G
D:db_flash_cache_SI2E is automatically configured by the instance at startup
Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）
A:V$LOG
B:V$LOFHIST
C:V$LOGFILE
D:V$LOG_HISTORY
You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1. Which two statements are true in this scenario for the features enabled for ASM? （）
A:The ASM-preferred mirror read feature is enabled.
B:The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.
C:The ASM disk is dropped immediately from a disk group when it becomes unavailable.
D:The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.
在下列各选项中，关于序列的描述哪一项是不正确的？（）
A:序列是Oracle提供的用于产生一系列唯一数字的数据库对象
B:序列并不占用实际的存储空间
C:使用序列时，需要用到序列的两个伪列NEXTVAL与CURRVAL。其中，NEXTVAL将返回序列生成的下一个值，而CURRVAL返回序列的当前值
D:在任何时候都可以使用序列的伪列CURRVAL，以返回当前序列值
You notice that the performance of the database has degraded because of frequent checkpoints.  Which twoactions resolve the issue（）
A:Disable automatic checkpoint tuning.
B:Check the size of the redo log file size and increase the size if it is small.
C:Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
D:Decrease the number of redo log members if there are more than one redo log members available in eachredo log group.
Given: Which two can be results?（）
A:java.lang.RuntimeException: Problem
B:run.java.lang.RuntimeException: Problem
C:End of method.java.lang.RuntimeException: Problem
D:End of method.run.java.lang.RuntimeException: Problem
E:run.java.lang.RuntimeException: Problem End of method.
When starting up your ASM instance, you receive the following error: What is the cause of the error?（）
A:The ASM_DISKGROUPS parameter is configured for three disk groups: DGROUP1, DGROUP2, and DGROUP3. The underlying disks for these disk groups have apparently been lost.
B:The format of the ASM_DISKGROUPS parameter is incorrect. It should reference the disk group numbers, not the names of the disk groups
C:The ASM_POWER_LIMIT parameter is incorrectly set to 1. It should be set to the number of disk groups being attached to the ASM instance.
D:The ASM_DISKSTRING parameter is not set; therefore disk discovery is not possible. 
E:There is insufficient information to solve this problem.
In which case would you use a FULL OUTER JOIN? （）
A:Both tables have NULL values.
B:You want all unmatched data from one table.
C:You want all matched data from both tables.
D:You want all unmatched data from both tables.
E:One of the tables has more data than the other.
F:You want all matched and unmatched data from only one table.
Which two statements are true with respect to the maintenance window？（） .
A: A DBA can enable or disable an individual task in all maintenance windows.
B: A DBA cannot change the duration of the maintenance window after it is created.
C: In case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.
D: A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window
You work as a database administrator for Supportcenter.cn. While setting up the database for your production environment， you want to create a user according to the requirements in the exhibit. Which three options of the CREATE USER command would you use to achieve this objective？（）
A:Profile
B:Account lock
C:Account unlock
D:Password expire
E:Quota 10MB on SupportCenter TBS1
F:Password never expire
G:Defaulttablespace SupportCenter TBS1
H:Quota unlimited on SupportCenter TBS1
I:TemporarytablespaceTEMP
J:TemporarytablespaceSYSTEM
You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?（）
A:Set metric threshold
B:Implement Database Resource Manager
C:Enable resumable timeout for user sessions
D:Add directives to Automatic Database Diagnostic Monitor (ADDM)
Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?（）
A:SELECT SUBSTR( ‘Hello World’,1) FROM dual;
B:SELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;
C:SELECT LOWER(SUBSTR(‘Hello World’, 1, 1) FROM dual;
D:SELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;
E:SELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;
You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test database named TESTDB. The test database is primarily used for testing database commands and configuration settings befor implementing these settings on the production database. The test database is also used for the development of database applications. You have been asked by the senior DBA to grant the SYSDBA privilege to a new team member， John， so that he can perform some administrative tasks， such as shutdown and startup operations， on TESTDB. You use the password file to configure remote authentication on the TESTDB database. You execute the following statement to grant the SYSDBA privilege to John：   SQL>GRANT SYSDBA TO john；   However， you receive the following error：   ORA-01996： GRANT failed： password file   ’c：/oracle/ora9i/dbs/testdb.pwd’ is full   Which action should you take to add the user john to the password file without removing any of the existing users？（）
A: Create another password file and then re-execute the GRANT statement.
B: Re-create the password file， specifying a larger number of allowed entries， and then re-execute the GRANT statement.
C: Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in theinitialization parameter file to NONE and then re-execute the GRANT statement.
D: Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in the initialization parameter file to SHARED and then re-execute the GRANT statement.
Given： Which two methods， inserted individually， correctly complete the Three class？（）
A:public void foo（） {}
B:public int foo（） { return 3； }
C:public Two foo（） { return this； }
D:public One foo（） { return this； }
E:public Object foo（） { return this； }
Which three SELECT statements display 2000 in the format "$2,000.00"? （）
A:SELECT TO_CHAR(2000, '$#,###.##') FROM dual;
B:SELECT TO_CHAR(2000, '$0,000.00') FROM dual;
C:SELECT TO_CHAR(2000, '$9,999.00') FROM dual;
D:SELECT TO_CHAR(2000, '$9,999.99') FROM dual;
E:SELECT TO_CHAR(2000, '$2,000.00') FROM dual;
F:SELECT TO_CHAR(2000, '$N,NNN.NN') FROM dual;
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true?（）
A:The C # # ROLE1 role is created in the root database and all the PDBs.
B:The C # # ROLE1 role is created only in the root database because the container clause is not used.
C:Privileges are granted to the C##A_ADMIN user only in the root database.
D:Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
E:The statement for granting a role to a user fails because the CONTAINER clause is not used.
Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package?（）
A:It can be used to allow the access privilege settings for users but not roles.
B:It can be used to allow the access privilege settings for users as well as roles.
C:It can be used to control the time interval for which the access privilege is available to a user.
D:It can be used to selectively restrict the access for each user in a database to different host computers.
E:It can be used to selectively restrict a user's access to different applications in a specific host computer.
You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）
A:All control files are opened
B:All redo files are opened
C:The password file is opened
D:The parameter file is opened
E:All online data files are opened
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30am. Which option must you use to check whether a flashback operation can recover the database to the specified time?（）
A:Check the alert log file
B:Query the V$FLASHBACK_DATABASE_LOG view
C:Query the V$RECOVERY_FILE_DEST_SIZE view
D:Query the V$FLASHBACK_DATABASE_STAT view
E:Check the value assigned for the UNDO_RETENTION parameter
What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）
A:It fails with the ORA-665610 Invalid DDL statement on history-tracked message
B:The rows in the table are truncated without being archived.
C:The rows in the table are archived, and then truncated.
D:The rows in both the table and the archive are truncated.
What is true about sequences?（）
A:Once created, a sequence belongs to a specific schema.
B:Once created, a sequence is linked to a specific table.
C:Once created, a sequence is automatically available to all users.
D:Only the DBA can control which sequence is used by a certain table.
E:Once created, a sequence is automatically used in all INSERT and UPDATE statements.
Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）
A:CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
B:CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
C:CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
D:CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
View the Exhibit to examine the output for the CROSSCHECK BACKUP command.  Which statement is true about the output of the command（）
A:The backup piece is expired as the new backup is available.
B:The backup piece is expired because the operating-system file was not found.
C:The backup piece is expired because the retention period for the backup has expired.
D:The backup piece is expired because the backup set to which it belongs is not complete.
Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"? （）
A:SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;
B:SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;
C:SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;
D:SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;
E:SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;
An RMAN backup job fails， displaying the following error：  ORA/x7f19809： limit exceeded for recovery files  Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in future？（）
A:take the backup of the flash recovery area less frequently
B:increase the value of the UNDO_RETENTION initialization parameter
C:change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTO
D:change the backup retention policy to retain the backups for a smaller period of time 
E:increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter
F:increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter
Given： Which two， independently， will allow Sub to compile？（）
A:Change line 2 to：public int a；
B:Change line 2 to：protected int a；
C:Change line 13 to：public Sub（） { this（5）； }
D:Change line 13 to：public Sub（） { super（5）； }
You executed the following commands: Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?（）
A:The statistics are stored in the pending statistics table in the data dictionary.
B:The statistics are treated as the current statistics by the optimizer for all sessions.
C:The statistics are treated as the current statistics by the optimizer for the current sessions only.
D:The statistics are temporary and used by the optimizer for all sessions until this session terminates.
You need to recover five data files that are spread across multiple disks. Which initialization parameter should you set to speed up redo application？（）
A:RECOVERY_PARALLELISM
B:FAST_START_MTTR_TARGET
C:LOG_CHECKPOINT_INTERVAL
D:FAST_START_PARALLEL_ROLLBACK
our database instance is started using the server parameter file （SPFILE）. You executed a command tochange 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 theSystem Global Area （SGA）
想在另一个模式中创建表，用户最少应该具有什么系统权限？（）
A:CREATE TABLE
B:CREATE ANY TABLE
C:RESOURCE
D:DBA
首页 <上一页 38 39 40 41 42 下一页> 尾页