Oracle 1z0-074 問題集

質問 1：
In a Database Cloud Service (DBCS) environment, which pre-created user has sudo privileges to run certain root commands?
A. grid
B. oinstall
C. nobody
D. oracle
E. opc
正解：E

質問 2：
A CDB, CDB1, has a LOCATIONS application container.
NORTH_PDB and SOUTH_PDB are two application PDBs in LOCATIONS.
Both application PDBs are synchronized with the application installed in the LOCATIONS root...
In CDB2, you create a remote clone, LOC_R, of the LOCATIONS application root.
You want to query data across the LOCATIONS application PDBs created in CDB1 and CDB2.
How can you do this?
A. by creating a proxy PDB in CDB2 root, referencing LOC_R
B. by creating a proxy PDB in CDB1 root, referencing LOC_R
C. by using private database links created in CDB1 and CDB2
D. by creating a proxy PDB in LOCATIONS_ROOT in CDB1, referencing LOC_R
E. by using public database links created in CDB1 and CDB2
正解：A

質問 3：
To which two components does the term "shape" refer in Oracle Database Cloud Service (DBaaS)? (Choose two.)
A. number of database instances
B. number of storage LUNs
C. amount of RAM
D. number of network interface cards (NICs)
E. number of CPUs
正解：C,E

質問 4：
Which two statements are true about FLEX ASM? (Choose two.)
A. Database instances that depend on an ASM instance that is terminated fail over to a node that has a surviving ASM instance.
B. A separate ASM network is required.
C. It is impossible to connect to a database instance on one node if the database password file for the same database is corrupt on another node in the cluster.
D. A database instance on any node can connect to an ASM instance on any node.
E. Database instances that depend on an ASM instance that is terminated connect to a surviving ASM instance.
正解：A,E

質問 5：
A multi-tenant container database (CDB) contains three PDBs.
Which three are prerequisites for performing a cross-platform transport of any of the PDBs? (Choose three.)
A. The source and target platforms must have the same endianness.
B. The source PDBs must be closed for a cross-platform PDB backup.
C. The CDB should be in MOUNT state.
D. Flashback database must be enabled for the CDB.
E. The COMPATIBLE parameter must be set to 12.2 or greater in the CDB.
F. The CDB must use Automatic Memory Management.
正解：A,B,E

質問 6：
Which two statements are true about a band join? (Choose two.)
A. It is a non-equijoin in which the key values in one data set must fall within the specified range of the second data set.
B. For each row in the first row source, Oracle probes the second row source for matching rows and joins them.
C. The SQL runtime engine avoids unnecessary scanning of rows that fall outside the defined ranges.
D. It returns rows for SQL statements that contain an equijoin.
E. The optimizer always uses the smaller of the two row sources to build a hash table on the join key.
正解：A,C

質問 7：
Which three tasks are performed automatically by Database Upgrade Assistant (DBUA) when the database to be upgraded is in archivelog mode and has the database flashback feature enabled? (Choose three.)
A. It creates a restore point to restore the database if the upgrade fails
B. It automatically resets the COMPATIBLE parameter value to 12.0.0
C. It changes Oracle kernel parameters if required
D. It drops all the invalid objects
E. It modifies or creates new tablespaces as required
F. It calls the catctl.pl script to perform the upgrade process in parallel
正解：A,D,F