Free Oracle 1Z0-171 Exam Dumps Questions & Answers

Which clause is used to ensure that only specific rows are deleted in a DELETE statement?

• A.  SET
• B.  FROM
• C.  WHERE
• D.  HAVING

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

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

What is the primary purpose of an index in SQL?

• A.  To store metadata about a table
• B.  To ensure uniqueness of values in a column
• C.  To enforce data integrity constraints
• D.  To improve the performance of data retrieval queries

Which SQL statement is used to insert a new row into a table?

• A.  ALTER
• B.  UPDATE
• C.  INSERT
• D.  SELECT

Which data dictionary view provides information about all tables accessible to the current user?

• A.  USER_TABLES
• B.  SESSION_TABLES
• C.  ALL_TABLES
• D.  DBA_TABLES