Free Access to Oracle.1Z1-082.v2023-12-08.q100 with Valid Practice Test (Page 17)

Question 76

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

A.Employees 100 and 200 will have the same JOB_ID as before the update command
B.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
C.Employees 100 and 200 will have the same SALARY as before the update command
D.Employee 100 will have SALARY set to the same value as the SALARY of employee 200
E.Employee 200 will have SALARY set to the same value as the SALARY of employee 100
F.Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

Question 77

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

Question 78

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?

A.It executes successfully and gives the required result
B.It gives an error because the GROUP BY clause is not valid
C.It executes successfully but does not give the required result
D.It gives an error because the ALL keyword is not valid

Question 79

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

A.Dynamic service registration cannot be used for this database instance
B.The LREG process registers services dynamically with the LISTENER_1 listener
C.LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
D.There are two listeners named LISTENER and LISTENER_1 running simultaneously using port
1521 on the same host as the database instances
E.The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Question 80

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

A.It can display multiple rows and columns
B.It can display multiple rows but only a single column
C.It can be used to display only constants or pseudo columns
D.It can be accessed by any user who has the SELECT privilege in any schema
E.It can be accessed only by the SYS user
F.It consists of a single row and single column of VARCHAR2 data type

Question 76

Question 77

Question 78

Question 79

Question 80

Download PDF File