Pregunta 1
Pregunta
This question requires that you evaluate the underlined text to determine if it is correct. Use the ALLOW SELECT command to give a user permission to read the data in a table.
Instructions: Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct:
Respuesta
-
No change is needed
-
GRANT SELECT
-
LET HEAD
-
PERMIT READ
Pregunta 2
Pregunta
You have a user that has server roles as defined below:
Respuesta
-
no
-
read-only
-
unlimited
-
no
-
unlimited
-
configuration
Pregunta 3
Pregunta
The following illustration shows backup strategies that use the simple recovery model and the full recovery model:
Respuesta
-
less
-
more
-
the same
-
less
-
more
-
the same
Pregunta 4
Pregunta
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
Pregunta 5
Pregunta
The following graphic shows the components of a SQL Server application. You access the
SQL Server application through Internet Explorer.
Respuesta
-
client
-
www.contoso.com
-
s01.contoso.com
-
client
-
www.contoso.com
-
s01.contoso.com
Pregunta 6
Pregunta
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
Respuesta
-
YES
-
NO
-
YES
-
NO
-
YES
-
NO
-
YES
-
NO
Pregunta 7
Pregunta
You assign User1 a set of permissions that include the WITH GRANT OPTION. The WITH GRANT OPTION enables User1 to:
Respuesta
-
request a log of permission use.
-
delegate permissions to other users.
-
create new database users.
-
view other users’ permissions.
Pregunta 8
Pregunta
A named group of SQL statements that can be executed in a database is called a:
Respuesta
-
Subroutine
-
Formula
-
Stored procedure
-
Method
Pregunta 9
Pregunta
A named group of SQL statements that can be executed in a database is called a:
Respuesta
-
Subroutine
-
Formula
-
Stored procedure
-
Method
Pregunta 10
Pregunta
You need to establish a set of permissions that you can routinely assign to new users.
What should you create?
Pregunta 11
Pregunta
Which database term is used to describe the process of applying a backup to a damaged or corrupt
database?
Respuesta
-
Recover
-
Restore
-
Commit
-
Attach
Pregunta 12
Pregunta
You need to disable User1’s access to view the data in the Customer table. Which statement should you use?
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 13
Pregunta
One reason to create a stored procedure is to:
Pregunta 14
Pregunta
Which permission does a user need in order to run a stored procedure?
Pregunta 15
Pregunta
Which command should you use to give a user permission to read the data in a table?
Respuesta
-
ALLOW SELECT
-
LET READ
-
PERMIT READ
-
GRANT SELECT
Pregunta 16
Pregunta
In which situation do you need to perform a restore on a database?
Respuesta
-
when data becomes corrupted in the database
-
when you need to roll back a transaction
-
when you encounter an error in your application
-
when data needs to be deleted from the database
Pregunta 17
Pregunta
At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600
hours), you create a table named Customer and import data into the table. At 5:00 P.M.
(1700 hours), your server fails. You run a script to apply only the 3:00 P.M. backup to
your database. What is the result of the script?
Respuesta
-
The Customer table no longer exists.
-
The Customer table is unaffected.
-
The Customer table exists but has no data.
-
The script fails.
Pregunta 18
Pregunta
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.