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

A. It will remove all synonyms for the DEPARTMENTS table.

B. It will delete all rows from the DEPARTMENTS table, but retain the empty table.

C. It will remove all views that are based on the DEPARTMENTS table.

D. It will remove the DE PARTMENTS table from the database.

E. It will drop all indexes on the DEPARTMENTS table.

F. Neither can it be rolled back nor can the DEPARTMENTS table be recovered.

A. The owner of an object acquires all object privilege on that object by default.

B. An object privilege can be granted to a role only by the owner of that object.

C. An object privilege can be granted to other users only by the owner of object.

D. The WITH GRANT OPTION clause can be used only by DBA users.

E. A table owner must grant the references privilege to allow other users to create FOREIGN KEY constraints using that table.

A.

B.

C.

D.

A. The data dictionary is constantly updated to reflect changes to database objects, permissions, and data.

B. All users have permissions to access all information in the data dictionary by default

C. Base tables in the data dictionary have the prefix DBA_.

D. The SYS user owns all base tables and user-accessible views in the data dictionary.

E. All user actions are recorded in the data dictionary.

A. SELECT *
FROM employees e
JOIN departments d
ON e.department_id=d.department_id
AND d.department_id=90;

B. SELECT *
FROM employees e
JOIN departments d
ON e.department_id=d.department_id
WHERE d.department_id=90;

C. SELECT *
FROM employees e
JOIN department d
WHERE e.department_id=d.department_id
AND d.department_id=90;

D. SELECT *
FROM employees e
JOIN departments d
ON d.departments_id=90
WHERE e.department_id=d.department_id;

A. They can be indexed.

B. They can be referenced In the where clause of an update or debete statement.

C. They can be referenced in the set clause of an update statement as the name of the column To be updated.

D. They cannot have a data type explicitly specified.

E. They can be referenced in the column expression of another virtxial column.

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

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

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

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

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

A. TIMESTAMP WITH LOCAL TIMEZONE

B. TIMESTAMP WITH TIMEZONE

C. TIMESTAMP

D. INTERVAL DAY TO SECOND

E. INTERVAL YEAR TO MONTH

A. GRANT UPDATE ON customers.title, customers.address TO andrew WITH ADMIN OPTION;

B. GRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION:

C. GRANT UPDATE ON customers. title, customers.address TO andrew;

D. GRANT UPDATE (title, address) ON customers TO andrew WITH ADMIN OPTION;

E. GRANT UPDATE (title, address) ON customers TO andrew;

F. GRANT UPDATE ON customers. title, customers.address TO andrew WITH GRANT OPTION;

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

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

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

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

E. Constraints are enforced only during INSERT operations.

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. INSERT INTO rate_list VALUES (0.551) inserts the value as .55.

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

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

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

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

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

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.