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

Which keyword can be used to combine two results into one table?

• A.CONSOLIDATE
• B.INTEGRATE
• C.UNION
• D.MERGE

Which keyword is used to introduce a limiter in a SELECT statement?

• A.INTO
• B.FROM
• C.DROP
• D.WHERE

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

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

Which action does the % operator accomplish in MySQL?

• A.Raises a numeric value to the power of another
• B.Subtracts a numeric value from another
• C.Compares two numeric values for equality
• D.Divides two numeric values and returns the remainder

Which SELECT statement uses valid syntax for SQL?

• A.SELECT ALL column1, column2 FROM table_name;
• B.SELECT "column name", "column name" FROM "table name" WHERE "column name"
• C.SELECT column1, column2 WHERE condition FROM table_name;
• D.SELECT column1, column2 FROM table_name;