Free Oracle 1Z1-082 Exam Dumps Questions & Answers

Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

• A.  Oracle Net Manager can be used to centrally configure listeners on any database server target
• B.  The lsnrctl utility requires a listener.ora file to exist before it is started
• C.  Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
• D.  Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target
• E.  Oracle Net Manager can be used to locally configure naming methods on a database server
• F.  The Oracle Net Configuration Assistant is only used when running the Oracle installer

Which two statements are true about segment types in an Oracle Database?

• A.  Cluster segments may contain data from multiple tables.
• B.  Index segments always have two or more extents.
• C.  Temporary segments are only stored in a temporary tablespace.
• D.  Undo segments are only stored in an undo tablespace.
• E.  Table segments always have two or more extents.

You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)

• A.  It is a locally managed tablespace
• B.  It must be smaller than the smallest BIGFILE tablespace
• C.  It uses the database default blocksize
• D.  Any data files added to the tablespace must have a size of 5 gigabytes
• E.  Free space is managed using freelists

Which three statements are true regarding single row subqueries?

• A.  They can be used in the having clause.
• B.  They can be used in the where clause.
• C.  They must be placed on the right side of the comparison operator or condition.
• D.  They must be placed on the left side of the comparison operator or condition.
• E.  A SQL statement may have multiple single row subquery blocks.
• F.  They must return a row to prevent errors in the SQL statement.

The sales table has columns prod_id and quantity_sold of data type number In two queries execute successfully? x

• A.  SELECT prod_id FROM sales WHERE quantity_sold > 5S000 AND COUNT(-) > 10 GROUP BY prod_id HAVING COUNT(-) > 10;
• B.  SELECT COUNTlprod_id> FROM sales GROUP BY prod_id WHERE quantity_Sold > 55000;
• C.  SELECT COUNT|prod_id> FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;
• D.  SELECT prod_id FROM sales WHERE quantity_scld > 55000 AND COUNT(-) > 10 GROUP BY COUNT(-) > 10;
• E.  SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(-) > 10;