18. Which method can often tell if the backend of a web form is using SQL? Quest
ID: 3859223 • Letter: 1
Question
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
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.
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
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
Step Associated sample sQu Show available seats for StudentA Select from SEATS Where seat status-'open' Show available seats for Student B Select from SEATS Where seat status-'open Add seat for StudentA Update SEATS Setseat reserved Student A'Where seat no lastseat Update SEATS Set seat reserved-'Student B' Where seat no- lastseat Add seat for StudentB NOTE: result of the SQL statement (whether it is successful or not) is NOT showinExplanation / Answer
19.Database inference is easily solved by:
Allowing users only access to aggregated data results
21Relationships when mapped to tables are expressed by:
primary Key and Foreign Key
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?
Student A will get the ticket
23)white listing is the recommended procedure for white listing
24)The process of tracking who accesses a database and which resources are accessed is called Tracking
This document is called log file
25)Transaction is also known as concuurrent 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.
28)Noramlization
What is the functional dependency?
29)Pesimistic Update
30) These are not able to be
GamesForm, PrintedTicket , SeatAvailabilityReport
31)The best method of providing access to end users to data contained in a database is:
a web form connected to the database
32)Recovery is done and the process must be Rollback.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.