Page: 1
/ 16
Total 236 questions
Which three statements are true about inner and outer joins? (Choose three.)
- A. A full outer join returns matched and unmatched rows.
- B. Outer joins can be used when there are multiple join conditions on two tables.
- C. A full outer join must use Oracle syntax.
- D. Outer joins can only be used between two tables per query.
- E. A left or right outer join returns only unmatched rows.
- F. An inner join returns matched rows.
Answer : ABF
Examine the description of the EMPLOYEES table:
Which two queries return all rows for employees whose salary is greater than the average salary in their department? (Choose two.)
A.
B.
C.
D.
E.
Answer : BE
Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)
- A. The Oracle join syntax supports creation of a Cartesian product of two tables.
- B. The Oracle join syntax only supports right outer joins.
- C. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.
- D. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax.
- E. The Oracle join syntax supports natural joins.
- F. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
- G. The SQL:1999 compliant ANSI join syntax supports natural joins.
Answer : ACG
Which two are true about the NVL, NVL2, and COALESCE functions? (Choose two.)
- A. NVL must have expressions of the same data type.
- B. NVL can have any number of expressions in the list.
- C. NVL2 can have any number of expressions in the list.
- D. COALESCE stops evaluating the list of expressions when it finds the first non-null value.
- E. The first expression in NVL2 is never returned.
- F. COALESCE stops evaluating the list of expressions when it finds the first null value.
Answer : DE
Reference:
https://www.interviewsansar.com/difference-between-nvl-nvl2-nullif-and-coalesce-functions/
Examine this statement:
What is returned upon execution?
- A. an error
- B. 2 rows
- C. 0 rows
- D. 1 row
Answer : D
Examine this statement:
What is returned upon execution?
- A. an error
- B. 2 rows
- C. 0 rows
- D. 1 row
Answer : D
An Oracle Database session has an uncommitted transaction in progress which updated 5000 rows in a table.
In which three situations does the transaction complete thereby committing the updates? (Choose three.)
- A. when a CREATE TABLE AS SELECT statement is issued in the same session but fails with a syntax error
- B. when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT
- C. when the session logs out successfully
- D. when a CREATE INDEX statement is executed successfully in the same session
- E. when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT
- F. when a COMMIT statement is issued by the same user from another session in the same database instance
Answer : ACD
Which two are true about using constraints? (Choose two.)
- A. NOT NULL can be specified at the column and at the table level.
- B. A table can have only one PRIMARY KEY and one FOREIGN KEY constraint.
- C. A FOREIGN KEY column in a child table and the referenced PRIMARY KEY column in the parent table must have the same names.
- D. PRIMARY KEY and FOREIGN KEY constraints can be specified at the column and at the table level.
- E. A table can have multiple PRIMARY KEY and multiple FOREIGN KEY constraints.
- F. A table can have only one PRIMARY KEY but may have multiple FOREIGN KEY constraints.
Answer : DF
Examine this statement:
On which two columns of the table will an index be created automatically? (Choose two.)
- A. ORDER_ID
- B. ORDER_TOTAL
- C. ORDER_DATE
- D. PRODUCT_ID
- E. STATUS
- F. SERIAL_NO
Answer : AF
Examine this partial query:
Examine this output:
Which GROUP BY clause must be added so the query returns the results shown?
- A. GROUP BY ch.channel_type, ROLLUP(t.month, co.country_code);
- B. GROUP BY ch.channel_type, t.month, ROLLUP(co.country_code);
- C. GROUP BY CUBE(ch.channel_type, t.month, co.country_code);
- D. GROUP BY ch.channel_type, t.month, co.country_code;
Answer : A
Examine the description of the EMPLOYEES table:
Which statement will execute successfully, returning distinct employees with non-null first names?
- A. SELECT first_name, DISTINCT last_name FROM employees WHERE first_name <> NULL;
- B. SELECT first_name, DISTINCT last_name FROM employees WHERE first_name IS NOT NULL;
- C. SELECT DISTINCT * FROM employees WHERE first_name IS NOT NULL;
- D. SELECT DISTINCT * FROM employees WHERE first_name <> NULL;
Answer : C
Examine the description of the BRICKS table:
Examine the description of the BRICKS_STAGE table:
Which two queries execute successfully? (Choose two.)
A.
B.
C.
D.
E.
Answer : BE
Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:
Which two statements are true? (Choose two.)
- A. Employees 100 and 200 will have the same SALARY as before the update command.
- B. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200.
- C. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100.
- D. Employees 100 and 200 will have the same JOB_ID as before the update command.
- E. Employee 100 will have SALARY set to the same value as the SALARY of employee 200.
- F. Employee 200 will have SALARY set to the same value as the SALARY of employee 100.
Answer : BE
30 days access 