Database Mock Test - 2

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Sharmiladevi
S
Sharmiladevi
Community Contributor
Quizzes Created: 4 | Total Attempts: 8,549
Questions: 9 | Attempts: 1,393

SettingsSettingsSettings
Database Mock Test - 2 - Quiz

This is a simple quiz which is created for test your basic data base knowledge!


Questions and Answers
  • 1. 

    What does a positive value of SQL code mean?

    • A.

      Error

    • B.

      Successful execution

    • C.

      No rows found

    Correct Answer
    B. Successful execution
    Explanation
    A positive value of SQL code typically indicates a successful execution. This means that the SQL statement was processed without any errors and the desired operation was completed successfully. It could mean that data was inserted, updated, or deleted successfully in the database, or that a query was executed and returned the expected results.

    Rate this question:

  • 2. 

    . AUTOMATIC RECOMPILATION occurs when

    • A.

      A existing index is dropped.

    • B.

      A new index is created.

    • C.

      Both (A) and (B).

    Correct Answer
    C. Both (A) and (B).
    Explanation
    Automatic recompilation occurs when either an existing index is dropped or a new index is created. In both cases, the database management system automatically recompiles the affected queries to ensure that they continue to execute efficiently. This process is necessary because dropping an index can change the access path for queries, and creating a new index may provide a more efficient access path. Therefore, both scenarios trigger automatic recompilation to maintain optimal query performance.

    Rate this question:

  • 3. 

    Collections are essentially just a means of giving a name to a logically related set of packages

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    This statement is true because collections in programming are used to group together logically related sets of packages or objects. They provide a convenient way to organize and manage data, making it easier to access and manipulate. By giving a name to a collection, it becomes easier to refer to and work with the items it contains. Therefore, collections are indeed a means of giving a name to a logically related set of packages.

    Rate this question:

  • 4. 

    Cartesian product ‘ is the result of a join that does not specify matching columns

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The statement is true because a Cartesian product is the result of a join operation where no specific matching columns are specified. In a Cartesian product, every row from one table is combined with every row from another table, resulting in a combination of all possible pairs of rows from both tables. This can be a very large result set and should be used with caution to avoid performance issues.

    Rate this question:

  • 5. 

    13   Group By does not do any sorting .        

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    Group By does not do any sorting. This statement is true. When using the Group By clause in SQL, the result set is grouped based on the specified column(s), but it does not guarantee any specific order of the grouped data. The order of the groups or the rows within each group is not defined unless an additional sorting operation is applied, such as using the Order By clause. Therefore, Group By does not inherently perform any sorting.

    Rate this question:

  • 6. 

    .    In EXIST operator when a match is found, the query ends processing for that row

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    In the EXIST operator, when a match is found, the query ends processing for that row. This means that if the condition specified in the EXISTS operator evaluates to true for a particular row, the query will stop processing that row and move on to the next row. This can be useful in optimizing queries and improving performance, as it allows the database to stop processing a row as soon as a match is found, rather than continuing to evaluate the condition for the remaining rows.

    Rate this question:

  • 7. 

    .   GRANT SELECT ON EMPTAB TO USER  is a correct syntax

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The given statement "GRANT SELECT ON EMPTAB TO USER" is not a correct syntax. In SQL, the correct syntax for granting privileges is "GRANT privileges ON table TO user". Therefore, the correct syntax in this case would be "GRANT SELECT ON EMPTAB TO USER".

    Rate this question:

  • 8. 

    Performed for each row in the result table

    • A.

      Scalar function

    • B.

      Group by

    • C.

      Aggregate function

    Correct Answer
    A. Scalar function
    Explanation
    A scalar function is a type of function that operates on a single value and returns a single value. In the context of the given statement, the scalar function is performed for each row in the result table. This means that the function is applied individually to each row in the table, producing a result specific to that row. This is different from aggregate functions, which operate on multiple rows and return a single result for the entire group. Group by is used to group rows together based on a common value, while aggregate functions calculate a single value for each group.

    Rate this question:

  • 9. 

    .    What is single bound DBRM with optimized access path .

    • A.

      1) PLAN

    • B.

      2) PACKAGE

    • C.

      3) BIND

    Correct Answer
    B. 2) PACKAGE
    Explanation
    A single bound DBRM with optimized access path refers to a package. A package is a compiled version of an application program that contains the optimized access path to the database. It is created after the BIND process, which binds the DBRM (Database Request Module) to create an executable module. The package is then stored in the database and can be reused by multiple application programs, saving compilation time and optimizing performance by using the already optimized access path.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 19, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jul 28, 2011
    Quiz Created by
    Sharmiladevi

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.