최신 1Z1-082 무료덤프 - Oracle Database Administration I

A. The foreign key constraint will be disabled.

B. The foreign key constraint will be enabled and deferred.

C. The primary key constraint will be enabled and deferred.

D. The foreign key constraint will be enabled and immediate.

E. The primary key constraint will be enabled and immediate.

A. CONCAT : can be used to combine any number of values

B. TRUNC : can be used with NUMBER and DATE values

C. FLOOR : returns the smallest integer greater than or equal to a specified number

D. MOD : returns the quotient of a division operation

E. CEIL : can be used for positive and negative numbers

A. It gives an error because the ALL keyword is not valid

B. It executes successfully but does not give the required result

C. It gives an error because the GROUP BY clause is not valid

D. It executes successfully and gives the required result

A. in the SPFILE and SPFILEc

B. only In the SPFILE

C. only in memory

D. in the SPFILE, SPFILE, and memory

E. in the SPFILE and in memory

A. INTERSECT returns rows common to both sides of the compound query

B. Reversing the order of the intersected tables can sometimes affect the output

C. The number of columns in each SELECT in the compound query can be different

D. INTERSECT ignores NULLs

E. Column names in each SELECT in the compound query can be different

A. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable

B. Display the total number of products supplied by supplier 102 which have a product status of obsolete

C. Display the minimum PROD_LIST_PRICE for each product status

D. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE

E. Display suppliers whose PROD_LIST_PRICE is less than 1000

A. It must be smaller than the smallest BIGFILE tablespace

B. It is a locally managed tablespace

C. It uses the database default blocksize

D. Free space is managed using freelists

E. Any data files added to the tablespace must have a size of 5 gigabytes

A. It frees unused temporary segments

B. It frees resources held by abnormally terminated processes

C. It records checkpoint information in the control file

D. It registers database services with all local and remote listeners known to the database instance

E. It kills sessions that exceed idle time

A. A segment might have only one extent

B. A smallfile tablespace might be bigger than a bigfile tablespace

C. All tablespaces may have one or more data files

D. Segments can span multiple tablespaces

E. A segment can span multiple data files in some tablespaces

F. A segment's blocks can be of different sizes

G. The extents of a segment must always reside in the same datafile

A. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated

B. A block will always be eligible for inserts if the row is short enough to fit into the block

C. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows

D. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted

E. PCTFREE defaults to 10% for all blocks in all segments for all compression methods