1Z0-171 試験問題を無料オンラインアクセス

What does the NEXTVAL pseudocolumn do in SQL?

• A.Retrieves the current value of a sequence without incrementing it
• B.Resets the sequence to its starting value
• C.Deletes the sequence from the database
• D.Retrieves the next value in a sequence and increments the sequence

Which component of an ERD (Entity-Relationship Diagram) represents the attributes of an entity?

• A.Ovals
• B.Arrows
• C.Diamonds
• D.Rectangles

Which type of join retrieves only the rows with matching values in both tables?

• A.OUTER JOIN
• B.NATURAL JOIN
• C.INNER JOIN
• D.CROSS JOIN

What will the following SQL query return?
SELECT TRUNC(15.678, 2) AS truncated_value FROM dual;

• A.15.678
• B.15.68
• C.15.6
• D.15.67

Which of the following statements creates an ascending sequence starting at 100 and incrementing by 10?

• A.CREATE SEQUENCE seq_1 START WITH 100 INCREMENT BY 10;
• B.CREATE SEQUENCE seq_1 START WITH 10 INCREMENT BY -100;
• C.CREATE SEQUENCE seq_1 START WITH 100 INCREMENT BY -10;
• D.CREATE SEQUENCE seq_1 START WITH 10 INCREMENT BY 100;