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

A. Insert statements can always be done on a table through a view.

B. Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.

C. WITH CHECK clause has no effect when deleting rows from the underlying table through the view.

D. Delete statements can always be done on a table tough a view.

E. Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.

F. Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.

A. SELECT employee_ name FROM employees WHERE (SYSDATE - hire_ data) / 365>5

B. SELECT employee_ name FROM employees WHERE (CUARENT_ DATE - hire_ data / 365>5

C. SELECT employee_ name FROM employees WHERE (SYSNAYW - hire_ data / 12> 3

D. SELECT employee_ name FROM employees WHERE (CUNACV_ DATE - hire_ data / 12> 3

E. SELECT employee_ name FROM employees WHERE (SYSNAYW - hire_ data / 12> 3

F. There are typos in this option (CUNACV_DATE should be CURRENT_DATE and hire_data should be hire_date). Additionally, dividing by 12 incorrectly assumes that a month is equivalent to a year.

G. SELECT employee_ name FROM employees WHERE (SYSTIMESTAMP - hire_ data) / 365>

A. The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.

B. INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.

C. INTERVAL YEAR TO MONTH columns support yearly intervals.

D. INTERVAL DAY TO SECOND columns support fractions of seconds.

E. The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.

F. INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.

A. The WHEN MATCHED clause can be used to specify the updates to be performed.

B. The WHEN MATCHED clause can be used to specify the inserts to be performed.

C. The WHEN NOT MATCHED clause can be used to specify the deletions to be performed.

D. The WHEN NOT MATCHED clause can be used to specify the updates to be performed.

E. The WHEN NOT MATCHED clause can be used to specify the inserts to be performed.

A. SELECT join _ date FROM employees WHERE join date > *10-02-2018';

B. SELECT join_ date + '20' EROM employees;

C. SELECT join_ date||''|| salary FROM employees;

D. SELECT salary + '120.50' FROM employees;

E. SELECT SUBSTR(join date, 1, 2) - 10 FROM employees;

A. GRANT UPDATE ON scott. emp TO fin manager;

B. SELECT * FROM user_ tab._ privs;

C. DELETE FROM scott. emp;

D. AITER SESSION set NLs. _DATE FORMAT = 'DD/MM/YYYY';

E. TRUNCATE TABLE emp:

A. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount+100 DUES FROM transactions;

B. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount+100 "DUES" from transactions;

C. SELECT customer_id AS 'CUSTOMER-ID',transaction_date AS DATE, amount+100 'DUES' from transactions;

D. SELECT customer id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount+100 "DUES AMOUNT" FROM transactions;

E. SELECT customer_id CUSTID, transaction_date TRANS_DATE,amount+100 DUES FROM transactions;

A. A GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view.

B. A GLOBAL TEMPORARY TABLE can have only one index.

C. A GLOBAL TEMPORARY TABLE cannot have PUBLIC SYNONYM.

D. Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.

E. A GLOBAL TEMPORARY TABLE can have multiple indexes

F. A trigger can be created on a GLOBAL TEMPORARY TABLE

A. INSERT INTO rate_list VALUES (0.551) inserts the value as .55.

B. INSERT INTO rate_list VALUES (-99.99) inserts the value as 99.99.

C. INSERT INTO rate_list VALUES (0.999) produces an error.

D. INSERT INTO rate_list VALUES (-.9) inserts the value as -.9.

E. INSERT INTO rate_list VALUES (87654. 556) inserts the value as 87654.6.

F. INSERT INTO rate_list VALUES (-10) produces an error.

A. 

B. 

C. 

D. 

A. WHERE order_date IN (TO_DATE ('Oct 21 2018','MON DD YYYY'), TO_CHAR('Nov 21 2018','MON DD YYYY'));

B. WHERE order_date> TO_DATE('JUL 10 2018','MON DD YYYY');

C. WHERE TO_CHAR(order_date,'MON DD YYYY') ='JAN 20 2019';

D. WHERE ordet_date> TO_CHAR(ADD_MONTHS(SYSDATE, 6),'MON DD YYYY')

E. WHERE order_date> TO_DATE(ADD_MONTHS(SYSDATE,6),'MON DD YYYY');

A. Creating an external table creates a dump file that can be used by an external table in the same or a different database.

B. Creating an external table creates a directory object.

C. Creating an external table creates a dump file that can be used only by an external table in the same database.

D. When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.

E. When creating an external table, data can be selected only from a table whose rows are stored in database blocks.

A. Views with the prefix dba_ display only metadata for objects in the SYS schema.

B. The data dictionary does not store metadata in tables.

C. The data dictionary is accessible when the database is closed.

D. Views with the prefix all_, dba_ and useb_ are not all available for every type of metadata.

E. Views with the prefix all_ display metadata for objects to which the current user has access.

A. It best supports relational databases

B. It provides independence for logical data structures being manipulated from the underlying physical data storage

C. It is used to define encapsulation and polymorphism for a relational table

D. It requires that data be contained in hierarchical data storage

E. It guarantees atomicity, consistency, isolation, and durability (ACID) features

F. It is the only language that can be used for both relational and object-oriented databases