1z1-062 무료 덤프문제 온라인 액세스

Examine these statements:
DESC emp

INSERT INTO emp VALUES ( 101, 'John', 12000);
1 row created.
SAVEPOINT after_insert;
Savepoint created.
UPDATE emp SET salary=16000 WHERE empno=101;
1 row updated.
SAVEPOINT after_update;
Savepoint created.
DELETE FROM emp WHERE empno=101;
1 row deleted.
SAVEPOINT after_delete;
Savepoint created.
ROLLBACK TO SAVEPOINT after_update;
Rollback complete.
INSERT INTO emp VALUES ( 102, 'Emma', 12000);
ROLLBACK TO SAVEPOINT after_delete;
Which is the result and effect of this ROLLBACK?

• A.The ROLLBACK backs out all DMLS before after_delete.
• B.The ROLLBACK throws an error.
• C.The ROLLBACK executes successfully but does not back out any DMLS.
• D.The ROLLBACK backs out all DMLS until after_delete.

What happens if a maintenance window closes before a job that collects optimizer statistics completes?

• A.The job is terminated but the gathered statistics are not published.
• B.The job continues to run until all statistics are gathered.
• C.The job is terminated and the gathered statistics are not saved.
• D.The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.

Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup.
Which two statements are true in this scenario? (Choose two.)

• A.The database must be in MOUNT state to take RMAN backup.
• B.The RMAN backup contains only data files.
• C.The RMAN backup can be performed while the database is open.
• D.The database must be shut down to take a user-managed backup.
• E.The user-managed backup consists of only formatted data blocks.

You want to create a role that:
- is protected from unauthorized usage
- does not use a password embedded in the application source code or stored in a table
- is enabled for a user based on security policies defined in a PL/SQL package How would you create this role?

• A.with global authentication
• B.with definer's rights
• C.as a secure application role
• D.with external authentication

As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database. SCOTT's password is TIGER. The service mane "HQ" is used to connect to the remote HQ database.
Which command would you execute to create the database link?

• A.CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';
• B.CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';
• C.CREATE DATABASE LINK HQ USING 'HQ';
• D.CREATE DATABASE LINK HQ CONNECT TO CURRENT_USER USING 'HQ';