1Z0-006 SQL Fundamentals & Data Manipulation

Question 1

Which SQL statement is used to add a new row to a table?

Accepted Answer

INSERT

Answer

The `INSERT` statement is the standard SQL command used to add one or more new rows (records) into a table. It specifies the table name and the values to be inserted into its columns. This is distinct from `UPDATE`, which modifies existing rows, or `ALTER`, which modifies the table structure itself.

Question 2

To modify existing data in a table, you would use the _____ statement:

Accepted Answer

UPDATE

Answer

The `UPDATE` statement in SQL is specifically designed to modify existing records in a table. It allows you to change the values of one or more columns for rows that meet a specified condition. This is different from `DELETE`, which removes rows, or `SELECT`, which retrieves data, making `UPDATE` the correct choice for altering current data.

Question 3

Which clause filters rows returned by a SELECT query based on a condition?

Accepted Answer

WHERE

Answer

The WHERE clause is used in a SELECT statement to specify conditions that individual rows must meet to be included in the result set. It filters data based on specific criteria before any grouping or ordering occurs. This allows users to retrieve only the relevant subset of data from a table.

Question 4

The SQL wildcard character that substitutes for any sequence of characters in a LIKE pattern is:

Accepted Answer

%

Answer

The percent sign (%) is the SQL wildcard character that matches any sequence of zero or more characters in a LIKE pattern. It is commonly used for partial string matching, allowing queries to find values that contain, start with, or end with a specific substring. For example, 'A%' matches any string beginning with 'A'.

Question 5

Which function returns the number of rows in a group or entire table?

Accepted Answer

COUNT()

Answer

The COUNT() aggregate function is specifically designed to return the number of rows. When used with COUNT(*), it counts all rows in a group or the entire table, including those with NULL values. If a column name is specified, like COUNT(column_name), it counts only non-null values in that column within the specified scope.

(1Z0-006) Oracle Database Foundations Associate Practice Test

(1Z0-006) Oracle Database Foundations Associate Practice Test

1Z0-006 SQL Fundamentals & Data Manipulation