Download Oracle Database 11g SQL Fundamentals I.1z0-051.PracticeDumps.2018-01-09.290q.tqb

Vendor:	Oracle
Exam Code:	1z0-051
Exam Name:	Oracle Database 11g SQL Fundamentals I
Date:	Jan 09, 2018
File Size:	16 MB

Download Exam

How to open TQB files?

Files with TQB (Taurus Question Bank) extension can be opened by Taurus Exam Studio.

Download
Taurus Exam Studio

Purchase
Coupon: TAURUSSIM_20OFF

Discount: 20%

Demo Questions

Evaluate the SQL statement:

TRUNCATE TABLE DEPT;

Which three are true about the SQL statement? (Choose three.)

It releases the storage space used by the table.
It does not release the storage space used by the table.
You can roll back the deletion of rows after the statement executes.
You can NOT roll back the deletion of rows after the statement executes.
An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

Correct answer: ADF

Explanation:

A: The TRUNCATE TABLE Statement releases storage space used by the table,D: Can not rollback the deletion of rows after the statement executes,F: You must be the owner of the table or have DELETE ANY TABLE system privilege to truncate the DEPT table. Incorrect answer:Cis not true Dis not true Eis not true Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 8-18

A: The TRUNCATE TABLE Statement releases storage space used by the table,

D: Can not rollback the deletion of rows after the statement executes,

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

Incorrect answer:

Cis not true

Dis not true

Eis not true

Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 8-18

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?

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));
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));
CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3),
CONSTRAINT FOREIGN KEY (student_id) REFERENCES students(student_id));
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));

Correct answer: D

Explanation:

CONSTRAINT name FOREIGN KEY (column_name) REFERENCES table_name (column_name); Incorrect answer:Ainvalid syntax Binvalid syntax Cinvalid syntax Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 10-14

CONSTRAINT name FOREIGN KEY (column_name) REFERENCES table_name (column_name);

Incorrect answer:

Ainvalid syntax

Binvalid syntax

Cinvalid syntax

Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 10-14

Here is the structure and data of the CUST_TRANS table:

Exhibit:

CUST_TRANS

Name Null? Type

-------------- ----------------- ------------------

CUSTNO NOT NULL CHAR (2)

TRANSDATE DATE

TRANSAMT NUMBER (6, 2)

CUSTNO TRANSDATE TRANSAMT

------------- ----------------------- -----------------------

11 01-JAN-07 1000

22 01-FEB-07 2000

33 01-MAR-07 3000

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

SELECT transdate + '10' FROM cust_trans;
SELECT * FROM cust_trans WHERE transdate = '01-01-07';
SELECT transamt FROM cust_trans WHERE custno > '11';
SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';
SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000;

Correct answer: ACD

See the Exhibit and examine the structure and data in the INVOICE table:

Exhibit:

Which two SQL statements would executes successfully? (Choose two.)

SELECT MAX(inv_date),MIN(cust_id) FROM invoice;
SELECT MAX(AVG(SYSDATE - inv_date)) FROM invoice;
SELECT (AVG(inv_date) FROM invoice;
SELECT AVG(inv_date - SYSDATE),AVG(inv_amt) FROM invoice;

Correct answer: AD

Which three statements are true regarding sub queries? (Choose three.)

Multiple columns or expressions can be compared between the main query and sub query
Main query and sub query can get data from different tables
Sub queries can contain GROUP BY and ORDER BY clauses
Main query and sub query must get data from the same tables
Sub queries can contain ORDER BY but not the GROUP BY clause
Only one column or expression can be compared between the main query and subqeury