Quiz Discussion

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

Course Name: SQL -Structured Query Language

  • 1]

    Interaction

  • 2]

    Operation

  • 3]

    Transaction

  • 4]

    None of these

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

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

Granting and Authorization for data access is provided by _____________

  • 1]

    DBA

  • 2]

    Application Developer

  • 3]

    Storage Manager

  • 4]

    Database Manager

Solution
3
Discuss

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

  • 1]

    Complexity

  • 2]

    Security

  • 3]

    Multiplicity

  • 4]

    None of these

Solution
4
Discuss

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

Database Manager Performs following query related operation

  • 1]

    Drop Table

  • 2]

    Creating Schema

  • 3]

    Retrieving Record

  • 4]

    Creating View

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

Structured data may include which of the following?

  • 1]

    Photo image

  • 2]

    Video clip

  • 3]

    Dates

  • 4]

    None of the above

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