Create Next App

Exam contains 339 questions

Page 13 of 57

Question 73 🔥

Which two statements are true regarding single row functions?

Which database solution meets these requirements?

A. MOD: returns the quotient of a division

Highly voted

B. TRUNC: can be used with number and date values

Highly voted

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

Highly voted

D. SYSDATE: returns the database server current date and time

Highly voted

E. INSTR: can be used to find only the first occurrence of a character in a string

Highly voted

F. TRIM: can be used to remove all the occurrences of a character from a string

Highly voted

Discussion of the question

Question 74 🔥

Which two statements are true regarding the count function?

Which database solution meets these requirements?

A. The count function can be used only for CHAR, VARCHAR2, and NUMBER data types.

Highly voted

B. Count (*) returns the number of rows including duplicate rows and rows containing null value in any of the columns.

Highly voted

C. Count (cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column.

Highly voted

D. Count (distinct inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column.

Highly voted

E. A select statement using the COUNT function with a DISTINCT keyword cannot have a where clause.

Highly voted

Discussion of the question

Question 75 🔥

Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? (Choose three.)

Which database solution meets these requirements?

A. It releases the storage space used by the table.

Highly voted

B. It does not release the storage space used by the table.

Highly voted

C. You can roll back the deletion of rows after the statement executes.

Highly voted

D. You can NOT roll back the deletion of rows after the statement executes.

Highly voted

E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

Highly voted

F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

Highly voted

Discussion of the question

Question 76 🔥

You need to design a student registration database that contains several tables storing academic information.The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key.You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table.Which statement creates the foreign key?

Which database solution meets these requirements?

A. CREATE TABLE student_grades (student_id NUMBER(12), semester_end DATE, gpa NUMBER(4, 3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY students(student_id));

Highly voted

B. CREATE TABLE student_grades(student_id NUMBER(12), semester_end DATE, gpa NUMBER(4, 3), student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id));

Highly voted

C. CREATE TABLE student_grades(student_id NUMBER(12), semester_end DATE, gpa NUMBER(4, 3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES students(student_id));

Highly voted

D. CREATE TABLE student_grades(student_id NUMBER(12), semester_end DATE, gpa NUMBER(4, 3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id));

Highly voted

Discussion of the question

Question 77 🔥

Here is the structure and data of the CUST_TRANS table:Exhibit:Dates are stored in the default date format dd-mm-rr in the CUST_TRANS table.Which three SQL statements would execute successfully? (Choose three.)

Which database solution meets these requirements?

A. SELECT transdate + '10' FROM cust_trans;

Highly voted

B. SELECT * FROM cust_trans WHERE transdate = '01-01-07';

Highly voted

C. SELECT transamt FROM cust_trans WHERE custno > '11';

Highly voted

D. SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';

Highly voted

E. SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000;

Highly voted

Discussion of the question

Question 78 🔥

Evaluate the following SQL statement:Which statement is true regarding the outcome of the above query?

Which database solution meets these requirements?

A. It executes successfully and displays rows in the descending order of PROMO_CATEGORY.

Highly voted

B. It produces an error because positional notation cannot be used in the order by clause with set operators.

Highly voted

C. It executes successfully but ignores the order by clause because it is not located at the end of the compound statement.

Highly voted

D. It produces an error because the order by clause should appear only at the end of a compound query-that is, with the last select statement.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_061

Exam contains 339 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us