Crowdly

Add to Chrome

Universities
softserve.academy
DataBase Fundamentals new

DataBase Fundamentals new

Looking for DataBase Fundamentals new test answers and solutions? Browse our comprehensive collection of verified answers for DataBase Fundamentals new at softserve.academy.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

Which of the following functions ...

(match the appropriate)

is used to concatenate two or more strings in PostgreSQL

is used to calculate the length of a string in PostgreSQL

returns the absolute value of a number in PostgreSQL

is used to extract a substring from a string in PostgreSQL

View this question

The SQL operator used to retrieve the data in a column of a table, based on a specified pattern is

View this question

Which of the following is a valid syntax for using multiple columns in the GROUP BY clause?

GROUP BY column1 AND column2

GROUP column1, column2

GROUP BY column1, column2

GROUP column1 AND column2

View this question

Which aggregate function returns ...

(match the appropriate)

the lowest value of a column

the average value in a column

the total number of rows in the table

the highest value of a column

the total sum of numeric values in a column

View this question

Which of the following is not an aggregate function?

MAX()

AVG()

MIN()

COUNT()

REPLACE()

View this question

What is the output of the following query:

SELECT COUNT(*) FROM employees;

The total number of rows with not empty values in "EmployeeID" column in the "employees" table

The total number of rows in the "employees" table

All columns in the "employees" table

The total number of columns in the "employees" table

View this question

Given customers table in the sales DB.

Image failed to load

Which of the queries should return the information about all the customers from California state (value of the state column equals 'CA')

SELECT

*

FROM

sales.customers

WHERE

state EQUALS 'CA';

SELECT

*

FROM

sales.customers

WHERE

state IN 'CA';

SELECT

*

FROM

sales.customers

WHERE

state LIKE 'CA';

SELECT

*

FROM

sales.customers

WHERE

state BETWEEN 'C' AND 'A';

SELECT

*

FROM

sales.customers

WHERE

state = 'CA';

View this question

The HAVING clause is often used with the GROUP BY clause

to filter groups based on a specified list of conditions

applies for setting up any condition for result set after ordering

can be used without grouping

can be used instead of WHERE

View this question

Match the clauses and their usage

Operator to check if a value is NULL or not.

The clause is used in the SELECT statement to remove duplicate rows from a result set. It keeps one row for each group of duplicates.

An optional clause of the SELECT statement that constrains the number of rows returned by the query.

To conform with the SQL standard, PostgreSQL supports this clause to retrieve a number of rows returned by a query.

View this question

The query

SELECT DISTINCT
    column_name
FROM
    table_name;

returns only distinct values in the specified column

cannot be applied to one column in the select list of the SELECT statement

keep all rows for each group of duplicates

removes the duplicate values in the column from the result set

View this question

Previous
1
14
15
16
17
Next

Want instant access to all verified answers on softserve.academy?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank

Terms of Use Contact Us

Add to Chrome

Add to Chrome