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

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

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

• A.SELECT * FROM customers WHERE city LIKE `D_%';
• B.SELECT * FROM customers WHERE city LIKE `D_';
• C.SELECT * FROM customers WHERE city = `D_%';
• D.SELECT * FROM customers WHERE city = `%D_';

Comment: *

Name: *

Email: *

Verification: *

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

• A.Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
• B.Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted
• C.PCTFREE defaults to 10% for all blocks in all segments for all compression methods
• D.ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
• E.A block will always be eligible for inserts if the row is short enough to fit into the block

Comment: *

Name: *

Email: *

Verification: *

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

• A.They can accept only one argument
• B.The data type returned can be different from the data type of the argument
• C.They can be used only in the WHERE clause of a SELECT statement
• D.They can be nested to any level
• E.They return a single result row per table
• F.The argument can be a column name, variable, literal or an expression

Comment: *

Name: *

Email: *

Verification: *

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

• A.Configure a nonstandard block size for a new database
• B.Register a new database with an available Enterprise Manager Management server
• C.Change the standard block size of an existing database
• D.Configure incremental backups for a new database
• E.Enable flashback database for an existing database

Comment: *

Name: *

Email: *

Verification: *