Oracle 1Z0-050 問題集

質問 1：
You are managing an Oracle Database 11 g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command:
ASMCMD> lsdsk-l -d DATA
Which statement is true regarding the outcome of this command?
A. The command succeeds and retrieves information by scanning the disk headers based on an ASMJDISKSTRING value.
B. The command succeeds but it retrieves only the disk names.
C. The command succeeds but it shows only the status of the ASM instance.
D. The command produces an error because the ASM instance is down.
正解：A

質問 2：
Evaluate the following block of code
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
acl => lmycompany-com-permissions.xmll1
principal => 'ACCTJvlGR1,
is_grant => TRUE,
privilege => 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
acl => 'mycompany-com-permissions.xml',
host => ".mycompany.com');
END;
What is the outcome of the above code?
A. It produces an error because the range of ports associated with the hosts has not been specified.
B. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges
C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
D. It produces an error because a fully qualified host name needs to be specified.
正解：B

質問 3：
You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M
Which two statements are true regarding these parameters after the database instance is restarted? (Choose two.)
A. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
B. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
C. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually.
D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.
正解：B,D

質問 4：
View the Exhibit for the object interdependency diagram.

The PRODUCTS table is used to create the PRODCAT_VW view.
PRODCAT_VW is used in the GET_DATA procedure.
GET_DATA is called in the CHECK_DATA function.
A new column PROD_QTY is added to the PRODUCTS table.
How does this impact the status of the dependent objects?
A. Only the procedure and function become invalid and must be recompiled.
B. Only the procedure and function become invalid and get automatically revalidated the next time they are called.
C. All dependent objects remain valid.
D. Only the view becomes invalid and gets automatically revalidated the next time it is used.
正解：C

質問 5：
View the Exhibit to observe the error.

You receive this error regularly and have to shut down the database instance to overcome the error. What can the solution be to reduce the chance of this error in future, when implemented?
A. locking the SGA in memory
B. setting the PRE_PAGE_SGA parameter to TRUE
C. increasing the value of SGA_MAX_SIZE
D. automatic memory management
正解：D

質問 6：
Observe the following warning in an RMAN session of your database instance:
WARNING: new failures were found since last LIST FAILURE command
Which statement describes the scenario that must have produced this warning?
A. The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed.
B. The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).
C. The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE
D. The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).
正解：C

質問 7：
Which steps are mandatory to enable Direct NFS?
1.Mount all required file systems using the kernel NFS driver.
2.Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.
3.Replace the ODM library libodm11 .so_stub with libodm11 .so.
A. 1, 2 and 3
B. 1 and 2
C. 2 and 3
D. 1 and 3
正解：D

質問 8：
In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file.
You issued the following command:
SQL>SELECT /*+ RESULT_CACHE 7 sale_categoiy, sum(sale_amt)
FROM sales
GROUP BY sale_categoiy;
Where would the result of this query be stored?
A. PGA
B. database buffer cache
C. shared pool
D. large pool
正解：C