100% Real & Accurate 1Z0-082 Questions and Answers with Free and Fast Updates [Q30-Q49]

NO.30 Examine this SQL statement:
SELECT cust_id, cust_last_name “Last Name”
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully.
(Choose three.)

NO.31 Which two functions are performed by a listener?

NO.32 Which three activities are recorded in the database alert log? (Choose three.)

NO.33 Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

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

NO.35 You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE ‘/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

NO.36 You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

NO.37 You want to use table compression suitable for OLTP that will:
Compress rows for all DML statements on that table
Minimize the overheads associated with compression
Which compression option is best suited for this?

NO.38 Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

NO.39 Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

NO.40 In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

NO.41 Which two statements are true about the DUAL table? (Choose two.)

NO.42 Which two tasks can you perform using DBCA for databases? (Choose two.)

NO.43 Which two statements are true about the rules of precedence for operators? (Choose two.)

NO.44 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.)

NO.45 Which three statements are true about single-row functions? (Choose three.)

NO.46 Which two are true about the roles? (Choose two.)

NO.47 Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

NO.48 You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

NO.49 Examine this command and some partial output:

Why does the DB01.abc.comservice show unknown status?