Database Mock Test
-
All PLANS are stored in ____DB2 directory_____________________.
-
SY.SYSPL
-
SYPSL.SB
-
SYSIBM.SYSPL
-
None of these
-
Here is a very interesting quiz which is a database mock test for you. We have prepared this quiz to test your knowledge of the database and how well you understand that. There are many questions on the topic in the quiz; you will need to answer as many correctly as you can. In the end, your score will be See morea reflection of your knowledge of the subject. Let's go for it. Best of luck to you!
Quiz Preview
- 2.
Count(*) will return -----------------if the target table is empty.
-
0
-
1
-
2
-
3
Correct Answer
A. 0Explanation
The count(*) function in SQL returns the number of rows in a table. If the target table is empty, there are no rows, so the count(*) function will return 0.Rate this question:
-
- 3.
ENTITY INTEGRITY is a state where a column that is part of a primary key can have null values.
-
True
-
False
Correct Answer
A. FalseExplanation
ENTITY INTEGRITY is a state where a column that is part of a primary key cannot have null values. This ensures that each record in a table is uniquely identified and prevents duplicate or missing values in the primary key column. Therefore, the statement that a column that is part of a primary key can have null values is incorrect.Rate this question:
-
- 4.
An ______ is an ordered set of pointers to rows of a base table.
-
Index
-
Opened-file
-
Auto-file
-
None of these
Correct Answer
A. IndexExplanation
An index is an ordered set of pointers to rows of a base table. It allows for efficient retrieval of data by providing a quick way to locate specific rows based on the values in one or more columns. The index stores the values of the indexed columns along with the pointers to the corresponding rows, making it easier and faster to search for specific data in the table.Rate this question:
-
- 5.
SQLCODE -922 is for authorization failure.
-
True
-
False
Correct Answer
A. TrueExplanation
SQLCODE -922 is indeed for authorization failure. In SQL, authorization failure occurs when a user attempts to access a database or perform a specific action without the necessary permissions or privileges. When this happens, the SQLCODE -922 is returned to indicate the authorization failure. This can happen if the user does not have the required privileges to execute a certain SQL statement or access a particular table or view.Rate this question:
-
- 6.
We Can use MAX on a CHAR column.
-
True
-
False
Correct Answer
A. TrueExplanation
In some database systems, it is possible to use the MAX function on a CHAR column. The MAX function is used to retrieve the maximum value from a column, and it can be applied to numerical as well as character data types. When used on a CHAR column, the MAX function will return the highest value based on the alphabetical order of the characters. However, it is important to note that this behavior may vary depending on the specific database system being used.Rate this question:
-
- 7.
Every SQL statement is executable.
-
True
-
False
Correct Answer
A. FalseExplanation
The statement "Every SQL statement is executable" is false. Not every SQL statement is executable as there are certain types of SQL statements that are used for defining database structures or performing administrative tasks rather than executing a specific action on the data. Examples of such statements include CREATE TABLE, ALTER TABLE, and GRANT. These statements do not directly manipulate the data but rather modify the structure or access rights of the database. Therefore, not all SQL statements are executable.Rate this question:
-
- 8.
SUBSTR(CUSTNAME,1,3) will extract 1st 3 character from CUSTNAME string.
-
True
-
False
Correct Answer
A. TrueExplanation
The function SUBSTR(CUSTNAME,1,3) is used to extract the first three characters from the CUSTNAME string. Therefore, the given statement is true.Rate this question:
-
- 9.
Which of the following DB2 objects allows multiple users to access data in a table, with each only being able to access certain portions of the data?
-
Views
-
Aliases
-
indexes
-
Mirrored tables
-
table constraints
Correct Answer
A. ViewsExplanation
Views in DB2 allow multiple users to access data in a table, with each user only being able to access certain portions of the data. Views provide a way to present a subset of the data from one or more tables, allowing users to see only the specific columns or rows that they are authorized to view. This can be useful for security purposes, as it allows for fine-grained control over the data that each user can access.Rate this question:
-
- 10.
The final result of a DB2 BIND is
-
Load-module
-
DB2 catalog
-
Database request module
-
DB2 (application) Plan
Correct Answer
A. DB2 (application) PlanExplanation
The final result of a DB2 BIND is the DB2 (application) Plan. This plan is created during the BIND process and contains the optimized access paths for executing SQL statements in the application. It is used by the DB2 optimizer to determine the most efficient way to access data and execute queries. The plan is stored in the DB2 catalog and is loaded into memory when the application is executed.Rate this question:
-
- 11.
Which one of the following is NOT a DB2 object?
-
Storage Group
-
Table
-
Synonym
-
Column
Correct Answer
A. ColumnExplanation
A column is not a DB2 object because it is a component of a table. In a relational database like DB2, a table is made up of rows and columns, where columns define the structure and data type of the data stored in the table. Therefore, while a storage group, table, and synonym are all examples of DB2 objects, a column is not considered a separate object but rather a part of a table object.Rate this question:
-
- 12.
What does a positive value of SQL code mean?
-
Warning
-
Error
-
Successful execution
-
No rows found
Correct Answer
A. WarningExplanation
A positive value of SQL code typically indicates a warning. This means that the SQL statement executed successfully, but there may be some potential issues or non-critical errors that occurred during the execution. It serves as a notification to the user that there might be something worth investigating or addressing, but it does not indicate a critical failure or error in the execution of the SQL code.Rate this question:
-
- 13.
AUTOMATIC RECOMPILATION occurs when
-
An existing index is dropped.
-
A new index is created.
-
Both A and B
-
None of the above
Correct Answer
A. A new index is created.Explanation
When a new index is created, it triggers the process of automatic recompilation. This process is necessary to update the database's query execution plans and optimize performance based on the new index. Dropping an existing index does not require automatic recompilation as it simply removes the index from the database. Therefore, the correct answer is that automatic recompilation occurs when a new index is created.Rate this question:
-
- 14.
In DB2, DATA is physically stored in
-
VSAM ESDS.
-
VSAM KSDS.
-
VSAM LDS
-
TABLES
Correct Answer
A. VSAM LDS -
- 15.
DATABASE SERVICES doesn’t consist of
-
BIND
-
RUNTIME SUPERVISOR
-
PACKAGES.
-
PRECOMPILER.
Correct Answer
A. PACKAGES.Explanation
The correct answer is PACKAGES. Database services do not consist of packages. Packages are a way to organize and group related database objects together. They are not a part of the core database services but rather a feature or tool that can be used within the database system.Rate this question:
-
- 16.
.______ is a single bound DBRM with an optimized access path.
-
Box
-
Package
-
File
-
None of these
Correct Answer
A. PackageExplanation
A package is a single bound DBRM with an optimized access path. It is a collection of related DBRMs that are stored together in a single package. The package contains information about the access path, which is the most efficient way to retrieve data from the database. By storing multiple DBRMs in a package, the access path can be optimized for the specific requirements of the application, resulting in improved performance. Therefore, a package is the correct answer as it provides an optimized access path for the DBRM.Rate this question:
-
Quiz Review Timeline (Updated): Nov 16, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Nov 16, 2023Quiz Edited by
ProProfs Editorial Team -
May 28, 2011Quiz Created by
Poornima972_pati
Back to top