GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

1Z0-061

lomasdelicioso 10 questions

Take the quiz

Questions in this quiz (10)

  1. 1Retrieving Data Using the SQL SELECT Statement
    1. AList the capabilities of SQL SELECT statements
    2. BExecute a basic SELECT statement
  2. 2Restricting and Sorting Data
    1. ALimit the rows that are retrieved by a query
    2. BSort the rows that are retrieved by a query
    3. CUse ampersand substitution to restrict and sort output at runtime
  3. 3Using Single-Row Functions to Customize Output
    1. ADescribe various types of functions available in SQL
    2. BUse character, number, and date functions in SELECT statements
  4. 4Using Conversion Functions and Conditional Expressions
    1. ADescribe various types of conversion functions that are available in SQL
    2. BUse the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
    3. CApply conditional expressions in a SELECT statement
  5. 5Reporting Aggregated Data Using the Group Functions
    1. AIdentify the available group functions
    2. BDescribe the use of group functions
    3. CGroup data by using the GROUP BY clause
    4. DInclude or exclude grouped rows by using the HAVING clause
  6. 6Displaying Data from Multiple Tables Using Joins
    1. AWrite SELECT statements to access data from more than one table using
      equijoins and nonequijoins
    2. BJoin a table to itself by using a self-join
    3. CView data that generally does not meet a join condition by using outer joins
    4. DGenerate a Cartesian product of all rows from two or more tables
  7. 7Using Subqueries to Solve Queries
    1. ADefine subqueries
    2. BDescribe the types of problems that the subqueries can solve
    3. CDescribe the types of subqueries
    4. DWrite single-row and multiple-row subqueries
  8. 8Using the SET Operators
    1. ADescribe set operators
    2. BUse a set operator to combine multiple queries into a single query
    3. CControl the order of rows returned
  9. 9Managing Tables Using DML Statements
    1. ATruncate data
    2. BInsert rows into a table
    3. CUpdate rows in a table
    4. DDelete rows from a table
    5. EControl transactions
  10. 10Introduction to Data Definition Language
    1. ACategorize the main database objects
    2. BExplain the table structure
    3. CDescribe the data types that are available for columns
    4. DCreate a simple table
    5. EExplain how constraints are created at the time of table creation

Information

Description
1Z0-061 exam topics
Language
English
Views
23
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?