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

Which two are client-side components of Oracle Data Guard Broker?

• A.Oracle Data Guard Broker Manager
• B.Oracle Data Guard command-line interface (DGMGRL)
• C.Oracle Data Guard monitor
• D.Oracle Enterprise Manager Cloud Control

Which two statements represent where Oracle Net must reside?

• A.On both the web server and database server for web-based applications
• B.Only on the client for traditional client/server applications
• C.Only on the database server for web-based applications
• D.On both the client and database server for traditional client/server applications.

All database users are currently connected to the database instance and are working. The HR user opens three database sessions and executes this command in one of the sessions:
SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';
123 rows updated.
SQL> DELETE FROM persons WHERE exp='Y';
3 rows deleted.
The SYS user opens a new session after HR executes the preceding commands. Which option represents the sessions that can see the effect of the UPDATE and DELETE commands?

• A.the session of the HR user that executed the commands
• B.all sessions of the HR user
• C.all sessions for which database users have access privileges to the PERSONS table
• D.all sessions of the HR user and the SYS user

Which three DBA operations can be performed by using Oracle SQL Developer?

• A.database backup and recovery using RMAN
• B.performance tuning operations such as generation of AWR, ADDM, and ASH reports
• C.storage configuration for data files and redo log groups
• D.database status view and Data Pump export and import jobs
• E.storage configuration for archive logs and control files

View the current parameter settings shown in the output below.
NAMETYPEVALUE db_file_multiblock_read_count integer 107 ddl_lock_timeout integer 60 Distributed_lock_timeout integer 60 dml_locks integer 748 lock_sga boolean FALSE enab1e_dd1_1ogging boolean FALSE resumable_timeout integer 0
A user logs in to the hrschema and issues the following commands: SQL> CREATE TABLE emp
(empno NUMBER(3),
enamo VARCHAR2(20),
sal NUMBER (8, 2));
SQL> INSERT INTO emp (empno, ename) VALUES(1, 'JAMES');
At this moment, a second user also logs in to the hrschema and issues the following command:
SQL> ALTER TABLE emp MODIFY salNUMBER(10, 2);
What happens in this scenario?

• A.The second user's command executes successfully.
• B.The second user's session waits for a time before producing a "resource busy" error.
• C.A deadlock is created.
• D.The second user's session immediately produces a "resource busy" error.