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

You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used.
Which data type should you use?

• A.CHAR (3, 30)
• B.CHAR (30)
• C.VARCHAR (3, 30)
• D.VARCHAR (30)

You work at a coffee shop. They ask you to set up a website that stores charges on purchases.
You need to recommend a data type in a database table to run financial functions against the charged amounts.
Which data type should you recommend?

• A.Money
• B.Binary
• C.Varchar
• D.Bit

Your database contains a table named Customer.
You need to delete the record from the Customer table that has a CusromerID of 12345.
Which statement should you use?

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

The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?

• A.Trigger
• B.View
• C.Function
• D.Stored procedure
• E.Index

Which constraint ensures a unique value in the ID column for each customer?

• A.DISTINCT
• B.FOREIGN KEY
• C.SEQUENTIAL
• D.PRIMARY KEY