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
Ans:– A ,
More Database Systems Related questions:
What is the method of handling deadlocks?
Options: Use a protocol to ensure that the system will never enter a deadlock state.
B. Allow the system to enter the deadlock state and then recover.
C. Pretend that deadlocks never occur in the system.
D. All of the Above
Ans:– D ,
A homogenous distributed database is which of the following?
Options: The same DBMS is used at each location and data are not distributed across all nodes., The same DBMS is used at each location and data are distributed across all nodes., A different DBMS is used at each location and data are not distributed across all nodes., A different DBMS is used at each location and data are distributed across all nodes.
Which of the following would be good reasons to run NAT? You need to connect to the Internet and your hosts don't have globally unique IP addresses. You change to a new ISP that requires you to renumber your network. You don't want any hosts connecting to the Internet. You require two intranets with duplicate addresses to merge.
Options: 1, 2 and 4, 2 and 4, 3 only, All of the above
Which SQL Query is use to remove a table and all its data from the database?
a. Create Table
b. Alter Table
c. Drop Table
d. None of these
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
In laser technology, what happens during the transfer stage?
Options: Residual toner is transferred to the waste receptacle, The laser transfers the image from the drum to the paper, The image is transferred from the drum to the paper, A negative charge is transferred to the surface of the drum
. To achieve and effect when you are entering criteria in a query design window
Options: a. Write criteria values vertically one in a row
b. Write criteria values horizontally
c. Write criteria values in same field separated with and
d. Write criteria values in same field separated with &
Which of the following describes an industry-wide standard suite of protocols and algorithms that allows for secure data transmission over an IP-based network that functions at the layer 3 Network layer of the OSI model?
Options: decides which program to run, counts the number of instructions that have been executed, contains the address of the next instruction to be executed, is where arithmetic is done in a computer.
Which of the following statements mentioning the name of the array begins DOES NOT yield the base address? 1: When array name is used with the sizeof operator. 2: When array name is operand of the & operator. 3: When array name is passed to scanf() function. 4: When array name is passed to printf() function.
Which of the following is(are) true of the EDP auditors?
Options: they should have computer expertise, they will be replaced by traditional auditors in the near future, two of the above, currently, there is a very high demand for them, particularly from firms that use personal computers