1.Question 1In which phase of the database lifecycle does the database administrator work on logical and physical design?1 pointExpand2.Question 2Which of the following database objects defines a set of actions performed in response to an insert, update, or delete on a specified table?1 pointExpand3.Question 3What is the first step to modify the configuration of an on-premises relational database?1 pointExpand4.Question 4Database partitions store subsets of data from very large databases. Which of the following environments commonly use partitions?1 pointExpand5.Question 5What is one advantage of physical backups over logical backups?1 pointExpand6.Question 6What does a database management system (DBMS) use transaction logs to do?1 pointExpand7.Question 7What is one advantage of differential backups over full backups?1 pointExpand8.Question 8Assume that a particular database issue, should it occur, is important but does not require your immediate attention. Which automated database feature should you use to inform you when this issue occurs?1 pointExpand9.Question 9Which security method verifies that users are who they say they are?1 pointExpand10.Question 10When creating a backup and restore policy, you must determine an appropriate schedule. Which of the following factors should impact your decision regarding this schedule?1 pointExpand11.Question 11When you first create a database user, how many permissions will the user generally have by default?1 pointExpand12.Question 12The GRANT connect statement connects a user or group to a database. What else does the GRANT statement do?1 pointExpand13.Question 13In MySQL, you can use

. • 2h 5m. • 25 total points available.25 total pointsEnglishDueJul 22, 11:59 PM PDT1.Question 1In which phase of the database lifecycle does the database administrator work on logical and physical design?1 pointExpand2.Question 2Which of the following database objects defines a set of actions performed in response to an insert, update, or delete on a specified table?1 pointExpand3.Question 3What is the first step to modify the configuration of an on-premises relational database?1 pointExpand4.Question 4Database partitions store subsets of data from very large databases. Which of the following environments commonly use partitions?1 pointExpand5.Question 5What is one advantage of physical backups over logical backups?1 pointExpand6.Question 6What does a database management system (DBMS) use transaction logs to do?1 pointExpand7.Question 7What is one advantage of differential backups over full backups?1 pointExpand8.Question 8Assume that a particular database issue, should it occur, is important but does not require your immediate attention. Which automated database feature should you use to inform you when this issue occurs?1 pointExpand9.Question 9Which security method verifies that users are who they say they are?1 pointExpand10.Question 10When creating a backup and restore policy, you must determine an appropriate schedule. Which of the following factors should impact your decision regarding this schedule?1 pointExpand11.Question 11When you first create a database user, how many permissions will the user generally have by default?1 pointExpand12.Question 12The GRANT connect statement connects a user or group to a database. What else does the GRANT statement do?1 pointExpand

3.Question 3Which of the following statements is correct about modifying the configuration of a cloud-based relational database?1 pointExpand4.Question 4Database partitions store subsets of data from very large databases. Which of the following environments commonly use partitions?1 pointExpand5.Question 5Which of the following key considerations is perhaps the most important?1 pointExpand6.Question 6Transaction logs typically have which of the following characteristics?1 pointExpand7.Question 7Which type of backup is simple to create and restore, but can be slow to run and results in large files?1 pointExpand8.Question 8Assume that a particular database issue, such as extremely low drive space, would require your urgent attention should it occur. Which automated database feature should you use to inform you when this issue occurs?1 pointExpand9.Question 9Together authentication, authorization, encryption, and auditing provide system and data security. Which security method provides information that you can analyze to determine and find weak spots?1 pointExpand10.Question 10When creating a backup and restore policy, you must consider the frequency with which you should backup data. Which of the following factors should determine this frequency?1 pointExpand11.Question 11When you first create a database user, how many permissions will the user generally have by default?1 pointExpand12.Question 12Which of the following statements can you use to override a user’s permission for a certain object or action?1 pointExpand13.Question 13In MySQL, you can use which command to specify a different default storage engine?1 pointExpand14.Question 14Which of the following is an action you can take to help you identify potential future attacks, such as brute force attempts, on your system?1 pointExpand15.Question 15Which type of encryption uses a public and a private key?1 pointExpand

Describe the differences between logical and physical database design. Discuss the objectives of logical design, such as minimizing redundancy and improving data integrity, and the considerations involved in physical design, such as storage allocation and indexing. with diagram or scoring material

Database Management SystemsUNIT-ITwo marks questions:1. What is database? Define DBMS2. What do you mean by defining, constructing, manipulating and sharing adatabase?3. Define data abstraction. Give any two levels of abstraction4. Define query and transaction5. List the phases of database application6. List the characteristics of Database approach7. Give the disadvantages of file processing system.8. Define Metadata. Give an example9. What do you mean by program data independence and program-operationindependence?10.Define Data Model. Give the categories of data model11.Mention the following12.actors on the scene13.workers behind the scene14.What is redundancy? Which problems may arise while storing redundant data?15.List the limitations/disadvantages of DBMS16. Who is a DBA? What are the responsibilities of a DBA?17.Who are database designers? What are their responsibilities?18.What is the responsibility of backup and recovery subsystem?19.What are the advantages of using a DBMS?20.What does the isolation and atomicity property ensure?21.Define Entity, Attribute and relationship22.What is database schema, Schema diagram?23.What do you mean by database state? When do you say the database state is valid?24.Define the terms Internal, external and conceptual schema (any two)25.What do you mean by Logical Data Independence?26.What do you mean by physical data Independence?27.What is the purpose of storage manager?28.List the functions of runtime database processor29.Discuss about Data Definition language?30.Discuss about Data Definition language?31.List the functions of Database System Utilities32.Define a) meta-data b) data dictionary33.List various types of attributes?34.Explain data model and list the types of data model used?35.Define Single-Valued versus Multivalued Attributes, give example36.Define Stored versus Derived Attributes, give example37.Define Composite versus Simple (Atomic) Attributes, give example38.Composite versus Simple (Atomic) Attributes39.Define the terms i) Entity set ii) Relationship set40.Define the terms i) Key attribute ii) Value set(Domain)41.What do you mean by relationship type and relationship instances?42.Define “degree of relationship type”43.What do you mean by role names in the relationship? Give example44.What does the cardinality ratio specify? Which are the possible cardinality ratiosfor binary relationship types45.Define the terms i) Total participation ii) Partial Participation46.Define weak and strong entity types?47.What is partial key? Give example48.Who is Database Administrator?49.Definition of system designer, tool developer, operator & maintenance personnel.50.What is meant by restricting unauthorized access?51.What is deductive database system?52.Why storage definition language (SDL) is used?53.Why interfaces for DBA are used?3 OR MORE MARKS1. What are the characteristics of DBMS? Explain2. Explain the different categories of End Users in DBMS?3. Write a short note on4. DBA ii. Database Designers5. Explain the different categories of workers those are associated with the design,development and operation of the DBMS6. Explain any four advantages of DBMS7. Explain the different categories of data models8. Explain three schema architecture of database with a neat diagram9. What is data Independence? Explain their types10.What are the different database languages? Explain with example

QUESTION ONE a) James, a DBA working for a software development company was required to design adatabase management system.Required:(i) Outline two principle requirements he would consider when selecting thestorage media for the proposed database system (ii) Explain five benefits the proposed database system will deliver to thecompany (iii) List and explain three challenges James is likely to encounter whileimplementing the proposed database system b) List and explain four DML commands supported by SQL/ MYSQL [4 Marks]c) List and explain three components of a DBMS d) Explain three qualities of a good database system QUESTION TWO a) Explain the following terms as used in database systems:- (i) Database(ii) Data integrity(iii) Candidate key(iv) Relationshipb) Define the term “database normalization” c) Discuss four benefits of database normalization d) With the aid of appropriate illustrations, describe the following database models:-(i) Relational model(ii) Hierarchical mode e) Differentiate between the following database terms:-(i) Logical design & physical design Answer text