Oracle认证 - 自考题库

出自:Oracle认证

Which statement about using RMAN stored scripts is true?（）
A:To create and execute an RMAN stored script, you must use a recovery catalog.
B:When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.
C:RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
D:When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

What is the result？（）
A:The value "4" is printed at the command line.
B:Compilation fails because of an error in line 5.
C:Compilation fails because of an error in line 9.
D:A NullPointerException occurs at runtime.
E:A NumberFormatException occurs at runtime.
F:An IllegalStateException occurs at runtime.

What is the result？（）
A:Compilation fails.
B:aAaA aAa AAaa AaA
C:AAaa AaA aAa aAaA
D:AaA AAaa aAaA aAa
E:aAa AaA aAaA AAaa

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; For which database users is the audit policy now active?（）
A:All users except SYS
B:All users except SCOTT
C:All users except sys and SCOTT
D:All users except sys, system, and SCOTT

You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）
A: The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
B: Before the instance starts， you receive an error about the missing redo log files of a group.
C: The instance starts and the database opens with an error message written to the alert log file.
D: The instance starts and the database opens because two redo log groups still exist.
E: The instance starts and the database opens， but every attempt to write to redo log files fails with an error.

You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation is the same for both forms. The calculation code does not query or change the data in the database. When the calculation completes, it returns a single value to the non-base table field. To optimize performance and maintainability, which PL/SQL structure should be used? （）
A:A trigger in each form.
B:A subprogram in each form.
C:A stored subprogram in the database.
D:A subprogram in a library that is attached to each form.

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（）
A:The tablespace would require recovery to go back online.
B:A checkpoint is taken on all data files that are associated with the SALES tablespace.
C:The sessions that subsequently try to access the objects in the SALES tablespace receive an error
D:The new status of the SALES tablespace is recorded in the control file when the database instance isclosed

What is the result？（）
A:collie
B:harrier
C:Compilation fails.
D:collie harrier
E:An exception is thrown at runtime.

当需要提交某个事务时，可以使用（）语句。
A:ROLLBACK
B:COMMIT
C:SAVEPOINT
D:SET Transaction

You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）
A:Extents would be managed by the freelists.
B:The segment would be managed by bitmaps.
C:The segment would be managed by the freelists.
D:Free space would be managed by the data dictionary.

You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）
A:Use the Database Resource Manager.
B:Set the limits in the profiles used by users.
C:Modify the SESSIONS initialization parameter.
D:Set the warning threshold for the Current Logons Count metric.

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced?（）
A:Scott can create a synonym for the EMP_DEPT_LOC_VU bus using the command:   CREATE PRIVATE SYNONYM EDL_VU   FOR mary.EMP DEPT_LOC_VU;   then he can prefix the columns with this synonymn.
B:Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command:   CREATE SYNONYM EDL_VU   FOR mary.EMP_DEPT_LOC_VU;   then he can prefix the columns with this synonym.
C:Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command:   CREATE LOCAL SYNONYM EDL_VU   FOR mary.EMP DEPT_LOC_VU;   then he can prefix the columns with this synonym.
D:Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command:   CREATE SYNONYM EDL_VU   ON mary(EMP_DEPT_LOC_VU);   then he can prefix the columns with this synonym.
E:Scott cannot create a synonym because synonyms can be created only for tables.
F:Scott cannot create any synonym for Mary’s view. Mary should create a private ynonym for the view and grant SELECT privilege on that synonym to Scott.

What， inserted at line 39， will sort the keys in the props HashMap？（）
A:Arrays.sort（s）；
B:s = new TreeSet（s）；
C:Collections.sort（s）；
D:s = new SortedSet（s）；

Which four service offerings are included in Oracle Public Cloud?（）
A: Database Service
B: Data Service
C: Java Service
D: Security Service
E: .NET Service
F: SOA Service

Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?（）
A:BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container
B:BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container
C:BACKUP DATABASE while connected to the PDB1 container
D:BACKUP DATABASE while connected to the boot container
E:BACKUP PLUGGABLE database PDB1 while connected to PDB2

Given： 10. class One { 11. void foo（） { } 12. } 13. class Two extends One { 14. //insert method here 15. } Which three methods， inserted individually at line 14， will correctly complete class Two？（）
A: public void foo（） { }
B: private void foo（） { }
C: protected void foo（） { }
D: int foo（） { }
E: void foo（） { }

You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?（）
A:The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
B:The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
C:The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
D:Only the BZIP2 compression algorithm can be used to make compressed backups to disk.

The user SCOTT executes the following command successfully to increase the salary values in one of his sessions： SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20; Before SCOTT ends the transaction， user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values. Why does HR still see the old data？（）
A:because of redo data from redo log file
B:because of data from database buffer cache
C:because of data from a temporary tablespace
D:because of undo data from the undo tablespace

Which of the following are valid until command options when attempting point-in-time recovery in RMAN？（）
A: until time
B: until change
C: until sequence
D: until SCN
E: until commit

Examine the data in the EMPLOYEES table:

Which three subqueries work?（）
A:

The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE; What would you see in the output？（）
A:a list of all the expired backups and copies
B:a list of all those files that have been deleted in the last two days
C:a list of all those files that have been recovered within the last two days
D:a list of backups and copies that are outside the range covered by the current retention policy

While performing monitoring and tuning the database， you want to view the summarized information about the warning level alerts and critical level alerts. Which section of the Oracle Enterprise manager displays the summarized information about the warning and critical level alerts？（）
A:General
B: High Availability
C: Space Usage
D: Diagnostic Summary

Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）
A: open the database with the RESTRICTED option
B: open the database with the RESETLOGS option
C: recover to the required SCN only that data file in which the error occurred
D: recover all the data files to the same system change number （SCN）

You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set thePGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?（）
A:The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
B:The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
C:The database instance starts, but Automatic Memory Management is disabled
D:The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

Which view should a user query to display the columns associated with the constraints on a table owned by the user? （）
A:USER_CONSTRAINTS
B:USER_OBJECTS
C:ALL_CONSTRAINTS
D:USER_CONS_COLUMNS
E:USER_COLUMNS

What is the output of this command?（）
A:A list of files that require a backup within 3 days
B:A list of files requiring more than 3 days of archivelogs to apply
C:A list of files that RMAN recommends be backed up only once in every three days, based on low volatility
D:A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）
A: redo logs
B: control file
C: temporary files of temporary tablespace
D: the latest backup of only the damaged data file
E: the latest backup of all the data files In the USERS tablespace

Which two statements are true about alerts（）
A:Clearing an alert sends the alert to the alert history.
B:Response actions cannot be specified with server-generated alerts.
C:The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view.
D:Server-generated alerts notify the problems that cannot be resolved automatically and requireadministrators to be notified.

Which of the following parameters defines the location where Oracle should create archived redo logs?（）
A:LOG_ARCHIVE_1
B:LOG_DESTINATION_1
C:LOG_ARCHIVED_DESTINATION_1
D:LOG_ARCHIVE_DEST_1
E:LOG_ARCHIVE_SOURCE_1

Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure？（）
A: only encryption and compression settings for all SecureFile LOBs
B: only encryption and deduplication settings for only SecureFile CLOBs
C: deduplication，encryption，and compression settings for all SecureFile LOBs
D: deduplication，encryption，and compression settings only for SecureFile CLOBs

首页 <上一页 124 125 126 127 128 下一页> 尾页