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

Comment: *

Name: *

Email: *

Verification: *

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?

• A.SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';
• B.SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK
• C.SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';
• D.SELECT prod_id I I q' ('s not available) * 'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK
• E.SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;
• F.SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK

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: *

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

• A.Views can be updated without the need to re-grant privileges on the view
• B.Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• C.The WITH CHECK clause prevents certain rows from being displayed when querying the view
• D.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• E.The WITH CHECK clause prevents certain rows from being updated or inserted
• F.Data Manipulation Language (DML) can always be used on views
• G.Tables in the defining query of a view must always exist in order to create the view

Comment: *

Name: *

Email: *

Verification: *

Examine this command:
SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT
Which two statements are true?

• A.The shrink operation causes rows to be moved to empty space starting from the beginning of the orders segment.
• B.The high-water mark (HWM) of orders is adjusted.
• C.Only queries are allowed on ORDERS while the shrink is executing.
• D.Dependent indexes become UNUSABLE.
• E.The shrink operation causes rows to be moved to empty space starting toward the end of the orders segment.
• F.Queries and DML statements are allowed on ORDERS while the shrink is executing.

Comment: *

Name: *

Email: *

Verification: *