CET_TARDE - MTA Database - E_backup_permissions

Descripción

Database Quizzes preparing to certification
Hawerth Castro
Test por Hawerth Castro, actualizado hace más de 1 año
Hawerth Castro
Creado por Hawerth Castro hace más de 7 años
54
0

Resumen del Recurso

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.
Respuesta
  • YES
  • NO
  • YES
  • NO
  • YES
  • NO

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?
Respuesta
  • Resource
  • Group
  • List
  • Role

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:
Respuesta
  • Improve performance.
  • Minimize storage space.
  • Bypass case sensitivity requirements.
  • Give the user control of the query logic.

Pregunta 14

Pregunta
Which permission does a user need in order to run a stored procedure?
Respuesta
  • EXECUTE
  • ALLOW
  • CALL
  • RUN

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.
Respuesta
  • YES
  • NO
  • YES
  • NO
  • YES
  • NO
Mostrar resumen completo Ocultar resumen completo

Similar

CET_TARDE - MTA Database - E_COMANDS
Hawerth Castro
CET_TARDE - MTA Database - INDEX
Hawerth Castro
CET_TARDE - MTA Database - DIAGNOSTIC4
Hawerth Castro
CET_TARDE - MTA Database - DIAGNOSTIC5
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 1
Hawerth Castro
CET_TARDE - MTA Software Development Fundamentals 3
Hawerth Castro
CET_TARDE - MTA Mobility and Devices Fundamentals 1
Hawerth Castro
CET_TARDE - MTA Software Development Fundamentals 4
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 5
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 4
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 6
Hawerth Castro