This quiz is created for assesment after DB2/400 training
PF,LF,DSPF,PRT
PF,LF,DSP,PRT
PF,LF,DSPF,PRTF
*FILE,*FILE,*FILE,*FILE
None of the above
Change the key of physical file to emp name
Create another physical file with emp name as key and copy this data
Create a logical file on this file with emp name as key
Use SQL to read the file
None of the Above
CHGF
DLTF, CRTF
CHGPF
MODPF
None of the above
Physical and Logical files can be journaled
Only Logical Files can be journaled
Only Physical files can be journaled
Physical file can be deleted before logical file
Logical file can be created on another logical file
SFLSIZ,SFLPAGE
SFLSIZE,SFLPAGE
SFLSIZ,SFLPAG
SUBSIZ,SUBPAG
None of the Above
Journal the file, create journal receiver, create journal
Create journal, create journal receiver, journal file
Create journal receiver, journal file, create journal
Create journal receiver, create journal, journal file
None of the Above
Joining the physical files
Joining the physical and logical files
Joining the logical files only
This is not a valid key word
None of the Above
File level keyword
Field level keyword
Records level keyword
All of the Above
Can be specified in a physical file only
Quiz Review Timeline (Updated): Mar 15, 2022 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
IBM DB2 Database Quiz
Welcome to this informative IBM DB2 Database quiz. IBM DB2 is a product that was developed by IBM. The most amazing part about this product is that it works on a relational model....
Questions:
10 |
Attempts:
623 |
Last updated:
Aug 27, 2023
|
DB2 Practice 1
DB2 Practice 1 quiz assesses knowledge on DB2 database management, specifically focusing on database creation, performance optimization, and schema management. It is designed for...
Questions:
68 |
Attempts:
416 |
Last updated:
Mar 21, 2023
|
DB2 Basics, Part 3
DB2 Basics, Part 3 explores key database concepts using DB2. It covers data types for multimedia (BLOB), character storage (CLOB), and the use of constraints to enforce business...
Questions:
46 |
Attempts:
114 |
Last updated:
Mar 21, 2023
|
Wait!
Here's an interesting quiz for you.