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 Key & Constraint - Not Null Constraint Quiz

# Quiz
1
Discuss
Not Null Constraint

A _____ indicates an absent value that may exist but be unknown or that may not exist at all.

  • 1]

    Empty tuple

  • 2]

    New value

  • 3]

    Null value

  • 4]

    Old value

Solution
2
Discuss
Not Null Constraint

If the attribute phone number is included in the relation all the values need not be entered into the phone number column. This type of entry is given as

  • 1]

    0

  • 2]

    -

  • 3]

    Null

  • 4]

    Empty space

Solution
3
Discuss
Not Null Constraint

The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is_______ false and unknown is _____ while unknown and unknown is _____

  • 1]

    Unknown, unknown, false

  • 2]

    True, false, unknown

  • 3]

    True, unknown, unknown

  • 4]

    Unknown, false, unknown

Solution
4
Discuss
Not Null Constraint
SELECT name
FROM instructor
WHERE salary IS NOT NULL;
Selects
  • 1]

    Tuples with null value

  • 2]

    Tuples with no null values

  • 3]

    Tuples with any salary

  • 4]

    All of the mentioned

Solution
5
Discuss
Not Null Constraint

In an employee table to include the attributes whose value always have some value which of the following constraint must be used?

  • 1]

    Null

  • 2]

    Not null

  • 3]

    Unique

  • 4]

    Distinct

Solution
6
Discuss
Not Null Constraint

Using the ______ clause retains only one copy of such identical tuples.

  • 1]

    Null

  • 2]

    Unique

  • 3]

    Not null

  • 4]

    Distinct

Solution
7
Discuss
Not Null Constraint
CREATE TABLE employee (id INTEGER,name VARCHAR(20),salary NOT NULL);
INSERT INTO employee VALUES (1005,Rach,0);
INSERT INTO employee VALUES (1007,Ross, );
INSERT INTO employee VALUES (1002,Joey,335);

Some of these insert statements will produce an error. Identify the statement.

  • 1]

    Insert into employee values (1005,Rach,0)

  • 2]

    Insert into employee values (1002,Joey,335);

  • 3]

    Insert into employee values (1007,Ross, );

  • 4]

    None of the mentioned

Solution
8
Discuss
Not Null Constraint

The primary key must be

  • 1]

    Unique

  • 2]

    Not null

  • 3]

    Both Unique and Not null

  • 4]

    Either Unique or Not null

Solution
9
Discuss
Not Null Constraint

You attempt to query the database with this command:

 SELECT nvl (100 / quantity, NONE)
 FROM inventory;

Why does this statement cause an error when QUANTITY values are null?

  • 1]

    The expression attempts to divide by a null value

  • 2]

    The data types in the conversion function are incompatible

  • 3]

    The character string none should be enclosed in single quotes (‘ ‘)

  • 4]

    A null value used in an expression cannot be converted to an actual value

Solution
10
Discuss
Not Null Constraint

The result of _____unknown is unknown.

  • 1]

    Xor

  • 2]

    Or

  • 3]

    And

  • 4]

    Not

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.