Identify two situations in which the alert log file is updated.
Correct Answer: A,E
The alert log is a chronological log of messages and errors, and includes the following items: * All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur * Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements * Messages and errors relating to the functions of shared server and dispatcher processes * Errors occurring during the automatic refresh of a materialized view * The values of all initialization parameters that had nondefault values at the time the database and instance start Note: * The alert log file (also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file is: database startup, shutdown, log switches, space errors, etc. This file should constantly be monitored to detect unexpected messages and corruptions.
1Z1-060 Exam Question 22
In your multitenant container database (CDB) that contains pluggable databases (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: How can you prevent users having the EXECUTEprivilege on the CREATE_TESTprocedure from inserting values into tables on which they do not have any privileges?
Correct Answer: C
Explanation/Reference: Explanation: If a program unit does not need to be executed with the escalated privileges of the definer, you should specify that the program unit executes with the privileges of the caller, also known as the invoker. Invoker's rights can mitigate the risk of SQL injection. Incorrect Answers: A: By default, stored procedures and SQL methods execute with the privileges of their owner, not their current user. Such definer-rights subprograms are bound to the schema in which they reside. not B: Using the GRANT option, a user can grant an Object privilege to another user or to PUBLIC.
1Z1-060 Exam Question 23
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?
Correct Answer: A
Previously(10g and earlier), in the case of Oracle RAC, the CRS took care of the detection and restarts. If you didn't use RAC, then this was not an option for you. However, in this version of Oracle, you do have that ability even if you do not use RAC. The functionality - known as Oracle Restart - is available in Grid Infrastructure. An agent checks the availability of important components such as database, listener, ASM, etc. and brings them up automatically if they are down. The functionality is available out of the box and does not need additional programming beyond basic configuration. The component that checks the availability and restarts the failed components is called HAS (High Availability Service). Here is how you check the availability of HAS itself (from the Grid Infrastructure home): $ crsctl check has CRS-4638: Oracle High Availability Services is online Note: *crsctl config has Use the crsctl check has command to display the automatic startup configuration of the Oracle High Availability Services stack on the server. *The crsctl confighascommand returns output similar to the following: CRS-4622: Oracle High Availability Services autostart is enabled.
1Z1-060 Exam Question 24
Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?
Correct Answer: A,C,D
Explanation/Reference: Explanation: C: During the first execution of a SQL statement, an execution plan is generated as usual. D: if multi-column statistics are not present for the relevant combination of columns, the optimizer can fall back on cardinality feedback. (not B)* Cardinality feedback. This feature, enabled by default in 11.2, is intended to improve plans for repeated executions. optimizer_dynamic_sampling optimizer_features_enable * dynamic sampling or multi-column statistics allow the optimizer to more accurately estimate selectivity of conjunctive predicates. Note: * OPTIMIZER_DYNAMIC_SAMPLING controls the level of dynamic sampling performed by the optimizer. Range of values. 0 to 10 * Cardinality feedback was introduced in Oracle Database 11gR2. The purpose of this feature is to automatically improve plans for queries that are executed repeatedly, for which the optimizer does not estimate cardinalities in the plan properly. The optimizer may misestimate cardinalities for a variety of reasons, such as missing or inaccurate statistics, or complex predicates. Whatever the reason for the misestimate, cardinality feedback may be able to help.
1Z1-060 Exam Question 25
Examine the following command: CREATE TABLE(prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in the PRODUCTS table?
Correct Answer: A,B,C
AB:You can make individual table columns invisible. Any generic access of a table does not show the invisible columns in the table. For example, the following operations do not display invisible columns in the output: *SELECT * FROM statements in SQL *DESCRIBE commands in SQL*Plus *%ROWTYPE attribute declarations in PL/SQL *Describes in Oracle Call Interface (OCI) Incorrect: Not D:You can make invisible columns visible. You can make a column invisible during table creation or when you add a column to a table, and you can later alter the table to make the same column visible. Reference:Understand Invisible Columns
