Online Access Free Oracle.1Z0-060.v2022-02-05.q119 Practice Test (Page 25)

1Z0-060 Exam Question 116

Which statement is true concerning dropping a pluggable database (PDB)?

A.The PDB must be unplugged.

B.A dropped PDB can never be plugged back into a multitenant container database (CDB).

C.The PDB data files are always removed from disk.

D.The PDB must be open in read-only mode.

E.The PDB must be in mount state.

1Z0-060 Exam Question 117

Examine these two statements: Which three are true about the MRKT tablespace?

A.The MRKT tablespace may be dropped if it has no contents.

B.Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

C.The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

D.The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.

E.No more data files can be added to the tablespace.

1Z0-060 Exam Question 118

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index.
Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.
This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.
You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.
Which three methods could transparently help to achieve this result?

A.Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

B.Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.

C.Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

D.Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.

E.Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.

F.Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.

1Z0-060 Exam Question 119

Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)?

A.System privileges apply only to the PDB in which they are used.

B.Local users cannot use local system privileges on the schema of a common user.

C.The granter of system privileges must possess the set container privilege.

D.Common users connected to a PDB can exercise privileges across other PDBs.

E.System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

Other Version: 108Oracle.Braindumpsit.1Z0-060.v2022-05-19.by.brian.119q.pdf; 114Oracle.Itpass4sure.1Z0-060.v2021-09-12.by.haley.189q.pdf; 2521Oracle.1Z0-060.v2021-08-28.q107

Latest Upload: 164ACSM.020-222.v2025-09-11.q48; 156VMware.5V0-31.23.v2025-09-10.q73; 130Oracle.1z0-915-1.v2025-09-10.q24; 159Citrix.1Y0-231.v2025-09-10.q87; 134SAP.C-THR85-2505.v2025-09-09.q29; 164Adobe.AD0-E727.v2025-09-09.q76; 129Oracle.1Z0-1123-25.v2025-09-09.q20; 134SAP.C_SIGPM_2403.v2025-09-08.q20; 251EXIN.ITIL.v2025-09-08.q161; 169BCS.PC-BA-FBA-20.v2025-09-08.q45

1Z0-060 Exam Question 116

1Z0-060 Exam Question 117

1Z0-060 Exam Question 118

1Z0-060 Exam Question 119

Download PDF File