Which three statements are true about the DESCRIBE command? (Choose three.)

• A.It displays the NOT NULL constraint for any columns that have that constraint
• B.It can be used from SQL Developer
• C.It displays the PRIMARY KEY constraint for any column or columns that have that constraint
• D.It can be used to display the structure of an existing view
• E.It displays all constraints that are defined for each column
• F.It can be used only from SQL *Plus

Comment: *

Name: *

Email: *

Verification: *

Examine this command:
CREATE UNDO TABLESPACE undotbs01
DATAFILE `undotbs_01.dbf'
SIZE 100M
AUTOEXTEND ON;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

• A.Add the NOLOGGING clause
• B.Add the ONLINE clause
• C.Make certain that the database operates in automatic undo management mode
• D.Set UNDO_TABLESPACE to UNDOTBS01
• E.Add the SEGMENT SPACE MANAGEMENT AUTO clause

Comment: *

Name: *

Email: *

Verification: *

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 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 products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
• E.Display the minimum PROD_LIST_PRICE for each product status

Comment: *

Name: *

Email: *

Verification: *

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

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