최신Oracle Database: SQL Fundamentals I - 1Z1-051무료샘플문제

A. CREATE ROLE manager;
GRANT create table, create view
TO manager;
GRANT manager TO BLAKE,CLARK;

B. GRANT manager ROLE TO BLAKE,CLARK;
GRANT create table, create voew
TO BLAKE CLARK;
***MISSING***

C. CREATE ROLE manager;
GRANT create table, create voew
TO manager;
GRANT manager ROLE TO BLAKE,CLARK;

A. When you update a view the constraints on the views always override the constraints on theunderlying tables.

B. When you update a view group functions are automatically computed.

C. When you update a view only the constraints on the underlying table will be in effect.

D. You cannot update a view with group functions.

A. SELECT promo_name, promo_begin_date FROM promotions WHERE promo_begiii_date > '01-JAN-01' ORDER BY 2 DESC; B. SELECT promo_name. promo_begiii_date FROM promotions WHERE promo_begin_date > '01-JAN-01' ORDER BY promo_name DESC:

B. SELECT promo_name, promo_begin_date "START DATE" FROM promotions WHERE promo_begin_date > '01-JAN-01' ORDER BY "START DATE" DESC;

C. SELECT promo_name. promo_begin_date FROM promotions WHERE promo_begin_date > '01-JAN-01' ORDER BY 1DESC:

A. integer

B. calendar

C. conversion

D. numeric

E. date

F. string

G. translation

H. character

A. It generates an error because fm and double quotation marks should not be used in the format string.

B. It generates an error because rrrr should be replaced by rr in the format string.

C. It executes successfully but does not return the correct result.

D. It executes successfully and returns the correct result.

E. It generates an error because TO_CHAR should be replaced with TO_DATE.

A. the WHERE clause in SELECT as well as all DML statements

B. field names in the SELECT statement

C. the HAVING clause in the SELECT statement

D. the GROUP BY clause in the SELECT statement

E. the WHERE clause in only the SELECT statement

F. the FROM clause in the SELECT statement

A. SELECTstudent_id, marks, ROWID "Rank"
FROMstudents
WHEREROWID <= 10
ANDfinish_date BETWEEN '01-JAN-99' AND '31-DEC-99'
ANDcourse_id = 'INT_SQL'
ORDER BYmarks;

B. SELECTstudent_id, marks, ROWNUM "Rank"
FROM(SELECT student_id, marks
FROMstudents
WHEREROWNUM <= 10
ANDfinish_date BETWEEN '01-JAN-99' AND '31-DEC-
99'
ANDcourse_id = 'INT_SQL'
ORDER BYmarks DESC);

C. SELECTstudent_ id, marks, ROWNUM "Rank"
FROMstudents
WHEREROWNUM <= 10
ANDfinish_date BETWEEN '01-JAN-99' AND '31-DEC-99
ANDcourse_id = 'INT_SQL'
ORDER BYmarks DESC;

D. SELECTstudent_id, marks, ROWNUM "Rank"
FROM(SELECT student_id, marks
FROMstudents
WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99'
AND course_id = 'INT_SQL'
ORDER BY marks DESC)
WHEREROWNUM <= 10 ;

E. SELECTstudent id, marks, ROWNUM "Rank"
FROM(SELECT student_id, marks
FROM students
ORDER BY marks)
WHEREROWNUM <= 10
ANDfinish date BETWEEN '01-JAN-99' AND '31-DEC-99'
ANDcourse_id = 'INT_SQL';

A. It executes successfully.

B. It executes successfully only if the CUST_CREDIT_LIMIT column does not contain any null values.

C. It produces an error because the AND operator cannot be used to combine multiple BETWEEN clauses.

D. It produces an error because the condition on CUST_LAST_NAME is invalid.

A. You cannot have two constraints on one column

B. You cannot add a primary key constraint if data exists in the column

C. The primary key constraint can be created only a the time of table creation

D. You can add the primary key constraint even if data exists, provided that there are no duplicate values

A. Once created, a sequence belongs to a specific schema.

B. Once created, a sequence is automatically available to all users.

C. Once created, a sequence is linked to a specific table.

D. Only the DBA can control which sequence is used by a certain table.

E. Once created, a sequence is automatically used in all INSERT and UPDATE statements.

A. The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required

B. The default internal storage of dates is in the character format

C. The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century

D. The default internal storage of dates is in the numeric format

A. A MERGE statement is used to merge the data of one table with data from another.

B. A MERGE statement can be used to update existing rows in a table.

C. A MERGE statement replaces the data of one table with that of another.

D. A MERGE statement can be used to insert new rows into a table.