Which two events always request the LGWR to write? A)When DBWn writes dirty buffers. B)When a log swit...
Which two events always request the LGWR to write? A)When DBWn writes dirty buffers. B)When a log swit...
Which four are true about the Automatic Workload Repository (AWR)? A)AWR data can be retained for a month. ...
Which three are true about AWR snapshots? A)They are always created automatically. B)They are always c...
Which two are true about AWR snapshots? A)They are stored in the SYSAUX tablespace. B)They are always ...
Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSTEM tabl...
Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSTEM tabl...
Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSAUX tabl...
Which two are true about Optimizer Statistics? A)They are gathered by the Manageability Monitor(MMON) backg...
Which two are true about Oracle's Optimizer statistics? A)They are automatically updated when ddl statement...
Which three are true about Optimizer Statistics? A)They can be gathered manually B)They are automatica...
Which two are true about PL/SQL objects? A)They must be in an invalid state to be recompiled. B)...
Which is true about invalid PL/SQL objects? A)They are automatically recompiled against the new definit...
Examine these attributes for the profile assigned to USER1 whose password is oracle_4U • PASSWORD_REU...
Examine these attributes for the profile assigned to USER1 whose password is oracle_4U. • PASSWORD_REUS...
Which four statements are true about truncating a table? A)Any insert triggers for the table will be ex...
78、View the exhibit and examine the structure of the CUSTOMERStable. Which two tasks would require subqueries or joins to be executed in a singl...
80、View the exhibit and examine the structure in ORDERS and ORDER_ITEMS tables. You need to create a view that displays the ORDER_ID, ORDER_DATE...
79、Which statement is true about transactions? A. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPO...
48、(10-12)choose the best answer View the Exhibit and examine the description for the PRODUCTS and SALES table. PROD_ID is a primary key in the...
71、(32-18) choose three Which three statements indicate the end of a transaction? (Choose three.) A) after a CREATE statement is issued B) after...
73、Which statement correctly grants a system privilege? A. GRANT CREATE VIEW ON table1 TO user1; B. GRANT ALTER TABLE TO PUBLIC; C. GRANT CRE...
72、View the exhibit for the structure of the STUDENTand FACULTYtables. STUDENT Name Null? Type ------------------ ------------------- -------...
70、(31-2)choose the best answer: View the Exhibit and examine the structure of the Book table. The BOOKS table contains details of 100 books. Ex...
69、(31-1)choose the best answer: Evaluate the following query: SELECT INTERVAL '300' MONTH, INTERVAL '54-2' YEAR TO MONTH, INTERVAL '11:12:10.1...
76、View the exhibit and examine the description of the DEPARTMENTSand EMPLOYEEStables. The retrieve data for all the employees for their EMPLOYE...
75、Which statements are correct regarding indexes? (Choose all that apply.) A. A non-deferrable PRIMARY KEYor UNIQUE KEYconstraint in a table auto...
77、Which two statements are true about sequences created in a single instance database? (Choose two.) A. When the MAXVALUElimit for the sequence i...
14、(6-13) choose the best answer: View the Exhibit and examine the structure of the ORDERS table. Which UPDATE statement is valid? A) UPDATE order...
26.choose two Examine the structure of the PRODUCTS table. Which two statements are true? A) EXPIRY_DATE always stores date and time in characte...
20.choose two Examine the description of the EMP_DETAILS table given below: Which two statements are true regarding SQL statements that can be ex...