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

An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode? (Choose four.)

• A.You can connect by using a Net Service name.
• B.You can connect as a local user by using the connect statement.
• C.You can connect by using OS authentication.
• D.You can conned as a common user by using the connect statement.
• E.You can connect as a local user by using the SET CONTAINER statement.
• F.You can connect by using easy connect.

You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

• A.The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
• B.The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
• C.The statement results in an error because there are open PDBs.
• D.The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.

Your database instance is started by using a server parameter file (SPFILE). You execute the following command to change the value of the LOG_BUFFER initialization parameter:
ALTER SYSTEM SET LOG_BUFFER=32 M;
What is the outcome of this command?

• A.It returns an error because the value of this parameter cannot be changed dynamically.
• B.It returns an error because SCOPE should be set to MEMORY.
• C.The parameter value is changed and it comes into effect as soon as space becomes available in the SGA.
• D.The parameter value is changed and it comes into effect at the next instance startup.

You execute the following PL/SQL:

Which two statements are true? (Choose two.)

• A.FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
• B.FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.
• C.Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.
• D.FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?

• A.Decreasing the value of the IDLE_TIME resource limit in the default profile
• B.Setting a metric threshold
• C.Implementing Database Resource Manager
• D.Enabling resumable timeout for user sessions