What is filter factor?
One divided by the number of distinct values of a column.
Zero divided by the number of distinct values of a column.
Zero divided by the number of distinct values of a row.
One divided by the number of distinct values of a Rrow.
Web Services technology can be divided into 5 stack layers, in which layer SOAP be categorize
Discovery
Description
Packaging
Transport
Network
What is referential integrity?
The relation of the primary key of a base table with foreign key of the reference table is known as referential integriety.
The relation of the secondary key of a base table with foreign key of the reference table is known as referential integriety.
The relation of the primary key of a secondary table with foreign key of the reference table is known as referential integriety.
The relation of the primary key of a base table with index key of the reference table is known as referential integriety.
What is FREEPAGE and PCTFREE in TABLESPACE creation?
PCTFREE: percentage of each page to be left free and FREEPAGE: Number of pages to be loaded with data between each free page.
PCTFREE: percentage of each page to be loaded with data and FREEPAGE: Number of pages to be loaded with data between each free page.
PCTFREE: percentage of each page to be left free and FREEPAGE: Number of pages to be left free with data between each loaded page.
PCTFREE: percentage of each page to be loaded with data between each free page and FREEPAGE: Number of pages to be left free.
What are the 4 environments which can access DB2?
TSO and CICS
IMS and BATCH
TSO, CICS, IMS and DB2
TSO, CICS, IMS and VSAM
Are views updateable?
True
False
When will you chose to run RUNSTATS?
After a load
After mass updates
After a deletes
After a inserts
SAY "HELLO" "THERE" SAY "HELLO" || "THERE Result? HELLO THERE HELLOTHERE
NAME1 = "JHON" NAME2 = " JHON " IF NAME1 == NAME2 THEN SAY " MATCHED " ELSE SAY " NOT MATCHED " Result: NOT MATCHED
Which of the following is not a SDLC models?
Waterfall
Spiral
Baig-bang
Fix-it