SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAMEFRO

→ Technical MCQs
→ 2D Transformation And Answers in Technical MCQs
→ SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMEN..


            
                        
                        

                             
                
                    
                        
                            
                                
                                    
                                    
                                    1.
                                
                                
                                    
                                        SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAMEFROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;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?
                                    
                                
                            
                        

                        
                                                            
                                    A.
                                    difference, projection, join
                                    
                                
                                                            
                                    B.
                                    selection, projection, join
                                    
                                
                                                            
                                    C.
                                    Selection, intersection, join
                                    
                                
                                                            
                                    D.
                                    Intersection, projection, join
                                    
                                
                                                            
                                    E.
                                    
                                    
                                
                                                    

                        
                            
                                
                                    Answer» C. Selection, intersection, join
                                
                            
                        

                        
                        
                            
                                
                                    
                                
                            
                        
                    
                    
                         
                    
                
            
            
             


            
                    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

1.	`SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAMEFROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;`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?
A.	difference, projection, join
B.	selection, projection, join
C.	Selection, intersection, join
D.	Intersection, projection, join
E.
Answer» C. Selection, intersection, join

Discussion

No Comment Found

Related MCQs

Reply to Comment