최신 1z0-071 무료덤프 - Oracle Database SQL

A. A user can be the owner of multiple schemas In the same database.

B. When you execute an UPDATE statement, the database instance locks each updated row.

C. The database guarantees read consistency at select level on user-created tablers.

D. Updates performed by a database user can be rolled back by another user by using the ROLLBACK command.

E. A query can access only tables within the same schema.

A. Foreign key columns allow null values.

B. Every primary or unique key value must refer to a matching foreign key value.

C. Primary key columns allow null values.

D. Unique key columns allow null values

E. Every foreign key value must refer to a matching primary or unique key value.

A. The DEPARTMENT_ID column can be recovered from the recycle bin

B. The DEPARTMENT_ID column is set to null for all tows in the table

C. A new column with the name DEPARTMENT_ID can be added to the EMPLOYEES table.

D. A query can display data from the DEPARTMENT_ID column.

E. No updates can be made to the data in the DEPARTMENT_ID column.

F. The storage space occupied by the DEPARTMENT_ID column is released only after a COMMIT is issued.

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

B. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in USER_TABLES.

C. All users can query DBA_TABLES successfully.

D. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in ALL_TABLES.

E. You must have ANY TABLE system privileges, or be granted object privilges on the table, to viewa tabl e in DBA TABLES.

F. ALL TABLES displays all tables owned by the current user.

A. It must be an equijoin.

B. It can be an inner join.

C. The join key column must have an index.

D. It can be a left outer join.

E. It must be a full outer join.

A. SALES1 created with no rows.

B. SALES1 created with 55, 000 rows

C. SALES1 created with 1 row.

D. SALES1 has NOT NULL constraints on any I selected columns which had those constraints I in the SALES table.

E. SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.

A. All the dynamic performance views prefixed with V$ are accessible to all the database users.

B. The USER OBJECTS view can provide information about the tables and views created by the user only.

C. The user SYSTEM owns all the base tables and user-accessible views of the data dictionary.

D. DICTIONARY is a view that contains the names of all the data dictionary views that the user can access.

E. The USER SYNONYMS view can provide information about private synonyms.

A. invoice_date> '01-02-2019': uses implicit conversion

B. CONCAT(qty_sold, invoice_date): requires explicit conversion

C. qty_sold ='05549821 ': requires explicit conversion

D. qty_sold BETWEEN '101' AND '110': uses implicit conversion

E. invoice_date = '15-march-2019': uses implicit conversion

A. SELECT last_ name (monthly_ salary+ monthly_ commission _ pct) *12 AS annual_ FROM employees ;

B. SELECT last name, (monthly_ salary *12) + (monthly_ salary * 12 * NVL (monthly commission pct,0) ) As annual _ comp FROM employees;

C. SELECT last_ name, monthly_ salary*12) + (monthly_ salary * 12 * Monthly commission _Pct) AS annual_ comp FROM employees;

D. SELECT last name,
(monthly salary*12) + (monthly_commission_pct * 12) AS
annual comp
FROM employees
;

A. The foreign key constraint will be disabled.

B. The primary key constraint will be enabled and IMMEDIATE.

C. The foreign key constraint will be enabled and IMMEDIATE.

D. The primary key constraint will be enabled and DEFERRED.

E. The foreign key constraint will be enabled and DEFERRED.

A. SELECT AVG(MAX(salary)) FROM employees GROUP BY salary;

B. SELECT dept id, MAX (SUM(salary)) FROM employees GROUP BY dept_id;

C. SELECT dept_ id, AVG(MAX(salary)) FROM employees GROUP BY dept_id, salary;

D. SELECT dept_ iD, sum(salary) FROM employees WHERE hire_date > '01-JAN-9' GROUP BY dept_id;

E. SELECT dept_ id, AVG (MAX(salary)) FROM employees GROUP By dept_id HAVING hire_date> ' O1-JAN-19';

A. 11-JUL-2019 11,00,00,000000AM -05:00

B. 11-JUL-2019 6,00,00,000000 AM

C. 11-JUL-2019 11,00,00,00000000 AM

D. 11-JUL-2019 6,00,00,00000000 AM - 05:00

A.

B.

C.

D.

E.

A. Views can be indexed.

B. Theethi CHEcK clause prevents certalin rows from being updated or inserted in the underying table through the view.

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

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

E. The wITH CHECK clause prevents certain rows from being displayed when querying the view.

A. SELECT TO_CHAR (ADD_MONTHS (SYSDATE, 6), 'dd-mon-yyyy') FROM DUAL;

B. SELECT TO_DATE (SYSDATE, 'RRRR-MM-DD') FROM DUAL;

C. SELECT TO_CHAR (SYSDATE, 'MM/DD/YYYY') FROM DUAL;

D. SELECT TO_DATE(TO_CHAR(SYSDATE,'MM/DD/YYYY'),'MM/DD/YYYY') FROM DUAL;

E. SELECT TO_DATE (ADD_MONTHS(SYSDATE,6), 'dd-mon-yyyy') FROM DUAL;

F. SELECT TO_CHAR (ADD_MONTHS (SYSDATE,6)) FROM DUAL;

A. The same table name can be used for tables in different schemas.

B. A primary key constraint is manadatory.

C. Creating an external table will automatically create a file using the specified directory and file name.

D. A system privilege is required.

E. A create table statement can specify the maximum number of rows the table will contain.