1z1-497無料問題集「Oracle Database 12c Essentials」

質問 1

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）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';

（C）Add a data file:
SQL>ALTER TABLESPACE MYTBS ADD DATAFILE ' /disk1/mytbs_2 .dbf SIZE 10M;

（D）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;

正解：B、C、D 解答を投票する

質問 2

Which three options best describe Patch Set Updates (PSUs) in Oracle Database 12c?

（A）cumulative

（B）non-cumulative

（C）stabilizing

（D）proactive

（E）multi-version

正解：A、C、D 解答を投票する

質問 3

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）Multiple PDBs with the same name can reside in the same CDB.

（D）You can create common users in PDBs.

（E）A seed PDB can sometimes be opened for particular operations.

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 4

Examine the commands:
SQL> CONNECT sys@CDBl AS SYSDBA
$QL>STARTUP MOUNT
SQL> ALTER DATABASE cdbl MOUNT;
Which four options represent what happens when these commands are executed?

（A）The PDBs are mounted, and opened in READ WRITE mode, while the seed is opened In READ ONLY mode.

（B）The root is opened.

（C）The PDBs are mounted.

（D）The CDB control files are opened for the instance.

（E）The instance is started.

（F）The root is mounted.

（G）The PDBs are mounted, and the seed is opened in READ ONLY mode.

正解：C、D、E、F 解答を投票する

質問 5

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, e, f

（B）b, c, a, d

（C）a, b, c, d

（D）b, c, a, d, e, f

（E）c, b, a, d, f, e

正解：C 解答を投票する

質問 6

In Oracle Database 12c, when does a transaction begin?

（A）when the first executable SQL statement is encountered

（B）when a user explicitly issues a "begin" statement

（C）when a transaction is assigned to an available undo data segment to record undo entries for the new transaction

（D）when a transaction ID is allocated for it.

正解：D 解答を投票する

質問 7

Which two statements describe data dictionary views?

（A）They are owned by the SYS user.

（B）They speed up query and data manipulation language (DML) operations.

（C）They are based on virtual tables.

（D）The VSFIXED_TABLEview can be queried to list the names of these views.

（E）They are stored in the SYSTEM tablespace.

正解：A、E 解答を投票する

質問 8

Your customer wants all email addresses from the database displayed as [hidden]@company.com. What method of data redaction must you use?

（A）no redaction

（B）regular expressions

（C）full redaction

（D）random redaction

（E）partial redaction

正解：C 解答を投票する

質問 9

Oracle Database 12c provides new task-specific privileges (SYSBACKUP, SYSDG, and SYSKM) to handle standard administration duties. Which two statements about these standard administration privileges are true?

（A）After connecting with these privileges, you are connected under a predefined user whose name is the privilege name.

（B）Without being a member of OSBACKUP. OSDG, and OSKM OS groups, users cannot connect as administrative users by using OS authentication.

（C）These administrative privileges allow a user to view DBA_xxx, GV$, VS, and SELECT on application tables.

（D）These administrative privileges enable you to connect to the database only if the database is open.

正解：A、B 解答を投票する

質問 10

Which new process was introduced as of Oracle Database 12c?

（A）Change Tracking Writer process (CTWR)

（B）Listener Registration process (LREG)

（C）Result Cache Background process (RCBG)

（D）AQ Coordinator process (QMNC)

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

1z1-497 無料問題集「Oracle Database 12c Essentials」

弊社を連絡する

関連リンク

トップ試験