1z0-062試験無料問題集「Oracle Database 12c: Installation and Administration 認定」

A. A segment is allocated for the table if the ALTER TABLE... ALLOCATE EXTENT command is issued.

B. A segment is allocated when an index is created for any column in the table.

C. The table is created and extents are immediately allocated as per the default storage defined for its tablespace.

D. The table is created without a segment because the storage clause is missing.

E. A segment is allocated when the first row is inserted in the table.

A. The values assigned to the resource limits and password parameters in the default profile can be altered.

B. It can be dropped and recreated.

C. it must be explicitly assigned to the user.

D. A different DEFAULT profile can be created before each user in a database.

A. One control file copy is intact and damaged control file copies have to be restored to the default location.

B. One control file copy is intact and damaged control file copies have to be restored to a non-default location.

C. All copies of the control file are damaged and the CREATE CONTROLFILE statement is executed manually.

D. One control file copy is intact so the spfile is changed to refer to only one copy.

E. All copies of the control file are damaged and the auto backed up control file is used for recovery.

A. Use transparent parallel processing without having to split the external data first.

B. Transform the data while it is being loaded into the database.

C. Generate unique sequential key values in specified columns.

D. Load data into multiple tables during the same load statement.

A. by implementing Database Resource Manager and assign it a role for the user

B. by using appropriate PASSWORD parameters set in the profile assigned to the user

C. by using appropriate KERNEL parameters set in the profile assigned to the user

D. by alerting the appropriate user attributes with an ALTER USER command

E. by implementing Database Resource Manager and assign it a profile for the user

A. Enabling resumable timeout for user sessions

B. Decreasing the value of the IDLE_TIME resource limit in the default profile

C. Implementing Database Resource Manager

D. Setting a metric threshold

A. Statements that refer to standalone procedure can be audited.

B. DDL statements can be audited.

C. Only one audit record is ever created for a session per audited statement even though it is executed more than once.

D. Operations by the users logged on as SYSDBA cannot be audited.

A. 1, 2, 6, 4, 5

B. 1, 3, 7, 2, 6, 4, 5

C. 1, 3, 2, 6, 7, 4, 5

D. 1, 6, 2, 4, 5

E. 1, 3, 2, 4, 5

A. Each multithreaded Oracle process has an SCMN thread.

B. Each Oracle process runs an SCMN thread.

C. Thread creation must be routed through a dispatcher process

D. The local listener may spawn a now process and have that new process create a thread

E. The local listener may pass the request to an existing process which in turn will create a thread.

A. A DBaaS instance can support only one Oracle database instance.

B. An Oracle database instance can support multiple DBaaS instances.

C. A DBaaS instance can support multiple Oracle database instances.

D. A DBaaS instance runs in a pluggable database (PDB), which is contained in a multi-tenant container database (CDB).

E. An Oracle database instance can support only one DBaaS instance.

A. Undo data is written to flashback logs after 1200 seconds.

B. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.

C. You can perform a Flashback Database operation only within the duration of 1200 seconds.

D. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

A. You must copy the VPD policies manually from the original table to the new table during online redefinition.

B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.

C. VPD policies are copied from the original table to the new table during online redefinition.

D. All the triggers for the table are disabled without changing any of the column names or column types in the table.

A. 2, 3, 4, and 5

B. 1 and 3

C. 2, 5, and 6

D. 1, 2, and 3

A. 1, 2, 3, 4, 6, 8, 9 and 10

B. 1, 2, 4, 5, 6 and 7

C. 1, 2, 4, 5, 7, 8, 9 and 10

D. 1, 2, 4, 5, 6, 7 and 8

E. 1, 2, 3, 8, 9 and 10