Oracle database 10g:Administration I (1Z0-042) Free Practice Test

Question 1

View the Exhibit and analyze the CREATE TABLE statements used to create the ITEMS and ORDERS tables.
The ITEMS table has 50 rows and ORDERS table has 500 rows. Because you decide to not deal with the item code 188 in future, you execute the following command to remove the item:
SQL> DELETE FROM items WHERE item_code=188;
What is the effect of this command?

A. The command fails with integrity violation error.

B. The row containing the value 188 corresponding to the ITEM_CODE column is deleted from the ITEMS table, and the foreign key constraint is disabled in the ORDERS table.

C. The row containing the value 188 corresponding to the ITEM_CODE column is deleted from the ITEMS table, and the dependent rows in the ORDERS table are also deleted automatically.

D. The row containing the value 188 corresponding to the ITEM_CODE column is deleted from the ITEMS table, and the dependent rows in the ORDERS table are populated with
NULL values in their ITEM_CODE columns.

Correct Answer: C

Question 2

Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file ? (Choose two.)

A. dropping a data file from a tablespace

B. adding a new user to the database

C. dropping a user from the database

D. adding a new tablespace to the database

E. dropping a table from the database

Correct Answer: A,D

Question 3

Which is the memory area that is created when a dedicated server process is started, and contains data and control information for that server process?

A. Streams Pool

B. PGA

C. SGA

D. Shared Pool

Correct Answer: B

Question 4

Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choose three.)

A. The corresponding indexes for the table are also truncated.

B. Delete triggers on the table are fired during the execution of the TRUNCATE command.

C. The child table is truncated when the TRUNCATE command is applied on the parent table.

D. Very little or no undo data is generated during the execution of the TRUNCATE command.

E. The high-water mark (HWM) is set to point to the first useable data block in the table segment.

Correct Answer: A,D,E

Question 5

The user SCOTT executes the following command successfully to increase the salary values in one of his sessions:
SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20;
Before SCOTT ends the transaction, user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values.
Why does HR still see the old data?

A. because of undo data from the undo tablespace

B. because of data from database buffer cache

C. because of data from a temporary tablespace

D. because of redo data from redo log file

Correct Answer: A

Question 6

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. SCHEMAS

B. FULL

C. REMAP_DATAFILES

D. REMAP_SCHEMA

E. REMAP_TABLESPACE

Correct Answer: D

Question 7

You are working on a database created with the Oracle Database 10g software in which the initialization parameter COMPATIBLE is set to 10.0.0. The hr_tbs tablespace in the database is created as follows:
CREATE TABLESPACE hr_tbs DATAFILE '/oracle/oradata/hr_tbs.dbf' SIZE 50M;
View the Exhibit to see the properties of the database.
Which statement is correct in this scenario?

A. hr_tbs is a dictionary-managed tablespace.

B. All the tablespaces in the database will be locally managed by default.

C. All the tablespaces in the database must be of the smallfile tablespace type.

D. hr_tbs is a bigfile tablespace.

E. The tablespace type bigfile or smallfile must be mentioned in the command.

Correct Answer: B

Question 8

A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance? (Choose two.)

A. Oracle Enterprise Manager

B. Database Configuration Assistant (DBCA)

C. Oracle Net Manager

D. Data Pump

E. Oracle Universal Installer (OUI)

Correct Answer: A,C

Question 9

Which three statements are true regarding the logical structure of the Oracle database? (Choose three.)

A. Each data block in the database always corresponds to one OS block.

B. It is possible to have tablespaces of different block sizes in a database.

C. Multiple tablespaces can share single data file.

D. A data block is the smallest unit of I/O for data files.

E. Each segment contains one or more extents.

Correct Answer: B,D,E

Welcome to TestSimulate

Oracle database 10g:Administration I (1Z0-042) Free Practice Test