Quiz Discussion

Database Manager Performs following query related operation

Course Name: SQL -Structured Query Language

  • 1]

    Drop Table

  • 2]

    Creating Schema

  • 3]

    Retrieving Record

  • 4]

    Creating View

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

Granting and Authorization for data access is provided by _____________

  • 1]

    DBA

  • 2]

    Application Developer

  • 3]

    Storage Manager

  • 4]

    Database Manager

Solution
2
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
3
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
4
Discuss

Schema Definition is written by ___________.

  • 1]

    Application Programmer

  • 2]

    Naive User

  • 3]

    Database Administrator

  • 4]

    Sophisticated user

Solution
5
Discuss

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

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

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

  • 1]

    Personal

  • 2]

    Workgroup

  • 3]

    Department

  • 4]

    Enterprise

Solution
9
Discuss

Overall design of the database is called as _________.

  • 1]

    Database Instance

  • 2]

    Database Abstraction

  • 3]

    Database Schema

  • 4]

    None of these

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