Which statement is true regarding the USING clause in table joins?

Which statement is true regarding the USING clause in table joins? (Choose two.) Question: Which statement is true regarding the USING clause in table joins? Options: It can be used to join a maximum of three tables. It can be used to access data from tables through equijoins as well as nonequijoins. It can be … Read more

Which statement would accomplish this requirement?

You need to produce a report where each customer’s credit limit has been incremented by $1000. In the output, the customer’s last name should have the heading Name and the incremented credit limit should be labeled New Credit Limit.The column headings should have only the first letter of each word in uppercase.Which statement would accomplish … Read more

Which three tasks can be performed by DDL statements?

Which three tasks can be performed by DDL statements? Question: Which three tasks can be performed by DDL statements? Options: providing an alternative name for a table modifying a table to prevent data that violate certain conditions from being entered in a column preventing any data modification to a table preventing data retrieval from a … Read more

Which statement is true about aggregate functions?

Which statement is true about aggregate functions?Reference: https://docs.oracle.com/database/121/SQLRF/functions003.htm Question: Which statement is true about aggregate functions? Options: The AVG function implicitly converts NULLS to zero. Aggregate functions can be nested to any number of levels. The MAX and MIN functions can be used on columns with character data types. Aggregate functions can be used in … Read more

Which statement is true about the INTERSECT operator used in compound queries?

Which statement is true about the INTERSECT operator used in compound queries? Question: Which statement is true about the INTERSECT operator used in compound queries? Options: INTERSECT is of lower precedence than UNION or UNION ALL. Multiple INTERSECT operators are not possible in the same SQL statement. It ignores NULLs. It processes NULLs in the … Read more

Which two statements are true regarding the command?

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:$> sqlldr hr/[email protected] table=employeesWhich two statements are true regarding the command? Question: Which two statements are true regarding the command? Options: It succeeds with default settings if the EMPLOYEES table belonging … Read more

Which statement is true regarding the UNION operator?

Which statement is true regarding the UNION operator? Question: Which statement is true regarding the UNION operator? Options: By default, the output is not sorted. Null values are not ignored during duplicate checking. Names of all columns must be identical across all select statements. The number of columns selected in all select statements need not … Read more

A non-correlated subquery can be defined as __________. (Choose the best answer.)

A non-correlated subquery can be defined as __________. (Choose the best answer.) Question: A non-correlated subquery can be defined as __________. (Choose the best answer.) Options: A set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query. A set … Read more

Which statement is true about the Oracle SQL, DELETE and TRUNCATE statements?

Which statement is true about the Oracle SQL, DELETE and TRUNCATE statements? Question: Which statement is true about the Oracle SQL, DELETE and TRUNCATE statements? Options: DELTE and TRUNCATE statements can have a rollback done to restore data into a table. DELETE and TRUNCATE statements remove all indexes for the tables on which they are … Read more

Why would the ORD_ITEMS table not get created?

Evaluate the following CREATE TABLE commands:CREATE_TABLE orders(ord_no NUMBER (2) CONSTRAINT ord_pk PRIMARY KEY, ord_date DATE, cust_id NUMBER (4));CREATE TABLE ord_items (ord _no NUMBER (2), item_no NUMBER(3), qty NUMBER (3) CHECK (qty BETWEEEN 100 AND 200), expiry_date date CHECK (expiry_date> SYSDATE), CONSTRAINT it_pk PRIMARY KEY (ord_no, item_no),CONSTARAINT ord_fk FOREIGN KEY (ord_no) REFERENCES orders (ord_no) );Why would … Read more