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

A. 1

B. 4

C. 6

D. 16

E. 0

F. 10

A. You must have SELECT privileges on a table to view it in ALL TABLES.

B. All users can query DBA TABLES successfully.

C. You must have SELECT privileges on a table to view it in USER TABLES.

D. USER TABLES displays all tables owned by the current user.

E. All TABLES displays all tables owned by the current user.

F. You must have SELECT privileges on a table to view it in DBA TABLES.

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

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

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

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.

A. CASCADE CONSTRAINTS must be specified when referential integrity constraints on other objects refer to primary or unique keys in the view to be dropped.

B. Data selected by a view's defining query is deleted from its underlying tables when the view is dropped.

C. Views referencing a dropped view become invalid.

D. The creator of a view to be dropped must have the drop any view privilege.

E. Read only views cannot be dropped.

A. When you terminate your session, the row will be deleted.

B. Other sessions can view the committed row.

C. To drop the table in this session, you must first truncate it.

D. You can add a column to the table in this session.

E. You can add a foreign key to the table.

A. Tables in the defining query of a view must always exist in order to create the view.

B. Date Manipulation Language (DML) can always be used on views.

C. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.

D. The WITH CHECK clause prevents certain rows from being displayed when querying the view.

E. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.

F. Views can be updated without the need to re-grant privileges on the view.

G. The WITH CHECK clause prevents certain rows from being updated or inserted.

A. Constraints are enforced only during INSERT operations.

B. All constraints can be defined at the table or column level.

C. A column with a foreign key constraint can never contain a null value.

D. A column with a UNIQUE constraint can contain a NULL value.

E. A constraint can be disabled even if the constrained column contains data.

A. EXPIRY_ DATE cannot be used in arithmetic expressions.

B. PRODUCT_ PRICE contains the value zero by default if no value is assigned to it.

C. PRODUCT_ PRICE can be used in an arithmetic expression even if it has no value stored in it.

D. PRODUCT_ NAME cannot contain duplicate values.

E. PRODUCT_ ID can be assigned the PRIMARY KEY constraint.

F. EXPIRY_ DATE contains the SYSDATE by default if no date is assigned to it.

A. Their data is always stored in the default temporary tablespace of the user who created them.

B. Indexes can be created on them.

C. If the ON COMMIT clause Is transaction-specific, all rows in the table are deleted alter each COMMIT or ROLLBACK.

D. They can be created only by a user with the DBA role,but can be accessed by all users who can create a session.

E. Backup and recovery operations are available for these tables.

F. If the ON COMMIT clause is session-specific,the table is dropped when the session is terminated.

A. SELECT TO_DATE(TO_NUMBER(INTERVATL '800' SECOND)) FROM DUAL;

B. SELECT TO_CHAR(INTERVAL '800' SECOND, 'HH24:MM') FROM DUAL;

C. SELECT TO_NUWBER(TO_DATE(INTERVAL '800' SECOND)) FROM DUAL;

D. SELECT TO_DATE(INTERVAL '800' SECOND,'HH24:MM') FROM DUAL;

E. SELECT TO_NUMBER(INTERVAL'800' SECOND, 'HH24:MM') FROM DUAL;

A. RIGHT OUTER

B. LEFT OUTER

C. FULL OUTER

D. CROSS

A. only departments where the total salary is greater than 3000, returned in no particular order

B. all departments and a sum of the salaries of employees with a salary greater than 3000

C. only departments where the total salary is greater than 3000, ordered by department

D. an error

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. SELECT prod_id || q'('s not available)' 'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK';

B. SELECT prod_id || q'('s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK';

C. SELECT prod_id "CURRENT AVAILABILITY" || q'('s not available)' FROM product_status WHERE status = 'OUT OF STOCK';

D. SELECT prod_id || q's not available'' FROM product_status WHERE status='OUT OF STOCK';

E. SELECT prod_id || q'('s not available)' FROM product_status WHERE status = 'OUT OF STOCK';

F. SELECT prod_id || q"'s not available" FROM product_status WHERE status = 'OUT OF STOCK';

A. providing variable definition capabilities.

B. providing database transaction control

C. providing update capabilities for data in external files

D. providing graphical capabilities

E. processing sets of data

A. SELECT-TO_CHAR(TO _DATE('29-10-2019'+ INTERVAL '2' MONTH+INTERVAL '6' DAYINTERVAL
'120' SECOND, 'DD-MON-YY') AS "daTe"
FROM DUAL;

B. SELECT-TO_CHAR(TO _DATE('29-10-2019'+ INTERVAL '2' MONTH+INTERVAL '4' DAYINTERVAL
'120' SECOND, 'DD-MON-YY') AS "daTe"
FROM DUAL;

C. SELECT To CHAR(TO _DATE('29-10-2019') + INTERVAL '2' NONTH + INTERVAL '5' DAY INEERVAL '120' SECOND, ' DD-MON-YYY) AS "date" FROM DUAL;

D. SELECT TO_ CHAR(TO_ DATE('29-10-2019') +INTERVAL '2'; MONTH + INTERVAL '5'; DAY - INTERVAL '86410' SECOND, ' DD-MON-YYYY') AS "date" FROM DUAL;

E. SELECT TO_ CHAR(TO_ DATE('29-10-2019') + INTERVAL '3' MONTH + INTERVAL '7' DAY - INTERVAL '360' SECOND, ' DD-MON-YYYY') AS "date" FROM DUAL;

A. INTERVAL YEAR TO MONTH

B. TIMESTAMP WITH TIMEZONE

C. TIMESTAMP WITH LOCAL TIMEZONE

D. TIMESTAMP

E. INTERVAL DAY TO SECOND

A. MERGE INTO new_prices n
USING products p
ON (p.prod_id =n.prod_id)
WHEN NOT MATCHED THEN
INSERT (n.prod _id, n.price) VALUES (p.prod_id, cost*.01)
WHERE (p.cost<200);

B. MERGE INTO new_prices n
USING (SELECT * FROM products WHERE cost>150) p
ON (n.prod_id= p.prod_id)
WHEN MATCHED THEN
UPDATE SET n.price= p.cost*.01
DELETE WHERE (p.cost<200);

C. MERGE INTO new_prices n
USING (SELECT * FROM products WHERE cost>150) p
ON (n.prod_id= p.prod_id)
WHEN MATCHED THEN
DELETE WHERE (p.cost<200)

D. MERGE INTO new_prices n
USING (SELECT * FROM products) p
WHEN MATCHED THEN
UPDATE SET n.price= p.cost* 01
WHEN NOT MATCHED THEN
INSERT(n.prod_id, n.price) VALUES(p.prod_id, cost*.01)
WHERE(p.cost<200);