Oracle 1z0-497 問題集

質問 1：
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 immediately produces a "resource busy" error.
C. A deadlock is created.
D. The second user's session waits for a time before producing a "resource busy" error.
正解：B

質問 2：
Which command do you use to create a local role while you are connected as the local user?
A. create local role l_hr;
B. create role l_hr container=all;
C. create role c##_hr container=current;
D. create role l_hr container=current;
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Identify three outcomes of using the Oracle Multitenant option in Oracle Database 12c.
A. same time needed for patching and upgrade as in the previous release
B. less instance overhead
C. fast and easy provisioning
D. isolation
E. increased storage cost
F. minor application changes
正解：A,B,C

質問 4：
Which three events signal a database writer (DWR) to write buffers to disk?
A. A server process cannot find non-dirty blocks after scanning a threshold number of buffers.
B. The redo log buffer becomes full.
C. The database advances a checkpoint.
D. A tablespace is changed to read-only status.
E. The database is shut down in immediate mode.
F. A client process commits a transaction.
正解：A,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
There are two listeners, LISTENER1 arid LISTENER2, and one service name ORCL available for your database. The database is running and currently, only LISIENER1 is started. You issue the command:
lsnrctl start listener2
What would be the outcome?
A. It gives an error because multiple listeners cannot run simultaneously.
B. It starts the second listener without affecting current sessions.
C. It starts the second listener and terminates all current sessions.
D. It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You execute the following command:
SQL> ALTER USER skd ACCOUNT LOCK;
Which two statements are correct?
A. The SKD user's password expires and the user is forced to change the password at the next login.
B. The objects owned by the SKD user are not accessible to any user.
C. The SKD user cannot log in to the database instance.
D. Other users can access objects owned by the SKD user, to which they have access.
正解：C,D

質問 7：
Which database feature can be used for organizing data when there is a very large amount of data?
A. Index
B. Database vault
C. Row-level security
D. Triggers
E. Partitioning
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which statement about CDB architecture is true?
A. A CDB can have an infinite number of PDBs.
B. Oracle-supplied metadata resides only in the root container.
C. A seed PDB can sometimes be opened for particular operations.
D. You can create common users in PDBs.
E. Multiple PDBs with the same name can reside in the same CDB.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Examine the command below:
LSNRCTL> SERVICES LISTENER2
Connecting to (DESCRIPTION=(ADDRESS= (PROTOCOL=TCP) (HOST=estb. us. abc.com) (PORT=1525)))
Services Summary. . .
Service "orcl.oracle.com" has 1 instance(s).
Instance "oracle", status UNKNOWN, has 1 handler(s) for this service... Handler(s):
"DEDICATED" established:2 refused:0 LOCAL SERVER The command completed successfully
Which two statements are true about LISTENER2?
A. The ORCL instance is registered dynamically with the listener.
B. The number of current client connections handled by the service handler is two.
C. The total number of client connections handled so far by the service handler is two.
D. The ORCL instance is registered statically in the listener.ora file.
正解：C,D