Tag Archives: ocp

Q150 Identify three ORDER BY clauses, any one of which can complete the query successfully

Q150 Examine this SQL statement: SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id =...

Q149 You want to apply the principle of Least Privilege in all your live databases

Q149 You want to apply the principle of Least Privilege in all your live databases....

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

Q148 Examine the data in the CUST_NAME column of the CUSTOMERS table: CUST_NAME ———————————- Renske...

Q147 Which three actions are ways to apply the principle of least privilege?

Q147 Which three actions are ways to apply the principle of least privilege? A) setting...

Q146 Examine these SQL statements which execute successfully

Q146 Examine these SQL statements which execute successfully: Which two statements are true after execution?...

Q145 Which three statements are true about roles?

Q145 Which three statements are true about roles? (A). All roles granted to a user...

Q144 Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?

Q144 Which two statements are true about the WHERE and HAVING clauses in a SELECT...

Q143 Which statement is true about database links?

Q143 Which statement is true about database links? (A). Private database link creation requires the...

Q142 What is true about non-equijoin statement performance?

Q142 What is true about non-equijoin statement performance? (Choose two.) (A). Table aliases can improve...

Q141 Which two where conditions demonstrate the correct usage of conversion functions?

Q141 The orders table has a column ORDER_DATE of data type date. The default display...

Q140 Which two statements are true about interval data types?

Q140 Which two statements are true about interval data types? (A). INTERVAL year TO month...

Q139 Which two are true about shrinking a segment online?

Q139 Which two are true about shrinking a segment online? (Choose two.) (A). It is...