Online database with answers to the test, 26 questions

Pay with:
i agree with "Terms for Customers"
Sold: 35
Refunds: 0

Uploaded: 16.05.2014
Content: 40516224356390.rar (15,75 kB)

Description

Test items for the discipline "Databases» № 2, 26 questions.



Question 1. The operator, containing proposals in the following order ...

SELECT

WHERE ...

HAVING ...

ORDER BY ...

1. - inadmissible as WHERE and HAVING clause can not be used simultaneously in the same sentence;

2. - say;

3. - say on the composition of the proposals, but the order is wrong suggestions;

4 - is unacceptable, as there is no mandatory offer FROM (50%);

5. - is unacceptable, as the HAVING clause can not be used without the offer of GROUP BY ... (50%)




Question 2. The SELECT statement allows you to ...

1. - to select data from one or more tables and display them on the screen;

2. - to create tables;

3. - The correct data;

4. - delete the selected entry.



Question 3. The scheme of relationship:

Client (ID client name of the client, № branch, № account balance).

Select branches that have fewer than 10 clients.

1. - SELECT FROM customer №filiala

GROUP BY № branch

HAVING COUNT (*) <10;

2. - SELECT FROM customer №filiala

WHERE COUNT (ID) <10;

3. - SELECT FROM customer №filiala

HAVING COUNT (ID) <10;

4. - SELECT FROM customer №filiala

WHERE № accounts <10;


Question 4. The scheme of relations branch number

Client (ID client name of the client, № branch, № account balance).

Count the number of customers who have accounts on the rest of the branch №3 0

1. - SELECT ID FROM customer

WHERE remainder = 0 AND №filiala = 3;

2. - SELECT * FROM customer

GROUP BY remainder = 0;

3. - SELECT COUNT (*) FROM customer

WHERE remainder = 0 AND №filiala = 3;

4. - SELECT ID FROM customer

HAVING remainder = 0 AND №filiala = 3;


Question 5. The SQL language is designed to work with ...

1 - The hierarchical data model;

2 - The network data model;

3. - relational data model;

4. - object data model.



Question 6. FROM clause SQL SELECT statement sets ...

1 - The list of source tables;

2. - A list of initial forms;

3 - The initial list of attributes;

4. - A list of aliases.



Question 7. WHERE clause query SQL SELECT statement sets ...

1 - The condition of selection lines (50%);

2 - The condition of selection fields;

3 - The condition of selection of the data set;

4. - join condition tables (50%)



Question 8. In HAVING SQL SELECT statement specified ...

1 - The conditions of selection of groups;

2 - The conditions of sorting strings;

3 - The terms of the selection lines;

4 - The conditions of selection of columns.



Question 9. aggregate functions in SQL are

1. - Count (20%);

2. Sum (20%);

3. Avg (20%);

4. Min (20%);

5. Max (20%);

6. Product;

7. - Division.


Question 10. In SQL subqueries can be as follows ...

1 - scalar (33%);

2. - deferred;

3. - string (33%);

4. - table (34%);

5 - components.

Question 11. SQL scalar subquery returns ...

1. - one line;

2 - the same value;

3 - a single table;

4 - a single number.


Question 12. The SELECT statement with a subquery can contain the phrase ...

1. - ALL (50%);

2. - EXISTS (50%);

3. - DIVISION;

4. - PRODUCT.


Question 13. What operation lets you combine the results of multiple queries?


1. UNION;

2. RIGHT JOIN;

3. LEFT JOIN;

4. - MULTIPLY.


Question 14. The scheme of the relationship:

Client (ID client name of the client, № branch, № account balance).

You must define the account with the highest residues. Choose the correct statement.

1. - SELECT * FROM customer

WHERE residue = (SELECT MAX (balance)

FROM customer);

2. - SELECT MAX (residue) FROM customer;


3. - SELECT * FROM customer

WHERE remainder = MAX (balance)


4. - SELECT * FROM cu

Additional information

Question 16. What is the keyword query SQL SELECT statement is designed to remove duplicate rows

1. - distinct;

2. - all;

3. - exists;

4. - Like.


Question 17. What is the function of the operator SQL SELECT query returns the average value in the specified column

1. Count;

2. Sum;

3. Avg;

4. Min;

5. Max.


Question 18. What are the functions of the SQL SELECT statement queries can be used only numeric field

1. Count;

2. Sum (50%);

3. Avg (50%);

4. Min;

5. Max.


Question 19. View subquery of queries SQL SELECT, which returns a single value

1 - scalar;

2. - string;

3 - The multiple-;

4. - table.


Question 20. What is the keyword query SQL SELECT statement must precede the subquery so that the comparison shall be satisfied if it is carried out for at least one of the values \u200b\u200bof the result column.

1. - Any;

2. - All;

3. - exists;

4. - distinct.


Question 21. If returned by the subquery table query SQL SELECT statement contains at least one row, the result of the predicate will not exist

1. - false;

2. - true;

3. - exists;

4. - null.

Question 22. What is the keyword query SQL SELECT statement to be used in the phrase Order by, to sort descending line

1. asc

2. desc;

3. Any;

4. All;

5. distinct.


Question 23. The scheme of the relationship: Session (name, discipline, evaluation, date of delivery)

Output data on student grades in mathematics and history.

1. - select name, discipline, evaluation session from where discipline = "Mathematics» or discipline = "history";

2. - select name, discipline, evaluation session from where discipline = "mathematics» and discipline = "history";

3. - select name, discipline = ´history, mathematics, "assessment from the session;

4. - select name, discipline, evaluation session from where discipline = "mathematics» and discipline = ´story »group by discipline;


Question 24. The scheme of the relationship: Session (name, discipline, evaluation, date of delivery)

Print the average score for each student

1. - select name, discipline, evaluation session from GROUP BY evaluation;

2. - select name, discipline, Avg (score) from session GROUP BY evaluation;

3. - select name, discipline, Count (estimate) from session GROUP BY evaluation

4. - select name, discipline, Avg (score) from session GROUP BY name.

Question 25. What is the symbol of the template SQL SELECT query statement indicates the presence or absence of any number of arbitrary characters

1 -%

2. - _;

3. - #;

4. - *.

Question 26. What is the symbol of SQL SELECT query means that the result table includes all columns from the original table

1 -%

2. - _;

3. - #;

4. - *.


IF YOU DO NOT SOMETHING liked the work, the report indicates E-MAIL, we will contact you and analyze all of your claim during the day.

If you like the work, please leave feedback, this will help you to increase the product list of inexpensive but high-quality work.

Works in * .rar opens archiver download any free and open.

Complete list of questions you can see the work before buying on our site.

Feedback

1
ОГРОМНОЕ СПАСИБО! Долго искал ответы,хорошо,что они у вас уже есть,Вы лучшие!2014-05-14
Period
1 month 3 months 12 months
0 0 0
0 0 0
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.com the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)