You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

• A.It must be bigger than the largest SMALLFILE tablespace
• B.AUTOEXTEND is possible for the datafile
• C.It will be a dictionary-managed tablespace by default
• D.Additional data files may not be added
• E.It will always have a 32K blocksize

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 number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
• B.Display the total number of products supplied by supplier 102 which have a product status of obsolete
• 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 minimum PROD_LIST_PRICE for each product status
• E.Display suppliers whose PROD_LIST_PRICE is less than 1000

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

• A.It must be the name of the server running the database to whose instance HR wishes to connect
• B.It must be the name of the database to whose instance HR wishes to connect
• C.It must resolve to a valid connect descriptor in the server's tnsnames.ora file
• D.It must be the value of the SERVICE_NAMES parameter on the client side
• E.It must resolve to a valid connect descriptor in the client's tnsnames.ora file

Comment: *

Name: *

Email: *

Verification: *

Which three object types support deferred segment creation? (Choose three.)

• A.external tables
• B.temporary tables
• C.index organized tables
• D.clustered tables
• E.partitioned tables
• F.heap organized tables

Comment: *

Name: *

Email: *

Verification: *

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

• A.The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
• B.The sales user must have been granted the CREATE SESSION privilege
• C.The sales user must have their quota on the users tablespace removed
• D.The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
• E.The sales user must have a quota on the TEMP tablespace
• F.The sales user must have been granted the CREATE TABLE privilege

Comment: *

Name: *

Email: *

Verification: *