98-364 試験問題を無料オンラインアクセス

Which permission does a user need in order to run a stored procedure?

• A.ALLOW
• B.RUN
• C.EXECUTE
• D.CALL

You have a table named Employee that includes the following columns:
EmployeeID Smp1oyeeName Which statement should you use to return the number of rows in the table?

• A.Option B
• B.Option C
• C.Option A
• D.Option D

While attending college, you accept an IT internship at a local charity. The charity needs to report on data that is related and exists in two tables.
You need to establish a relationship between the data that is in the two tables.
Which constraint should you define?

• A.Default key
• B.Index key
• C.Link key
• D.Foreign key

You have two tables named Salesperson and Sales.
You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table.
Which database object should you add to the Sales table?

• A.Nonclustered index
• B.Clustered index
• C.Foreign key
• D.Primary key

One difference between a function and a stored procedure is that a function:

• A.Cannot contain a transaction.
• B.Must be called from a trigger.
• C.Cannot accept parameters.
• D.Must return a value.