Oracle Database 12c R2: SQL and PL/SQL Fundamentals Ed 2 Quiz Questions and Answers 
        
        
            
                
                    
                       
                        
                                   
                                       
                                       
                                           
                                               Explanation : 
                                               
                                           <p>The INSERT statement is used to add one or more rows to a table</p>
                                               
                                               
                                        
                                    
                                   
                                       
                                       
                                           
                                               Answer : 
                                               
                                                                                                                  - Limits the row data are returned
 
                                               Explanation : 
                                               
                                           NULL
                                               
                                               
                                        
                                    
                                   
                                       
                                       
                                           
                                               Answer : 
                                               
                                                               - COUNT, SUM, AVG, MAX, MIN
 
                                               Explanation : 
                                               
                                           NULL
                                               
                                               
                                        
                                    
                                   
                                       
                                       
                                           
                                               Answer : 
                                               
                                                                                                                                                                                                                        - A) Data types 
 B) Primary keys
 C) Default values
 All of the above
 
                                               Explanation : 
                                               
                                           abc
                                               
                                               
                                        
                                    
                                   
                                       
                                       
                                           
                                               Answer : 
                                               
                                                                                                                                                                     - DELETE FROM CUSTOMER WHERE ...
 
                                        
                                    
                                   
                                       
                                       
                                           
                                               Answer : 
                                               
                                                                                                                                                                                                                        - A) To specify the syntax and semantics of SQL data definition language 
 B) To specify the syntax and semantics of SQL manipulation language
 C) To define the data structures
 All of the above