1Z0-071 practice questions 231–238

1. Question 231 · 238 in bank

   Select 3

   You issued this command: DROP TABLE hr.employees; Which three statements are true? (Choose three.)

   • ASequences used to populate columns in the HR.EMPLOYEES table are dropped.
   • BSynonyms for HR.EMPLOYEES are dropped.
   • CViews referencing HR.EMPLOYEES are dropped.
   • DAll constraints defined on HR.EMPLOYEES are dropped.
   • EThe HR.EMPLOYEES table may be moved to the recycle bin.
   • FAll indexes defined on HR.EMPLOYEES are dropped

   Show answer

   Answer: DEF

   Next question

2. Question 232 · 238 in bank

   Select 2

   Examine the description of the SALES table:

   

   The SALES table has 55,000 rows. Examine this statement:

   

   Which two statements are true? (Choose two.)

   • ASALES1 is created with 55,000 rows.
   • BSALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.
   • CSALES1 is created with no rows.
   • DSALES1 is created with 1 row
   • ESALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.

   Show answer

   Answer: AB

   Next question

3. Question 233 · 238 in bank

   Select 3

   Examine this statement:

   

   Identify three ORDER BY clauses, any one of which will complete the query successfully. (Choose three.)

   • AORDER BY CUST_NO
   • BORDER BY 2, cust_id
   • CORDER BY 2, 1
   • DORDER BY "Last Name"
   • EORDER BY "CUST_NO"

   Show answer

   Answer: BCD

   Next question

4. Question 234 · 238 in bank

   Select 2

   Which two statements are true about views? (Choose two.)

   • AThe WITH CHECK clause prevents certain rows from being updated or inserted in the underlying table through the view.
   • BThe WITH CHECK clause prevents certain rows from being displayed when querying the view.
   • CViews can be indexed.
   • DViews can be updated without the need to re-grant privileges on the view.
   • ETables in the defining query of a view must always exist in order to create the view.

   Show answer

   Answer: AD

   Next question

5. Question 235 · 238 in bank

   Select 2

   Examine the description of the EMPLOYEES table:

   

   Which two statements will run successfully? (Choose two.)

   • ASELECT ‘The first_name is ‘‘ || first_name || ‘‘ FROM employees;
   • BSELECT ‘The first_name is ‘‘‘ || first_name || ‘‘‘‘ FROM employees;
   • CSELECT ‘The first_name is ‘‘‘ || first_name || ‘‘‘ FROM employees;
   • DSELECT ‘The first_name is ‘ || first_name || ‘‘ FROM employees;
   • ESELECT ‘The first_name is \‘‘ || first_name || ‘\‘‘ FROM employees;

   Show answer

   Answer: BD

   Next question

6. Question 236 · 238 in bank

   Select 2

   Examine the data in the CUST_NAME column of the CUSTOMERS table:

   

   You want to display the CUST_NAME values where the last name starts with Mc or MC. Which two WHERE clauses give the required result? (Choose two.)

   • AWHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name, ' ') + 1)) LIKE 'Mc%'
   • BWHERE SUBSTR(cust_name, INSTR(cust_name, ' ') + 1) LIKE 'Mc%'
   • CWHERE SUBSTR(cust_name, INSTR(cust_name, ' ') + 1 ) LIKE 'Mc%' OR 'MC%'
   • DWHERE UPPER(SUBSTR(cust_name, INSTR(cust_name, ' ') + 1)) LIKE UPPER('MC%')
   • EWHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name, ' ’) + 1)) IN ('MC%', 'Mc%)

   Show answer

   Answer: AD

   Next question

7. Question 237 · 238 in bank

   Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?

   • Athe first VARCHAR2 column in the first SELECT of the compound query
   • Bthe first column in the first SELECT of the compound query
   • Cthe first NUMBER column in the first SELECT of the compound query
   • Dthe first NUMBER or VARCHAR2 column in the last SELECT of the compound query
   • Ethe first column in the last SELECT of the compound query

   Show answer

   Answer: B

   Next question

8. Question 238 · 238 in bank

   Select 2

   Which two statements are true about the ORDER BY clause? (Choose two.)

   • AIn a character sort, the values are case-sensitive.
   • BNULLS are not included in the sort operation.
   • CNumeric values are displayed in descending order if they have decimal positions.
   • DColumn aliases can be used in the ORDER BY clause.
   • EOnly columns that are specified in the SELECT list can be used in the ORDER BY clause.

   Show answer

   Answer: AD

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

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