Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Database Technology 2, Lecture notes of Information Technology Management

You can learn a lot for this topic

Typology: Lecture notes

2019/2020

Available from 11/27/2021

carlojohnracho11
carlojohnracho11 🇵🇭

18 documents

1 / 1

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Database Administrator
1. What does the primary key of a database table represent? What about its secondary key?
2. What is the difference between an operational database, relational database, and object-
oriented database?
3. How would you migrate a database built in MySQL to Microsoft SQL Server?
4. What do the ‘INSERT’, ‘UPDATE’, and ‘DROP’ queries do?
5. When would you use an offline backup method versus an online method?

Partial preview of the text

Download Database Technology 2 and more Lecture notes Information Technology Management in PDF only on Docsity!

Database Administrator

  1. What does the primary key of a database table represent? What about its secondary key?
  2. What is the difference between an operational database, relational database, and object- oriented database?
  3. How would you migrate a database built in MySQL to Microsoft SQL Server?
  4. What do the ‘INSERT’, ‘UPDATE’, and ‘DROP’ queries do?
  5. When would you use an offline backup method versus an online method?