. Which of the following statements about criteria in a query is NOT true?
Options: a. Criteria can contain wildcard characters.
b. Criteria in a query selects or excludes certain records.
c. Criteria cannot be specified as an expression.
d. Multiple criteria can be specified using AND, OR, and relational operators.
Options: Acts like a WHERE clause but is used for groups rather than rows., Acts like a WHERE clause but is used for rows rather than columns., Acts like a WHERE clause but is used for columns rather than groups., Acts EXACTLY like a WHERE clause.
The advantage of a command processor running only built-in commands is:
Options: flexibility to the users in running lists of commands by simply collecting them in named batch command files, the command set being common across different hardware configurations, users can create system programs and run them as commands, the processing is much faster than would other-wise be the case when user defined commands are used
Which of the following option is use to retrieval of data?
b. Data Structure
c. Linked list
Options: Every primary-key value must match a primary-key value in an associated table
B. Every primary-key value must match a foreign-key value in an associated table
C. Every foreign-key value must match a primary-key value in an associated table
D. Every foreign-key value must match a foreign-key value in an associated table
Ans:– d ,
. To drag a selected range of data to another worksheet in the same workbook, use the
Options: a. Tab key b. Alt key c. Shift key d. Ctrl key
Options: An official standard has been defined for QBE., QBE cannot be used for client/server systems., QBE does not give the programmer a visual programming environment., Complete applications can be written using QBE.
Sales persons and other employees of the company who spend much of their time away from their offices but keep in touch with their company's microcomputers or main frame computers over telephone lines are called
Options: field workers, telecommuters, teleprocessors, company directors