1Z1-051試験無料問題集「Oracle Database: SQL Fundamentals I 認定」

A. It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.

B. It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.

C. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.

D. The set of statements contains an error and does not work.

E. It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.

F. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.

A. It executes successfully but returns no result.

B. It executes successfully and returns the required result.

C. It generates an error because the condition specified for the PROD_CATEGORY column is not valid.

D. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.

A. SELECT student_id, gpa FROM student_grades ORDER BY gpa;

B. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;

C. SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;

D. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;

E. SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;

F. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;

A. It can have a maximum of five expressions in a list.

B. It returns the highest NOT NULL value in the list for all rows.

C. It requires that all expressions in the list must be of the same data type.

D. It requires that at least one of the expressions in the list must have a NOT NULL value.

A. A sub query can retrieve zero or more rows.

B. A sub query should retrieve only one row.

C. When a sub query is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the sub query should contain only one column.

D. A sub query CANNOT be used in an SQL query statement that uses group functions.

E. Sub queries CANNOT be nested by more than two levels.

F. A sub query can be used only in SQL query statements.

A. WHERE (promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%')OR promo_cost > 20000 OR promo_end_date > '1-JAN-01'

B. WHERE promo_name NOT LIKE 'T%' AND promo_name NOT LIKE 'N%' AND promo_cost > 20000 AND promo_end_date > '1-JAN-01'

C. WHERE promo_name NOT LIKE 'T%' OR promo_name NOT LIKE 'N%' AND promo_cost > 20000 AND promo_end_date > '1-JAN-01'

D. WHERE (promo_name NOT LIKE '%T%' OR promo_name NOT LIKE '%N%') AND(promo_cost > 20000 AND promo_end_date > '1-JAN-01')

A. It produces an error because the data types are not matching.

B. It executes successfully and introduces an 's at the end of each promo_name in the output.

C. It executes successfully and displays the literal" {'s start date was} " for each row in theoutput.

D. It produces an error because flower braces have been used.

A. All data in the table is deleted, and the table structure is also deleted.

B. All data in the table is deleted, but the structure of the table is retained.

C. All pending transactions are committed.

D. All indexes based on the DEPT table are dropped.

E. You cannot roll back this statement.

F. Allviews based on the DEPT table are deleted.

G. All synonyms based on the DEPT table are deleted.

A. SELECT inv_no,NVL2(inv_date,'Pending','Incomplete') FROM invoice;

B. SELECT inv_no,NVL2(inv_amt,inv_amt*.25,'Not Available') FROM invoice;

C. SELECT inv_no,NVL2(inv_date,sysdate-inv_date,sysdate) FROM invoice;

D. SELECT inv_no,NVL2(inv_amt,inv_date,'Not Available') FROM invoice;

A. SELECT DISTINCT cust_income_level ' ' cust_credit_limit * 0.50 AS "50% Credit Limit"
FROM customers;

B. SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit
Limit"
FROM customers;

C. SELECT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit"
FROM customers;

D. SELECT cust_income_level ' ' cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers;

A. CHECK

B. PRIMARY KEY

C. UNIQUE

D. CASCADE

E. CONSTANT

F. NONUNIQUE

G. NOT NULL

A. CREATE INDEX ord_idx2
ON ord_items(ord_no);

B. CREATE INDEX ord_idx3
ON ord_items(item_no);

C. CREATE INDEX ord_idx4
ON ord,ord_items(ord_no, ord_date,qty);

D. CREATE INDEX ord_idx1
ON ord(ord_no);

A. It produces an error because the condition on the CUST_FIRST_NAME column is not valid.

B. It produces an error because conditions on the CUST_CREDIT_LIMIT column are not valid.

C. It executes successfully.

D. It produces an error because the condition on the CUST_CITY column is not valid.

A. SELECT TO_CHAR(TO_NUMBER(prod_price)* .25.'$99.999.00') FROM PRICE_LIST;

B. SELECT TO_CRAR(TO_NUMBER(prod_price.'S99.999.99')* .25.'$99.999.00') FROM PRICE_LIST:

C. SELECT TO_NUMBER(TO_NUMBER(prod_price.,$99.999.99')* .25/$99.999.00') FROM PRICE_LIST:

D. SELECT TO_CHAR(prod_price* .25.'$99.999.99') FROM PRICEJLIST:

A. It executes successfully and gives the correct result.

B. It generates an error because a subquery cannot have a join condition in an UPDATE statement.

C. It generates an error because multiple columns (SALARY, COMMISION) cannot be specified together in an UPDATE statement.

D. It executes successfully but does not give the correct result.

A. When the MAXVALUE limit for a sequence isreached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement

B. DELETE would remove a sequence from the database

C. When a database instance shuts down abnormally, the sequence numbers that have been cached but not used would be available once again when the database instance is restarted

D. The numbers generated by a sequence can be used only for one table

E. CURRVAL is used to refer to the last sequence number that has been generated