Data-Management-Foundations 試験問題を無料オンラインアクセス

Which function is considered an aggregate function?

• A.DESC
• B.TRIM
• C.MAX
• D.ABS

Which description defines a data type?

• A.It is an unnamed tuple of values.
• B.It has a name and a varying set of rows.
• C.It is a named set of values.
• D.It has values corresponding to columns.

Which optional clause is used to reject inserts and updates that do not satisfy the WHERE clause of a view query?

• A.MATERIALIZED VIEW
• B.WITH CHECK OPTION
• C.BASE TABLE
• D.JOIN VIEWS

How many bytes of storage does a BIGINT data type hold in MySQL?

• A.3 bytes
• B.1 byte
• C.8 bytes
• D.4 bytes

Which statement uses valid syntax for the DELETE statement in SQL?

• A.DELETE FROM table_name;
• B.DELETE * FROM table_name WHERE condition;
• C.DELETE table_name WHERE condition;
• D.DELETE FROM table_name WHERE condition;