Business Data Base Systems Exam 2 Kahoot

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/17

encourage image

There's no tags or description

Looks like no tags are added yet.

18 Terms

1
New cards

Which composite key fits LineItems table?

(InvoiceID, LineNumber)

2
New cards

Best primary key for Countries table?

CountryCode (ISO-2)

3
New cards

Which adds UNIQUE constraint on Users?

ALTER TABLE Users ADD CONSTRAINT UQ_Users_Username UNIQUE (Username);

4
New cards

True or False: A surrogate key has no business meaning.

True

5
New cards

Third Normal Form (3NF) removes:

Transitive dependencies between non-key attributes

6
New cards

Valid foreign key in library schema?

Loans.MemberID → Members.MemberID

7
New cards

Match normal form to its rule: 1NF

Attributes are atomic

8
New cards

In Crow's Foot ERD, correct mapping?

Forked "crow's foot" = Many

9
New cards

Best data type for emails up to 320 characters?

VARCHAR(320)

10
New cards

Best reason to create view vActiveSubscriptions:

Hide complex joins/filters and expose limited columns

11
New cards

Which executes stored procedure with named parameter?

EXEC dbo.uspFindOrder @OrderID = 42;

12
New cards

True or False: A view stores SELECT definition only.

True

13
New cards

Which usually makes a view non-updatable?

Includes GROUP BY

14
New cards

How to drop a view called vRecentSales?

DROP VIEW dbo.vRecentSales;

15
New cards

Which command switches context to AnalyticsDb?

USE AnalyticsDb;

16
New cards

Which are valid T-SQL comment styles?

-- single line and /* multi-line */

17
New cards

True or False: GO is executed by SQL Server.

False

18
New cards

Safest pattern for all-or-nothing changes:

BEGIN TRAN; …; COMMIT;