最新的Oracle Database 12c: SQL Fundamentals - 1z0-061免費考試真題

A. If a NONUNIQUE index already exists on the column, a UNIQUE index will be created implicitly.

B. If any index exists on the column, there will be an error as Oracle attempts to create another index implicitly.

C. If a UNIQUE index already exists on the column, it will be used.

D. If a NONUNIQUE index already exists it will be used.

A. You can use aggregate functions on a table, only by grouping the whole table as one single group.

B. You can pass column names, expressions, constants, or functions as parameter to an aggregate function.

C. You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.

D. You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.

E. You cannot group the rows of a table by more than one column while using aggregate functions.

F. You can use aggregate functions in any clause of a SELECT statement.

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

B. DELETE <sequencename> would remove a sequence from the database

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

D. 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

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

A. SELECT promo_name, promo_begin_date FROM promotionsWHERE
promo_begin_date > ALL (SELECT promo_begin_dateFROM promotionsWHERE
promo_category = 'INTERNET');

B. SELECT promo_name, promo_begin_date FROM promotionsWHERE
promo_begin_date IN (SELECT promo_begin_dateFROM promotionsWHERE
promo_category='INTERNET');

C. SELECT promo_name, promo_begin_date FROM promotionsWHERE
promo_begin_date > ANY (SELECT promo_begin_dateFROM promotionsWHERE
promo_category = 'INTERNET');

D. SELECT promo_name, promo_begin_date FROM promotionsWHERE
promo_begin_date > ALL (SELECT MAX(promo_begin_date) FROM promotions
)ANDpromo_category = 'INTERNET';

A. The second statement will fail because an object S1 already exists.

B. The third statement will show the contents of the table S1, if such a table exists in the current schema.

C. The third statement will show the contents of EMPLOYEES.

D. The third statement will show the contents of DEPARTMENTS.

A. ORDER BY prod_list_price DESC, prod_name DESC;

B. ORDER BY prod_name DESC, prod_list_price DESC;

C. ORDER BY (2*prod_min_price)DESC, prod_name;

D. ORDER BY prod_name, (2*prod_min_price)DESC;

E. ORDER BY prod_list_price DESC, prod_name;

A. inv_date > '01-02-2008': uses implicit conversion

B. CONCAT (inv_amt, inv_date): requires explicit conversion

C. inv_no BETWEEN '101' AND '110': uses implicit conversion

D. inv_date = '15-february-2008': uses implicit conversion

E. inv_amt ='0255982': requires explicit conversion

A. The CUST_STATUS column would store exactly one character.

B. The CUST_STATUS column would give an error.

C. The TRANS_VALIDITY column would have a maximum size of one character.

D. The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds

E. The CUST_CREDIT_LIMIT column would not be able to store decimal values.

F. The TRANS_VALIDITY column would give an error.

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. SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;

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

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

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

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

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

A. Constraints can be created after the table is created.

B. Constraint names must start with SYS_C.

C. All constraints must be defined at the column level.

D. Constraints can be created at the same time the table is created.

E. Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.

A. SELECT * FROM custjrans WHERE transdate='01-JANUARY-07':

B. SELECT * FROM custjrans WHERE transdate = '01-01-07':

C. SELECT transamt FROM custjrans WHERE custno > '11':

D. SELECT custno - 'A' FROM custjrans WHERE transamt > 2000:

E. SELECT transdate + '10' FROM custjrans;

A. NOT NULL

B. UNIQUE

C. CASCADE

D. CONSTANT

E. PRIMARY KEY

F. CHECK

G. NONUNIQUE

A. INSERT INTO employees (employee_id, first_name, last_name, hire_date)VALUES (
1 000, 'John', 'Smith', '01/01/01');

B. INSERT INTO employees(employee_id, first_name, last_name, hire_date)VALUES (
1 000, 'John', 'Smith', 01-Jan-01);

C. INSERT INTO employees(employee_id, first_name, last_name, hire_date)VALUES (
1 000, 'John', 'Smith', '01 January 01');

D. INSERT INTO employees(employee_id, first_name, last_name, Hire_date)VALUES (
1 000, 'John', 'Smith', To_date('01/01/01'));