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 Delete - Delete Table Quiz

# Quiz
1
Discuss
Delete Table

Which of the following is used to access the database server at the time of executing the program and get the data from the server accordingly?

  • 1]

    Embedded SQL

  • 2]

    Dynamic SQL

  • 3]

    SQL declarations

  • 4]

    SQL data analysis

Solution
2
Discuss
Delete Table

If DBA modify the structure of the data record then this modification do not affect other application is called as _____________.

  • 1]

    Data Independence

  • 2]

    Data Integrity

  • 3]

    Data Isolation

  • 4]

    Data Security

Solution
3
Discuss
Delete Table

Collection of information stored in database at particular instance of time is called as __________.

  • 1]

    Data Structure

  • 2]

    Database Schema

  • 3]

    Instance of Database

  • 4]

    Objects in Database

Solution
4
Discuss
Delete Table

Overall design of the database is called as _________.

  • 1]

    Database Instance

  • 2]

    Database Abstraction

  • 3]

    Database Schema

  • 4]

    None of these

Solution
5
Discuss
Delete Table

__________ is collection of operations that performs a single logical function in database application.

  • 1]

    Interaction

  • 2]

    Operation

  • 3]

    Transaction

  • 4]

    None of these

Solution
6
Discuss
Delete Table

Database Manager Performs following query related operation

  • 1]

    Drop Table

  • 2]

    Creating Schema

  • 3]

    Retrieving Record

  • 4]

    Creating View

Solution
7
Discuss
Delete Table

User which interact with the system using database query language is called as ___________

  • 1]

    Application Programmer

  • 2]

    Sophisticated User

  • 3]

    Naive User

  • 4]

    Specialized User

Solution
8
Discuss
Delete Table

Which of the user write programs in the host language and embed the DML statements into it?

  • 1]

    Specialized User

  • 2]

    Sophisticated User

  • 3]

    Application Programmer

  • 4]

    Naive User

Solution
9
Discuss
Delete Table

Database Manager is also known as _________

  • 1]

    Sophisticated User

  • 2]

    System Manager

  • 3]

    Application Programmer

  • 4]

    Storage Manager

Solution
10
Discuss
Delete Table

Granting and Authorization for data access is provided by _____________

  • 1]

    DBA

  • 2]

    Application Developer

  • 3]

    Storage Manager

  • 4]

    Database Manager

Solution
11
Discuss
Delete Table

Duty of Database manager is to enforce integrity and _________ checks.

  • 1]

    Complexity

  • 2]

    Security

  • 3]

    Multiplicity

  • 4]

    None of these

Solution
12
Discuss
Delete Table

Farmer goes to ATM Center to withdraw an amount of Rs.300/-. Which type of user farmer is?

  • 1]

    Unsophisticated User

  • 2]

    Sophisticated User

  • 3]

    Application Programmer

  • 4]

    Specialized User

Solution
13
Discuss
Delete Table

Schema Definition is written by ___________.

  • 1]

    Application Programmer

  • 2]

    Naive User

  • 3]

    Database Administrator

  • 4]

    Sophisticated user

Solution
14
Discuss
Delete Table

Person A is Java Developer interacts with Person D to understand the complete database schema
written by him.
Person B knows the database Schema and he is able to hit complex queries.
Unlike Person B, Person C does not use traditional database processing frameworks.
Who among the 4 users will be called as Sophisticated User.

  • 1]

    Person B

  • 2]

    Person A

  • 3]

    Person C

  • 4]

    Person D

Solution
15
Discuss
Delete Table

An extranet is which of the following?

  • 1]

    The use of Internet protocols with limited access to company data by the company's customers and suppliers.

  • 2]

    The use of Internet protocols with unlimited access to company data by the company's customers and suppliers.

  • 3]

    The use of Internet protocols with limited access to company data by people within an organization.

  • 4]

    The use of Internet protocols with unlimited access to company data by people within an organization.

Solution
16
Discuss
Delete Table

Data administrators are responsible for

  • 1]

    physical database design

  • 2]

    managing technical issues in the database environment

  • 3]

    overall management of data resources in an organization

  • 4]

    writing application programs

Solution
17
Discuss
Delete Table

Some advantages of the database approach include all, but

  • 1]

    minimal data redundancy

  • 2]

    improved data consistency

  • 3]

    improved data sharing

  • 4]

    program-data dependency

Solution
18
Discuss
Delete Table

Which of the following types of databases are the most common?

  • 1]

    Personal

  • 2]

    Workgroup

  • 3]

    Department

  • 4]

    Enterprise

Solution
19
Discuss
Delete Table

Duplicate data often results in loss of data integrity because

  • 1]

    the data formats may be inconsistent

  • 2]

    data values may not agree

  • 3]

    Both A & B

  • 4]

    Neither A & B

Solution
20
Discuss
Delete Table

Metadata enables database designers and users to do all of the following except

  • 1]

    sample data

  • 2]

    understand what data exist

  • 3]

    what the fine distinctions are between similar data items

  • 4]

    what the data mean

Solution
21
Discuss
Delete Table

Structured data may include which of the following?

  • 1]

    Photo image

  • 2]

    Video clip

  • 3]

    Dates

  • 4]

    None of the above

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.