Exam 3: Database Concepts I

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

An employee in one department such as sales wanting to check on inventory levels would have to contact the inventory department and enquire about inventory balances.This indicates an absence of:

(Multiple Choice)
4.7/5
(35)

How can data about customer contact details and data about their orders be stored in a database?

(Multiple Choice)
4.8/5
(41)

DBMS stands for:

(Multiple Choice)
4.9/5
(36)

Information is:

(Multiple Choice)
4.8/5
(42)

What are the three possible types of relationship in ER diagrams? Explain.

(Essay)
4.9/5
(38)

Give an example of how data redundancy can occur.

(Essay)
4.8/5
(34)

Which of the following is NOT an instance of data anomalies?

(Multiple Choice)
5.0/5
(36)

The following database tables are used Student Table The following database tables are used Student Table   Course Table   The Course_ID in the student table is best described as: Course Table The following database tables are used Student Table   Course Table   The Course_ID in the student table is best described as: The Course_ID in the student table is best described as:

(Multiple Choice)
4.9/5
(36)

The particular values for a customer are stored in the ____ of a ____ within the customer ________.

(Multiple Choice)
4.9/5
(40)

Which of the following is less likely to be the job of a database administrator?

(Multiple Choice)
4.7/5
(36)

With regards to a database system,which of the following statements is NOT true?

(Multiple Choice)
4.9/5
(41)

A database system consists of:

(Multiple Choice)
4.8/5
(33)

In relational database,the columns and rows in a table represent,respectively:

(Multiple Choice)
4.9/5
(34)

Student Table Student Table     Course Table     The Course_ID in the student table is best described as: -Examine the database tables in Q44.If Course_ID is removed from the student table,then when a query is performed on the student table: (i)It is unable to determine the name of the course related to the student (ii)It is unable to determine the ID of the course related to the student (iii)It is unable to determine the course_semester related to the student. Course Table Student Table     Course Table     The Course_ID in the student table is best described as: -Examine the database tables in Q44.If Course_ID is removed from the student table,then when a query is performed on the student table: (i)It is unable to determine the name of the course related to the student (ii)It is unable to determine the ID of the course related to the student (iii)It is unable to determine the course_semester related to the student. The Course_ID in the student table is best described as: -Examine the database tables in Q44.If Course_ID is removed from the student table,then when a query is performed on the student table: (i)It is unable to determine the name of the course related to the student (ii)It is unable to determine the ID of the course related to the student (iii)It is unable to determine the course_semester related to the student.

(Multiple Choice)
4.8/5
(33)

Refer to the following ER diagram Refer to the following ER diagram   The Charges time to shape represents a: The "Charges time to" shape represents a:

(Multiple Choice)
4.8/5
(31)

An attribute (or column)that uniquely identifies a particular object (or row)in the table is called:

(Multiple Choice)
4.8/5
(37)

The process of developing ER diagrams is:

(Multiple Choice)
4.8/5
(33)

How is the design of a relational database determined in an organisation?

(Multiple Choice)
4.9/5
(41)

A table is:

(Multiple Choice)
4.9/5
(41)

Relational databases typically store data:

(Multiple Choice)
4.8/5
(37)
Showing 21 - 40 of 60
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)