2022 Latest 1Z1-082 DUMPS Q&As with Explanations Verified & Correct Answers [Q13-Q31]

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

NO.14 Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

NO.15 View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:

Exhibit 1.

Exhibit 2.

What will be the result?

NO.16 Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

NO.17 Which three statements are true about table data storage in an Oracle Database? (Choose three.)

NO.18 Which three statements are true about data block storage in an Oracle Database?

NO.19 In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

NO.20 Which two statements are true about the Oracle Data Dictionary?

NO.21 Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)

NO.22 Which statement is true about aggregate functions?

NO.23 Examine the description of the PRODUCT_STATUS table:

The status column contains the values ‘in stock’ or ‘out of stock’ for each row.
Which two queries will execute successfully?

NO.24 A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql
What will happen upon execution?

NO.25 Which three statements are true about roles?

NO.26 In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

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

NO.28 The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

NO.29 Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

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

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