最新的Oracle 1Z0-042免費考試真題

問題1

You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?

A. REMAP_TABLESPACE

B. REMAP_DATAFILES

C. SCHEMAS

D. FULL

E. REMAP_SCHEMA

正確答案: E

問題2

You executed the following command to back up your control file:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which initialization parameter is used to specify the location of the trace file?

A. BACKGROUND_DUMP_DEST

B. CORE_DUMP_DEST

C. BACKUP_DUMP_DEST

D. USER_DUMP_DEST

E. TRACE_DUMP_DEST

正確答案: D

問題3

Data files of which three tablespaces can be recovered by performing an open recovery? (Choose three.)

A. TEMP

B. SYSTEM

C. UNDO

D. INDEX

E. SYSAUX

正確答案: A,D,E

問題4

Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus?

A. No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.

B. Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager, and grant the webDba role to the user.

C. The user must be listed in the password file for the authentication.

D. The user must be granted the database administrator (DBA) privilege.

正確答案: B

問題5

After being hired as a database administrator, you find that there is only one database that
is functional and that is being accessed by the applications. You want to create a replica of the database, to be used for testing purposes. What is the best method to create the replica?

A. use DBCA to create a template from the existing database to contain the database structure and then manually copy the data using Oracle Data Pump

B. use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location

C. use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure

D. create a database by using CREATE DATABASE .. command and manually copy the data

正確答案: B

問題6

Your database is configured with the following parameters related to SGA:
SGA_TARGET=256MB
SHARED_POOL_SIZE=32MB
DB_CACHE_SIZE=100MB
LARGE_POOL_SIZE=0
JAVA_POOL_SIZE=0
STREAMS_POOL_SIZE=0
Which two statements are true about the configuration? (Choose two.)

A. The shared pool and the default buffer pool will not be sized bigger than 32 MB and 100 MB, respectively.

B. The shared pool and the default buffer pool will not be sized smaller than 32 MB and 100 MB, respectively.

C. The SGA_TARGET value cannot be sized smaller than 100 MB.

D. 124 MB (256 minus 132) of memory is available for use by all the manually sized components.

E. 124 MB (256 minus 132) of memory is available for use by all the manually and automatically sized components.

正確答案: B,E

問題7

When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed:
TZ set to America/New_york
OC4J Configuration issue. /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found.
Which two environment variables do you need to set appropriately to avoid such errors, and start the Database Control successfully? (Choose two.)

A. ORACLE_BASE

B. ORACLE_HOME

C. NLS_LANG

D. LD_LIBRARY_PATH

E. ORACLE_SID

正確答案: B,E

問題8

Which two statements about Flashback Query are true? (Choose two.)

A. It fails when undo data pertaining to the transaction is overwritten.

B. The database has to be opened with the resetlogs option after performing Flashback Query.

C. It helps in row-level recovery from user errors.

D. It is generated by using the redo log files.

E. It can be performed to recover ALTER TABLE statements

正確答案: A,C

問題9

Due to media failure you lost one of the data files belonging to the USERS tablespace, and the tablespace is not available to use. Which statement regarding the status of the database is true?

A. The database gets shut down automatically.

B. The status of the database depends on the status of the USERS tablespace.

C. The database becomes read only.

D. The database instance gets aborted.

E. The database gets dismounted.

F. The database remains open.

正確答案: F

問題10

Users of HR schema complain about slower-than-normal performance. On investigation the DBA found that maintenance was recently performed on some of the tables. The DBA traced the query that takes longer than normal to execute.
View the Exhibit exhibit_before.
After the DBA resolves the problem, the query performs normally.
View the Exhibit exhibit_after.
What action would the DBA have taken to resolve the performance problem?

A. moved the EMPLOYEES table to another location in the same tablespace

B. moved the indexes associated with the EMPLOYEES table to the same tablespace where the EMPLOYEES table exists

C. moved the EMPLOYEES table in to a locally managed tablespace

D. analyzed the EMPLOYEES table to collect the current statistics

E. reorganized the associated indexes for the EMPLOYEES table that were in an unusable state

正確答案: E

最新的Oracle database 10g:Administration I - 1Z0-042免費考試真題

聯系我們

站內鏈接

最新更新