Алмат Мейржан
Quiz von , erstellt am more than 1 year ago

test

223
0
0
Keine Merkmale angegeben
Алмат Мейржан
Erstellt von Алмат Мейржан vor fast 7 Jahre
Schließen

data

data

Frage 1 von 50

1

Which symbol do you use if you need to choose all the columns from the table to the result query?

Wähle eine der folgenden:

  • *

  • +

  • All

  • %

Erklärung

Frage 2 von 50

1

Which is right order of the following clauses?

Wähle eine der folgenden:

  • SELECT … FROM … GROUP BY … ORDER BY … WHERE

  • SELECT … WHERE … ORDER BY … GROUP BY

  • SELECT … FROM … WHERE … GROUP BY … ORDER BY

  • SELECT … FROM … WHERE … ORDER BY … GROUP BY

Erklärung

Frage 3 von 50

1

Which symbol is used to create a substitution variable?

Wähle eine der folgenden:

  • *

  • &

  • _

  • %

Erklärung

Frage 4 von 50

1

Which keyword is used to provide an alias to a column?

Wähle eine der folgenden:

  • COLUMN

  • ALIAS

  • IS

  • AS

Erklärung

Frage 5 von 50

1

Which command is used to view the structure of the table LOCATIONS?

Wähle eine der folgenden:

  • DESCRIBE LOCATIONS

  • SELECT * FROM LOCATIONS

  • SHOW STRUCTURE LOCATIONS

  • PRINT LOCATIONS

Erklärung

Frage 6 von 50

1

Which of the following is a concatenation operator?

Wähle eine der folgenden:

  • *

  • +

  • &

  • ||

Erklärung

Frage 7 von 50

1

Which keyword is used to eliminate duplicate rows in the result?

Wähle eine der folgenden:

  • DESCRIBE

  • GROUP BY

  • HAVING

  • DISTINCT

Erklärung

Frage 8 von 50

1

Which of the following operations is an analogue to the CONCAT function?

Wähle eine der folgenden:

  • ||

  • +

  • LIKE

  • IN

Erklärung

Frage 9 von 50

1

When using LIKE conditions which symbol is used to denote zero or many characters?

Wähle eine der folgenden:

  • *

  • +

  • _

  • %

Erklärung

Frage 10 von 50

1

When using LIKE conditions which symbol is used to denote one character?

Wähle eine der folgenden:

  • *

  • +

  • _

  • %

Erklärung

Frage 11 von 50

1

Which of the following clauses is used to limit the rows that are retrieved by the query?

Wähle eine der folgenden:

  • WHERE

  • FROM

  • ORDER BY

  • GROUP BY

Erklärung

Frage 12 von 50

1

Which of the following clauses is used to sort the rows that are retrieved by the query?

Wähle eine der folgenden:

  • WHERE

  • FROM

  • ORDER BY

  • GROUP BY

Erklärung

Frage 13 von 50

1

Which of the following functions extracts a string of determined length?

Wähle eine der folgenden:

  • SUBSTR

  • INSTR

  • CONCAT

  • TRIM

Erklärung

Frage 14 von 50

1

Which of the following functions finds the numeric position of a named character?

Wähle eine der folgenden:

  • SUBSTR

  • INSTR

  • CONCAT

  • TRIM

Erklärung

Frage 15 von 50

1

Which of the following functions joins two strings together?

Wähle eine der folgenden:

  • CONCAT

  • TRIM

  • SUBSTR

  • INSTR

Erklärung

Frage 16 von 50

1

Which of the following functions is not single-row function?

Wähle eine der folgenden:

  • SUM

  • UPPER

  • CONCAT

  • ROUND

Erklärung

Frage 17 von 50

1

Which of the following functions is not multiple-row function?

Wähle eine der folgenden:

  • TRUNC

  • SUM

  • AVG

  • COUNT

Erklärung

Frage 18 von 50

1

FULL OUTER JOIN is used when

Wähle eine der folgenden:

  • each row of one table must be join with each row of another table

  • each row of one table must be join with each row of another table even if the tables do not have any columns in common

  • the rows from both tables must be displayed even if they do not satisfy the JOIN condition

  • a Cartesian product of the two tables must be displayed

Erklärung

Frage 19 von 50

1

Queries that return only one row from the inner SELECT statement are called

Wähle eine der folgenden:

  • Single-column subqueries

  • Multiple-column subqueries

  • Multiple-row subqueries

  • Single-row subqueries

Erklärung

Frage 20 von 50

1

Queries that return more than one row from the inner SELECT statement are called

Wähle eine der folgenden:

  • Multiple-row subqueries

  • Single-row subqueries

  • Multiple-column subqueries

  • Single-column subqueries

Erklärung

Frage 21 von 50

1

The _______operator compares a value to each value returned by a subquery.

Wähle eine der folgenden:

  • ANY

  • ALL

  • NOT

  • SOME

Erklärung

Frage 22 von 50

1

The ________operator compares a value to every value returned by a subquery.

Wähle eine der folgenden:

  • ALL

  • ANY

  • NOT

  • SOME

Erklärung

Frage 23 von 50

1

Subqueries have the following characteristics:
I. Can pass one row of data to a main statement that contains a single-row operator, such as =, <>, >, >=, <, or <=
II. Can pass multiple rows of data to a main statement that contains a multiple-row operator, such as IN
III. Are processed first by the Oracle server, after which the WHERE or HAVING clause uses the results

Wähle eine der folgenden:

  • I and III

  • I, II, and III

  • I and II

  • I only

Erklärung

Frage 24 von 50

1

A SELECT statement that is embedded in a clause of another SELECT statement is called

Wähle eine der folgenden:

  • subquery

  • inner query

  • outer query

  • main query

Erklärung

Frage 25 von 50

1

You can place the subquery in a number of SQL clauses, including the following:
I. WHERE clause
II. HAVING clause
III. FROM clause

Wähle eine der folgenden:

  • I and III

  • I, II and III

  • I and II

  • I only

Erklärung

Frage 26 von 50

1

Comparison conditions fall into two classes:

Wähle eine der folgenden:

  • single-row operators (>, =, >=, <, <>, <=) and multiple-column operators (IN, ANY, ALL)

  • single-column operators (>, =, >=, <, <>, <=) and multiple-column operators (IN, ANY, ALL)

  • multiple-row operators (>, =, >=, <, <>, <=) and single-row operators (IN, ANY, ALL)

  • single-row operators (>, =, >=, <, <>, <=) and multiple-row operators (IN, ANY, ALL)

Erklärung

Frage 27 von 50

1

The subquery generally executes_________, and its output is used to complete the query condition for the main (or_________) query.

Wähle eine der folgenden:

  • last, outer

  • first, inner

  • last, inner

  • first, outer

Erklärung

Frage 28 von 50

1

A subquery must be enclosed in_________________.

Wähle eine der folgenden:

  • curly braces

  • double quotes

  • single quotes

  • parentheses

Erklärung

Frage 29 von 50

1

_________ clause can be used and is required in the subquery to perform Top-N analysis.

Wähle eine der folgenden:

  • ORDER BY

  • HAVING

  • WHERE

  • GROUP BY

Erklärung

Frage 30 von 50

1

Which of the following operators is equivalent to the IN operator?

Wähle eine der folgenden:

  • < ANY

  • = ALL

  • = ANY

  • > ANY

Erklärung

Frage 31 von 50

1

Queries containing set operators are called______________.

Wähle eine der folgenden:

  • outer queries

  • compound queries

  • subqueries

  • inner queries

Erklärung

Frage 32 von 50

1

The _____________operator returns all rows that are selected by either query eliminating duplicates.

Wähle eine der folgenden:

  • INTERSECT

  • UNION

  • MINUS

  • UNION ALL

Erklärung

Frage 33 von 50

1

Use the ________________operator to return all rows from multiple tables and eliminate any duplicate rows.

Wähle eine der folgenden:

  • UNION ALL

  • UNION

  • MINUS

  • INTERSECT

Erklärung

Frage 34 von 50

1

_______________ returns all rows selected by either query, including all duplicates.

Wähle eine der folgenden:

  • NTERSECT

  • MINUS

  • UNION

  • UNION ALL

Erklärung

Frage 35 von 50

1

Use the __________________operator to return all rows that are common to multiple queries.

Wähle eine der folgenden:

  • UNION

  • UNION ALL

  • MINUS

  • INTERSECT

Erklärung

Frage 36 von 50

1

Use the ______________operator to return rows returned by the first query that are not present in the second query.

Wähle eine der folgenden:

  • MINUS

  • INTERSECT

  • UNION

  • UNION ALL

Erklärung

Frage 37 von 50

1

Which statement discards all pending data changes

Wähle eine der folgenden:

  • DISCARD

  • SAVEPOINT

  • ROLLBACK

  • COMMIT

Erklärung

Frage 38 von 50

1

Which of the following commands removes rows and a table structure?

Wähle eine der folgenden:

  • REMOVE TABLE

  • ALTER TABLE

  • DROP TABLE

  • DELETE TABLE

Erklärung

Frage 39 von 50

1

Which of the following commands is a part of the Data Manipulation Language?

Wähle eine der folgenden:

  • TRUNCATE

  • DROP

  • ALTER

  • SELECT

Erklärung

Frage 40 von 50

1

Which of the following commands is a part of the Data Definition Language?

Wähle eine der folgenden:

  • DELETE

  • UPDATE

  • SELECT

  • CREATE

Erklärung

Frage 41 von 50

1

Which of the following constraints does not exist?

Wähle eine der folgenden:

  • UNIQUE

  • CHECK

  • NOT NULL

  • DEFAULT

Erklärung

Frage 42 von 50

1

Consider the EMPLOYEES table. Which of the following SQL statements is correct to display the last name of the employee with its hire date providing the Employee and Hire Date aliases (case is important)?

Wähle eine der folgenden:

  • SELECT last_name AS 'Employee', hire_date AS 'Hire Date' FROM employees;

  • SELECT last_name "Employee", hire_date "Hire Date" FROM employees;

  • SELECT last_name Employee, hire_date Hire Date FROM employees;

  • SELECT last_name AS Employee, hire_date AS Hire Date FROM employees;

Erklärung

Frage 43 von 50

1

Consider the EMPLOYEES table. Which of the following SQL statements is correct to provide the sentence in the format "King has been working since 01.01.1987" with "Employee Information" alias?

Wähle eine der folgenden:

  • SELECT last_name || ' has been working since ' || hire_date Employee Information FROM employees;

  • SELECT last_name || ' has been working since ' || hire_date 'Employee Information' FROM employees;

  • SELECT last_name || " has been working since " || hire_date "Employee Information" FROM employees;

  • SELECT last_name || ' has been working since ' || hire_date "Employee Information" FROM employees;

Erklärung

Frage 44 von 50

1

What will be the result of the following SQL statement?

Wähle eine der folgenden:

  • he number of employees within each department will be displayed

  • An error will occur since the GROUP BY clause is missing

  • The unique department ids will be displayed

  • The number of departments will be displayed

Erklärung

Frage 45 von 50

1

Which of the following SQL statements will not generate an error?

Wähle eine der folgenden:

  • SELECT department_id Dep, COUNT(last_name) Num FROM employees GROUP BY department_id HAVING Num > 5

  • SELECT department_id Dep, COUNT(last_name) FROM employees GROUP BY Dep

  • SELECT last_name Name FROM employees WHERE Name like 'K%'

  • SELECT last_name Name FROM employees ORDER BY Name

Erklärung

Frage 46 von 50

1

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those whose salary is greater than 5000 but less than 18000?

Wähle eine der folgenden:

  • WHERE salary > 5000 AND salary > 18000

  • WHERE salary > 5000 AND salary < 18000

  • WHERE salary < 5000 AND salary > 18000

  • WHERE salary > 5000 OR salary < 18000

Erklärung

Frage 47 von 50

1

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to IT programmers with salary greater than 5000?

Wähle eine der folgenden:

  • WHERE salary > 5000 AND job_id = 'IT_PROG'

  • WHERE salary > 5000 OR job_id = 'IT_PROG'

  • WHERE salary > 5000 AND job_id = "IT_PROG"

  • WHERE salary > 5000 AND job_id = IT_PROG

Erklärung

Frage 48 von 50

1

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those who work in the departments 90 and 60?

Wähle eine der folgenden:

  • WHERE department_id BETWEEN 60 AND 90

  • WHERE department_id BETWEEN 90 AND 60

  • WHERE department_id = 90 OR department_id = 60

  • WHERE department_id = 90 AND department_id = 60

Erklärung

Frage 49 von 50

1

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those who do not work in the departments 90 and 60?

Wähle eine der folgenden:

  • WHERE department_id = 90 OR department_id = 60

  • WHERE department_id NOT IN (90, 60)

  • WHERE department_id = 90 AND department_id = 60

  • WHERE department_id IN (90, 60)

Erklärung

Frage 50 von 50

1

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those whose last name and first name starts with the letter ‘K’?

Wähle eine der folgenden:

  • WHERE last_name LIKE 'K%' and first_name LIKE 'K%'

  • WHERE last_name LIKE 'K_' and first_name LIKE 'K_'

  • WHERE last_name = 'K%' and first_name = 'K%'

  • WHERE last_name and first_name = 'K%'

Erklärung

Vorherige
Antwort prüfen
Nächste