The Relational Database Model MCQs | Database Management System

MCQ

51.

The assignment operator is denoted by

Discussion

MCQ

52.

Find the ID, name, dept name, salary for instructors whose salary is greater than $80,000 .

{t | t ? instructor ? t[salary] > 80000}

? t ? r (Q(t))

{t | ? s ? instructor (t[ID] = s[ID]? s[salary] > 80000)}

None of the mentioned

Discussion

MCQ

53.

A query in the tuple relational calculus is expressed as:

{t | P() | t}

{P(t) | t }

{t | P(t)}

All of the mentioned

Discussion

MCQ

54.

Which of the following best describes the query?


{t | ? s ? instructor (t[name] = s[name]
? ? u ? department (u[dept name] = s[dept name]
? u[building] =



                                
                                                                                                                        
                                                
                                                
                                                
                                                    A                                                
                                                
                                                
                                                    Finds the names of all instructors whose department is in the Watson building                                                
                                            
                                                                                    
                                                
                                                
                                                
                                                    B                                                
                                                
                                                
                                                    Finds the names of all department is in the Watson building                                                
                                            
                                                                                    
                                                
                                                
                                                
                                                    C                                                
                                                
                                                
                                                    Finds the name of the dapartment whose instructor and building is Watson                                                
                                            
                                                                                    
                                                
                                                
                                                
                                                    D                                                
                                                
                                                
                                                    Returns the building name of all the departments                                                
                                            
                                                                                                            

                                
                                    Correct Answer: A
                                    None.



                        
                            

                            
                            
                                                        
                                forum Discussion


                                        
                    
                        
                            
                            
                                
                                    report Report Error
                                
                                
                            

                            
                                
                                
                                    Select Issue Type
                                    
                                                                                
                                            
                                            Wrong Question
                                        
                                                                                
                                            
                                            Wrong Answer
                                        
                                                                                
                                            
                                            Formatting Issue
                                        
                                                                                
                                            
                                            No Solution
                                        
                                                                                
                                            
                                            Wrong Translation
                                        
                                                                                
                                            
                                            Copyright Issue
                                        
                                                                                
                                            
                                            Others
                                        
                                                                            
                                

                                
                                    
                                        
                                            Selected Issue
                                            
                                        
                                        
                                    

                                    
                                        Please provide more details (Optional)
                                    
                                    
                                
                                
                            

                            
                                
                                
                            
                        
                    
                    
                    
                                    
                        
                            
                                MCQ                            
                            
                        

                        
                            
                            
                                
                                    55.
                                    Which of the following symbol is used in the place of except?
                                

                                
                                                                                                                        
                                                
                                                
                                                
                                                    A                                                
                                                
                                                
                                                    ^                                                
                                            
                                                                                    
                                                
                                                
                                                
                                                    B                                                
                                                
                                                
                                                    V                                                
                                            
                                                                                    
                                                
                                                
                                                
                                                    D                                                
                                                
                                                
                                                    ~                                                
                                            
                                                                                                            

                                
                                    Correct Answer: C
                                    None.
                                
                            
                        

                        
                            

                            
                            
                                                        
                                forum Discussion
                            
                        
                    
                                        
                    
                        
                            
                            
                                
                                    report Report Error
                                
                                
                            

                            
                                
                                
                                    Select Issue Type
                                    
                                                                                
                                            
                                            Wrong Question
                                        
                                                                                
                                            
                                            Wrong Answer
                                        
                                                                                
                                            
                                            Formatting Issue
                                        
                                                                                
                                            
                                            No Solution
                                        
                                                                                
                                            
                                            Wrong Translation
                                        
                                                                                
                                            
                                            Copyright Issue
                                        
                                                                                
                                            
                                            Others
                                        
                                                                            
                                

                                
                                    
                                        
                                            Selected Issue
                                            
                                        
                                        
                                    

                                    
                                        Please provide more details (Optional)
                                    
                                    
                                
                                
                            

                            
                                
                                
                            
                        
                    
                    
                                            
                            
                        
                    
                                    
                        
                            
                                MCQ                            
                            
                        

                        
                            
                            
                                
                                    56.
                                    
                                

                                
                                                                                                                        
                                                
                                                
                                                
                                                    A                                                
                                                
                                                
                                                    ? t ? r (Q(t))                                                
                                            
                                                                                    
                                                
                                                
                                                
                                                    B                                                
                                                
                                                
                                                    ? t ? r (Q(t))                                                
                                            
                                                                                    
                                                
                                                
                                                
                                                    D                                                
                                                
                                                
                                                    ~ t ? r (Q(t))                                                
                                            
                                                                                                            

                                
                                    Correct Answer: B
                                    None.
                                
                            
                        

                        
                            

                            
                            
                                                        
                                forum Discussion
                            
                        
                    
                                        
                    
                        
                            
                            
                                
                                    report Report Error
                                
                                
                            

                            
                                
                                
                                    Select Issue Type
                                    
                                                                                
                                            
                                            Wrong Question
                                        
                                                                                
                                            
                                            Wrong Answer
                                        
                                                                                
                                            
                                            Formatting Issue
                                        
                                                                                
                                            
                                            No Solution
                                        
                                                                                
                                            
                                            Wrong Translation
                                        
                                                                                
                                            
                                            Copyright Issue
                                        
                                                                                
                                            
                                            Others
                                        
                                                                            
                                

                                
                                    
                                        
                                            Selected Issue
                                            
                                        
                                        
                                    

                                    
                                        Please provide more details (Optional)
                                    
                                    
                                
                                
                            

                            
                                
                                
                            
                        
                    
                    
                    
                                    
                        
                            
                                MCQ                            
                            
                        

                        
                            
                            
                                
                                    57.
                                    Which of the following is the comparison operator in tuple relational calculus
                                

                                
                                                                                                                        
                                                
                                                
                                                
                                                    A                                                
                                                
                                                
                                                    ?                                                
                                            
                                                                                    
                                                
                                                
                                                
                                                    B                                                
                                                
                                                
                                                    =                                                
                                            
                                                                                    
                                                
                                                
                                                
                                                    C                                                
                                                
                                                
                                                    ?                                                
                                            
                                                                                    
                                                
                                                
                                                
                                                    D                                                
                                                
                                                
                                                    All of the mentioned                                                
                                            
                                                                                                            

                                
                                    Correct Answer: B
                                    None.
                                
                            
                        

                        
                            

                            
                            
                                                        
                                forum Discussion
                            
                        
                    
                                        
                    
                        
                            
                            
                                
                                    report Report Error
                                
                                
                            

                            
                                
                                
                                    Select Issue Type
                                    
                                                                                
                                            
                                            Wrong Question
                                        
                                                                                
                                            
                                            Wrong Answer
                                        
                                                                                
                                            
                                            Formatting Issue
                                        
                                                                                
                                            
                                            No Solution
                                        
                                                                                
                                            
                                            Wrong Translation
                                        
                                                                                
                                            
                                            Copyright Issue
                                        
                                                                                
                                            
                                            Others
                                        
                                                                            
                                

                                
                                    
                                        
                                            Selected Issue
                                            
                                        
                                        
                                    

                                    
                                        Please provide more details (Optional)
                                    
                                    
                                
                                
                            

                            
                                
                                
                            
                        
                    
                    
                    
                                    
                        
                            
                                MCQ                            
                            
                        

                        
                            
                            
                                
                                    58.
                                    An expression in the domain relational calculus is of the form
                                

                                
                                                                                                                        
                                                
                                                
                                                
                                                    A                                                
                                                
                                                
                                                    {P(x1, x2, . . . , xn) | < x1, x2, . . . , xn > }                                                
                                            
                                                                                    
                                                
                                                
                                                
                                                    B                                                
                                                
                                                
                                                    {x1, x2, . . . , xn | < x1, x2, . . . , xn > }                                                
                                            
                                                                                    
                                                
                                                
                                                
                                                    C                                                
                                                
                                                
                                                    { x1, x2, . . . , xn | x1, x2, . . . , xn}                                                
                                            
                                                                                    
                                                
                                                
                                                
                                                    D                                                
                                                
                                                
                                                    {< x1, x2, . . . , xn > | P(x1, x2, . . . , xn)}                                                
                                            
                                                                                                            

                                
                                    Correct Answer: D
                                    None.
                                
                            
                        

                        
                            

                            
                            
                                                        
                                forum Discussion
                            
                        
                    
                                        
                    
                        
                            
                            
                                
                                    report Report Error
                                
                                
                            

                            
                                
                                
                                    Select Issue Type
                                    
                                                                                
                                            
                                            Wrong Question
                                        
                                                                                
                                            
                                            Wrong Answer
                                        
                                                                                
                                            
                                            Formatting Issue
                                        
                                                                                
                                            
                                            No Solution
                                        
                                                                                
                                            
                                            Wrong Translation
                                        
                                                                                
                                            
                                            Copyright Issue
                                        
                                                                                
                                            
                                            Others
                                        
                                                                            
                                

                                
                                    
                                        
                                            Selected Issue
                                            
                                        
                                        
                                    

                                    
                                        Please provide more details (Optional)

Banking

Engineering

General

Medical

The Relational Database Model Questions

Report Error

Report Error

Report Error

Report Error

Report Error

Report Error

Report Error

Report Error