A.Data Manipulation Language (DML) can always be used on views

B.The WITH CHECK clause prevents certain rows from being displayed when querying the view

C.Views can be updated without the need to re-grant privileges on the view

D.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

E.Tables in the defining query of a view must always exist in order to create the view

F.The WITH CHECK clause prevents certain rows from being updated or inserted

G.Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

A.It registers database services with all local and remote listeners known to the database instance

B.It frees resources held by abnormally terminated processes

C.It records checkpoint information in the control file

D.It frees unused temporary segments

E.It kills sessions that exceed idle time

A.The sales user must have a quota on the TEMP tablespace

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 been granted the CREATE TABLE privilege

E.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

F.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

A.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;

B.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount !=NULL;

C.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;

D.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;

E.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_incoms_level IS NOT NULLAND due_amount IS NOT NULL;

A.Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

B.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

C.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

D.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

E.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times