1z1-071 무료 덤프문제 온라인 액세스

Examine the data in the COLORS table:

Examine the data in the BRICKS table:

Which two queries return all the rows from COLORS?

• A.SELECT *
  EROM bricks | b
  JOIN colors C
  ON b. color_ rgb_ hex_ value =c. rgb _hex value;
• B.SELECT
  EROM colors C
  LEET JOIN bricks b
  ON b. color_ rgb_ hex value = c. rgb. hex.
• C.SELECT
  FROM bricks b
  FULL JOIN colors C
  ON b. color rgb _ hex_ value = c. rgb _hex_ value;
• D.SELECT.
  FROM bricks b
  RIGHT JOIN colors c
  ON b. color _rgb_ hex_ value = c. rgb hex_ value;
• E.SELECT
  EROM colors C
  LEFT JOIN bricks on
  USING (rgb _ hex_ value) ;

Examine the description of the BOOKS_TRANSACTIONS table:

Which two WHERE conditions give the same result?

• A.WHERE borrowed_date = SYSDATE AND transaction_type ='RM' OR member_id IN ('A101','A102');
• B.WHERE borrowed_date = SYSDATE AND (transaction_type ='RM' OR member_id IN ('A101','A102'));
• C.WHERE (borrowed_date = SYSDATE AND transaction_type ='RM') OR member_id IN ('A101','A102');
• D.WHERE borrowed_date = SYSDATE AND (transaction_type ='RM' AND (member_id ='A101' OR member_id ='A102') );
• E.WHERE borrowed_date = SYSDATE AND (transaction_type ='RM' AND member_id='A101' OR member_id ='A102'));

Which three are true aboutprivileges and roles?

• A.All roles are owned by the sYs schema.
• B.PUBIIC can be revoked from a user.
• C.A role is owned by the user who created it.
• D.A user has all object privileges for every object in their schema by default.
• E.PUBLIC acts as a default role granted to every user in a database.
• F.A role can contain a combination of several privileges and roles.
• G.System prilgese always set prilge for an entire database.

Examine this query:
SELECT INTERVAL '100' MONTH DURATION FROM DUAL;
What will be the output?

• A.DURATION
  +08-04
• B.DUFATION
  +100
• C.an error
• D.DURATION
  +08

Which statements are true regarding primary and foreign key constraints and the effect they can have on table data?

• A.It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted.
• B.A table can have only one primary key but multiple foreign keys.
• C.Only the primary key can be defined the column and table level.
• D.A table can have only one primary key and one foreign key.
• E.Primary key and foreign key constraints can be defined at both the column and table level.
• F.It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted.
• G.The foreign key columns and parent table primary key columns must have the same names.