Oracle 1Z0-051 Questions Answers

Which two statements are true regarding views? (Choose two.)

A. A sub query that defines a view cannot include the GROUP BY clause
B. A view is created with the sub query having the DISTINCT keyword can be updated
C. A Data Manipulation Language (DML) operation can be performed on a view that is created with the sub query having all the NOT NULL columns of a table
D. A view that is created with the sub query having the pseudo column ROWNUM keyword cannot be updated

Answer: CD
 

Which statements are regarding indexes? (Choose all that apply.)

A. For each data manipulation language (DML) operation performed, the corresponding indexes are automatically updated.
B. A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.
C. A FOREIGN KEY constraint on a column in a table automatically creates a non unique key
D. When a table is dropped, the corresponding indexes are automatically dropped

Answer: ABD

 

 https://ccsdschools.instructure.com/eportfolios/1708/Central_Technical_School/HuaweiHCS_Pre_Sale_IVS_Huawei_Certified_Presales_Specialist_IVS
https://atsu.instructure.com/eportfolios/386/Accelerated_Academy/VMwareProfessional_VMware_NSXT_Data_Center
https://ycs.instructure.com/eportfolios/234/Ravenwood_High/AmazonAWS_Certified_Solutions_ArchitectProfessional
https://iebh.instructure.com/eportfolios/732/Foundations_Academy/CompTIA_SY0601
https://umarycontinuinged.instructure.com/eportfolios/2140/Cypress_University/Splunk_Core_Certified_Consultant_SPLK3003