1Z1-082 試験問題を無料オンラインアクセス

Which two statements are true?

• A.SALES1 is created with 55,000 rows.
• B.SALES1 is created with no rows.
• C.SALES1 has not NULL constraints on any selected columns which had those constraints in the sales table.
• D.SALES1 has primary key and unique constraints on any selected columns which had those constraints in the sales table.
• E.SALES1 is created with 1 row.

Which three statements are true concerning logical and physical database structures? (Choose three.)

• A.A segment can span multiple data files in some tablespaces
• B.A segment might have only one extent
• C.The extents of a segment must always reside in the same datafile
• D.Segments can span multiple tablespaces
• E.All tablespaces may have one or more data files
• F.A smallfile tablespace might be bigger than a bigfile tablespace
• G.A segment's blocks can be of different sizes

Which three statements are true about views in an Oracle database? (Choose three.)

• A.Tables in the defining query of a view must always exist in order to create the view
• B.The WITH CHECK clause prevents certain rows from being displayed when querying the view
• C.Data Manipulation Language (DML) can always be used on views
• D.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• E.Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• F.Views can be updated without the need to re-grant privileges on the view
• G.The WITH CHECK clause prevents certain rows from being updated or inserted

Which two statements are true about views used for viewing tablespace and datafile information?
(Choose two.)

• A.Tablespace free space can be viewed in DBA_TABLESPACES
• B.A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened
• C.V$TABLESPACE displays information about tablespaces contained in the data dictionary
• D.V$TABLESPACE displays information that is contained in the controlfile about tablespaces
• E.Tablespace free space can be viewed in V$TABLESPACE

Which statement is true about the INTERSECT operator used in compound queries?

• A.It processes NULLs in the selected columns
• B.Multiple INTERSECT operators are not possible in the same SQL statement
• C.It ignores NULLs
• D.INTERSECT is of lower precedence than UNION or UNION ALL