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 Joins - Cross Join Quiz

# Quiz
1
Discuss
Cross Join

The default extension for an Oracle SQL*Plus file is:

  • 1]

    .txt

  • 2]

    .ora

  • 3]

    .pls

  • 4]

    .sql

Solution
2
Discuss
Cross Join

Triggers __________ enabled or disabled.

  • 1]

    Cannot be

  • 2]

    Can be

  • 3]

    Ought to be

  • 4]

    Always

Solution
3
Discuss
Cross Join

To include integrity constraint in a existing relation use :

  • 1]

    Create table

  • 2]

    Alter table

  • 3]

    Modify table

  • 4]

    Any of the above

Solution
4
Discuss
Cross Join

A _________ is a stored program that is attached to a table or a view.

  • 1]

    pseudofile

  • 2]

    trigger

  • 3]

    embedded SELECT statement

  • 4]

    None of the above is correct.

Solution
5
Discuss
Cross Join

The DROP TABLE statement:

  • 1]

    deletes the table structure only

  • 2]

    deletes the table structure along with the table data

  • 3]

    works whether or not referential integrity constraints would be violated

  • 4]

    is not an SQL statement

Solution
6
Discuss
Cross Join

SQL views can be used to hide

  • 1]

    columns and rows only

  • 2]

    complicated SQL syntax only

  • 3]

    both of the above can be hidden by an SQL view

  • 4]

    None of the above is correct

Solution
7
Discuss
Cross Join

The SQL statement to create a view is

  • 1]

    CREATE VIEW

  • 2]

    MAKE VIEW

  • 3]

    SELECT VIEW

  • 4]

    INSERT VIEW

Solution
8
Discuss
Cross Join

To update an SQL view, the DBMS must be able to associate the column(s) to be updated with

  • 1]

    a particular column in a particular underlying table

  • 2]

    a particular column in a particular row

  • 3]

    a particular row in a particular underlying table

  • 4]

    None of the above is correct

Solution
9
Discuss
Cross Join

Which of the following is NOT a type of SQL constraint?

  • 1]

    PRIMARY KEY

  • 2]

    ALTERNATE KEY

  • 3]

    UNIQUE

  • 4]

    FOREIGN KEY

Solution
10
Discuss
Cross Join

A _________ is a program that performs some common action on database data and that is stored in the database

  • 1]

    trigger

  • 2]

    stored procedure

  • 3]

    pseudofile

  • 4]

    None of the above

Solution
11
Discuss
Cross Join

For what purposes are views used?

  • 1]

    To hide columns only

  • 2]

    To hide rows only

  • 3]

    To hide complicated SQL statements only

  • 4]

    All of the above

Solution
12
Discuss
Cross Join

What is an SQL virtual table that is constructed from other tables?

  • 1]

    Just another table

  • 2]

    View

  • 3]

    Relation

  • 4]

    Query results

Solution
13
Discuss
Cross Join

When using the SQL INSERT statement

  • 1]

    rows can be modified according to criteria only

  • 2]

    rows cannot be copied in mass from one table to another only

  • 3]

    rows can be inserted into a table only one at a time only

  • 4]

    rows can either be inserted into a table one at a time or in groups

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.