Exam information

Exam 1Z0-051: Oracle Database 11g: SQL Fundamentals I (updated April 20th, 2016)

Other exams

Which three are true about the SQL statement?

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

Which statement creates the foreign key?

You need to design a student registration database that contains several tables storingacademic information. The STUDENTS table stores information about a student. TheSTUDENT_GRADES table stores information about the student’s grades. Both of the tableshave a column named STUDENT_ID. The […]

Which three SQL statements would execute successfully?

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

Which two SQL statements would executes successfully?

See the Exhibit and examine the structure and data in the INVOICE table: Exhibit: Whichtwo SQL statements would executes successfully? (Choose two.)

Which three statements are true regarding sub queries?

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

Which SQL statement would produce the required result?

See the Exhibit and examine the structure of the CUSTOMERS table: Using theCUSTOMERS table, you need to generate a report that shown the average credit limit forcustomers in WASHINGTON and NEW YORK. Which SQL statement would produce therequired result?

What is true about them?

Evaluate these two SQL statements: SELECT last_name, salary, hire_date FROMEMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROMEMPLOYEES ORDER BY 2 DESC; What is true about them?

Where can sub queries be used?

Where can sub queries be used? (Choose all that apply)

Which three SQL statements would display the value 1890.55 as $1,890.55?

Which three SQL statements would display the value 1890.55 as $1,890.55? (Choosethree.)

Which statement is true regarding the outcome of the above query?

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

Page 1 of 2512345...1020...Last »