Reference no: EM133453929
Questions:
1.What is a query? Summarize the steps required to formulate a query.
2.What is database optimization? Why do we need to optimize a DBMS with SQL performance tuning, even though they automatically optimize SQL queries?
3. Is it possible to remove a table from a database? How would this be done? Share an example using proper syntax.
4.What does NoSQL stand for? What is NoSQL and what are the major NoSQL approaches (categories)?
5.Before you start with data visualization, you must understand the data. The same data can be presented in multiple ways. Explain the two types of data.
6. What is a DBMS? Provide examples. List and describe some typical DBMS processes.
7. What are the mandatory clauses of a SELECT statement and what do they represent?
8. Based on the output of a table, which statement is valid?
9. Examine the table below. Provide the create table statement that created this table.
10. Describe the DBA's managerial role.
11. Describe the need for convenient and safe backup storage.
12. What is an Entity Relationship Diagram? Please describe the components. Why are these important?
13. Define each of the terms and describe how they work together in a table: data, field and record.
14. Explain the difference between a database and a spreadsheet.