Quiz Discussion

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.

Course Name: SQL -Structured Query Language

  • 1]

    Person B

  • 2]

    Person A

  • 3]

    Person C

  • 4]

    Person D

Solution
No Solution Present Yet

Top 5 Similar Quiz - Based On AI&ML

Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api

# Quiz
1
Discuss

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

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
3
Discuss

Database Manager Performs following query related operation

  • 1]

    Drop Table

  • 2]

    Creating Schema

  • 3]

    Retrieving Record

  • 4]

    Creating View

Solution
4
Discuss

Overall design of the database is called as _________.

  • 1]

    Database Instance

  • 2]

    Database Abstraction

  • 3]

    Database Schema

  • 4]

    None of these

Solution
5
Discuss

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
6
Discuss

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
7
Discuss

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
8
Discuss

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
9
Discuss

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
10
Discuss

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
# Quiz