1z0-074 試験問題を無料オンラインアクセス

USER1 is an OS user with the password oracle and is only a member of the oinstall group.
In the ORCL database, the OS_AUTHEN_PREFIX value is ops$.
Examine these commands executed by the DBA:
SQL> CREATE USER ops$user1 IDENTIFIED externally;
SQL> GRANT create session TO ops$user1;
How can USER1 be given the SYSRAC privilege?

• A.Make User1 a member of the OSDBA group in Linux or the ORA_%HOMENAME%_SYSDBA group in Windows only.
• B.Grant SYSRAC to ops$user1.
• C.Grant SYSDBA to ops$user1
• D.Grant SYSRAC to user1.
• E.Make USER1 a member of the OSRACDBA group in Linux or the ORA_%HOMENAME%_SYSRAC group in Windows.

Which statement is true about transportable tablespaces?

• A.The source tablespace can be encrypted
• B.They can be administrative tablespaces such as SYSTEM or SYSAUX
• C.The cannot be dictionary-managed tablespaces
• D.The tablespace data file or data files to be plugged in to the target database cannot have a different block size than any of the source database's data file or files.

You execute this command in your database:
ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL;
How does this affect the creation of tablespaces?

• A.User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in an on-premise database.
• B.TEMP and UNDO tablespaces are transparently encrypted with AES128 by default only in the cloud.
• C.User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are not encrypted anywhere.
• D.User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in the cloud.
• E.TEMP and UNDO tablespaces are transparently encrypted with AES128 by default in an on-premise database.

One of your databases supports an OLTP workload.
If a better plan is discovered for a statement, then you want that plan to be used.
Which two can cause better plans to be used for a statement? (Choose two.)

• A.adaptive execution plans
• B.using literals in SQL statements
• C.SQL Performance Analyzer
• D.SQL Access Advisor
• E.adaptive cursor sharing

Examine these parameters in a PFILE used to start database instance.

Which two statements are true after an instance restart is attempted and why? (Choose two.)

• A.The MEMORY_MAX_TARGET parameter is set to zero for the instance.
• B.MEMORY_MAX_TARGET is automatically set to 4G for the instance.
• C.PGA_AGGREGATE_TARGET and SGA_TARGET are set to zero for the instance.
• D.PGA_AGGREGATE_TARGET and SGA_TARGET remain 1G and 2G respectively.
• E.The instance does not start because AMM is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET are set to nonzero values.