Free Oracle 1Z1-082 Exam Dumps Questions & Answers

The customers table has a cust_last_name column of data type varchar2. The table has two rows whose "jst_last_name values are Andersen and Ausson. Which query produces output for cust_last_xame containing Oder for the first row and Aus for the second?

• A.  SELECT REPLACE<TRIM<TRAILING 'son* FROM cust_last_name), 'An', *O'> FROM customers;
• B.  SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;
• C.  SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;
• D.  SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;

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

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

Which three statements are true about inner and outer joins? (Choose three.)

• A.  An inner join returns matched rows
• B.  A full outer join returns matched and unmatched rows
• C.  Outer joins can only be used between two tables per query
• D.  A full outer join must use Oracle syntax
• E.  Outer joins can be used when there are multiple join conditions on two tables
• F.  A left or right outer join returns only unmatched rows

In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

• A.  Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
• B.  Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
• C.  Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
• D.  Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
• E.  Add the AUTOEXTEND ON clause with NEXT set to 100M.

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

• A.  Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
• B.  Usernames of all users including database administrators are stored in the data dictionary
• C.  Base tables can be queried directly
• D.  It is owned by the SYSTEM user
• E.  The data dictionary is created and maintained by the database administrator
• F.  Data dictionary views are created by joins of dictionary base tables and DBA-defined tables