Administering Relational Databases on Microsoft Azure (DP-300) Test 3
© examsiri.com
Question : 5 of 33
Marks:
+1,
-0
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:
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. ______
- To create additional tables in the Sales database, the LEOGER - ON parameter must be used. ______
- To ensure that a timestamp is added to each row in the orders table, the GENERATED ALWAYS ______
Go to Question: