Database Mock Test - 2
-
What does a positive value of SQL code mean?
-
Error
-
Successful execution
-
No rows found
-
About This Quiz
This is a simple quiz which is created for test your basic data base knowledge!
Quiz Preview
- 2.
. AUTOMATIC RECOMPILATION occurs when
-
A existing index is dropped.
-
A new index is created.
-
Both (A) and (B).
Correct Answer
A. 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
-
True
-
False
Correct Answer
A. TrueExplanation
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
-
True
-
False
Correct Answer
A. TrueExplanation
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 .
-
True
-
False
Correct Answer
A. TrueExplanation
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
-
True
-
False
Correct Answer
A. TrueExplanation
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
-
True
-
False
Correct Answer
A. FalseExplanation
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
-
Scalar function
-
Group by
-
Aggregate function
Correct Answer
A. Scalar functionExplanation
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 .
-
1) PLAN
-
2) PACKAGE
-
3) BIND
Correct Answer
A. 2) PACKAGEExplanation
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 (Updated): Mar 19, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 19, 2023Quiz Edited by
ProProfs Editorial Team -
Jul 28, 2011Quiz Created by
Sharmiladevi
Back to top