1z1-071試験無料問題集「Oracle Database SQL 認定」

A. The subquery is not a correlated subquery.

B. All existing rows in the ORDERS table are updated.

C. The subquery is executed for every updated row in the ORDERS table.

D. The subquery is executed before the UPDATE statement is executed.

E. The UPDATE statement executes successfully even if the subquery selects multiple rows.

A. INTERVAL YEAR TO MONTH

B. TIMESTAMP WITH TIMEZONE

C. TIMESTAMP WITH LOCAL TIMEZONE

D. TIMESTAMP

E. INTERVAL DAY TO SECOND

A. They can insert each computed row into more than one table.

B. They can be performed on external tables using SQL*Loader.

C. They can be performed only by using a subquery.

D. They can be performed on remote tables.

E. They can be performed on relational tables.

F. They can be performed on views.

A. A table can have only one PRIMARY KEY but may have multiple FOREIGN KEY constraints.

B. A table can have multiple PRIMARY KEY and multiple FOREIGN KEY constraints.

C. A table can have only one PRIMARY KEY and one FOREIGN KEY constraint.

D. PRIMARY KEY and FOREIGNY constraints can be specified at the column and at the table level

E. A FOREIGN KEY column in a child table and the referenced PRIMARY KEY column in the parenttable must have the same names.

F. NOT NULL can be specified at the column and at the table level.

A. ORDER BY NVL(enam,0) DESC, ename

B. ORDER BY comm DESC NULLS LAST, ename

C. ORDER BY NVL(comm,0) ASC NULLS LAST, ename

D. ORDER BY NVL(comm,0) ASC NULLS FIRST, ename

A. A primary key column cannot be dropped.

B. A column must be set as unused before it is dropped from a table.

C. A column that is referenced by another column in any other table cannot be dropped.

D. A column can be removed only if it contains no data.

E. Multiple columns can be dropped simultaneously using the ALTER TABLE command.

F. A column drop is implicitly committed

A. The data type returned can be different from the data type of the argument.

B. The argument can be a column name, variable, literal or an expression.

C. They can be used only in the WHERE clause of a SELECT statement.

D. They can accept only one argument.

E. They return a single result row per table.

F. They can be nested to any level.

A. It returns the date for the last Monday of the current month.

B. It returns the date for the first Monday of the next month.

C. It generates an error.

D. It executes successfully but does not return any result.

A. The names of employees earning the maximum salary will appear first in descending order.

B. All remaining employee names will appear in an unspecified order.

C. All remaining employee names will appear in ascending order.

D. All remaining employee names will appear in descending order.

E. The names of employees earning the maximum salary will appear first In ascending order.

F. The names of employees earning the maximum salary will appear first in an unspecified order.

A. TO_DATE(PROMO_BEGIN_DATE * 5) will return a date

B. PROMO_BEGIN_DATE-5 will return a date.

C. TO_NUMBER(PROMO_BEGIN_DATE)-5 will return number

D. PROMO_BEGIN_DATE-SYSDATE will return a number.

E. PROMO_BEGIN_DATE-SYSDATE will return an error.

A. SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;

B. SELECT produet_id, unit_pricer, 5 "Discount",unit_price+surcharge-discount FROM products;

C. SPLECT product_id, expiry_date * 2 FROM products;

D. SELECT ptoduct_id, (expiry_date-delivery_date) * 2 FROM products;

E. SELEGT product_id, unit_price, unit_price + surcharge FROM products;

F. SELECT product_id,unit_price || "Discount", unit_price + surcharge-discount FROM products;

A. Display the minimum PROD_LIST_PRICE for each product status.

B. Display the total number of products supplied by supplier 102 which have a product status of obsolete.

C. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable.

D. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE.

E. Display suppliers whose PROD_LIST_PRICE is less than 1000.

A. FLOOR: returns the smallest integer greater than or equal to a specified number

B. CONCAT: can be used to combine any number of values

C. MOD: returns the quotient of a division operation

D. CEIL: can be used for positive and negative numbers

E. TRUNC: can be used with NUMBER and DATE values

A. It can be used in SQL Developer and SQL*Plus.

B. It displays values for variables created by the DEFINE command.

C. It displays values for variables used only in the WHERE clause of a query.

D. It can be used only in SQL*plus.

E. It displays values for variables prefixed with &&.

A. SELECT q'! Hello! We're ready! 'FROM DUAL;

B. SELECT q'[Hello! We're ready]'FROM DUAL;

C. SELECT 'Hello! We're ready' FROM DUAL;

D. SELECT 'Hello! we\ re ready' ESCAPE'N'FROMDUAL:

E. SELECT "Hello! We're ready "FROM |DUAL;

A. It retains the integrity constraints defined on the table.

B. A Flashback TABLE statement can be used to retrieve the deleted data.

C. It always retains the space used by the removed rows

D. It retains the indexes defined on the table.

E. A ROLLBACK statement can be used to retrieve the deleted data.

F. It drops any triggers defined on the table.