1z0-074 무료 덤프문제 온라인 액세스

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.A database instance on any node can connect to an ASM instance on any node.
• D.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.
• E.Database instances that depend on an ASM instance that is terminated connect to a surviving ASM instance.

To which two components does the term "shape" refer in Oracle Database Cloud Service (DBaaS)? (Choose two.)

• A.number of storage LUNs
• B.amount of RAM
• C.number of network interface cards (NICs)
• D.number of CPUs
• E.number of database instances

In a Database Cloud Service (DBCS) environment, which pre-created user has sudo privileges to run certain root commands?

• A.oracle
• B.grid
• C.opc
• D.oinstall
• E.nobody

You plan to execute this command:

Which statement is true and why?

• A.It creates partitions P1 and P2 where COUNTRY and CHANNEL are multi-column partition keys.
• B.It returns an error because only one set of multiple values can be specified for each partition.
• C.It creates partitions P1 and P2 where COUNTRY is a single column partition key and CHANNEL is a subpartition key.
• D.It returns an error because only a single column key can be used for a list-partitioned table.
• E.It returns an error because the AUTOMATIC option must be specified.

You log in to the ORCL database as SYSTEM and successfully execute these two blocks of code:

The SCOTT user has the SELECT privilege on HR.EMP.
Which statement is true about queries by non-DBA users with the SELECT privilege on HR.EMP?

• A.All their queries display blanks for LAST_NAME and zeroes for SALARY.
• B.Only SCOTT'S queries display the true contents of the SALARY column and blanks for LAST_NAME.
• C.Only SCOTT'S queries display the true contents of the SALARY and LAST_NAME columns.
• D.Only SCOTT'S queries display zero for SALARY and the true contents of the LAST_NAME column.
• E.All their queries display blanks for LAST_NAME and the true contents of the SALARY column.