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

Question 36

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

A.Private Temporary Tables (PTTS) store metadata in memory only
B.If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement
C.A table that is truncated will always have its segment removed
D.An index that is altered to be UNUSABLE will retain its segment
E.An index created with the UNUSABLE attribute has no segment

Question 37

Evaluate these commands which execute successfully:

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

A.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
B.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
C.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
D.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
E.Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

Question 38

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

A.It is available only when the database is open
B.It can be used to perform database recovery
C.The same port number can be used for Database Express configurations for databases on different hosts
D.It can be used to switch a database into ARCHIVELOGMODE
E.The same port number can be used for multiple Database Express configurations for multiple databases on the same host

Question 39

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

Question 40

View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

A.Display the total number of products supplied by supplier 102 which have a product status of obsolete
B.Display the minimum PROD_LIST_PRICE for each product status
C.Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
D.Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
E.Display suppliers whose PROD_LIST_PRICE is less than 1000

Question 36

Question 37

Question 38

Question 39

Question 40

Download PDF File