Hub for All Education Needs
Correct Answer for the Question – Which query can be used? is given below SELECT * FROM customers WHERE city LIKE ‘D_%’; SELECT * FROM customers WHERE city = ‘%D_’; SELECT * FROM customers WHERE city LIKE ‘D_’; SELECT * FROM customers WHERE city = ‘D_%’; Correct Answer The Correct Answer for this Question is SELECT … Read more
Correct Answer for the Question – Which query is valid? is given below SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id; SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id; SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date; SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id; Correct Answer The Correct Answer for this Question … Read more
Correct Answer for the Question – What will happen upon execution? is given below The command succeeds and HR will be connected to the orcl and abc.sql databases The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed The command fails because the script must refer … Read more
Correct Answer for the Question – Which statement is true about aggregate functions? is given below Aggregate functions can be nested to any number of levels The AVG function implicitly converts NULLS to zero Aggregate functions can be used in any clause of a SELECT statement The MAX and MIN functions can be used on columns … Read more
Correct Answer for the Question – Which statement is true about the INTERSECT operator used in compound queries? is given below Multiple INTERSECT operators are not possible in the same SQL statement It processes NULLs in the selected columns INTERSECT is of lower precedence than UNION or UNION ALL It ignores NULLs Correct Answer The Correct … Read more
Correct Answer for the Question – What is the outcome? is given below The value is changed only in the PFILE and takes effect at the next instance startup The value is changed for the current instance and in the PFILE It fails because the SCOPE clause is missing Change is applied to the current instance, … Read more
Correct Answer for the Question – Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? is given below Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.) An undo segment may be … Read more
Correct Answer for the Question – Which four account management capabilities can be configured using Oracle profiles? is given below Which four account management capabilities can be configured using Oracle profiles? (Choose four.) the number of hours for which an account is locked after the configured number of login attempts has been reached the number of … Read more
Correct Answer for the Question – Which three statements are true concerning logical and physical database structures? is given below Which three statements are true concerning logical and physical database structures? (Choose three.) All tablespaces may have one or more data files The extents of a segment must always reside in the same datafile A smallfile … Read more
Correct Answer for the Question – Which three statements are true about dropping and unused columns in an Oracle database? is given below Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.) A primary key column referenced by another column as a foreign key can be dropped if using … Read more