A many to many relationship between two entities usually results in how many tables?

Select one:
a. Three 
b. Two
c. Four

d. One
Feedback

The correct answer is: Three

Question 2
Correct
Mark 0.50 out of 0.50

Flag question

Question text

Select count (____ ID)

Select one:
a.  DISTINCT 
b. COUNT
c.  AVG

d. PRIMARY KEY
Feedback

Your answer is correct.

Question 3
Correct
Mark 0.50 out of 0.50
 Flag question

Question text

The database environment has all of the following components except:

Select one:
a. Separate files 
b. Database administrator
c. Database.

d. Users.
Feedback

The correct answer is: Separate files

Question 4
Correct
Mark 0.50 out of 0.50

Flag question

Question text

In ERD, the relationship type with degree 3 is known as

Select one:
a. Unary
b. Binary
c. Ternary 

d. Nary
Feedback

Your answer is correct.

Flag question

Question text

In case of entity integrity, the primary key maybe

Select one:
a. not Null 
b. Null
c. both Null & not Null.

d. any value.
Feedback

The correct answer is: not Null

Question 6
Incorrect
Mark 0.00 out of 0.50

Flag question

Question text

The keyword to eliminate duplicate rows from the query result in SQL is

Select one:
a. None of above
b. NO DUPLICATE
c. UNIQUE

d.  DISTINCT 
Feedback

Your answer is incorrect.

Question 7
Correct
Mark 0.50 out of 0.50

Flag question

Question text

The relational model feature is that there

Select one:
a. is much more data independence than some other database models. 
b. is no need for primary key data.
c. are explicit relationships among records.

d. are tables with many dimensions.

The correct answer is: is much more data independence than some other database models.

Question 8
Correct
Mark 0.50 out of 0.50

Flag question

Question text

Not applicable condition can be represented in relation entry as

Select one:
a. NULL 
b. NA
c. 0

d. Blank Space
Feedback

The correct answer is: NULL

Question 9
Correct
Mark 0.50 out of 0.50

Flag question

Question text

In relational terminology (RDBMS), an attribute is

Select one:
a. a field 
b. a record
c. an entity

d. a table
Feedback

The correct answer is: a field

Question 10
Correct
Mark 0.50 out of 0.50

Flag question

Question text

A type of query that is placed within a WHERE or HAVING clause of another query is called
Select one:
a. Master query
b. Super query
c. Multi query

d. Sub query 
Feedback

Your answer is correct.

Question 11
Correct
Mark 0.50 out of 0.50

Flag question

Question text

In a database, data is stored in spreadsheets which have rows and columns.

Select one:
True

False 
Feedback

The correct answer is 'False'.

Question 12
Correct
Mark 0.50 out of 0.50

Flag question

Question text
A relationship in database shows an association between two or more entities

Select one:
True 

False
Feedback

The correct answer is 'True'.

Question 13
Correct
Mark 0.50 out of 0.50

Flag question

Question text

An attribute describes the entity's characteristics.

Select one:
a. True 

b. False
Feedback

The correct answer is: True

Question 14
Correct
Mark 0.50 out of 0.50

Flag question

Question text

A database is called "self-describing" because it contains a description of itself.

Select one:
True 
 False
Feedback

The correct answer is 'True'.

Question 15
Correct
Mark 0.50 out of 0.50

Flag question

Question text

A database view is a searchable object in a database that is defined by a query.

Select one:
True 

False
Feedback

The correct answer is 'True'.

Question 16
Correct
Mark 0.50 out of 0.50

Flag question

Question text

Cardinality refers to the uniqueness of data values contained in a column.

Select one:
a. True 

b. False
Feedback

The correct answer is: True

Question 17
Correct
Mark 0.50 out of 0.50

Flag question

Question text

 The GROUP BY statement follows the WHERE clause in a SELECT statement and precedes
the ORDER BY clause.

Select one:
True 

False
Feedback

The correct answer is 'True'.

Question 18
Correct
Mark 0.50 out of 0.50

Flag question

Question text

Referential integrity constraints are also called as Functional dependencies.

Select one:
a. False 

b. True
Feedback

The correct answer is: False

Question 19
Correct
Mark 0.50 out of 0.50

Flag question

Question text

 You can use Subquery with SELECT, UPDATE, INSERT, DELETE statements along with the
operators like =, <, >, >=, <=, IN, BETWEEN.

Select one:
True 

False
Feedback

The correct answer is 'True'.

Question 20
Correct
Mark 0.50 out of 0.50

Flag question

Question text

A logical description of some portion of database that is required by a user to perform task
is called as System View.

Select one:
a. False 
b. True
Feedback

The correct answer is: False

Question 21
Complete
Marked out of 2.00

Flag question

Question text

What are constraints in DBMS?

The constraints are:

Question 22
Complete
Marked out of 2.00

Flag question

Question text

 Write and SQL query to fetch three max and min salaries from a table.
Question 23
Complete
Marked out of 2.00

Flag question

Question text

If primary key of table A is used as Foreign key in table B then which attribute will be
common in both tables ?

The attribute that is primary key in table A is common in both tables.

Question 24
Complete
Marked out of 2.00

Flag question

Question text

Differentiate between total and partial participation.

Question 25
Complete
Marked out of 2.00
 Flag question

Question text

Write down the difference between ternary and binary relationship

Question 26
Not answered
Marked out of 5.00

Flag question

Question text

A salesperson may manage many other salespeople. A salesperson is managed by only one
salespeople. A salesperson can be an agent for many customers. A customer is managed by
one salespeople. A customer can place many orders. An order can be placed by one
customer. An order lists many inventory items. An inventory item may be listed on many
orders. An inventory item is assembled from many parts. A part may be assembled into
many inventory items. Many employees assemble an inventory item from many parts. A
supplier supplies many parts. A part may be supplied by many suppliers.
Also identify cardinality, different types of attributes and keys and total and partial
participation