Apresentação

A Revista Brasileira de Direito Processual – RBDPro, adormecida por quase 16 anos retorna, agora devidamente revitalizada pela Editora Fórum.

Trata-se de um veículo especializado, cujo propósito volta-se ao desenvolvimento da ciência processual, isso mediante a divulgação de doutrinas de ponta, pareceres, jurisprudências selecionadas – algumas na íntegra, outras comentadas – resenhas, um fórum e outros atrativos mais.

QUESTION 9
You have a database that stores information for a shipping company. You create a table named Customers by running the following Transact-SQL statement.
(Line numbers are included for reference only.)
You need to ensure that salespeople can view data only for the customers that are assigned to them.
Which Transact-SQL segment should you insert at line 07?
A. RETURNS varchar(20)WITH Schemabinding
B. RETURNS dbo.CustomersORDER BY @salesPerson
C. RETURNS tableORDER BY @salesPerson
D. RETURNS tableWITH Schemabinding
Correct Answer: D
Explanation
Explanation/Reference:
The return value can either be a scalar (single) value or a table. SELECT 1 just selects a 1 for every row, of course. What it’s used for in this case is testing
whether any rows exist that match the criteria: if a row exists that matches the WHERE clause, then it returns 1, otherwise it returns nothing. Specify the WITH
SCHEMABINDING clause when you are creating the function. This ensures that the objects referenced in the function definition cannot be modified unless the
function is also modified.
References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-function-transact- sql

70-646 dumps

QUESTION 10
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question
presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The
environment hosts several customer databases, and each customer uses a dedicated instance. The environments that you manage are shown in the following
table.You need to monitor WingDB and gather information for troubleshooting issues.
What should you use?
A. sp_updatestats
B. sp_lock
C. sys.dm_os_waiting_tasks
D. sys.dm_tran_active_snapshot_database_transactions
Correct Answer: B
Explanation
Explanation/Reference:
The sp_lock system stored procedure is packaged with SQL Server and will give you insight into the locks that are happening on your system. This procedure
returns much of its information from the syslock info in the master database, which is a system table that contains information on all granted, converting, and
waiting lock requests.
Note: sp_lock will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that
currently use this feature. To obtain information about locks in the SQL Server Database Engine, use the sys.dm_tran_locks dynamic management view.
sys.dm_tran_locks returns information about currently active lock manager resources in SQL Server 2008and later. Each row represents a currently active request
to the lock manager for a lock that has been granted or is waiting to be granted.
References:https://docs.microsoft.com/en-us/sql/relational-databases/system-stored- procedures/sp-lock-transact-sql

Com periodicidade trimestral, a RBDPro possui como premissa básica a qualidade de seu conteúdo, traço esse que sempre a caracterizou, haja vista a personalidade exigente de seus antigos diretores, os saudosos professores Edson Prata e Ronaldo Cunha Campos.

Assim, por opção metodológica, à edição de assuntos atuais será dada preferência, circunstância, por certo, interessante, especialmente numa época em que o processo sofre modificações constantes e não só novos institutos são criados, mas outros, já antigos, adquirem novos contornos.

Esperamos que a novidade agrade a todos!