1Z0-071 practice questions 141–150

1. Question 141 · 238 in bank

   Select 3

   Which three are true about the MERGE statement? (Choose three.)

   • AIt can use subqueries to produce source rows.
   • BIt can update the same row of the target table multiple times.
   • CIt can update, insert, or delete rows conditionally in multiple tables.
   • DIt can use views to produce source rows.
   • EIt can merge rows only from tables.
   • FIt can combine rows from multiple tables conditionally to insert into a single table.

   Show answer

   Answer: ADF

   References

   • Oracle documentation

   Next question

2. Question 142 · 238 in bank

   Select 3

   Which three statements are true about defining relations between tables in a relational database? (Choose three.)

   • APrimary key columns allow null values.
   • BEvery primary or unique key value must refer to a matching foreign key value.
   • CEvery foreign key value must refer to a matching primary or unique key value.
   • DForeign key columns allow null values.
   • EUnique key columns allow null values.

   Show answer

   Answer: CDE

   Next question

3. Question 143 · 238 in bank

   Select 2

   Which two join conditions in a FROM clause are non-equijoins? (Choose two.)

   • Atable1 JOIN table2 USING (column1, column2)
   • Btable1 JOIN table2 ON (table1.column BETWEEN table2.column1 AND table2.column2)
   • Ctable1 NATURAL JOIN table2
   • Dtable1 JOIN table2 ON (table1.column >= table2.column)
   • Etable1 JOIN table2 ON (table1.column = table2.column) WHERE table2.column LIKE ‘A%’

   Show answer

   Answer: BD

   Next question

4. Question 144 · 238 in bank

   Select 2

   Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

   • ADuplicates are eliminated automatically by the UNION ALL operator.
   • BThe output is sorted by the UNION ALL operator.
   • CThe names of columns selected in each SELECT statement must be identical.
   • DNULLs are not ignored during duplicate checking.
   • EThe number of columns selected in each SELECT statement must be identical.

   Show answer

   Answer: DE

   Next question

5. Question 145 · 238 in bank

   Select 3

   Which three actions can you perform only with system privileges? (Choose three.)

   • AQuery any table in a database.
   • BExecute a procedure in another schema.
   • CLog in to a database instance.
   • DAccess flat files, which are stored in an operating system directory, via the UTL_FILE package.
   • EUse the WITH GRANT OPTION clause.

   Show answer

   Answer: ABC

   Explanation

   D 'WARNING:The privileges needed to access files in a directory object are operating system specific. UTL_FILE directory object privileges give you read and write access to all files within the specified directory.'

   Source: Adapted from community discussion — JUMP56

   References

   • Oracle documentation

   Next question

6. Question 146 · 238 in bank

   Select 2

   1. MANAGER is an existing role with no privileges or roles. 2. EMP is an existing role containing the CREATE TABLE privilege. 3. EMPLOYEES is an existing table in the HR schema. Which two commands execute successfully? (Choose two.)

   • AGRANT CREATE SEQUENCE TO manager, emp;
   • BGRANT CREATE TABLE, emp TO manager;
   • CGRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;
   • DGRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION;
   • EGRANT CREATE TABLE, SELECT ON hr.employees TO manager;

   Show answer

   Answer: AB

   Next question

7. Question 147 · 238 in bank

   Select 2

   Which two statements will convert the string Hello World to ello world? (Choose two.)

   • ASELECT INITCAP(TRIM(‘H’ FROM ‘Hello World’)) FROM DUAL;
   • BSELECT SUBSTR(‘Hello World’, 2) FROM DUAL;
   • CSELECT LOWER(SUBSTR(‘Hello World’, 2, 1)) FROM DUAL;
   • DSELECT LOWER(TRIM(‘H’ FROM ‘Hello World’)) FROM DUAL;
   • ESELECT LOWER(SUBSTR(‘Hello World’, 2)) FROM DUAL;

   Show answer

   Answer: DE

   Next question

8. Question 148 · 238 in bank

   Select 3

   Which three actions can you perform by using the ALTER TABLE command? (Choose three.)

   • ADrop pseudocolumns from a table.
   • BRestrict all DML statements on a table.
   • CLock a set of rows in a table.
   • DRename a table.
   • EDrop all columns simultaneously from a table.
   • FEnable or disable constraints on a table.

   Show answer

   Answer: BDF

   Explanation

   B. Alter Table XYZ Read only D. Alter Table XYZ Rename to ABC F. ALTER TABLE employees ADD CONSTRAINT emp_pk PRIMARY KEY (employee_id); ----- E. You cant drop all columns from table with Drop. you can drop multiple.

   Source: Adapted from community discussion — ArslanAltaf

   Next question

9. Question 149 · 238 in bank

   Select 3

   Which three statements are true about built-in data types? (Choose three.)

   • AThe default length for a CHAR column is always one character.
   • BA VARCHAR2 blank-pads column values only in the data stored is non-numeric and contains no special characters.
   • CA VARCHAR2 column definition does not require the length to be specified.
   • DA CHAR column definition does not require the length to be specified.
   • EA BLOB stores unstructured binary data within the database.
   • FA BFILE stores unstructured binary data in operating system files.

   Show answer

   Answer: AEF

   Next question

10. Question 150 · 238 in bank

    Select 3

    Which three are true about granting object privileges on tables, views, and sequences? (Choose three.)

    • AUPDATE can be granted only on tables and views.
    • BDELETE can be granted on tables, views, and sequences.
    • CSELECT can be granted on tables and views.
    • DALTER can be granted only on tables and sequences.
    • EREFERENCES can be granted only on tables and views.
    • FINSERT can be granted on tables, views, and sequences.

    Show answer

    Answer: ADE

    Explanation

    A. TRUE B. FALSE. Only Table C. True. Can also be granted on sequences D. False. Trick question as alter is system privilege. Alter can be granted on both table and sequences. E. TRUE F. False. Insert can be granted to table and synonym

    Source: Adapted from community discussion — Misi_Oracle

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

1Z0-071 practice, question 141. 238 questions available.