whatsapp

Connect on Whatsapp : +1 206 673 2541, Get Homework Help 24x7, 100% Confidential. Connect Now

Database | Database management systems homework help

  1. One of three basic database functions that are necessary to balance these conflicting goals is backup and recovery. Briefly analyze the goal of backup and recovery.

 

  1. In Database, What is the difference between DELETE and TRUNCATE?

 

  1. Which of the following is not an entity?

 

  • Student

 

  • Employee

 

  • Instructor

 

 

  1. A table can be logically connected to another table by defining which of the following?

 

  • common field.

 

  • primary key.

 

 

  • foreign key.

 

  1. A relational database is a group of which of the following?

 

  • common fields.

 

  • related tables.

 

  • field values.

 

 

 

  1. Of the following fields, which would be the most appropriate for the primary key in a customer information table? Explain.

 

  • Customer name

 

  • Customer number

 

  • Phone number

 

  • Customer address.

 

  1. In the data step merge, the BY variables in all data sets must have the same _____.

 

  • Name and type

 

  • Name, type, and length

 

  • Name and length

 

 

 

  1. Which of the following is an example of a lost update?

 

  1. The system assigns the last aisle seat on a flight to John whereas Peter receives a window seat, although both indicated preference for an aisle seat.

 

  1. John and Peter receive each a window seat as they both requested.

 

  1. John is initially assigned the last window seat, but this seat is later on assigned to Peter.

 

  1. None of the above.

 

 

  1. All transactions must display ____________________

 

  1. atomicity, serializability, and durability.

 

  1. durability, atomicity, consistency, and isolation.

 

  1. serializability, durability, and isolation.

 

  1. durability and isolation
Get FREE Essay Price Quote
Pages (550 words)
Approximate price: -