A database management system can be thought of as replacing...

A database management system can be thought of as replacing an organisation's: Select one: Oa. Computers b. Records Oc. Filing cabinet O d. Telephone Primary keys are used to identify a unique set of records. Select one: O True False Which of the following is not one of the strengths of the database approach? Select one: Oa. A database can ensure that each piece of data is recorded in only one place; therefore, one can control redundancy and prevent inconsistencies. Ob. Updating data is easier, as there is only one place where the data is housed. O c. Data can be kept more secure. Od. Anyone can set up and edit a database.

Transcript

00:02 Hello students, as of here is an sql statement that grants the privilege to the user accounts a, b, c and d and then creates the whiff to restrict the attributes for the account b.

00:14 So, where these statements are used to control the access to the specific tables and the columns within the database.

00:21 So, as of here you can see the first is to grant the privilege to the account with the a as account a is grant with the select insert update with this select insert update delete on the employee table.

00:40 So, on the employee department, department location project on depends.

00:46 So, here the grant option here you can see the grant option is used to allow the grant a to grant these privileges to the other users.

00:56 Whereas next as it sets the propagation time limit for the account a up to the 5.

01:04 So, where the statement sets a limit on how many accounts a can further propagate the privilege up to.

01:11 So, we have here assigned the 5 as up to they can apply they can like further it can have the accounts up to the limit of the 5.

01:23 The next is within grant with the privilege to the account b.

01:27 So, same with the grant b similar to that grant as the account b is granted select insert as well as the delete options.

01:39 Where in a grant account b select insert and update as well as the delete privilege on a specific column on the employee department and as well as with the employee locations like the department location and the project as they works on with it.

01:59 So, the grant privilege to the account c with the account c is granted to select insert as well as update and delete privileges works on with the table...

Question

Please give Ace some feedback