Free Access Oracle.1Z0-082.v2023-08-24.q111 Practice Test (Page 16)

Question 71

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions? (Choose two.)

A.qty_sold BETWEEN '101' AND '110' : uses implicit conversion

B.qty_sold = '0554982' uses implicit conversion

C.invoie_date > '01-02-2019' : uses implicit conversion

D.CONCAT (qty_sold, invoice_date) : requires explicit conversion

E.invoice_date = '15-march-2019' : uses implicit conversion

Question 72

In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

A.Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.

B.Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.

C.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.

D.Add the AUTOEXTEND ON clause with NEXT set to 100M.

E.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

Question 73

You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

A.analysis of all privileges used by all users including administrative users in the database

B.analysis of all privileges used by all users but excluding administrative users in the database

C.analysis of privileges that a user has on their own schema objects that they did not use

D.analysis of privileges that a user has on their own schema objects that they did use

E.analysis of privileges granted directly to a role that are then used by a user who has been granted that role

F.analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

Question 74

Which two can you use to recover a dropped table? (Choose two.)

A.FLASHBACK TRANSACTION

B.FLASHBACK DATABASE

C.FLASHBACK DROP

D.FLASHBACK TABLE TO SCN

E.FLASHBACK QUERY

Question 75

In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

A.Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.

B.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

C.Add the AUTOEXTEND ON clause with NEXT set to 100M.

D.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.

E.Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.

Question 71

Question 72

Question 73

Question 74

Question 75

Download PDF File