-
Derek has created a view in the products.nsf database. Derek wants the markup column in the view to display the selling price of the cost. He wants this value to display in currency. Which one of the following should derekl do? ()
A . use the @currenty in thr column formula in the view
B . Select currency on the numbers tab in the view properties box
C . Select currency on the numbers tab in the column properties box
D . Select currency on the numbers tab in the field properties box&e
-
Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?()
A . The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
B . The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
C . All the components may be moved into SYSAUX tablespace.
D . All the components may be moved from the SYSAUX tablespace.
-
Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?()
A . SELECT UNIQUE dept FROM staff
B . SELECT DISTINCT dept FROM staff
C . SELECT (dept) UNIQUE FROM staff
D . SELECT (dept) DISTINCT FROM staff
-
You created a tabular report for human resources department. After viewing layout users have requested that you change the label of the dept column to something more meaningful. How would you change the label in the live previewer?()
A . Use the report wizard to change the column label.
B . Click and high light the column label and replace it with desired text.
C . Click the column label and alter its property palette.
D . Click the dept column and alter its property palette.&e
-
which one of the following should maria do to display the release date in a text column?()
A . used the number and time format options
B . used the @date to text functions to convert time to text
C . concatenated the date types using mathematical operators
D . used the @text functions to convert time and number data to text in text columns&e
-
You’re a network administer and you issue the command (show port 3/1) on an Ethernet port. To your surprise you notice a non-zero entry in the ’Giants’ column. What could be the cause of this? ()
A . IEEE 802.1Q
B . IEEE 802.10
C . Misconfigured NIC
D . User configuration
E . All of the above
-
Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?()
A . Define the column MAINID as NOT UPDATABLE
B . Define the column MAINID as a PRIMARY KEY
C . Define the column MAINID as a FOREIGN KEY
D . Define an UPDATE trigger on table TABLEX
-
A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?()
A . Table
B . Columns
C . Table and Alias
D . Columns and Alia
-
You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this. Which data type would you use for the new column()
A . CLOB
B . BLOB
C . BFILE
D . LONG RAW
-
Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?()
A . DB2 will no longer allow updating the value of IDCOL1 in TABLE1.
B . When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.
C . When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2, that is values which do not exist in IDCOL1.
D . When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.
-
You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this. Which data type would you use for the new column()
A . CLOB
B . BLOB
C . BFILE
D . LONG RAW
-
What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?()
A . A check constraint on the EMPLOYEE table
B . A unique constraint on the EMPLOYEE table WORKDEPT column
C . A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
D . A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table
-
Horizontal subdivision decks forming watertight compartments in the columns of a semisubmersible ship increase the unit’s().
A . tank capacities
B . stability in the event of damage
C . towing speed
D . anchor holding ratio
-
Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?()
A . Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.
B . Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).
C . Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.
D . Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.
-
tommy has created a sales view in his sales.nsf database. Tommy wants negative numbers in the sales number column in the view parenthesis. which one of the following should tommy do?()
A . select the parenthesis when negative value in the view properties box
B . select the parenthesis when negative value in the column properties box
C . use the @function @negative to set this in the column formula in the view
D . use a formula to format the value in the field on the form that will be displaying in the view
-
Derek has created a view in the sales.nsf db. Derek wants the sales value column in the view to be punctuated to display two decimal places . which one of the following should he do?()
A . use the @function @decimal in the column formula in the view
B . select decimal on the numbers tab in the view properties box
C . select decimal on the numbers tab in the column properties box
D . use the @function @decimal to format the value in the field on the form that will display in the view&e
-
After running the vmstat command, which of the following would most likely cause the value in the blocked column to be unusually high?()
A . Kernel thread
B . Too many users
C . Memory shortage
D . Network contentio
-
Straight B/L has a specified name in the column of __________ of the B/L.
-
The new type of advertisement in the classified columns of newspapers ________.
-
The material and cross-section of the four columns shown in the figure are all the same. What is the order of instability?http://image.zhihuishu.com/zhs/onlineexam/ueditor/201904/0e41844625fd4a3ebdb6901c268ada2f.png
-
The line chart is a simple form of graphic representation, in which data are arranged in rows and columns. ( )
-
In the process of completing a work sheet, you determine that the Income Statement debit column totals $83,000, while the Income Statement credit column totals $65,000. To enter net income () for the period into the work sheet would require an entry to
A.theAdjustmentsdebitcolumnandtheAdjustmentscreditcolumn.
B.theUnadjustedTrialBalancedebitcolumnandtheAdjustmentscreditcolumn.
C.itisnotpracticaltoenterNetIncomeontheworksheet.
D.theBalanceSheet﹠StatementofOwner’sEquitydebitcolumnandtheIncomeStatementcreditcolumn.
E.theIncomeStatementdebitcolumnandtheBalanceSheet﹠StatementofOwner’sEquitycreditcolumn.
-
Identify the accounts that would normally have balances in the credit column of a business’s trial balance
A.Revenues and liabilities.
B.Liabilities and expenses.
C.Revenues and expenses.
D.Assets and revenues.
E.Withdrawals and liabilities.
-
The Presidents comments on the number of lost jobs last month was______.
A.negative
B.positive
C.hopeless
D.enlightening