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

Which two statements are true about the Oracle Data Dictionary?

• A.It is owned by the system user.
• B.Data dictionary views are always created with queries that join two or more base tables.
• C.Data dictionary base tables can be queried directly.
• D.It is owned by the sys user.
• E.All data dictionary view joins base tables to dynamic performance views.

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

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

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)

• A.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;
• B.SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
• C.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;
• D.SELECT customer_id AS `CUSTOMER-ID', transaction_date AS DATE, amount + 100 `DUES AMOUNT' FROM transactions;
• E.SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100
  "DUES AMOUNT" FROM transactions;

You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), `MON'), `dd "Monday for"
fmMonth rrrr')
What is the result?

• A.It returns the date for the last Monday of the current month
• B.It executes successfully but does not return any result
• C.It returns the date for the first Monday of the next month
• D.It generates an error

You must create a tablespace of non-standard block size in a new file system and plan to use this command:

The standard block size is 8k but other non-standard block sizes will also be used. Which two are requirements for this command to succeed?

• A.d3_32k_cache_size should be set to a value greater than db_cache_size.
• B.db_32k_cache_size must be set to a value that can be accommodated in the SGA.
• C.The operating system must use a 32k block size.
• D.db_cache_s:ze must be set to a size that is smaller than db_32k_cache_size.
• E.The /u02 file system must have at least lOOg space for the datafile.
• F.db_32r_cache_si2e must be less than db_ca=he_size.