alternative
  • Home (current)
  • About
  • Tutorial
    Technologies
    C#
    Deep Learning
    Statistics for AIML
    Natural Language Processing
    Machine Learning
    SQL -Structured Query Language
    Python
    Ethical Hacking
    Placement Preparation
    Quantitative Aptitude
    View All Tutorial
  • Quiz
    C#
    SQL -Structured Query Language
    Quantitative Aptitude
    Java
    View All Quiz Course
  • Q & A
    C#
    Quantitative Aptitude
    Java
    View All Q & A course
  • Programs
  • Articles
    Identity And Access Management
    Artificial Intelligence & Machine Learning Project
    How to publish your local website on github pages with a custom domain name?
    How to download and install Xampp on Window Operating System ?
    How To Download And Install MySql Workbench
    How to install Pycharm ?
    How to install Python ?
    How to download and install Visual Studio IDE taking an example of C# (C Sharp)
    View All Post
  • Tools
    Program Compiler
    Sql Compiler
    Replace Multiple Text
    Meta Data From Multiple Url
  • Contact
  • User
    Login
    Register

SQL -Structured Query Language - SQL Table - Alter - Rename Table Quiz

# Quiz
1
Discuss
Alter - Rename Table
Name
Annie
Bob
Callie
Derek

Which of these queries will display the table given above?

  • 1]

    Select employee from name

  • 2]

    Select name

  • 3]

    Select name from employee

  • 4]

    Select employee

Solution
2
Discuss
Alter - Rename Table

Here which of the following displays the unique values of the column?

SELECT ________ dept_name 
FROM instructor;

 

  • 1]

    All

  • 2]

    From

  • 3]

    Distinct

  • 4]

    Name

Solution
3
Discuss
Alter - Rename Table

The query given below will not give an error. Which one of the following has to be replaced to get the desired output?

SELECT ID, name, dept name, salary * 1.1
WHERE instructor;

 

  • 1]

    Salary*1.1

  • 2]

    ID

  • 3]

    Where

  • 4]

    Instructor

Solution
4
Discuss
Alter - Rename Table

This Query can be replaced by which one of the following?

SELECT name, course_id
FROM instructor, teaches
WHERE instructor_ID= teaches_ID;

 

  • 1]

    Select name,course_id from teaches,instructor where instructor_id=course_id;

  • 2]

    Select name, course_id from instructor natural join teaches;

  • 3]

    Select name, course_id from instructor;

  • 4]

    Select course_id from instructor join teaches;

Solution
5
Discuss
Alter - Rename Table
SELECT * FROM employee WHERE salary>10000 AND dept_id=101;

Which of the following fields are displayed as output?

  • 1]

    Salary, dept_id

  • 2]

    Employee

  • 3]

    Salary

  • 4]

    All the field of employee relation

Solution
6
Discuss
Alter - Rename Table
Employee_id Name Salary
1001 Annie 6000
1009 Ross 4500
1018 Zeith 7000

This is the Employee table.
Which of the following employee_id will be displayed for the given query?

SELECT * FROM employee WHERE employee_id>1009;

 

  • 1]

    1009, 1001, 1018

  • 2]

    1009, 1018

  • 3]

    1001

  • 4]

    1018

Solution
7
Discuss
Alter - Rename Table

Which of the following statements contains an error?

  • 1]

    Select * from emp where empid = 10003;

  • 2]

    Select empid from emp where empid = 10006;

  • 3]

    Select empid from emp;

  • 4]

    Select empid where empid = 1009 and lastname = ‘GELLER’;

Solution
8
Discuss
Alter - Rename Table

In the given query which of the keyword has to be inserted?

INSERT INTO employee _____ (1002,Joey,2000);

 

  • 1]
    Table
  • 2]

    Values

  • 3]

    Relation

  • 4]

    Field

Solution
9
Discuss
Alter - Rename Table

A Delete command operates on ______ relation.

  • 1]

    One

  • 2]

    Two

  • 3]

    Several

  • 4]

    Null

Solution
10
Discuss
Alter - Rename Table
Delete from r where P;

The above command

  • 1]

    Deletes a particular tuple from the relation

  • 2]

    Deletes the relation

  • 3]

    Clears all entries from the relation

  • 4]

    All of the mentioned

Solution
11
Discuss
Alter - Rename Table

Which one of the following deletes all the entries but keeps the structure of the relation.

  • 1]
    Delete from r where P;

     

  • 2]
    Delete from instructor where dept name= ’Finance’;

     

  • 3]
    Delete from instructor where salary between 13000 and 15000;

     

  • 4]
    Delete from instructor;

     

Solution
# Quiz
SQL -Structured Query Language

SQL -Structured Query Language

  • Introduction
  • Overview
    • How To Download And Install MySql Workbench
    • SQL Syntax
  • SQL Database
    • Create Database
    • Drop Database
    • Use / Select Database
  • SQL Table
    • Create Table
    • Alter - Rename Table
    • Alter - Add Column
    • Alter - Modify Column
    • Alter - Rename Column
    • Alter - Drop Column
    • Copy Table
    • Drop Table
  • SQL Insert
    • Insert Record
  • Sql Update
    • Update Record
  • Sql Select
    • Select Record
    • Select - Count
    • Select - Average
    • Select - Sum
    • Select - Min Max
    • Select - Distinct
    • Select - Limit
    • Select - First
    • Select - Last
  • Sql Clause
    • Like Clause
    • And Operator
    • Or Operator
    • Between & Not Between Operator
    • As or Alias
    • In Clause
    • Group By Clause
    • Having Clause
  • Sql Order By
    • Ascending
    • Descending
    • Random
    • Ascending Descending Multiple Column
  • SQL Joins
    • Joins and its type
    • Inner Join
    • Left Join
    • Right Join
    • Full Join
    • Cross Join
  • SQL View
    • Create View
    • Update View
    • Delete View
  • SQL Delete
    • Delete Table
    • Truncate Table
  • Sql Key & Constraint
    • Primary Key
    • Foreign Key
    • Unique Key
    • Not Null Constraint
    • Check Constraint
    • Default Constraint
  • Normalization
    • Overview
    • 1 NF
    • 2 NF
    • 3 NF
    • Boyce Codd normal form ( BCNF )

About Fresherbell

Best learning portal that provides you great learning experience of various technologies with modern compilation tools and technique

Important Links

Don't hesitate to give us a call or send us a contact form message

Terms & Conditions
Privacy Policy
Contact Us

Social Media

© Untitled. All rights reserved. Demo Images: Unsplash. Design: HTML5 UP.