Exam information

Exam 1Z0-051: Oracle Database 11g: SQL Fundamentals I (May 21th, 2013)

Other exams

Which three are true about the SQL statement?

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

Which statement creates the foreign key?

You need to design a student registration database that contains several tables storing academicinformation.The STUDENTS table stores information about a student. The STUDENT_GRADES table storesinformation about the student’s grades. Both of the tables have a column named STUDENT_ID.The […]


Which three SQL statements would execute successfully?

Here is the structure and data of the CUST_TRANS table: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 two SQL statements would executes successfully?

See the Exhibit and examine the structure and data in the INVOICE table:Which two 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 the CUSTOMERS table, you need to generate a report that shown the average credit limitfor customers in WASHINGTON and NEW YORK.Which SQL statement would produce the required result?

What is true about them?

Evaluate these two SQL statements:SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES 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? (Choose three.)

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

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

Page 1 of 2912345...1020...Last »