-
You execute the following PL/SQL:Which two statements are true?()
A . Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.
B . FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.
C . FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
D . FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
-
Which component does the SQL Tuning Advisor NOT analyze for the SQL statements?()
A . ADDM
B . AWR
C . Cursor Cache
D . SQL Tuning Sets
E . Flash Recovery Area
-
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? ()
A . You cannot roll back this statement.
B . All pending transactions are committed.
C . All views based on the DEPT table are deleted.
D . All indexes based on the DEPT table are dropped.
E . All data in the table is deleted, and the table structure is also deleted.
F . All data in the table is deleted, but the structure of the table is retained.
G . All synonyms based on the DEPT table are deleted.
-
Which two statements regarding a SQL profile are true?()
A . It is built by Automatic Tuning Optimizer.
B . It cannot be stored persistently in the data dictionary.
C . It can be used by the query optimizer automatically.
D . It can be created manually by using the CREATE PROFILE command.
-
Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?()
A . SQL Access Advisor recommendations are automatically implemented.
B . Individual SQL Access Advisor recommendations can be scheduled for implementation.
C . All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
D . SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.
E . None of the above.
-
Which SQL statement returns a numeric value?()
A . SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
B . SELECT ROUND(hire_date) FROM EMP;
C . SELECT sysdate-hire_date FROM EMP;
D . SELECT TO_NUMBER(hire_date + 7) FROM EMP
-
Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?()
A . SQL Access Advisor recommendations are automatically implemented.
B . Individual SQL Access Advisor recommendations can be scheduled for implementation.
C . All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
D . SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.
E . None of the above.
-
Which two statements are true about Shared SQL Area and Private SQL Areas()
A . Shared SQL Area will be allocated in the shared pool.
B . Shared SQL Area will be allocated when a session starts.
C . Shared SQL Area will be allocated in the large pool always.
D . The whole of Private SQL Area will be allocated in the Program Global Area (PGA) always.
E . Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
F . The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.
-
Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? ()
A . It releases the storage space used by the table.
B . It does not release the storage space used by the table.
C . You can roll back the deletion of rows after the statement executes.
D . You can NOT roll back the deletion of rows after the statement executes.
E . An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
F . You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
-
Which three statements are true about adaptive SQL plan management?()
A . It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
B . The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
C . It adds new, bettor plans automatically as fixed plans to the baseline.
D . The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
E . The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
-
Which two statements regarding a SQL profile are true?()
A . It is built by Automatic Tuning Optimizer.
B . It cannot be stored persistently in the data dictionary.
C . It can be used by the query optimizer automatically.
D . It can be created manually by using the CREATE PROFILE command.
-
Which three statements describe how the strict SQL mode provides added security?()
A . It rejects statements that try to insert out-of-range values
B . It rejects invalid dates
C . It limits the operations that the server can perform
D . It rejects queries that produce out-of-range values
E . It rejects dates with zero day or month value
-
Which two statements are true regarding the SQL Repair Advisor?()
A . The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
B . The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
C . The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
D . The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
-
Which four statements correctly describe functions that are available in SQL? ()
A . INSTR returns the numeric position of a named character.
B . NVL2 returns the first non-null expression in the expression list.
C . TRUNCATE rounds the column, expression, or value to n decimal places.
D . DECODE translates an expression after comparing it to each search value.
E . TRIM trims the heading or trailing characters (or both) from a character string.
F . NVL compares two expressions and returns null if they are equal, or the first expression if they are not equal.
G . NULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal.
-
Which two statements are true regarding the SQL Repair Advisor?()
A . The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
B . The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
C . The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
D . The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
-
Which three statements about performance analysis by SQL Performance Analyzer are true? ()
A . It detects changes in SQL execution plans.
B . It produces results that can be used to create the SQL plan baseline.
C . The importance of SQL statements is based on the size of the objects accessed.
D . It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E . It shows only the overall impact on workload and not the net SQL impact on workload.
-
Which three are the valid statements in relation to SQL plan baselines?()
A . The plans can be manually loaded to the SQL plan baseline.
B . The plans in the SQL plan baseline are verified and accepted plans.
C . The plans generated for every SQL statement are stored in the SQL plan baseline by default.
D . The plan baselines are stored temporarily in the memory as long as the database instance is running.
E . For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
-
Which two statements about the SQL Management Base (SMB) are true? ()(Choose two.)
A . It contains only SQL profiles generated by SQL Tuning Advisor.
B . It stores plans generated by the optimizer using a stored outline.
C . It is part of the data dictionary and stored in the SYSAUX tablespace.
D . It is part of the data dictionary and stored in the SYSTEM tablespace.
E . It contains the statement log, the plan history, plan baselines, and SQL profiles.
-
Which two statements are true regarding a PL/SQL package body?()
A . It cannot be created without a package specification.
B . It cannot invoke subprograms defined in other packages.
C . It can contain only the subprograms defined in the package specification.
D . It can be changed and recompiled without making the package specification invalid.
-
Which three are the valid statements in relation to SQL plan baselines?()
A . The plans can be manually loaded to the SQL plan baseline.
B . The plans in the SQL plan baseline are verified and accepted plans.
C . The plans generated for every SQL statement are stored in the SQL plan baseline by default.
D . The plan baselines are stored temporarily in the memory as long as the database instance is running.
E . For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
-
Which two statements about the SQL Management Base (SMB) are true?()
A . It contains only SQL profiles generated by SQL Tuning Advisor.
B . It stores plans generated by the optimizer using a stored outline.
C . It is part of the data dictionary and stored in the SYSAUX tablespace.
D . It is part of the data dictionary and stored in the SYSTEM tablespace.
E . It contains the statement log, the plan history, plan baselines, and SQL profiles.
-
Which two statements describe the behavior of the server's SQL mode?()
A . The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax
B . The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE
C . The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value" command
D . The server's SQL mode, when globally set on a slave server, applies to events sent from the master
-
Which two statements are true about Shared SQL Area and Private SQL Area()
A . Shared SQL Area will be allocated in the shared pool.
B . Shared SQL Area will be allocated when a session starts.
C . Shared SQL Area will be allocated in the large pool always.
D . Private SQL Area will be allocated in the Program Global Area (PGA) always.
E . Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
F . The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.
-
In the following options, which languages can be embossed SQL statements ()
A.Java
B.C
C.PHP
D.Python