8.In system buffer cache, used in UNIX, following not true
Options: (A)It is a disk cache (B) It is not a disk cache (C) Data transfer between buffer cache and user process space always occurs using DMA. (D) I/O operations with disk are handled through buffer code. 14
5.In system modeling: A-Architectural model: B-Stimulus-response model: C-Behavioral models::1-Used to describe the overall behavior of the system: 2-State transition diagram show how the system reacts to internal and external events:3-Shows principal sub-systems which makes the system
Which of the following is correct regarding Aggregate functions?
Options: it takes a list of values and return a single values as result
B. it takes a list of values and return a list of values as result
C. it takes a single value and returns a list of values as result
D. it takes a single value and returns a single value as result
Options: to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace, to create a database trigger, to add/rename data files, to change storage, All of the above
Options: a. Checks the value entered when user leaves the field
b. Displays the value in specified format when user leaves the field
c. Defines the appearance for the text
d. There is no option of Validation Rule
To create primary key for a table when in design view
Options: a. Type PRIMARY in field type box when creating required field,
b. Mark the Primary check box in field name of required field,
c. Click the Primary Key button in Design ribbon when the cursor is in required field,
d. None of the above
Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
Options: Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row., Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column., Three rows have the values Brown, NULL, and Blue in the same column., One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.