Try Oracle : 1Z0-082 valid & accurate questions and answers

Examine the description of the members table:

Examine the partial query:
SELECT city, last__name 1NAME FROM members
You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query?

• A. WHERE city IN (?AN%')
• B. ORDER BY 1, 2
• C. ORDER BY last_narae DESC, city ASC
• D. WHERE city LIKE *%AN%*
• E. WHERE city = =%AN%'
• F. ORDER BY 1, LNAME DESC

Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

• A. the number of days for which an account may be inactive before it is locked
• B. the number of password changes required within a period of time before a password can be reused
• C. the number of days for which an account is locked after the configured number of login attempts has been reached
• D. the ability to prevent a password from ever being reused
• E. the maximum number of sessions permitted for a user before the account is locked
• F. the number of hours for which an account is locked after the configured number of login attempts has been reached
• G. the maximum amount of CPU time allowed for a user's sessions before their account is locked

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

• A. Primary key and foreign key constraints can be defined at both the column and table level
• B. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
• C. A table can have only one primary key and one foreign key
• D. Only the primary key can be defined at the column and table level
• E. The foreign key columns and parent table primary key columns must have the same names
• F. A table can have only one primary key but multiple foreign keys
• G. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

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 100 will have SALARY set to the same value as the SALARY of employee 200
• C. Employee 200 will have SALARY set to the same value as the SALARY of employee 100
• D. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
• E. Employees 100 and 200 will have the same SALARY as before the update command
• F. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

Examine these commands:

Which two statements are true about the sqiidr execution?

• A. It overwrites the data for Alan and adds data for Curl and Bob
• B. It generates a sqi script that it uses to load data from EMP.DAT TO EMP.
• C. It generates a log that contains control file entries, which can be used with normal SQL'Loader operations.
• D. It overwrites all data in emp with data from emp.dat.
• E. It appends data from EMP.DAT TO EMP.