Oracle Database 1z0-062시험을 패스하기 위하여 잠을 설쳐가며 시험준비 공부를 하고 계신 분들은 이 글을 보는 즉시 공부방법이 틀렸구나 하는 생각이 들것입니다. Pass4Test의 Oracle Database 1z0-062덤프는 실제시험을 대비하여 제작한 최신버전 공부자료로서 문항수도 적합하여 불필요한 공부는 하지 않으셔도 되게끔 만들어져 있습니다.가격도 착하고 시험패스율 높은 Pass4Test의 Oracle Database 1z0-062덤프를 애용해보세요. 놀라운 기적을 안겨드릴것입니다.
NO.1 The hr user receiver, the following error while inserting data into the
sales table: ERROR at line
1:
ORA-01653; unable to extend table HR.SALES
by 128 in tablespace USERS
On investigation, you find that the users
tablespace uses Automnrif Segment Space Management
(ASSM). It is the default
tablespace for the HR user with an unlimited quota on it.
Which two methods
would you use to resolve this error?
A. Altering the data life associated
with the USERS tablespace to ex automatically
B. Adding a data life to the
USERS tablespace
C. Changing segment space management for the USERS
tablespace to manual
D. Creating a new tablespace with autoextend enabled and
changing the default tablespace of the
HR user to the new tablespace
E.
Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter
to a
nonzero value
Answer: A,D
NO.2 The ORCL database is configured
to support shared server mode. You want to ensure that a
user connecting
remotely to the database instance has a one-to-one ratio between client and
server
processes.
Which connection method guarantees that this requirement
is met?
A. connecting by using an external naming method
B. connecting by
using the easy connect method
C. creating a service in the database by using
the dbms_service.create_service procedure and using
this service for creating
a local naming service"
D. connecting by using the local naming method with
the server = dedicated parameter set in the
tnsnames.ora file for the net
service
E. connecting by using a directory naming method
Answer:
C,E
NO.3 Examine the resources consumed by a database instance whose
current Resource Manager
plan is displayed.
SQL> SELECT name,
active_sessions, queue_length, Consumed_cpu_time, cpu_waits,
cpu_wait_time
FROM v$rsrc_consumer_group;
NAMEACTIVE_SESSIONS QUEUE_LENGTH
CONSUMED_CPU_WAITS CPU_WAIT_TIME
OLTP__ORDER__ENTRY1029690 467 6709
OTHES__GROUPS 0 059823664089 60425 SYS_GROUP 1
02420704 914 19540
DS.S_QUERIES4245946603004 55700
Which two statements are true?
A. An
attempt to start a new session by a user belonging to DSS_QUERIES fails with an
error.
B. An attempt to start a new session by a user belonging to
OTHE_GROUPS fails with an error.
C. The CPU_WAIT_TIME column indicates the
total time that sessions in the consumer group waited
for the CPU due to
resource management.
D. The CPU_WAIT_TIME column indicates the total time
that sessions in the consumer group waited
for the CPU due to I/O waits and
latch or enqueue contention.
E. A user belonging to the DSS__QUERIES resource
consumer group can create a new session but
the session will be
queued.
Answer: C,E
NO.4 What happens if a maintenance window closes
before a job that collects optimizer statistics
completes?
A. The job is
terminated and the gathered statistics are not saved.
B. The job is
terminated but the gathered statistics are not published.
C. The job
continues to run until all statistics are gathered.
D. The job is terminated
and statistics for the remaining objects are collected the next time
the
maintenance window opens.
Answer: D
NO.5 Examine the parameters
for your database instance:
NAMETYPE VALUE
undo_management string AUTO
undo_retentioninteger 12 00 undo_tablespace string UNDOTBS1
You execute the
following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION
NOGUARANTEE;
Which statement is true in this scenario?
A. Undo data is
written to flashback logs after 1200 seconds.
B. Inactive undo data is
retained for 1200 seconds even if subsequent transactions fail due to lack
of
space in the undo tablespace.
C. You can perform a Flashback Database
operation only within the duration of 1200 seconds.
D. An attempt is made to
keep inactive undo for 1200 seconds but transactions may overwrite the
undo
before that time has elapsed.
Answer: A
NO.6 Which two statements are
true about the logical storage structure of an Oracle database?
A. An extent
contains data blocks that are always physically contiguous on disk.
B. An
extent can span multiple segments,
C. Each data block always corresponds to
one operating system block.
D. It is possible to have tablespaces of
different block sizes.
E. A data block is the smallest unit of I/O in data
files.
Answer: B,D
NO.7 Which three factors
influence the optimizer's choice of an execution plan?
A. the optimizer_mode
initialization parameter
B. operating system (OS) statistics
C.
cardinality estimates
D. object statistics in the data dictionary
E. fixed
baselines
Answer: A,B
NO.8 You plan to create a database by
using the Database Configuration Assistant (DBCA), with the
following
specifications:
-Applications will connect to the database via a middle
tier.
-The number of concurrent user connections will be high.
-The
database will have mixed workload, with the execution of complex BI queries
scheduled at
night.
Which DBCA option must you choose to create the
database?
A. a General Purpose database template with default memory
allocation
B. a Data Warehouse database template, with the dedicated server
mode option and AMM enabled
C. a General Purpose database template, with the
shared server mode option and Automatic
Memory Management (AMM) enabled
D.
a default database configuration
Answer:
C
sales table: ERROR at line
1:
ORA-01653; unable to extend table HR.SALES
by 128 in tablespace USERS
On investigation, you find that the users
tablespace uses Automnrif Segment Space Management
(ASSM). It is the default
tablespace for the HR user with an unlimited quota on it.
Which two methods
would you use to resolve this error?
A. Altering the data life associated
with the USERS tablespace to ex automatically
B. Adding a data life to the
USERS tablespace
C. Changing segment space management for the USERS
tablespace to manual
D. Creating a new tablespace with autoextend enabled and
changing the default tablespace of the
HR user to the new tablespace
E.
Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter
to a
nonzero value
Answer: A,D
NO.2 The ORCL database is configured
to support shared server mode. You want to ensure that a
user connecting
remotely to the database instance has a one-to-one ratio between client and
server
processes.
Which connection method guarantees that this requirement
is met?
A. connecting by using an external naming method
B. connecting by
using the easy connect method
C. creating a service in the database by using
the dbms_service.create_service procedure and using
this service for creating
a local naming service"
D. connecting by using the local naming method with
the server = dedicated parameter set in the
tnsnames.ora file for the net
service
E. connecting by using a directory naming method
Answer:
C,E
NO.3 Examine the resources consumed by a database instance whose
current Resource Manager
plan is displayed.
SQL> SELECT name,
active_sessions, queue_length, Consumed_cpu_time, cpu_waits,
cpu_wait_time
FROM v$rsrc_consumer_group;
NAMEACTIVE_SESSIONS QUEUE_LENGTH
CONSUMED_CPU_WAITS CPU_WAIT_TIME
OLTP__ORDER__ENTRY1029690 467 6709
OTHES__GROUPS 0 059823664089 60425 SYS_GROUP 1
02420704 914 19540
DS.S_QUERIES4245946603004 55700
Which two statements are true?
A. An
attempt to start a new session by a user belonging to DSS_QUERIES fails with an
error.
B. An attempt to start a new session by a user belonging to
OTHE_GROUPS fails with an error.
C. The CPU_WAIT_TIME column indicates the
total time that sessions in the consumer group waited
for the CPU due to
resource management.
D. The CPU_WAIT_TIME column indicates the total time
that sessions in the consumer group waited
for the CPU due to I/O waits and
latch or enqueue contention.
E. A user belonging to the DSS__QUERIES resource
consumer group can create a new session but
the session will be
queued.
Answer: C,E
NO.4 What happens if a maintenance window closes
before a job that collects optimizer statistics
completes?
A. The job is
terminated and the gathered statistics are not saved.
B. The job is
terminated but the gathered statistics are not published.
C. The job
continues to run until all statistics are gathered.
D. The job is terminated
and statistics for the remaining objects are collected the next time
the
maintenance window opens.
Answer: D
NO.5 Examine the parameters
for your database instance:
NAMETYPE VALUE
undo_management string AUTO
undo_retentioninteger 12 00 undo_tablespace string UNDOTBS1
You execute the
following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION
NOGUARANTEE;
Which statement is true in this scenario?
A. Undo data is
written to flashback logs after 1200 seconds.
B. Inactive undo data is
retained for 1200 seconds even if subsequent transactions fail due to lack
of
space in the undo tablespace.
C. You can perform a Flashback Database
operation only within the duration of 1200 seconds.
D. An attempt is made to
keep inactive undo for 1200 seconds but transactions may overwrite the
undo
before that time has elapsed.
Answer: A
NO.6 Which two statements are
true about the logical storage structure of an Oracle database?
A. An extent
contains data blocks that are always physically contiguous on disk.
B. An
extent can span multiple segments,
C. Each data block always corresponds to
one operating system block.
D. It is possible to have tablespaces of
different block sizes.
E. A data block is the smallest unit of I/O in data
files.
Answer: B,D
NO.7 Which three factors
influence the optimizer's choice of an execution plan?
A. the optimizer_mode
initialization parameter
B. operating system (OS) statistics
C.
cardinality estimates
D. object statistics in the data dictionary
E. fixed
baselines
Answer: A,B
NO.8 You plan to create a database by
using the Database Configuration Assistant (DBCA), with the
following
specifications:
-Applications will connect to the database via a middle
tier.
-The number of concurrent user connections will be high.
-The
database will have mixed workload, with the execution of complex BI queries
scheduled at
night.
Which DBCA option must you choose to create the
database?
A. a General Purpose database template with default memory
allocation
B. a Data Warehouse database template, with the dedicated server
mode option and AMM enabled
C. a General Purpose database template, with the
shared server mode option and Automatic
Memory Management (AMM) enabled
D.
a default database configuration
Answer:
C