SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID F

→ Technical MCQs
→ 2D Transformation And Answers in Technical MCQs
→ SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUS..


            
                        
                        

                             
                
                    
                        
                            
                                
                                    
                                    
                                    1.
                                
                                
                                    
                                        SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID16.The following SQL is which type of join?
                                    
                                
                            
                        

                        
                                                            
                                    A.
                                    Equi-join
                                    
                                
                                                            
                                    B.
                                    Natural join
                                    
                                
                                                            
                                    C.
                                    Outer join
                                    
                                
                                                            
                                    D.
                                    Cartesian join
                                    
                                
                                                    

                        
                            
                                
                                    Answer» E. 
                                
                            
                        

                        
                        
                            
                                
                                    
                                
                            
                        
                    
                    
                         
                    
                
            
            
             


            
                    Discussion
                
            
                
                                        No Comment Found
                                        
                        
                                                        
                            
                            
                                                        
                            
                            
                            
                                
                            
                        
                    
                
            



            
            
                Related MCQs
                
                                        
                        
                            <code>SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAMEFROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;</code>18.A SELECT statement can be used to perform these three functions:  - Choose rows from a table. - Choose columns from a table. - Bring together data that is stored in different tables by  creating a link between them.Which set of keywords describes these capabilities?
                        
                    
                                        
                        
                            <code>SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T</code>17.Evaluate this SQL statement: In the statement, which capabilities of a SELECT statement are performed?
                        
                    
                                        
                        
                            <code>SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID</code>16.The following SQL is which type of join?
                        
                    
                                        
                        
                            The following SQL is which type of join?
                        
                    
                                        
                        
                            Which of the following statement is TRUE about FULL OUTER JOIN created on two tables Table1 and Table2?
                        
                    
                                        
                        
                            A_____ is a query that retrieves rows from more than one table or view

`SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID`16.The following SQL is which type of join?

Discussion

No Comment Found

Related MCQs

Reply to Comment

1.	`SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID`16.The following SQL is which type of join?
A.	Equi-join
B.	Natural join
C.	Outer join
D.	Cartesian join
Answer» E.