programming languages Online Quiz - 236
| Description: programming languages Online Quiz - 236 | |
| Number of Questions: 20 | |
| Created by: Aliensbrain Bot | |
| Tags: programming languages |
-
4
-
8
-
6
-
12
SMB is
-
System managed Buffering
-
System managed buffer
-
Service managed Buffering
-
None of the above
AI Explanation
To answer this question, let's go through each option to understand why it is correct or incorrect:
Option A) System managed Buffering - This option is incorrect because SMB stands for Server Message Block, which is a protocol used for file sharing and communication between computers in a network. It does not stand for System managed Buffering.
Option B) System managed buffer - This option is incorrect because SMB does not stand for System managed buffer. As mentioned earlier, SMB stands for Server Message Block.
Option C) Service managed Buffering - This option is incorrect because SMB does not stand for Service managed Buffering. Again, SMB stands for Server Message Block.
Option D) None of the above - This option is incorrect because the correct answer is not "None of the above".
The correct answer is A) System managed Buffering.
AMP parameter BUFNI
-
increases the number of Index buffers for random access
-
increases the amount of virtual storage
-
increases the number of Data buffers for sequential access
-
All of the above
AI Explanation
To answer this question, you need to understand the purpose of the AMP parameter BUFNI in a database system.
The AMP parameter BUFNI stands for "Buffer Number of Indexes" and is used to determine the number of index buffers available for random access in a Teradata database system.
Option A) increases the number of Index buffers for random access - This option is correct. By increasing the BUFNI parameter, the number of index buffers is increased, which improves the performance of random access operations.
Option B) increases the amount of virtual storage - This option is incorrect. The BUFNI parameter does not affect the amount of virtual storage in the system. It only affects the number of index buffers.
Option C) increases the number of Data buffers for sequential access - This option is incorrect. The BUFNI parameter is specifically related to index buffers, not data buffers for sequential access.
Option D) All of the above - This option is incorrect. Only option A is correct.
The correct answer is A) increases the number of Index buffers for random access. This option is correct because the BUFNI parameter is used to increase the number of index buffers, improving the performance of random access operations.
The process of VSAM REORG are
-
Copy the data of VSAM file which has to be REORG into another dataset
-
Delete the current VSAM dataset
-
Define the VSAM dataset.
-
All of the above
To answer this question, the user needs to have knowledge of VSAM (Virtual Storage Access Method) and the process of VSAM REORG.
The correct answer is:
D. All of the above
Explanation:
The process of VSAM REORG involves the following steps:
A. Copy the data of VSAM file which has to be REORG into another dataset: This step involves backing up the data in the VSAM file to another dataset before the REORG process can begin. This ensures that the data is not lost in case the REORG process fails.
B. Delete the current VSAM dataset: Once the backup is complete and verified, the original VSAM dataset can be deleted.
C. Define the VSAM dataset: After the original dataset has been deleted, a new VSAM dataset can be defined with the same name and attributes as the original dataset.
Therefore, all of the options listed above are correct steps that are involved in the process of VSAM REORG.
Which utility is used to reduce the File backup time?
-
INZUTILB
-
IKJEFT1A
-
ADRDSSU
-
XUE10200
-
for Backup/Recovery
-
for increasing the speed
-
for file backup
-
All of the above
-
Can only be used for VSAM datasets
-
Dataset created by EXPORT command cannot have a sequential organization
-
Dataset created by the IMPORT step is not processed until it has gone through corresponding EXPORT step
-
Dataset created by EXPORT command can only have a sequential organization
Format of EXPORT Command
-
INFILE(ddname) | OUTDATASET(dsname)
-
OUTFILE(ddname)| INDATASET(dsname)
-
INFILE(ddname) | INDATASET(dsname)
-
OUTFILE(ddname)| OUTDATASET(dsname)
AI Explanation
To answer this question, we need to understand the format of the EXPORT command.
The correct format of the EXPORT command is:
D. OUTFILE(ddname) | OUTDATASET(dsname)
This option is correct because it specifies the correct syntax for the EXPORT command. The keyword "OUTFILE" is used to specify the output file or dataset name, followed by the name assigned to the file or dataset (ddname or dsname). The vertical bar (|) is used to separate the parameters.
Option A) INFILE(ddname) | OUTDATASET(dsname) - This option is incorrect because it uses the keyword "INFILE" instead of "OUTFILE". The "INFILE" keyword is used to specify the input file or dataset, not the output.
Option B) OUTFILE(ddname) | INDATASET(dsname) - This option is incorrect because it uses the keyword "INDATASET" instead of "OUTDATASET". The "INDATASET" keyword is not a valid keyword for the EXPORT command.
Option C) INFILE(ddname) | INDATASET(dsname) - This option is incorrect because it uses both "INFILE" and "INDATASET" keywords, which are not valid for the EXPORT command.
The correct answer is option D) OUTFILE(ddname) | OUTDATASET(dsname) because it correctly represents the format of the EXPORT command.
Which is not a subcommand of EXPORT Parameter?
-
ERASE / NOERASE
-
INHIBITSOURCE / NOINHIBITSOURCE
-
NOINHIBITSOURCE / INHIBITSOURCE
-
TEMPORARY / PERMANENT
AI Explanation
To answer this question, we need to understand the EXPORT parameter and its subcommands.
The EXPORT parameter is used in various programming languages and tools to specify how data should be exported or saved. It typically has several subcommands that can be used to modify its behavior.
Let's go through each option to determine which one is not a subcommand of the EXPORT parameter:
Option A) ERASE / NOERASE - This option is a valid subcommand of the EXPORT parameter. It is used to specify whether existing data should be erased before exporting or not.
Option B) INHIBITSOURCE / NOINHIBITSOURCE - This option is a valid subcommand of the EXPORT parameter. It is used to specify whether source code or references to the source code should be included in the exported data or not.
Option C) NOINHIBITSOURCE / INHIBITSOURCE - This option is not a valid subcommand of the EXPORT parameter. It seems to be a combination of two existing subcommands, but it is not a recognized subcommand itself.
Option D) TEMPORARY / PERMANENT - This option is a valid subcommand of the EXPORT parameter. It is used to specify whether the exported data should be temporary or permanent.
Based on the above analysis, it is clear that Option C is not a subcommand of the EXPORT parameter. Therefore, the correct answer is C.
-
Write only Mode
-
Read only Mode
-
Read Write Mode
-
All of the above
-
Write only Mode
-
Read only Mode
-
Read Write Mode
-
All of the above
-
DEFINE
-
DELETE
-
REPRO
-
ALTER
-
Write only Mode
-
Read only Mode
-
Read Write Mode
-
All of the above
-
ERASE operation is complete
-
NOERASE operation is complete
-
IMPORT operation is complete
-
EXPORT operation is complete
-
ERASE operation is complete
-
NOERASE operation is complete
-
IMPORT operation is complete
-
EXPORT operation is complete
-
Control Interval
-
Cascade Interval
-
Record Mode
-
None of the above
To solve this question, the user needs to know about the CIMODE parameter in mainframe systems.
The answer is: C. Record Mode
Explanation:
The CIMODE parameter is used in IBM mainframe systems to specify the mode of processing for the target dataset. It can have one of the following values:
CI (Control Interval) mode: This mode processes the target dataset in control interval format. Control intervals are groups of records that are read and written as a single unit. This mode is useful for datasets with a high number of records.
CA (Cascade) mode: This mode processes the target dataset in cascade mode, which means that records are read and written in groups of control areas. Control areas are groups of control intervals that are read and written as a single unit. This mode is useful for datasets with a high number of control intervals.
Record mode: This mode processes the target dataset in record mode, which means that records are read and written one at a time. This mode is useful for datasets with a low number of records.
Since the question asks which mode allows the processing of the target dataset in a record mode, the correct answer is C. Record Mode. Option A is incorrect because it refers to control interval mode, and option B is incorrect because it refers to cascade mode. Option D is incorrect because one of the above options is correct.
-
INTOEMPTY
-
OBJECTS
-
Only b
-
Both a and b
To solve this question, the user needs to have knowledge of the IMPORT command in SQL.
The correct answer is:
D. Both a and b
Explanation:
The IMPORT command is used to import data from an external file into a SQL database. The IMPORT command has several parameters, one of which is the "PARAMETERS" parameter. The "PARAMETERS" parameter has several subcommands, including "INTOEMPTY" and "OBJECTS".
- The "INTOEMPTY" subcommand is used to import data into an empty table.
- The "OBJECTS" subcommand is used to import data into an existing table.
Therefore, option D is correct because both subcommands "INTOEMPTY" and "OBJECTS" are subcommands of the IMPORT parameter.
Which is the correct syntax of INTOEMPTY Parameter?
-
IMPORT INFILE(DD1) OUTFILE(DD2) IEMPTY
-
IMPORT INFILE(DD1) OUTFILE(DD2) INTOEMPTY
-
IMPORT INFILE(DD1) OUTFILE(DD2) IETY
-
IMPORT INFILE(DD1) OUTFILE(DD2) EMPTY
AI Explanation
To answer this question, we need to understand the syntax for the INTOEMPTY parameter in the given context.
The correct syntax of the INTOEMPTY parameter is:
B. IMPORT INFILE(DD1) OUTFILE(DD2) INTOEMPTY
This option is correct because it uses the keyword "INTOEMPTY" to specify that the data from the input file (DD1) should be imported into the empty output file (DD2).
Option A) IMPORT INFILE(DD1) OUTFILE(DD2) IEMPTY - This option is incorrect because "IEMPTY" is not a valid keyword to specify the INTOEMPTY parameter.
Option C) IMPORT INFILE(DD1) OUTFILE(DD2) IETY - This option is incorrect because "IETY" is not a valid keyword to specify the INTOEMPTY parameter.
Option D) IMPORT INFILE(DD1) OUTFILE(DD2) EMPTY - This option is incorrect because "EMPTY" is not a valid keyword to specify the INTOEMPTY parameter.
Therefore, the correct answer is B) IMPORT INFILE(DD1) OUTFILE(DD2) INTOEMPTY.
-
STORCLAS
-
MGMTCLAS
-
SPACE
-
VOLUME
DFDSS cannot be used to
-
Reduce DASD free space fragmentation
-
Copy or move data sets from one DASD device to another or dump
-
Restore backup copies of entire DASD volumes
-
Increase File storage
AI Explanation
To answer this question, let's go through each option to understand why it is correct or incorrect:
Option A) Reduce DASD free space fragmentation - DFDSS can be used to reduce DASD free space fragmentation. DFDSS (Data Facility Data Set Services) is a utility program in z/OS that provides various functions related to managing datasets and storage. It includes functions for managing free space on DASD (Direct Access Storage Device) by defragmenting free space.
Option B) Copy or move data sets from one DASD device to another or dump - DFDSS can be used to copy or move data sets from one DASD device to another or to create backups of datasets through a dump operation. These operations are commonly performed using the DFDSS utility.
Option C) Restore backup copies of entire DASD volumes - DFDSS can be used to restore backup copies of entire DASD volumes. It provides functions for backup and restore operations, allowing users to restore datasets or entire volumes from backup copies.
Option D) Increase File storage - DFDSS cannot be used to increase file storage. DFDSS primarily deals with managing datasets and storage, but it does not have the capability to increase the storage capacity of a file.
Based on the explanations above, the correct answer is D) Increase File storage. This option is incorrect because DFDSS cannot be used to increase file storage.