Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)

• A.SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;
• B.SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
• C.SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
• D.SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;
• E.SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

Comment: *

Name: *

Email: *

Verification: *

Which three are types of segments in an Oracle Database? (Choose three.)

• A.sequences
• B.undo
• C.clusters
• D.stored procedures
• E.tables
• F.index

Comment: *

Name: *

Email: *

Verification: *

Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)

• A.one instance on one server not associated with any database
• B.one instance on one server associated with one database
• C.one instance on one server associated with two or more databases on the same server
• D.one instance on one server associated with two or more databases on separate servers
• E.two or more instances on separate servers all associated with one database

Comment: *

Name: *

Email: *

Verification: *

Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

• A.It overwrites data in EMP with data in EMP.DAT
• B.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
• C.It appends data from EMP.DAT to EMP
• D.It uses the database buffer cache to load data
• E.It generates a sql script that it uses to load data from EMP.DAT to EMP

Comment: *

Name: *

Email: *

Verification: *

You execute this command:

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

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

Comment: *

Name: *

Email: *

Verification: *