15.

Scenario b: Step Lock for StudentA Add seat for StudentA Associated sample SQL Lock Table SEATS Update SEATS Set seat reserved StudentA Where seat no lastseat Unlock Table SEATS Lock Table SEATS Lock for Student B Show available seats for Student B Add seat for Student B Select from SEATS Where seat status-open Update SEATS Setseat reserved-student B, where seat nolastseat, Unlock Table SEATS NOTE: result of the SQL statement (whether it is successful or not) is NOT shown

It is the KSU Fighting Owls football team's inaugural season and season tickets are in high demand. In fact, only one season ticket remains. Student A and Student B both want season tickets. Given the following, who gets the ticket?

Question options:

A

Student A and Student B both get the ticket

B

Not enough information to tell.

C

Student B

D

Student A

16.

SQL injections occur most often because of stolen passwords.

Question options:

A

True

B

False

17.

Which of the following about deadlocks is untrue?

Question options:

A

Most database systems automatically check for and resolve deadlocks.

B

Deadlocks occur when two transactions are each waiting for access to a table that the other one has locked.

C

Deadlocks rarely happen.

D

Serialized locking of all resources utilized by a transaction helps to prevent deadlocks.

18.

Which method can often tell if the backend of a web form is using SQL?

Question options:

A

Adding /sql onto the end of the Web form URL

B

Entering /sql?=' onto the end of the Web form URL

C

Entering a single quote into a username entry field on a web form

D

Entering 1=1 into a username entry field on a web form

19.

Database inference is easily solved by:

Question options:

A

Allowing users only access to aggregated data results

B

White listing

C

Prepared queries

D

There is not an easily implemented technology solution to prevent database inference

20.

The most common form of database security is implemented by:

Question options:

A

Pessimistic record locking

B

Table encryption

C

Complex SQL processing

D

Username/password

21.

SELECT ALL THAT APPLY.

Relationships when mapped to tables are expressed by:

Remember: SELECT ALL THAT APPLY.

Question options:

A

foreign keys

B

duplicate columns

C

data types

D

primary keys

22.

It is the KSU Fighting Owls football team's inaugural season and season tickets are in high demand. In fact, only one season ticket remains. Student A and Student B both want season tickets. From the following scenario, who gets the ticket?

Question options:

A

Both Student A and student B get the ticket

B

Student B

C

Student A

D

Not enough information to tell

23.

The recommended procedure for preventing SQL injections is:

Question options:

A

Prepared queries

B

Black listing

C

SQL mapping

D

White listing

24.

The process of tracking who accesses a database and which resources are accessed is called
_________________________ and the information obtained from this tracking is recorded in a ____________________.

Question options:

A

auditing, log file

B

auditing, archive file

C

tracking, log file

D

tracking, archive file

25.

Another name for a transaction is:

Question options:

A

SQL command

B

Concurrency control

C

Logical Unit of Work

D

Concurrent user action

26.

A

A professor may teach one or more classes but a student must take one or more classes. A class must be taught by one professor but a class may or may not have students.

B

A professor is required to teach at least one class and students must take at least one class.

C

A professor must teach one or more classes and a class must be taught by one professor. A student may take one or more classes but a class must have one or more students.

D

A professor may teach one or more classes and a student may take one or more classes. A class must be taught by one professor and a class must have at least one student.

27.

Given the following Security matrix, which is the most most complex form to implement?

Question options:

A

PrintedTicket

B

TicketForm

C

SpectatorInformationForm

D

SeatsForm

28.

Normalization answers which question:

Question options:

A

How many candidate keys are needed?

B

What should the primary key be?

C

How many tables?

D

What is the cardinality?

E

What are the functional dependencies?

29.

Which locking methods employs the use of making a copy of the original records and checking for changes to that record before committing an update?

Question options:

A

pessimistic locking

B

optmistic locking

C

lost-update

D

deadlock

30.

Given the following security matrix, which form(s) are not able to alter table data for any table?

Question options:

A

SeatsForm,TicketForm,GamesForm

B

GamesForm, PrintedTicket , SeatAvailabilityReport

C

SeatsForm, SeatAvailabilityForm

D

TicketForm

31.

The best method of providing access to end users to data contained in a database is:

Question options:

A

A multi-layer architecture composed of a middle layer that communicates with the database

B

a Web form connected to the database

C

A secure user login to the database system

D

A client app that is installed on the end users' PC or other device that establishes an ODBC connection to the database

32.

A database system crashes and needs to be restored to its state at the time of the crash. A complete backup of the database is done once a day. The crash occurred at 12 noon. The last full backup was done at 4:00 am.
The latest full backup is restored.

Then _______________________________ is done

in a process known as _________________________.

Question options:

A

reprocessing, roll forward

B

recovery, roll forward

C

reprocessing, rollback

D

recovery, redo

E

recovery, rollback

Scenario b: Step Lock for StudentA Add seat for StudentA Associated sample SQL Lock Table SEATS Update SEATS Set seat reserved 'StudentA' Where seat no 'lastseat Unlock Table SEATS Lock Table SEATS Lock for Student B Show available seats for Student B Add seat for Student B Select from SEATS Where seat status-'open' Update SEATS Setseat reserved-student B, where seat no'lastseat, Unlock Table SEATS NOTE: result of the SQL statement (whether it is successful or not) is NOT shown

Leave a Reply

Your email address will not be published. Required fields are marked *