GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Quiz

1Z0-061

lomasdelicioso 10 Fragen

Quiz starten

Fragen in diesem 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

Informationen

Beschreibung
1Z0-061 exam topics
Sprache
English
Aufrufe
23
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck