1z1-497試験無料問題集（150題）「Oracle Database 12c Essentials 認定」

出題：1

YOUR database crashes after a user accidentally kills a background process. What are three possible ways to restart your database?

A. S sqlplus / as sysdba SQL> startup immediate;

B. S srvctl start database -db SORACLE_SID

C. S sqlplus / as sysdba SQL> restart;

D. S sqlplus / as sysdba SQL> startup open recover;

E. S rman target / RMAN> Startup

正解：B,D,E 解答を投票する

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

出題：2

Which three statements about Automatic Database Diagnostic Monitor (ADDM) are true?

A. It retains snapshots in the SYSAUX tablespace until the database is restarted.

B. It analyzes the performance of specified objects.

C. It implements all recommendations automatically.

D. It analyzes the snapshots stored in the Automatic Workload Repository (AWR).

E. It requires the database to be open.

F. It recommends solutions and quantifies expected benefits.

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

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

出題：3

Which option represents the steps to add a multiplexed copy of the current control file or to rename a control file in Oracle Database 12c?
a - Shut down the database.
b - Restart the database.
c - Copy an existing control file to a new location by using operating system commands.
d - Edit the CONTROL_FILESparameter in the database initialization parameter file to add the new control file name, or to change the existingcontrol file name.

A. c, d, b

B. a, c, d, b

C. b, c, d

D. a, d, b, c

正解：B 解答を投票する

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

出題：4

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. Add a data file:
SQL>ALTER TABLESPACE MYTBS ADD DATAFILE ' /disk1/mytbs_2 .dbf SIZE 10M;

B. 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;

C. Extend the logical volume by 10 MB where the data files are stored;
# lvextend -L+10M /diskl

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

正解：A,B,D 解答を投票する

出題：5

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

A. storage configuration for archive logs and control files

B. database status view and Data Pump export and import jobs

C. storage configuration for data files and redo log groups

D. performance tuning operations such as generation of AWR, ADDM, and ASH reports

E. database backup and recovery using RMAN

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

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

出題：6

Which option represents a function of Global Data Services (GDS)?

A. performs database failovers

B. performs data replication

C. replaces the functionality of Oracle Clusterware and Oracle RAC

D. coordinates site failovers

E. works seamlessly with Oracle Site Guard

正解：E 解答を投票する

出題：7

Which type of file system is NOT valid for storing data files, online redo log files, and control files for a pluggable database?

A. logical volume (LVM)

B. clustered file system

C. Automatic Storage Management (ASM)

D. OS file system

E. RAW

正解：E 解答を投票する

出題：8

You have two database servers EMP and EXP. A user of the database from the EXP server wants to extract some information from the database in the EMP server for cross-verification. Which schema object enables the user to access the information from the remote database?

A. materialized view

B. database link

C. cluster

D. mapping table

正解：B 解答を投票する

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

出題：9

Which two statements about switchover and failover are true?

A. A snapshot standby can be the target of a switchover or fast-start failover operation.

B. You can activate a standby database to test whether it is being updated correctly.

C. For fast-start failover, you must preselect the target standby database that will be used.

D. Neither a switchover nor a failover is possible to a far sync instance.

正解：C,D 解答を投票する

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

出題：10

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. These administrative privileges allow a user to view DBA_xxx, GV$, VS, and SELECT on application tables.

B. These administrative privileges enable you to connect to the database only if the database is open.

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

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

正解：C,D 解答を投票する

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