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

Which three statements are true concerning the multitenant architecture? (Choose three.)

• A.PDBs share a common system tablespace.
• B.Log switches occur only at the multitenant container database (CDB) level.
• C.Instance recovery is always performed at the CDB level.
• D.A PDB can have a private temp tablespace.
• E.Different PDBs can have different default block sizes.
• F.PDBs can share the sysaux tablespace.
• G.Each pluggable database (PDB) has its own set of background processes.

A user establishes a connection to a database instance by using an Oracle Net.
You want to ensure that:
1. The user account must be locked after five consecutive unsuccessful login attempts.
2. Data read per session must be limited for the user.
3. The user cannot have more than three simultaneous sessions.
4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.
Which two would you do to implement this? (Choose two.)

• A.by using appropriate KERNEL parameters set in the profile assigned to the user
• B.by implementing Database Resource Manager and assign it a role for the user
• C.by alerting the appropriate user attributes with an ALTER USER command
• D.by implementing Database Resource Manager and assign it a profile for the user
• E.by using appropriate PASSWORD parameters set in the profile assigned to the user

Which two categories of segments are analyzed by the Automatic Segment Advisor? (Choose two.)

• A.segments in tablespaces that have exceeded a critical or warning space threshold
• B.segments for tables created using ADVANCED ROW COMPRESSION
• C.segments that have the highest growth rate in a database
• D.segments that are sparsely populated and have more than 10% of free space below the high water mark.
• E.segments that have unusable indexes

What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?

• A.The rows in both the table and the archive are truncated.
• B.The rows in the table are archived, and then truncated.
• C.The rows in the table are truncated without being archived.
• D.It fails with the ORA-665610 Invalid DDL statement on history-tracked message

Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be; used to back up only the PDB1 pluggable database? (Choose two.)

• A.BACKUP PLUGGABLE database PDB1 while connected to PDB2
• B.BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container
• C.BACKUP DATABASE while connected to the PDB1 container
• D.BACKUP DATABASE while connected to the boot container
• E.BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container