Which of the following is not an Aggregate function?

Question

Which of the following is not an Aggregate function?

A. Min

B. Max

C. Select

D. Avg

Correct Answer :

C. Select

Share this question with your friends

Show all Advance DBMS MCQ

Comment

A relation which is in 3NF is

Discuss this answer

A fragmentation is categorized in

A. 1 part

B. 2 part

C. 3 part

D. 4 part

Discuss this answer

Data Manipulation Language DML) is not to

Discuss this answer

A relation that has no partial dependencies is in which normal form

A. First

B. Second

C. Third

D. BCNF

Discuss this answer

Primary storage

D. cache

Discuss this answer

If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.

A. Noise

B. Delay

Discuss this answer

Triggers are also called

Discuss this answer

A type of query that is placed within a WHERE or HAVING clause of another query is called

Discuss this answer

In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?

B. serial

C. analog

Discuss this answer

Which of the following extracts its data from the result of an SQL SELECT statement.

A. View

Discuss this answer

Usenet is also known as

Discuss this answer

Transaction access data using two operations

Discuss this answer

Relational Algebra is

Discuss this answer

Mail services are available to network users through the

Discuss this answer

A transaction is said to have terminated if it has

Discuss this answer

The minimal set of super key is called

Discuss this answer

Which of the following is also known as Offline storage ?

Discuss this answer

In RDBMS, Data is presented as a collection of

B. Table

D. Entity

Discuss this answer

Which of the following works as a filter?

A. UPDATE

B. DROP

C. ALTER

D. SELECT

Discuss this answer

Transaction processing is associated with everything below except

Discuss this answer

What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency

Discuss this answer

.................. means sending a digital signal over a channel without changing the digital signal to an analog signal.

Discuss this answer

Which of the following submit and execute query at run time?

C. both

Discuss this answer

In an object oriented model, one object can access data of another object by passing?

Discuss this answer

In E-R Diagram weak entity set are represented by

Discuss this answer

Referential integrity

Discuss this answer

Select the incorrect statement

Discuss this answer

The access protocol used by traditional Ethernet

C. CSMA

Discuss this answer

Cross Product is a:

Discuss this answer

.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.

A. Noise

Discuss this answer

Answer 1

A. in 1NF also

Answer 2

B. in 2NF also

Answer 3

C. free from transitive dependencies

Answer 4

D. All of these

Answer 5

A. Create information table in the Database

Answer 6

B. Insertion of new information into the Database

Answer 7

C. Deletion of information in the Database

Answer 8

D. Modification of information in the Database

Answer 9

A. magnetic disk

Answer 10

B. magnetic tape

Answer 11

C. juke box

Answer 12

C. Dispersion

Answer 13

D. Attenuation

Answer 14

A. active rules

Answer 15

B. passive rules

Answer 16

C. inferences

Answer 17

D. none of the above

Answer 18

A. Super query

Answer 19

B. Sub query

Answer 20

C. Master query

Answer 21

D. Multi-query

Answer 22

A. parallel

Answer 23

D. digital

Answer 24

B. Synonym

Answer 25

C. Sequence

Answer 26

D. Transaction

Answer 27

A. Newsgroups

Answer 28

B. 10Km to 1Km

Answer 29

C. 10^3Km to 100Km

Answer 30

D. 100M to 10M

Answer 31

A. read(), print()

Answer 32

B. read(), write()

Answer 33

C. scan(), write()

Answer 34

D. none of the above

Answer 35

A. Data Definition Language.

Answer 36

B. Data Manipulation Language

Answer 37

C. Procedural query Language

Answer 38

D. None of the above

Answer 39

A. Session layer

Answer 40

B. Presentation layer

Answer 41

C. Application layer

Answer 42

D. Transport layer

Answer 43

A. either committed or aborted

Answer 44

B. either partially committed or aborted

Answer 45

C. either committed or failed

Answer 46

D. none of these

Answer 47

A. Primary key

Answer 48

B. Secondary key

Answer 49

C. Candidate key

Answer 50

D. Foreign key

Answer 51

A. primary storage

Answer 52

B. secondary storage

Answer 53

C. tertiary storage

Answer 54

D. none of the above

Answer 55

A. Relation

Answer 56

C. Attribute

Answer 57

A. producing detail, summary, or exception reports.

Answer 58

B. recording a business activity.

Answer 59

C. confirming an action or triggering a response.

Answer 60

D. maintaining data.

Answer 61

A. i, ii and iii only

Answer 62

B. i, ii and iv only

Answer 63

C. ii, iii and iv only

Answer 64

D. i, iii and iv only

Answer 65

A. Baseband transmission

Answer 66

B. Broadband transmission

Answer 67

C. Digital transmission

Answer 68

D. Analog transmission

Answer 69

A. Static SQL

Answer 70

B. Dynamic SQL

Answer 71

D. none of these

Answer 72

A. Instance variable

Answer 73

B. Variable

Answer 74

C. Message

Answer 75

D. Function

Answer 76

A. Ellipse

Answer 77

B. Dashed ellipse

Answer 78

C. Dashed Rectangle

Answer 79

D. Doubled Rectangle

Answer 80

A. controls relationships between operations of an object

Answer 81

B. controls relationships between instances of a class

Answer 82

C. controls relationships between attributes in a table

Answer 83

D. controls relationships between tables in a database

Answer 84

A. BCNF is stronger than 3NF

Answer 85

B. Relational algebra is a non-procedural language

Answer 86

C. Every conflict serializable schedule is view serializable.

Answer 87

D. none of the above

Answer 88

A. CSMA/CA

Answer 89

B. CSMA/CD

Answer 90

D. Token ring

Answer 91

A. Unary Operator

Answer 92

B. Binary Operator

Answer 93

C. Ternary Operator

Answer 94

D. none of the above

Answer 95

B. Delay distortion

Answer 96

C. Attenuation distortion

Answer 97

D. Dispersion

Which of the following is not an Aggregate function?

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

A relation which is in 3NF is

A fragmentation is categorized in

Data Manipulation Language DML) is not to

A relation that has no partial dependencies is in which normal form

Primary storage

If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.

Triggers are also called

A type of query that is placed within a WHERE or HAVING clause of another query is called

In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?

Which of the following extracts its data from the result of an SQL SELECT statement.

Usenet is also known as

Transaction access data using two operations

Relational Algebra is

Mail services are available to network users through the

A transaction is said to have terminated if it has

The minimal set of super key is called

Which of the following is also known as Offline storage ?

In RDBMS, Data is presented as a collection of

Which of the following works as a filter?

Transaction processing is associated with everything below except

What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency

.................. means sending a digital signal over a channel without changing the digital signal to an analog signal.

Which of the following submit and execute query at run time?

In an object oriented model, one object can access data of another object by passing?

In E-R Diagram weak entity set are represented by

Referential integrity

Select the incorrect statement

The access protocol used by traditional Ethernet

Cross Product is a:

.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.

Also checkout

Which of the following is not an Aggregate function?

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

A relation which is in 3NF is

A fragmentation is categorized in

Data Manipulation Language DML) is not to

A relation that has no partial dependencies is in which normal form

Primary storage

If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.

Triggers are also called

A type of query that is placed within a WHERE or HAVING clause of another query is called

In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?

Which of the following extracts its data from the result of an SQL SELECT statement.

Usenet is also known as

Transaction access data using two operations

Relational Algebra is

Mail services are available to network users through the

A transaction is said to have terminated if it has

The minimal set of super key is called

Which of the following is also known as Offline storage ?

In RDBMS, Data is presented as a collection of

Which of the following works as a filter?

Transaction processing is associated with everything below except

What are the different types of radio waves that are used for computer network applications?i) Spread spectrumii) High power, single frequencyiii) High power, multiple frequencyiv) Low power, single frequencyv) Low power, multiple frequency

.................. means sending a digital signal over a channel without changing the digital signal to an analog signal.

Which of the following submit and execute query at run time?

In an object oriented model, one object can access data of another object by passing?

In E-R Diagram weak entity set are represented by

Referential integrity

Select the incorrect statement

The access protocol used by traditional Ethernet

Cross Product is a:

.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.

Also checkout

What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency