Database Mock Test - 2 | Attempts: 1393 - Quiz, Trivia & Questions

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

Sharmiladevi

Community Contributor

Quizzes Created: 4 | Total Attempts: 8,560

Questions: 9 | Attempts: 1,393 | Updated: Mar 19, 2023

Questions

Settings

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Play as

Quiz Flashcard

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

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:

1
0
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

Database Mock Test - 2

What does a positive value of SQL code mean?

. AUTOMATIC RECOMPILATION occurs when

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

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

13 Group By does not do any sorting .

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

. GRANT SELECT ON EMPTAB TO USER is a correct syntax

Performed for each row in the result table

. What is single bound DBRM with optimized access path .