Which is true about the Automatic Diagnostic Repository (ADR) ? A) It is used only if the DIAGNOSTIC_DEST parameter is manually configured. B) It only contains the alert log and trace files for backgr...
Which is true about the Automatic Diagnostic Repository (ADR) ? A) It is used only if the DIAGNOSTIC_DEST parameter is manually configured. B) It only contains the alert log and trace files for backgr...
Which two are true about external tables? A)They can be stored in an ASM Cluster File System(ACFS). B)They can always be updated using SQL. C)They support the ORACLE_DATAPUMP access driver. ...
Examine these attributes for the profile assigned to USER1 whose password is oracle_4U • PASSWORD_REUSE_MAX is 5 • PASSWORD_REUSE_TIME is 10 • PASSWORD_GRACE_TIME is 15 Which two are true?...
Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSTEM tablespace. B)By default, AWR snapshots are taken every 60 minutes. C)It is the foundation for th...
Which two are true about Optimizer Statistics? A)They are gathered by the Manageability Monitor(MMON) background process. B)They can be gathered by executing the PL/SQL procedures in the DBMS_STATES p...
You want to access employee details contained in flat files created by an application. Which two methods will achieve this? A)Use a BFILE column in a table to access the flat file. ...
Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSAUX tablespace. B)Automatic AWR snapshots are created by the Manageability Monitor (MMON) background ...
Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSTEM tablespace. B)By default, AWR snapshots are taken every 60 minutes. C)It is the foundation for th...
Which four statements are true about truncating a table? A)Any insert triggers for the table will be executed. B)Any of the table’s indexes are also truncated. C)Any delete triggers for the ta....
Which three are true about Optimizer Statistics? A)They can be gathered manually B)They are automatically updated by DML statements C)They contain the execution plan for each executed SQL statement. ...
Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? A)It improves database performance b...
Examine this command: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, cl...
You successfully executed these commands: connect scott/tiger@prod1; CREATE DATABASE LINK db_prod2 CONNECT TO s...
Examine this session output: SQL> connect scott/tiger Connected. SQL>select name,value 2 from v$paramete...
Which four are true about auditing? A)DML statements can be audited when they fail to execute B)Select statement...
Which three are true about auditing? A)Auditing is active only when the database is OPEN. B)Audit records are al...
You want to audit update statements that refer to USER1.DEPT.DNAME. Which type of auditing must you use? A)stand...
Which two statements are true regarding the Oracle Data Pump export and import operations? (choose two) ...
Where is an expdp operation tracked? A)dump files B)control file C)log files D)Automatic Dia...
Which two can be exported by a non-administrative account by using Data Pump? A)directory objects B)ta...
Which state must a database be to enable ARCHIVELOG ? A)NOMOUNT B)OPEN IN READ WRITE mode C)OPEN ...
which four are true about the tools used to administer Oracle database? A)the Data Pump utility can be used...
64、(22-7) choose the best answer: View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS tables. Evaluate the following SQL sta...
Which two are true about the Inventory directory? A)It is shared by all Oracle software installations on a ...
34.choose two View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables. You have a requirement from the suppl...
65、(22-16) choose the best answer: The CUSTOMERS table has the following structure: You need to write a query that does the following tasks: 1...
57、(14-17) choose two: Examine the structure of the DEPARTMENTS table You execute the following command: SQL> ALTER TABLE departments SET ...
63、(22-4) choose the best answer: View the Exhibit and examine the data in the PRODUCTS table. Which statement would add a column called PRICE, w...