Instant Access Oracle.1Z1-082.v2022-11-09.q121 Actual Practice Test Engine for Free (Page 20)

40%off

1Z1-082 Premium Dumps

Latest 1Z1-082 Exam Premium Dumps provide by TrainingQuiz.com to help you Passing 1Z1-082 Exam! TrainingQuiz.com offers the updated 1Z1-082 exam dumps, the TrainingQuiz.com 1Z1-082 exam questions has been updated to correct Answer. Get the latest TrainingQuiz.com 1Z1-082 pdf dumps with Exam Engine here:

(165 Q&As Dumps, 40%OFF Special Discount: DumpsDB)

Question 91

Which two statements are true about views used for viewing tablespace and datafile information?
(Choose two.)

A.V$TABLESPACE displays information that is contained in the controlfile about tablespaces
B.V$TABLESPACE displays information about tablespaces contained in the data dictionary
C.Tablespace free space can be viewed in DBA_TABLESPACES
D.Tablespace free space can be viewed in V$TABLESPACE
E.A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened

Question 92

Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

A.the maximum number of sessions permitted for a user before the account is locked
B.the number of days for which an account is locked after the configured number of login attempts has been reached
C.the number of hours for which an account is locked after the configured number of login attempts has been reached
D.the number of password changes required within a period of time before a password can be reused
E.the ability to prevent a password from ever being reused
F.the maximum amount of CPU time allowed for a user's sessions before their account is locked
G.the number of days for which an account may be inactive before it is locked

Question 93

The sales table has columns prod_id and quantity_sold of data type number In two queries execute successfully? x

A.SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(-) > 10;
B.SELECT prod_id FROM sales WHERE quantity_sold > 5S000 AND COUNT(-) > 10 GROUP BY prod_id HAVING COUNT(-) > 10;
C.SELECT prod_id FROM sales WHERE quantity_scld > 55000 AND COUNT(-) > 10 GROUP BY COUNT(-) > 10;
D.SELECT COUNTlprod_id> FROM sales GROUP BY prod_id WHERE quantity_Sold > 55000;
E.SELECT COUNT|prod_id> FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;

Question 94

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

A.The same port number can be used for multiple Database Express configurations for multiple databases on the same host
B.The same port number can be used for Database Express configurations for databases on different hosts
C.It can be used to perform database recovery
D.It is available only when the database is open
E.It can be used to switch a database into ARCHIVELOGMODE

Question 95

You need to calculate the number of days from 1st January 2019 until today.
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)

A.SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;
B.SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;
C.SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;
D.SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;
E.SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;