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

A. The default length for a CHAR column is always one character

B. A BLOB stores unstructured binary data within the database

C. A BFILE stores unstructured binary data in operating systerm files

D. A VARCHAR2 blank pads column values only if the data stored is non numeric and contains no special characlers

E. A CHAR column definition does not require the length to be specified

F. A VARCHAR2 column definition does not require the length to be specified

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

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

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

D. MOD: returns the quotient of a division operation

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

A. A CHECK Constraint can refer to values in other rows.

B. A PRIMARY KEY Constraint can be added after a table has been created and populated.

C. A UNIQUE Constraint can use a pre-existing index on the constrained column or columns.

D. A FOREIGN KEY Column can contain NULLS.

E. A UNIQUE constraint permits NULLS.

F. A NOT NULL Constraint can be defined at the table level.

G. A Column can have only one CHECK Constraint.

A. sorted by DEPARTMENT_NAME

B. sorted by AVGSAL

C. sorted by DEPARTMENT_NAME and MAXSAL

D. Sorted by MAXSAL

E. sorted by DEPARTMENT_NAME and AVGSAL

A. CREATE GLOBAL SYNONYM emp FOR hcm.employee_records;

B. CREATE SYNONYM PUBLIC.emp FOR hcm.employee_records;

C. CREATE PUBLIC SYNONYM emp FOR hcm. employee_records;

D. CREATE SYNONYM SYS.emp FOR hcm.employee_records;

E. CREATE SYNONYM emp FOR hcm.employee_records;

A. The WHERE clause can be used to exclude rows before dividing them into groups.

B. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns.

C. The WHERE clause can be used to exclude rows after dividing them into groups

D. The HAVING clause can be used with aggregating functions in subqueries.

E. Aggregating functions and columns used in HAVING clauses must be specified in these SELECT list of a query.

A. It can never be used with a full outer join.

B. It is used to specify an explicit join condition involving operators.

C. All column names in a USING clause must be qualified with a table name or table alias.

D. It can never be used with onatural join.

E. It is used to specify an equijoin of columns that have the same name in both tables.

A. An error

B. 1 ROW

C. 2 rows

D. 0 rows

A. All users can query DBA TABLES successfully.

B. USER_ TABLES displays all tables owned by the current user.

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

D. You must have SELECT privileges on a table to view it in ALL _TABLES.

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. SELECT last _ NAME (monthly_ salary + monthly _commission _ pct) * 12 AS annual_ comp FROM employees;

B. SELECT last _ name, (monthly_ salary * 12) + (monthly_ salary * 12 * NVL (monthly_ commission _pct, 0)) AS annual _comp

C. SELECT last _ name, (monthly _ salary * 12) + (monthly_ commission _ pct * 12) AS FROM employees:

D. select last _ name, (monthly_ salary * 12) + (monthly_ salary * 12 *monthly_ commission_ pct) AS annual_ camp FROM employees

A. A user has all object privileges for every object in their schema by default.

B. PUBLIC can be revoked from a user.

C. System privileges always set privileges for an entire database.

D. All roles are owned by the SYS schema.

E. A role can contain a combination of several privileges and roles.

F. PUBLIC acts as a default role granted to every user in a database

G. A role is owned by the user who created it.

A. MERGE INTO employees e
USING new employees ne
ON (e.employee_id = ne.employee_id)
WHEN FOUND THEN
UPDATE SET e.name =ne.name, e.job_id=ne.job_id, e.salary =ne.salary
WHEN NOT FOUND THEN
INSERT VALUES (ne.employee_id,ne.name,ne.job_id,ne.salary) ;

B. MERGE INTO employees e
USING new employees ne
WHERE e.employee_id = ne.employee_ id
WHEN MATCHED THEN
UPDATE SET e.name = ne.name, e.job_id = ne.job_id,e.salary =ne. salary
WHEN NOT MATCHED THEN
INSERT VALUES (ne. employee_id,ne.name, ne.job_id,ne.salary) ;

C. MERGE INTO employees e
USING new_employees n
WHERE e.employee_id = ne.employee_id
WHEN FOUND THEN
UPDATE SET e.name=ne.name,e.job_id =ne.job_id, e.salary=ne.salary
WHEN NOT FOUND THEN
INSERT VALUES (ne.employee_ id,ne.name,ne.job id,ne.salary) ;

D. MERGE INTO employees e
USING new_employees n
ON (e.employee_id = ne.employee_id)
WHEN MATCHED THEN
UPDATE SET e.name = ne.name, e.job id = ne.job_id,e.salary =ne. salary
WHEN NOT MATCHED THEN
INSERT VALUES (ne. employee_id,ne.name,ne.job_id,ne.salary);

A. DROP TABLE products

B. CREATE INDEX price_idx on products (price);

C. TRUNCATE TABLE products;

D. ALTER TAELE products DROP COLUMN expiry_date;

E. ALTER TABLE products SET UNUSED(expiry_date);

F. ALTER TABLE products DROP UNUSED COLUMNS

A. Statement 2 may return multiple rows of output.

B. Both the statement given the same output.

C. Statement 2 returns only one row of output.

D. Statement 1 returns only one row of output.

E. Both statements will return NULL if either UNIT PRICE or QUANTITY contains NULL,