Question Discussion & Solution

MCQ

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.



            
                
                    
                    
                        
                            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)
                            
                            
                        
                        
                    

                    
                        
                        
                    
                
            
            
                

            
            
                
                    forum Community Discussion
                
                
                
                    
                                        
                    
                        
                        
                            speaker_notes_off
                            No discussions yet. Be the first to start!
                        
                        
                        
                            
                                sync
                                Loading more...
                            
                        
                        
                    

                    
                                                    
                                You must be logged in to participate in the discussion.
                                
                                    login Login to Discuss
                                
                            
                                            
                
            

                            
                    
                        auto_awesome Similar Questions
                    
                
                
                
                    
    
        
            
                MCQ            
            
        

        
            
                1.
                Which one of the following attribute can be taken as a primary key?
            

            
                                                            
                            
                            A
                            
                                Name                            
                        
                                            
                            
                            B
                            
                                Street                            
                        
                                            
                            
                            C
                            
                                Id                            
                        
                                            
                            
                            D
                            
                                Department                            
                        
                                                

            
                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            
            
        

        
            
                2.
                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            
            
        

        
            
                3.
                Which one of the following cannot be taken as a primary key?
            

            
                                                            
                            
                            A
                            
                                Id                            
                        
                                            
                            
                            B
                            
                                Register number                            
                        
                                            
                            
                            C
                            
                                Dept_id                            
                        
                                            
                            
                            D
                            
                                Street                            
                        
                                                

            
                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)
                    
                    
                
            

            
                
                
            
        
    
    
    
        
            
                MCQ            
            
        

        
            
                4.
                Which of the following operation is used if we are interested in only certain columns of a
table?
            

            
                                                            
                            
                            A
                            
                                PROJECTION                            
                        
                                            
                            
                            B
                            
                                SELECTION                            
                        
                                            
                            
                            C
                            
                                UNION                            
                        
                                            
                            
                            D
                            
                                JOIN                            
                        
                                                

            
                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            
            
        

        
            
                5.
                Natural join is equal to?
            

            
                                                            
                            
                            A
                            
                                Cartesian Product                            
                        
                                            
                            
                            B
                            
                                Combination of Union and Cartesian product                            
                        
                                            
                            
                            C
                            
                                Combination of selection and Cartesian product                            
                        
                                            
                            
                            D
                            
                                Combination of projection and Cartesian product                            
                        
                                                

            
                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)
                    
                    
                
            

            
                
                
            
        
    
                    
            
            
                
                    category More Database Management System Topics
                
            

            
                                    
                        
                            
                            
                                article
                            
                            
                            
                                Miscellaneous or General                            
                            
                            
                                format_list_bulleted
                                71 MCQs
                            
                        
                        
                        
                            
                                Practice arrow_forward
                            
                        
                    
                                    
                        
                            
                            
                                article
                            
                            
                            
                                Relational Algebra                            
                            
                            
                                format_list_bulleted
                                3 MCQs
                            
                        
                        
                        
                            
                                Practice arrow_forward
                            
                        
                    
                                    
                        
                            
                            
                                article
                            
                            
                            
                                Database Systems                            
                            
                            
                                format_list_bulleted
                                49 MCQs
                            
                        
                        
                        
                            
                                Practice arrow_forward
                            
                        
                    
                                    
                        
                            
                            
                                article
                            
                            
                            
                                Data Models                            
                            
                            
                                format_list_bulleted
                                16 MCQs
                            
                        
                        
                        
                            
                                Practice arrow_forward
                            
                        
                    
                                    
                        
                            
                            
                                article
                            
                            
                            
                                The Relational Database Model                            
                            
                            
                                format_list_bulleted
                                58 MCQs
                            
                        
                        
                        
                            
                                Practice arrow_forward
                            
                        
                    
                                    
                        
                            
                            
                                article
                            
                            
                            
                                Entity Relationship (ER) Modeling                            
                            
                            
                                format_list_bulleted
                                59 MCQs
                            
                        
                        
                        
                            
                                Practice arrow_forward
                            
                        
                    
                                    
                        
                            
                            
                                article
                            
                            
                            
                                Advanced Data Modeling                            
                            
                            
                                format_list_bulleted
                                1 MCQs
                            
                        
                        
                        
                            
                                Practice arrow_forward
                            
                        
                    
                                    
                        
                            
                            
                                article
                            
                            
                            
                                Normalization                            
                            
                            
                                format_list_bulleted
                                58 MCQs
                            
                        
                        
                        
                            
                                Practice arrow_forward
                            
                        
                    
                                    
                        
                            
                            
                                article
                            
                            
                            
                                Structured Query Language (SQL)                            
                            
                            
                                format_list_bulleted
                                7 MCQs
                            
                        
                        
                        
                            
                                Practice arrow_forward
                            
                        
                    
                                    
                        
                            
                            
                                article
                            
                            
                            
                                Advanced SQL                            
                            
                            
                                format_list_bulleted
                                90 MCQs
                            
                        
                        
                        
                            
                                Practice arrow_forward
                            
                        
                    
                                    
                        
                            
                            
                                article
                            
                            
                            
                                Database Design                            
                            
                            
                                format_list_bulleted
                                2 MCQs
                            
                        
                        
                        
                            
                                Practice arrow_forward
                            
                        
                    
                                    
                        
                            
                            
                                article
                            
                            
                            
                                Transaction and Concurrency                            
                            
                            
                                format_list_bulleted
                                10 MCQs
                            
                        
                        
                        
                            
                                Practice arrow_forward
                            
                        
                    
                                    
                        
                            
                            
                                article
                            
                            
                            
                                Data Warehouses                            
                            
                            
                                format_list_bulleted
                                10 MCQs
                            
                        
                        
                        
                            
                                Practice arrow_forward
                            
                        
                    
                                    
                        
                            
                            
                                article
                            
                            
                            
                                Database Administration                            
                            
                            
                                format_list_bulleted
                                1 MCQs
                            
                        
                        
                        
                            
                                Practice arrow_forward
                            
                        
                    
                                    
                        
                            
                            
                                article
                            
                            
                            
                                Mixed                            
                            
                            
                                format_list_bulleted
                                10 MCQs
                            
                        
                        
                        
                            
                                Practice arrow_forward



    
    

    
        
            
            
                
                    
                        school
                    
                    
                        ExaMocks                    
                
                
                    At ExaMocks, we believe that anyone can achieve their goals with the right practice. We are on a mission to reshape exam preparation with a best-in-class mock test experience.
                
                
                    
                
            
            
            
                Explore
                
                    chevron_right Browse Exams
                    workspace_premium Premium Pass
                    terminal Computer Science MCQ
                    android Android App
                
            

            
                Get in Touch
                
                    
                        
                            email
                        
                        
                            Email Support
                            
                                support@examocks.in                            
                        
                    
                                        
                        
                            call
                        
                        
                            Call Us
                            
                                6375051814                            
                        
                    
                                    
            
            
        

        
            
                © 2026 ExaMocks. All rights reserved.
            
            
                Terms
                Privacy
                Contact

Banking

Engineering

General

Medical

Question Discussion & Solution

Report Error

Community Discussion

Similar Questions

Report Error

Report Error

Report Error

Report Error

Report Error

More Database Management System Topics

Miscellaneous or General

Relational Algebra

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER) Modeling

Advanced Data Modeling

Normalization

Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction and Concurrency

Data Warehouses

Database Administration

Mixed