An Oracle database server session has an uncommitted transaction in progress which updated 5000 rows
in a table.
In which three situations does the transact ion complete thereby committing the updates?

• A.When the session logs out is successfully
• B.When a COMMIT statement is issued by the same user from another session in the same database instance
• C.When a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user, then issues a COMMIT
• D.When a CREATE INDEX statement is executed successfully in same session
• E.When a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session
• F.When a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the PRODUCT table.

Which two tasks would require subqueries? (Choose two.)

• A.display all suppliers whose list price is more than 1000
• B.display all products whose minimum list price is more than the average list price of products having the status 'orderable'
• C.display the number of products whose list prices are more than the average list price
• D.display the minimum list price for each product status
• E.display the total number of products supplied by supplier 102 and have product status as 'OBSOLETE'

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure in ORDERSand ORDER_ITEMStables.

You need to create a view that displays the ORDER_ID, ORDER_DATE, and the total number of items in each order.
Which CREATEVIEWstatement would create the views successfully?

• A.CREATE OR REPLACE VIEW ord_vu
  AS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)
  " NO OF ITEMS"
  FROM orders o JOIN order_items i
  ON (o.order_id = i.order_id)
  GROUP BY o.order_id, o.order_date;
• B.CREATE OR REPLACE VIEW ord_vu
  AS SELECT o.order_id, o.order_date, COUNT (i.line_item_id) ||
  " NO OF ITEMS"
  FROM orders o JOIN order_items i
  ON (o.order_id = i.order_id)
  GROUP BY o.order_id, o.order_date
  WHITH CHECK OPTION;
• C.CREATE OR REPLACE VIEW ord_vu
  AS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)
  FROM orders o JOIN order_items i
  ON (o.order_id = i.order_id)
  GROUP BY o.order_id, o.order_date;
• D.CREATE OR REPLACE VIEW ord_vu (order_id, order_date)
  AS SELECT o.order_id, o.order_date, COUNT (i.line_item_id)
  " NO OF ITEMS"
  FROM orders o JOIN order_items i
  ON (o.order_id = i.order_id)
  GROUP BY o.order_id, o.order_date;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the description for the SALES and CHANNELS tables.

You issued this SQL statement:

Which statement is true regarding the result? (Choose the best answer.)

• A.The statement will fail because a subquery cannot be used in a VALUES clause.
• B.The statement will fail because the VALUES clause is not required with the subquery.
• C.The statement will execute and a new row will be inserted in the SALES table.
• D.The statement will fail because the subquery in the VALUES clause is not enclosed within single quotation marks.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the data in the employees table.
You want to generate a report showing the total compensation paid to each employee to date.
You issue the following query:
What is the outcome?

• A.It executes successfully and gives the correct output.
• B.It generates an error because the usage of the round function in the expression is not valid
• C.It generates an error because the alias is not valid.
• D.It executes successfully but does not give the correct output.
• E.It generates an error because the concatenation operator can be used to combine only two items.

Comment: *

Name: *

Email: *

Verification: *