About SmartExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:

Accounting,Business & Finance See all

Accounting,Business & Finance,Economics,English,HR Management,Math Hide all

Teaching Since:	Apr 2017
Last Sign in:	4 Weeks Ago, 6 Days Ago
Questions Answered:	7559
Tutorials Posted:	7341

Education

BS,MBA, PHD
Adelphi University/Devry
Apr-2000 - Mar-2005

Experience

HOD ,Professor
Adelphi University
Sep-2007 - Apr-2017

Category > Programming Posted 24 Feb 2023 My Price 25.00

Introduction to Relational Database Management Systems Unit 3 Milestone

CIS 111 SOPHIA-STRAYER Introduction to Relational Database Management Systems Unit 3 Milestone-sobtell.com

Click link for Answers All Correct

In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment.

https://postgres.sophia.org/

Which of the following operators will attempt to use a hash or b-tree index?

•

https://postgres.sophia.org/

Which of the following statements would create a role named regular_user with no added features?

•

CREATE ROLE regular_user;

•

CREATE ROLE regular_user CREATEROLE;

•

CREATE ROLE regular_user INHERIT;

•

CREATE ROLE regular_user NOINHERIT;

https://postgres.sophia.org/

Which of the following scenarios reflects the durability property?

•

1. A user attempts to do a product transfer between companies.

2. The quantity of the product is moved from the first company.

3. Only once the product is verified to have been deducted, the quantity is moved to the second company.

4. Verification is done and identifies that the total amounts before and after the transactions are not maintained.

5. The transaction is reverted.

•

1. In the library database, there are 50 books available.

2. Billy has checked and there are 50 books.

3. Sam has checked and there are 50 books.

4. Billy has taken out 5 books.

5. The library system informs Sam of the update and Sam now checks that there are 45 books.

6. Sam checks out 10 books.

7. There are now 35 books in the library database.

•

1. Tiffany has updated a customer's address while on the phone with them.

2. The server restarted after Tiffany clicked on save.

3. When the server comes back up, Tiffany was able to verify that the address was updated.

•

1. In the flower database, there are 50 flowers available.

2. Reese has checked and there are 50 flowers.

3. Reese has attempted to take out 5 flowers.

4. Which trying to take them out, there was an error in trying to dispense.

5. While checking, there are still 50 flowers available in the system.

https://postgres.sophia.org/

Which is an advantage of both the command line and the GUI?

•

We can encode the backup file to another format.

•

We can restore a remote database.

•

We can use any parameters without limitation.

•

We can backup multiple databases at once.

https://postgres.sophia.org/

Which of the following statements would restore only the table 'customer' from the mydatabase database from backup.sql?

•

psql -t customer mydatabase < backup.sql

•

psql -a customer mydatabase < backup.sql

•

psql -t customer < backup.sql

•

psql mydatabase customer < backup.sql

https://postgres.sophia.org/

Which of the following criterion is specific to the isolation property?

•

All SQL requests of a transaction must be completed; if not, the transaction must be aborted.

•

Data used in one transaction cannot be used in another transaction until the first transaction is completed.

•

When a transaction is completed, the database must be in a consistent state.

•

Once transaction changes are done and saved, they cannot be lost.

https://postgres.sophia.org/

Using which type of process between the user input and dynamically created statements can help reduce the number of SQL injection attacks?

•

Coding

•

Posting

•

Filtering

•

Construction

https://postgres.sophia.org/

Which of the following statements will grant update permissions on the customer table to all users?

•

GRANT UPDATE ON 'customer' TO 'public';

•

GRANT UPDATE ON customer TO public;

•

GRANT UPDATE ON customer TO ALL;

•

GRANT UPDATE ON public to customer;

https://postgres.sophia.org/

Which of the following scenarios reflects the atomicity property?

•

1. Tiffany has updated a customer's address while on the phone with them.

2. The server restarted after Tiffany clicked on save.

3. When the server came back up, Tiffany was able to verify that the address was updated.

•

1. A user attempts to do a product transfer between companies.

2. The quantity of the product is moved from the first company.

3. The quantity is moved to the second company without verifying that it has been deducted from the first company.

4. The transaction is accepted.

•

1. In the flower database, there are 50 flowers available.

2. Reese has checked and there are 50 flowers.

3. Reese has attempted to take out 5 flowers.

4. While trying to take them out, there was an error in trying to dispense.

5. While checking, there are still 50 flowers available in the system.

•

1. In the library database, there are 50 books available.

2. Billy has checked and there are 50 books.

3. Sam has checked and there are 50 books.

4. Billy has taken out 5 books.

5. The library system informs Sam of the update and Sam now checks that there are 45 books.

6. Sam checks out 10 books.

7. There are now 35 books in the library database.

https://postgres.sophia.org/

Which of the following sequences of statements would ensure that Jennifer has the privileges of the roles of finance and executive?

•

CREATE ROLE executive NOINHERIT;

CREATE ROLE finance NOINHERIT;

GRANT executive to jennifer;

GRANT executive to finance;

•

CREATE ROLE executive INHERIT;

CREATE ROLE finance INHERIT;

GRANT finance to jennifer;

GRANT executive to jennifer;

•

CREATE ROLE executive NOINHERIT;

CREATE ROLE finance INHERIT;

GRANT finance to jennifer;

GRANT executive to finance;

•

CREATE ROLE executive NOINHERIT;

CREATE ROLE finance NOINHERIT;

GRANT finance to jennifer;

GRANT executive to finance;

https://postgres.sophia.org/

Which of the following statements represents a correctly structured transaction?

•

BEGIN;

COMMIT;

UPDATE customer

SET postal_code = '33433'

WHERE customer_id = 22;

UPDATE customer

SET postal_code = '10789'

WHERE city = 'Berlin';

UPDATE customer

SET company = 'Humor Inc.'

WHERE city = 'Prague';

•

BEGIN;

UPDATE customer

SET postal_code = '33433'

WHERE customer_id = 22;

UPDATE customer

SET postal_code = '10789'

WHERE city = 'Berlin';

UPDATE customer

SET company = 'Humor Inc.'

WHERE city = 'Prague';

COMMIT;

•

UPDATE customer

SET postal_code = '33433'

WHERE customer_id = 22;

UPDATE customer

SET postal_code = '10789'

WHERE city = 'Berlin';

UPDATE customer

SET company = 'Humor Inc.'

WHERE city = 'Prague';

COMMIT;

•

BEGIN

UPDATE customer

SET postal_code = '33433'

WHERE customer_id = 22

UPDATE customer

SET postal_code = '10789'

WHERE city = 'Berlin'

UPDATE customer

SET company = 'Humor Inc.'

WHERE city = 'Prague'

COMMIT

https://postgres.sophia.org/

Which type of backup would require no more than 2 backup sets?

•

Full backup and nightly backup

•

Incremental and full backup

•

Differential and incremental backup

•

Differential and full backup

https://postgres.sophia.org/

Which of the following scenarios reflect the consistency property?

•

1. Jeff checks his user profile and sees his email address is set to jeff@gmail.com.

2. Jeff changes his email to set it to jeff@outlook.com but does not click on save yet.

3. A customer rep checks into Jeff's account and sees jeff@gmail.com.

4. Jeff clicks on save.

5. Another customer rep checks Jeff's account and sees jeff@outlook.com.

•

1. User 1 has $500 in their online account.

2. User 2 has $300 in their online account.

3. User 1 sends user 2 $100.

4. User 1 has $400 in their account.

5. User 2 has $300 in their account.

6. The transaction is reverted.

•

1. A fairly large transaction is run to import new customers.

2. The import is saved to the logs.

3. The import starts to then save to the disk.

4. The disk fails midway through the update.

5. A new disk replaces the failed disk.

6. The backup is applied and the saving of the data is run from the logs.

•

1. A vendor has 5 orders available.

2. A customer attempts to purchase all 5.

3. The system deducts it from the vendor and adds it to the customer.

4. The vendor now has 0 orders available.

5. The customer has 0 orders purchased.

5. The transaction is saved.

https://postgres.sophia.org/

Which of the following statements would create a user login role named testuser1 with the password set as testpassword1 that is valid until 2042-01-01?

•

CREATE ROLE 'testuser1'

PASSWORD 'testpassword1'

EXPIRES '2042-01-01'

•

CREATE ROLE testuser1

VALID UNTIL '2042-01-01'

PASSWORD 'testpassword1'

•

CREATE ROLE testuser1

PASSWORD 'testpassword1'

VALID UNTIL '2042-01-01'

•

CREATE USER testuser1

PASSWORD testpassword1

VALID UNTIL 2042-01-01

https://postgres.sophia.org/

Which of the following scenarios reflects the isolation property?

•

1. User 1 has $500 in their online account.

2. User 2 has $300 in their online account.

3. User 1 sends user 2 $100.

4. User 1 has $400 in their account.

5. User 2 has $300 in their account.

6. The transaction is reverted.

•

1. The product quantity starts at 200.

2. Transaction 1 runs to read the quantity of the product to be updated.

3. Transaction 2 runs in parallel to read the quantity of the product to be updated.

4. Transaction 1 updates the product quantity to reduce it by 100.

5. Transaction 2 updates the product quantity to reduce it by 5.

6. The product quantity ends at 195.

•

1. A fairly large update to the products table.

2. The update is saved to the logs.

3. The update starts to then save to the disk.

4. The system fails midway through.

5. When the system starts back up, the committed transactions that haven't been written to disk are written.

•

1. Transaction 1 reads a product's cost which is set at $100.

2. Transaction 1 updates the product to set the price to $90.

3. Transaction 2 reads the same product's cost and sees $100.

4. Transaction 1 commits the cost.

5. Transaction 3 reads the same product's cost and sees $90.

https://postgres.sophia.org/

Which of the following permissions are automatically granted to a user?

•

All permissions need to be granted to the user or role.

•

Access to any piece that touches the underlying system

•

Permission to change items in the database

•

Access to enabling extensions

https://postgres.sophia.org/

Consider the following scenario:

1. Update

ROLLBACK

2. Insert

3. Insert

COMMIT

4. Delete

5. Update

COMMIT

In this scenario, which statements would be saved to the database, assuming these are all in a single transaction?

•

1, 2, 3, 4, 5

•

2, 3, 4, 5

•

4, 5

•

2, 3

https://postgres.sophia.org/

Which of the following statements would clean the database objects in a data dump of the mydatabase to backup.sql, prior to outputting the commands to create them?

•

pg_dump mydatabase > backup.sql

•

pg_dump -c mydatabase > backup.sql

•

pg_dump -a mydatabase > backup.sql

•

pg_dump -b mydatabase > backup.sql

https://postgres.sophia.org/

In which of the following cases would it make the most sense to use a b-tree index?

•

SELECT *

FROM customer

WHERE fax LIKE '+55%';

•

SELECT *

FROM album

WHERE artist_id < 5;

•

SELECT *

FROM employee

WHERE address LIKE '%i%';

•

SELECT *

FROM customer

WHERE customer_id > 10 AND customer_id < 20;

https://postgres.sophia.org/

Which of the following DROP INDEX statements would give a notice if the index does not exist but not an error?

•

DROP INDEX myindex RESTRICT;

•

DROP INDEX IF EXISTS myindex;

•

DROP INDEX CONCURRENTLY myindex;

•

DROP INDEX myindex;

https://postgres.sophia.org/

In which of the following cases would it make the most sense to use a hash index?

•

SELECT *

FROM customer

WHERE email LIKE '%gmail%';

•

SELECT *

FROM employee

WHERE employee_id > 2;

•

SELECT *

FROM invoice

WHERE invoice_id > 10 AND invoice_id < 200;

•

SELECT *

FROM track

WHERE album_id = 10;

https://postgres.sophia.org/

Which of the following operators will attempt to use a GiST index?

•

https://postgres.sophia.org/

Which of the following statements represents a correctly structured transaction?

•

UPDATE track

set media_type_id = 1

where album_id = 3;

DELETE FROM playlist

WHERE playlist_id = 1;

INSERT INTO genre (genre_id, name)

VALUES (30, 'Funk' ),(31,'Classical'),(32,'Pop Rock');

COMMIT;

•

BEGIN

UPDATE track

set media_type_id = 1

where album_id = 3

DELETE FROM playlist

WHERE playlist_id = 1

INSERT INTO genre (genre_id, name)

VALUES (30, 'Funk' ),(31,'Classical'),(32,'Pop Rock')

COMMIT

•

BEGIN;

UPDATE track

set media_type_id = 1

where album_id = 3;

DELETE FROM playlist

WHERE playlist_id = 1;

INSERT INTO genre (genre_id, name)

VALUES (30, 'Funk' ),(31,'Classical'),(32,'Pop Rock');

COMMIT;

•

BEGIN;

COMMIT;

UPDATE track

set media_type_id = 1

where album_id = 3;

DELETE FROM playlist

WHERE playlist_id = 1;

INSERT INTO genre (genre_id, name)

VALUES (30, 'Funk' ),(31,'Classical'),(32,'Pop Rock');

https://postgres.sophia.org/

Which of the following scenarios reflect the consistency property?

•

1. In the flower database, there are 50 flowers available

2. Reese has checked and there are 50 flowers.

3. Reese has attempted to take out 5 flowers.

4. Which trying to take them out, there was an error in trying to dispense.

5. While checking, there are still 50 flowers available in the system.

•

1. A user attempts to do a product transfer between companies.

2. The quantity of the product is moved from the first company.

3. Only once the product is verified to have been deducted, the quantity is moved to the second company.

4. Verification is done and identifies that the total amounts before and after the transactions are not maintained.

5. The transaction is reverted.

•

1. In the library database, there are 50 books available

2. Billy has checked and there are 50 books.

3. Sam has checked and there are 50 books.

4. Billy has taken out 5 books.

5. The library system informs Sam of the update and Sam now checks that there are 45 books.

6. Sam checks out 10 books.

7. There are now 35 books in the library database.

•

1. Tiffany has updated a customer's address while on the phone with them.

2. The server restarted after Tiffany clicked on save.

3. When the server comes back up, Tiffany was able to verify that the address was updated.

https://postgres.sophia.org/

Which of the following scenarios reflects the atomicity property?

•

1. Jeff checks his user profile and sees his email address is set to jeff@gmail.com.

2. Jeff changes his email to set it to jeff@outlook.com but does not click on save yet.

3. A customer rep checks into Jeff's account and sees jeff@gmail.com.

4. Jeff clicks on save.

5. Another customer rep checks Jeff's account and sees jeff@outlook.com.

•

1. User 1 has $800 in their online account.

2. User 2 has $600 in their online account.

3. User 1 sends user 2 $100.

4. User 1 has $700 in their account.

5. User 2 has $600 in their account.

6. The transaction is saved.

•

1. A vendor has 5 orders available.

2. A customer attempts to purchase all 5.

3. The system deducts it from the vendor and adds it to the customer.

4. The vendor now has 0 orders available.

5. The customer has 5 orders purchased.

6. The transaction is saved.

•

1. A fairly large transaction is run to import new customers.

2. The import is saved to the logs.

3. The import starts to then save to the disk.

4. The disk fails midway through the update.

5. A new disk replaces the failed disk.

6. The backup is applied and the saving of the data is run from the logs.

https://postgres.sophia.org/

Which of the following scenarios reflects the durability property?

•

1. Jeff checks his user profile and sees his email address is set to jeff@gmail.com.

2. Jeff changes his email to set it to jeff@outlook.com but does not click on save yet.

3. A customer rep checks into Jeff's account and sees jeff@gmail.com.

4. Jeff clicks on save.

5. Another customer rep checks Jeff's account and sees jeff@outlook.com.

•

1. A fairly large transaction is run to import new customers.

2. The import is saved to the logs.

3. The import starts to then save to the disk.

4. The disk fails midway through the update before being committed.

5. A new disk replaces the failed disk.

6. The backup is applied and the saving of the data is run from the logs.

•

1. User 1 has $500 in their online account.

2. User 2 has $300 in their online account.

3. User 1 sends user 2 $100.

4. User 1 has $400 in their account.

5. User 2 has $300 in their account.

6. The transaction is reverted.

•

1. A vendor has 5 orders available.

2. A customer attempts to purchase all 5.

3. The system deducts it from the vendor and adds it to the customer.

4. The vendor now has 0 orders available.

5. The customer has 5 orders purchased.

6. The transaction is saved.

https://postgres.sophia.org/

Which of the following statements would create a role named database_admin which gives them the ability to create databases?

•

CREATE ROLE database_admin INHERIT;

•

CREATE ROLE database_admin NOINHERIT;

•

CREATE ROLE database_admin CREATEROLE;

•

CREATE ROLE database_admin CREATEDB;

https://postgres.sophia.org/

Which type of backup would result in the largest storage space?

•

Nightly backup

•

Full backup

•

Incremental backup

•

Differential backup

https://postgres.sophia.org/

Which of the following statements would only restore the schema, but not the data, of the database mydatabase from backup.sql?

•

pg_restore mydatabase < backup.sql

•

pg_restore -s mydatabase < backup.sql

•

pg_restore -a mydatabase < backup.sql

•

pg_restore -d mydatabase < backup.sql

https://postgres.sophia.org/

In which of the following cases would it make the most sense to use a hash index?

•

SELECT *

FROM employee

WHERE address LIKE '%i%';

•

SELECT *

FROM customer

WHERE customer_id > 10 AND customer_id < 20;

•

SELECT *

FROM album

WHERE artist_id < 5;

•

SELECT *

FROM track

WHERE media_type_id = 1;

https://postgres.sophia.org/

Which of the following properties are specific to the durability property?

•

In the event of system failure, no transactions that were done can be undone.

•

Data used in one transaction cannot be used in another transaction until the first transaction is completed.

•

A transaction should be treated as a single logical unit of work that is indivisible.

•

If any of the transaction parts violates an integrity constraint, the entire transaction must be aborted.

https://postgres.sophia.org/

Which type of attack is often used to get passwords or other information using iterative trial and error?

•

Conditional

•

Row set

•

Schematic

•

Brute force

https://postgres.sophia.org/

In which of the following cases would it make the most sense to use a b-tree index?

•

SELECT *

FROM invoice

WHERE invoice_id > 10 AND invoice_id < 200;

•

SELECT *

FROM employee

WHERE title LIKE '%IT%';

•

SELECT *

FROM customer

WHERE email LIKE '%gmail%';

•

SELECT *

FROM customer

WHERE fax LIKE '%7070';

https://postgres.sophia.org/

Which of the following statements would dump ONLY the table customer from the mydatabase database to backup.sql?

•

pg_dump -a customer mydatabase > backup.sql

•

pg_dump mydatabase customer > backup.sql

•

pg_dump -t customer > backup.sql

•

pg_dump -t customer mydatabase > backup.sql

https://postgres.sophia.org/

Which is an advantage of both the command line and the GUI?

•

We can use any parameters without limitation.

•

We can back up a remote server.

•

We can backup the data, schema, or both at the same time.

•

We can compress the backup script.

https://postgres.sophia.org/

Consider the following scenario:

1. Update

2. Insert

3. Insert

4. Delete

5. Update

ROLLBACK

COMMIT

In this scenario, which statements would be saved to the database, assuming these are all in a single transaction?

•

1, 2, 3, 4, 5

•

none

•

https://postgres.sophia.org/

Which of the following DROP INDEX statement parameters are set by default?

•

DROP INDEX IF EXISTS myindex;

•

DROP INDEX myindex CASCADE;

•

DROP INDEX CONCURRENTLY myindex;

•

DROP INDEX myindex RESTRICT;

https://postgres.sophia.org/

Which of the following statements will grant insert permissions on the track table to all users?

•

GRANT INSERT ON track TO ALL;

•

GRANT INSERT ON track TO public;

•

GRANT INSERT ON 'track' TO 'public';

•

GRANT INSERT ON public to track;

https://postgres.sophia.org/

Which of the following permissions are not automatically granted to a superuser?

•

Permission to change items in the database

•

Access to operating system user accounts

•

Access to any piece that touches the underlying system

•

Access to enabling extensions

https://postgres.sophia.org/

Which of the following statements would create a user login role named temporary_user with the password set as changeme that is valid until 2025-05-01?

•

CREATE ROLE temporary_user

PASSWORD changeme

VALID UNTIL 2025-05-01

•

CREATE ROLE temporary_user

VALID UNTIL '2025-05-01'

PASSWORD 'changeme'

•

CREATE ROLE temporary_user

PASSWORD 'changeme'

EXPIRES '2025-05-01'

•

CREATE ROLE temporary_user

PASSWORD 'changeme'

VALID UNTIL '2025-05-01'

https://postgres.sophia.org/

Which of the following sequences of statements would ensure that Jimmy has the privileges of the roles of health_department and manager?

•

CREATE ROLE manager INHERIT;

CREATE ROLE health_department INHERIT;

GRANT health_department to jimmy;

GRANT manager to jimmy;

•

CREATE ROLE manager NOINHERIT;

CREATE ROLE health_department NOINHERIT;

GRANT health_department to jimmy;

GRANT manager to health_department;

•

CREATE ROLE manager NOINHERIT;

CREATE ROLE health_department NOINHERIT;

GRANT manager to jimmy;

GRANT manager to health_department;

•

CREATE ROLE manager NOINHERIT;

CREATE ROLE health_department INHERIT;

GRANT health_department to jimmy;

GRANT manager to health_department;

https://postgres.sophia.org/

Which of the following scenarios reflects the isolation property?

•

1. Jeff checks his user profile and sees his email address is set to jeff@gmail.com.

2. Jeff changes his email to set it to jeff@outlook.com but does not click on save yet.

3. A customer rep checks into Jeff's account and sees jeff@gmail.com.

4. Jeff clicks on save.

5. Another customer rep checks Jeff's account and sees jeff@outlook.com.

•

1. A fairly large transaction is run to import new customers.

2. The import is saved to the logs.

3. The import starts to then save to the disk.

4. The disk fails midway through the update.

5. A new disk replaces the failed disk.

6. The backup is applied and the saving of the data is run from the logs.

•

1. User 1 has $500 in their online account.

2. User 2 has $300 in their online account.

3. User 1 sends user 2 $100.

4. User 1 has $400 in their account.

5. User 2 has $300 in their account.

6. The transaction is reverted.

•

1. A vendor has 5 orders available.

2. A customer attempts to purchase all 5.

3. The system deducts it from the vendor and adds it to the customer.

4. The vendor now has 0 orders available.

5. The customer has 5 orders purchased.

6. The transaction is saved.

https://postgres.sophia.org/

Which of the following scenarios reflects the atomicity property?

•

1. User 1 has $500 in their online account.

2. User 2 has $300 in their online account.

3. User 1 sends user 2 $100.

4. User 1 has $400 in their account.

5. User 2 has $300 in their account.

6. The transaction is reverted.

•

1. A fairly large update to the products table.

2. The update is saved to the logs.

3. The update starts to then save to the disk.

4. The system fails midway through.

5. When the system starts back up, the committed transactions that haven't been written to disk are written.

•

1. The product quantity starts at 200.

2. Transaction 1 runs to read the quantity of the product to be updated.

3. Transaction 2 runs in parallel to read the quantity of the product to be updated.

4. Transaction 1 updates the product quantity to reduce it by 100.

5. Transaction 2 updates the product quantity to reduce it by 5.

6. The product quantity ends at 195.

•

1. Transaction 1 reads a product's cost which is set at $100.

2. Transaction 1 updates the product to set the price to $90.

3. Transaction 2 reads the same product's cost and sees $100.

4. Transaction 1 commits the cost.

5. Transaction 3 reads the same product's cost and sees $90.

Which of the following statements would only dump the data definitions and not the data of the mydatabase to backup.sql?

•

pg_dump mydatabase > backup.sql

•

pg_dump -d mydatabase > backup.sql

•

pg_dump -s mydatabase > backup.sql

•

pg_dump -a mydatabase > backup.sql

Which of the following statements would create a role named database_admin which gives them the ability to create databases?

•

CREATE ROLE database_admin NOINHERIT;

•

CREATE ROLE database_admin CREATEROLE;

•

CREATE ROLE database_admin CREATEDB;

•

CREATE ROLE database_admin INHERIT;

https://postgres.sophia.org/

In which of the following cases would it make the most sense to use a hash index?

•

SELECT *

FROM album

WHERE email LIKE '%t%';

•

SELECT *

FROM artist

WHERE artist_id < 10;

•

SELECT *

FROM track

WHERE track_id > 1 AND track_id < 15;

•

SELECT *

FROM playlist

WHERE playlist_id = 4;

https://postgres.sophia.org/

Which type of backup would result in the fastest restoration?

•

Differential backup

•

Nightly backup

•

Incremental backup

•

Full backup

https://postgres.sophia.org/

Which of the following statements represents a correctly structured transaction?

•

BEGIN

UPDATE track

set name = 'A New Road'

where track_id = 5;

insert into artist (artist_id, name) values (900, 'Special Artist' );

insert into genre (genre_id, name) values (30, 'Funk' );

COMMIT;

•

BEGIN;

COMMIT;

UPDATE track

set name = 'A New Road'

where track_id = 5;

insert into artist (artist_id, name) values (900, 'Special Artist' );

insert into genre (genre_id, name) values (30, 'Funk' );

•

BEGIN

UPDATE track

set name = 'A New Road'

where track_id = 5

insert into artist (artist_id, name) values (900, 'Special Artist' )

insert into genre (genre_id, name) values (30, 'Funk' )

COMMIT

•

BEGIN;

UPDATE track

set name = 'A New Road'

where track_id = 5;

insert into artist (artist_id, name) values (900, 'Special Artist' );

insert into genre (genre_id, name) values (30, 'Funk' );

COMMIT;

https://postgres.sophia.org/

Which is an advantage of both the command line and the GUI?

•

We can backup from one database and immediately send the result to restore another database.

•

We can continue to restore a database even if there are errors in the file.

•

We can back up a remote server.

•

We can restore a remote database.

https://postgres.sophia.org/

Which of the following scenarios reflects the atomicity property?

•

1. In the library database, there are 50 books available.

2. Billy has checked and there are 50 books.

3. Sam has checked and there are 50 books.

4. Billy has taken out 5 books.

5. The library system informs Sam of the update and Sam now checks that there are 45 books.

6. Sam checks out 10 books.

7. There are now 35 books in the library database.

•

1. In the flower database, there are 50 flowers available.

2. Reese has checked and there are 50 flowers.

3. Reese has attempted to take out 5 flowers.

4. While trying to take them out, there was an error in trying to dispense.

5. While checking, there are still 50 flowers available in the system.

•

1. Tiffany has updated a customer's address while on the phone with them.

2. The server restarted after Tiffany clicked on save.

3. When the server came back up, Tiffany was able to verify that the address was updated.

•

1. A user attempts to do a product transfer between companies.

2. The quantity of the product is moved from the first company.

3. The quantity is moved to the second company without verifying that it has been deducted from the first company.

4. The transaction is accepted.

https://postgres.sophia.org/

What is unique about a superuser compared to a user?

•

A superuser is the same as a regular user but with all permissions granted.

•

A superuser can bypass all permission checks.

•

A superuser has administrative privileges that users can't have.

•

A superuser has their permissions checked but passes all tests.

https://postgres.sophia.org/

Which of the following statements will grant update, delete and insert permissions on the employee table to all users?

•

GRANT UPDATE, INSERT, DELETE ON employee TO ALL;

•

GRANT UPDATE and INSERT AND DELETE ON employee TO ALL;

•

GRANT UPDATE, INSERT, DELETE ON ALL to employee;

•

GRANT UPDATE, INSERT, DELETE ON 'employee' TO 'ALL';

https://postgres.sophia.org/

Consider the following scenario:

1. Update

ROLLBACK

2. Insert

3. Insert

4. Delete

ROLLBACK

5. Update

COMMIT

In this scenario, which statements would be saved to the database, assuming these are all in a single transaction?

•

1, 2, 3, 4, 5

•

2, 3, 4, 5

•

None

https://postgres.sophia.org/

Which of the following statements would create a user login role named master_user with the password set as k489dJs9l that is valid until 2032-12-31?

•

CREATE ROLE master_user

WITH PASSWORD 'k489dJs9l'

EXPIRES '2032-12-31'

•

CREATE ROLE master_user

VALID UNTIL '2032-12-31'

PASSWORD 'k489dJs9l'

•

CREATE ROLE master_user

PASSWORD 'k489dJs9l'

VALID UNTIL '2032-12-31'

•

CREATE ROLE master_user

PASSWORD k489dJs9l

VALID UNTIL 2032-12-31

https://postgres.sophia.org/

Which type of application that acts as an interface to the database is used to perform most SQL injections?

•

Image

•

Text

•

System

•

Web

https://postgres.sophia.org/

Which of the following statements would create a role named database_test which gives them the ability login as a user?

•

CREATE ROLE database_test LOGIN;

•

CREATE ROLE database_test INHERIT;

•

CREATE ROLE database_test CREATEROLE;

•

CREATE ROLE database_test NOINHERIT;

https://postgres.sophia.org/

Which of the following scenarios reflect the consistency property?

•

1. The product quantity starts at 200.

2. Transaction 1 runs to read the quantity of the product to be updated.

3. Transaction 2 runs in parallel to read the quantity of the product to be updated.

4. Transaction 1 updates the product quantity to reduce it by 100.

5. Transaction 2 updates the product quantity to reduce it by 5.

6. The product quantity ends at 95.

•

1. User 1 has $50 in their online account.

2. User 2 has $60 in their online account.

3. User 1 sends user 2 $10.

4. User 1 has $40 in their account.

5. User 2 has $60 in their account.

6. The transaction is saved.

•

1. A fairly large update to the products table.

2. The update is saved to the logs.

3. The update starts to then save to the disk.

4. The system fails midway through.

5. When the system starts back up, the committed transactions that haven't been written to disk are written.

•

1. Transaction 1 reads a product's cost which is set at $100.

2. Transaction 1 updates the product to set the price to $90.

3. Transaction 2 reads the same product's cost and sees $100.

4. Transaction 1 commits the cost.

5. Transaction 3 reads the same product's cost and sees $90.

https://postgres.sophia.org/

In which of the following cases would it make the most sense to use a b-tree index?

•

SELECT *

FROM invoice

WHERE invoice_id > 10 AND invoice_id < 200;

•

SELECT *

FROM customer

WHERE fax LIKE '%7070';

•

SELECT *

FROM employee

WHERE title LIKE '%IT%';

•

SELECT *

FROM customer

WHERE email LIKE '%gmail%';

https://postgres.sophia.org/

Which of the following sequences of statements would ensure that Jimmy has the privileges of the roles of health_department and manager?

•

CREATE ROLE manager NOINHERIT;

CREATE ROLE health_department NOINHERIT;

GRANT manager to jimmy;

GRANT manager to health_department;

•

CREATE ROLE manager INHERIT;

CREATE ROLE health_department INHERIT;

GRANT health_department to jimmy;

GRANT manager to jimmy;

•

CREATE ROLE manager NOINHERIT;

CREATE ROLE health_department INHERIT;

GRANT health_department to jimmy;

GRANT manager to health_department;

•

CREATE ROLE manager NOINHERIT;

CREATE ROLE health_department NOINHERIT;

GRANT health_department to jimmy;

GRANT manager to health_department;

Answers

SmartExpert

(118)

Status NEW Posted 24 Feb 2023 04:02 AM My Price 25.00

CIS----------- 11-----------1 S-----------OPH-----------IA------------STR-----------AYE-----------R I-----------ntr-----------odu-----------cti-----------on -----------to -----------Rel-----------ati-----------ona-----------l D-----------ata-----------bas-----------e M-----------ana-----------gem-----------ent----------- Sy-----------ste-----------ms -----------Uni-----------t 3----------- Mi-----------les-----------ton-----------e-s-----------obt-----------ell-----------.co-----------m -----------Cli-----------ck -----------lin-----------k f-----------or -----------Ans-----------wer-----------s A-----------ll -----------Cor-----------rec-----------t-----------

Attachments

file 1677211424-Unit 3 Milestone Introduction to Relational Database Management Systems.doc preview (10420 words )

h-----------A f-----------bjb-----------j .-----------.hh-----------f -----------VVV-----------VVj-----------jjj-----------Ndj-----------G8P-----------1P1-----------P1C-----------DDD-----------FFF-----------FFF-----------FIl-----------LLG-----------VDD-----------DDD-----------GVV-----------P1C-----------8GK-----------KKD-----------VP1-----------VCF-----------KDF-----------KK4-----------FP1-----------tPH-----------ENC-----------FNG-----------0G/-----------ELI-----------LFF-----------LVF-----------(DD-----------KDD-----------DDD-----------GGJ-----------DDD-----------GDD-----------DDL-----------DDD-----------DDD-----------DDD----------- X ----------- DC-----------IS -----------111----------- SO-----------PHI-----------A-S-----------TRA-----------YER----------- In-----------tro-----------duc-----------tio-----------n t-----------o R-----------ela-----------tio-----------nal----------- Da-----------tab-----------ase----------- Ma-----------nag-----------eme-----------nt -----------Sys-----------tem-----------s U-----------nit----------- 3 -----------Mil-----------est-----------one------------so-----------bte-----------ll.-----------com----------- Cl-----------ick----------- li-----------nk -----------for----------- An-----------swe-----------rs -----------All----------- Co-----------rre-----------ct ----------- 1 -----------In -----------eac-----------h m-----------ile-----------sto-----------ne,----------- yo-----------u m-----------ay -----------wan-----------t o-----------r n-----------eed----------- to----------- us-----------e t-----------he -----------dat-----------aba-----------se -----------and----------- qu-----------ery----------- to-----------ol -----------to -----------ans-----------wer----------- so-----------me -----------of -----------the----------- qu-----------est-----------ion-----------s. -----------We -----------sug-----------ges-----------t y-----------ou -----------ope-----------n t-----------he -----------too-----------l i-----------n a-----------not-----------her-----------

Not Rated(0)

Buy Answer

Hire Dedicated Virtual Team / Business Solution for SMEs.

SmartExpert

(118)

About SmartExpert

Education

Experience

Introduction to Relational Database Management Systems Unit 3 Milestone

Answers

Attachments

Are You a Business Owner?