Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"? （）

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.

A . ADDM B . AWR C . Cursor Cache D . SQL Tuning Sets E . Flash Recovery Area

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.

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.

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.

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

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.

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.

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

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.

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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.

A．Java B．C C．PHP D．Python