Oracle 1z0-497 問題集

質問 1：
When you start up a CDB, which operations are performed automatically and in what order?
a - The instance is started.
b - Control files are opened.
c - The root container is opened (redo logs and root data files).
d - Seed pluggable database is in READ ONLY mode.
e - Other PDBs are still in MOUNTED mode.
f - Triggers may fire if they exist to open other PDBs.
A. a, b, c, d
B. b, c, a, d, e, f
C. c, b, a, d, f, e
D. b, c, a, d
E. a, b, c, d, e, f
正解：A

質問 2：
Which two statements are true about a buffer cache?
A. A buffer cache always resides completely in System Global Area (SGA).
B. Buffer access is kept efficient by maintaining a least recently used (LRU) list for dirty and clean buffers.
C. A buffer cache stores copies of data blocks from all files of the database.
D. When a buffer is read from a buffer cache, it may be inconsistent and require undo data to make it consistent.
E. A buffer cache contains exactly three pools: default, keep, and recycle pool.
正解：D,E

質問 3：
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 メンバーにのみ表示されます)

質問 4：
Which three tasks can you perform in Database Express?
A. Start up the database.
B. View performance and status information about the database instance.
C. Shut down the database.
D. Create database structures.
E. Manage users and security.
正解：B,D,E

質問 5：
Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC.
A. Automatic SGA Memory Management
B. object-level statistics
C. Oracle Database Trace files
D. all server-generated alerts
E. Oracle Database alert.log file
正解：A,B,D

質問 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：
Examine the statements:
SQL> CREATE TABLESPACE MYTBS DATAFILE '/disk1/mytbs_l.dbf ' SIZE 10M;
SQL> CREATE TABLE mytab (id NUMBER, descr VARCHAR2 (100) )
PARTITION BY RANGE(id) (
partition pi values loss than (100000) tablespacemytbs storage (initial lm),
partition p2 values less than (MAXVALUE) tablespacemytbs storage (initial 1m)
);
When inserting data, you get the error:
ORA-01688: unable to extend table SYS.MYTAB partition P2 by 128 in tablespace MYTBS
Which three operations would allow you to insert data without getting the error message?
A. Extend the logical volume by 10 MB where the data files are stored;
# lvextend -L+10M /diskl
B. Add a data file:
SQL>ALTER TABLESPACE MYTBS ADD DATAFILE ' /disk1/mytbs_2 .dbf SIZE 10M;
C. Move a partition to another tablespace:
SQL> CREATE TABLESPACE ADDITIONAL_TBS DATAFILE '/disk1/additional_tbs_1 .dbf' SIZE
10M;
SQL> ALTER TABLE MYTAB MOVE PARTITION P2 TABLESPACE ADDlTIONAL_TBS;
D. Resize the existing data file:
SQL> ALTER DATABASE DATAFILE '/diskl/mytbs_l .dbf' RESIZE 20M;
E) Remove a data file:
SQL> ALTER TABLESPACE MYTBS DROP DATAFILE '/diskl/mytbs_l - dbf';
正解：B,C,D

質問 8：
You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?
A. Oracle recommends that you back up the root. sh script after you complete the installation.
B. Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.
C. You should not install the Oracle Database software into an existing Oracle home from a different release.
D. You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.
E. A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.
正解：E

質問 9：
Which statement about Oracle patches is false?
A. Interim patches, also known as "one-off" patches, are created to provide a specific fix between the releases of patch sets.
B. Patch Set Update (PSU) is a collection of proactive, stabilizing, cumulative patches for a particular product version (base release or patch set). PSUs are cumulative and include all the security fixes from CPU patches, plus additional fixes.
C. Patch Set is the main way in which Oracle provides bug fixes in between releases. Oracle bundles a number of fixes, tests them thoroughly together, and packages, then together for easy download and installation.
D. Terminal Patch Set is an unsupported patch set by Oracle Lifetime Support policies.
E. Security Patch Update (SPU) is the primary means of releasing security fixes for Oracle products. SPUs are cumulative with respect to prior SPUs and generally contain only security fixes.
正解：D
解説: (Topexam メンバーにのみ表示されます)