these paths so basically split function it takes a path name and turns it into the two parts that is the directory path and the file name so for that what you can do is type in print and say os but part pasty pasty let me just copy the spot. Comment this so now I need to perform the join operation, so I just simply type in os dot path toward join and inside this I be writing two paths. You can also access the names of your file path by just typing in list dir. So let me just show you some of the operations with this os module if I go back to my pie chart it will create one more file here and I'll name it as os module. Now first of all, I have to import the modules. If you're typing in from the command line, you can use the import statement: import os. os that path jo join is one of the important oh a spot tools so it takes one or more paths and joins them by using the current os path separator, say to join two paths. os dot path provides a range of useful methods to manipulates the files and directories, should they implement some of the methods of this module also. os model has been joined with the python script ring, so next you can also split these paths so basically split function it takes a path name and turns it into the two parts that is the directory path and the file name so for that what you can do is type in print and say os but part pasty pasty let me just copy the spot. Comment this so now I need to perform the join operation, so I just simply type in os dot path toward join and inside this I be writing two paths.

First, you can use this math module to perform angular conversions, such as radians to degree or vice versa. You can also calculate the natural log or log base 10. Additionally, this module can be used to perform other calculations, such as finding the hypotenuse.

A Chief information Security Officer (CISO) has launched to create a rebuts BCP/DR plan for the entire company. As part of the initiative , the security team must gather data supporting s operational importance for the applications used by the business and determine the order in which the application must be back online. Which of the following be the FIRST step taken by the team?

Options:
A Perform a review of all policies an procedures related to BGP a and DR and created an educated educational module that can be assigned to at employees to provide training on BCP/DR events.
B Create an SLA for each application that states when the application will come back online and distribute this information to the business units.
C Have each business unit conduct a BIA and categories the application according to the cumulative data gathered.
D Implement replication of all servers and application data to back up detacenters that are geographically from the central datacenter and release an upload BPA to all clients.

A Chief information Security Officer (CISO) has launched to create a rebuts BCP/DR plan for the entire company. As part of the initiative , the security team must gather data supporting s operational importance for the applications used by the business and determine the order in which the application must be back online. Which of the following be the FIRST step taken by the team?

Options:
A Perform a review of all policies an procedures related to BGP a and DR and created an educated educational module that can be assigned to at employees to provide training on BCP/DR events.
B Create an SLA for each application that states when the application will come back online and distribute this information to the business units.
C Have each business unit conduct a BIA and categories the application according to the cumulative data gathered.
D Implement replication of all servers and application data to back up detacenters that are geographically from the central datacenter and release an upload BPA to all clients.

PL/SQL language

STATEMENTS :
A Bank is characterized by:
• Bank code: character on 10 positions,
• Company name: character on 10 positions
• Capital: Numeric with 3 positions after the comma,
• Address: character on 10 positions.
It has a set of Agencies. Each Agency is characterized by:
• Agency code: character in 10 positions,
• Label: character in 10 positions,
• Address: character on 10 positions,
• Latitude: character on 10 positions,
• Longitude: character in 10 positions.
An Agency has several clients. A Client is characterized by:
• Customer code: character on 10 positions,
• Name: character in 30 positions,
• Address: character in 30 positions,
• Telephone: character on 10 positions
A Client may have 1 or more Accounts. An Account is characterized by:
• Account number: character on 10 positions,
• Balance: Numerical with 3 positions after the comma,
• Flow rate threshold: Numeric with 3 positions after the decimal point,
• Balance date: Date.

• State: character on 10 positions.

There are two types of Account
• Current account
• Savings account.
An Account can have one or more Cards attached to it. A Card is characterized by:
• Card number: character on 16 positions
• Type of card: character on 10 positions
• Ceiling: Numerical with 3 positions after the decimal point
• Expiration date: Date

QUESTIONS :
1. Give the class diagram.
2. Give the different tables indicating the relationships between the different Tables.
3. Write a Withdraw function in PL/SQL that takes an account number as an argument and a withdrawal amount then performs the withdrawal operation by modifying the balance in the Account table. Note the withdrawal can only be made if balance – amount > threshold. The function returns the new balance after the withdrawal.
4. Write a Payment function in PL/SQL that takes as argument a number of the account and an amount then updates the balance in the Account table. The function returns the new balance after withdrawal.
5. Write a trigger to raise an exception in the event of a decrease in the balance of an account whose status is “blocked”.
6. To archive the history of Account table update operations, create a History table (NumCpt, operation_date, operation_type). Write a trigger allowing, after the execution of each operation on Account, to add a tuple regarding this operation to the History table.
7. Write a Withdrawal_Card function in PL/SQL which takes as argument a card number card and an amount then updates the balance in the Account table. Function returns the new balance after the withdrawal. The withdrawal can only be made if the balance allows him and the ceiling.
8. Write a trigger allowing to raise an exception in the case of an expiration of the date of a card.
9. Write a procedure that allows each Bank to display the branch code, wording of the Agency, name and balance of the Client having the largest balance in this Agency.
10. Write a PL/SQL procedure to display for all Agencies the three first highest Account balances, if there is not only one balance then display for the second and third, the same value as the first; and if he only two different balances exist, so display the same value for the third than the second.