1Z0-082 無料問題集「Oracle Database Administration I」

（A）EXPIRY_ DATE contains the sysdate by default if no date is assigned to it.

（B）EXPIRY_ DATE cannot be used in arithmetic expressions.

（C）PRODUCT _ic can be assigned the PRIMARY KEY constraint.

（D）PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.

（E）PRODUCT_NAKE cannot contain duplicate values.

（F）PRODUCT _price contains the value zero by default if no value is assigned to it.

（A）The query must use two different aliases for the table

（B）It must be an equijoin

（C）It must be an inner join

（D）The ON clause must be used

（E）It can be an outer join

（F）The ON clause can be used

（A）It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

（B）Primary key and foreign key constraints can be defined at both the column and table level

（C）Only the primary key can be defined at the column and table level

（D）The foreign key columns and parent table primary key columns must have the same names

（E）A table can have only one primary key and one foreign key

（F）It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

（G）A table can have only one primary key but multiple foreign keys

（A）d3_32k_cache_size should be set to a value greater than db_cache_size.

（B）db_cache_s:ze must be set to a size that is smaller than db_32k_cache_size.

（C）The operating system must use a 32k block size.

（D）The /u02 file system must have at least lOOg space for the datafile.

（E）db_32r_cache_si2e must be less than db_ca=he_size.

（F）db_32k_cache_size must be set to a value that can be accommodated in the SGA.

（A）It can be used in SQL Developer and SQL*Plus

（B）It displays values for variables created by the DEFINE command

（C）It displays values for variables used only in the WHERE clause of a query

（D）It displays values for variables prefixed with &&

（E）It can be used only in SQL*Plus

（A）A full outer join returns matched and unmatched rows

（B）Outer joins can be used when there are multiple join conditions on two tables

（C）A left or right outer join returns only unmatched rows

（D）A full outer join must use Oracle syntax

（E）An inner join returns matched rows

（F）Outer joins can only be used between two tables per query

（A）Data block headers contain their own Data Block Address (DBA)

（B）Index block free space is always contiguous in the middle of the block

（C）Data block free space is always contiguous in the middle of the block

（D）Multiple row pieces from the same row may be stored in the same block

（E）Multiple row pieces from the same row may be stored in different database blocks

（F）A table row piece can be chained across several database blocks

（A）Operating System authentication may be used for system-privileged administrative users.

（B）Password File authentication must be used for system-privileged administrative users.

（C）REKOTE_LOGIN_PASSMOREFiLE must be set to exclusive to permit password changes for system-privileged administrative users.

（D）Password File authentication is supported for any type of database user.

（E）Password authentication must be used for system-privileged administrative users.

（A）The BETWEEN condition always performs less well than using the >= and <= conditions

（B）Table aliases can improve performance

（C）The BETWEEN condition always performs better than using the >= and <= conditions

（D）The join syntax used makes no difference to performance

（E）The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

（A）SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;

（B）SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

（C）SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

（D）SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;

（E）SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;