Test Index

Administering Relational Databases on Microsoft Azure (DP-300) Test 3

© examsnet.com

Question : 5

Total: 33

HOTSPOT
You have an Azure SQL logical server.
You run the following script.
CREATE DATABASE Sales
GO
CREATE TABLE [dbo].[Orders]
(
[OrderID] INT NOT NULL,
[OrderDescription] NVARCHAR (MAX) NOT NULL,
[Timestamp] Dotetime2 NOT NULL
)
WITH (
SYSTEM_VERSIONING = ON,
LEDGER = ON
);
GO
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point
Hot Area:

The orders table will allow only rows to be inserted. ______
Yes
No
To create additional tables in the Sales database, the LEOGER - ON parameter must be used. ______
Yes
No
To ensure that a timestamp is added to each row in the orders table, the GENERATED ALWAYS ______
Yes
No

Go to Question:

Prev Question

Next Question