COF-C02 Question #220: Real Exam Question with Answer & Explanation

Question

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

Options

• Agrant USAGE on all tables in schema DB1. SCHEMA to role MYROLE;
• Bgrant USAGE on future tables in schema DB1. SCHEMA to role MYROLE;
• Cgrant SELECT on all tables in schema DB1. SCHEMA to role MYROLE;
• Dgrant SELECT on future tables in schema DB1. SCHEMA to role MYROLE;
• Egrant SELECT on all tables in database DB1 to role MYROLE;
• Fgrant SELECT on future tables in database DB1 to role MYROLE;