Maysa Hassan - MTA Databse Certificate - Sohag Team
-
On which database structure does an update statement operate?
-
Table
-
User
-
Trigger
-
Role
-
أهداء إلى احلى فريق
MTA Team Sohag
From : Maysa Hassan
Quiz Preview
- 2.
You have a table of products with fields for ProductID, Name, and Price. You need to write an UPDATE statement that sets the value in the In Stock field to Yes for a specific Product ID. Which clause should you use in your update statement?
-
WHERE
-
THAT
-
GROUP BY
-
HAVING
Correct Answer
A. WHEREExplanation
The WHERE clause should be used in the UPDATE statement to specify the condition for updating the value in the In Stock field to Yes for a specific Product ID. The WHERE clause allows you to filter the rows in the table based on a specified condition, in this case, the specific Product ID.Rate this question:
-
- 3.
You are writing a SQL statement to retreive rows from a table which Data Manipulation Language DML Command should you use ?
-
Select
-
Output
-
Read
-
Get
Correct Answer
A. SelectExplanation
The correct answer is "select" because the "select" command is used in SQL to retrieve rows from a table. It allows you to specify the columns you want to retrieve and apply conditions to filter the results if needed.Rate this question:
-
- 4.
Which two keys establish a relationship between two tables? (Choose two.)
-
Primary
-
Local
-
Superkey
-
Foreign
-
Candidate
Correct Answer(s)
A. Primary
A. ForeignExplanation
Primary and foreign keys are used to establish relationships between two tables in a relational database. The primary key is a unique identifier for each record in a table and is used to ensure data integrity and enforce referential integrity. The foreign key is a field in one table that refers to the primary key in another table, creating a link between the two tables. This allows for the establishment of relationships and the ability to retrieve related data from multiple tables using join operations.Rate this question:
-
- 5.
You have a table named Employee that includes four columns. You execute the following statement: SELECT * FROM Employee - Which columns are returned?
-
All columns
-
Only the last column
-
Only the first column
-
Only the first and last columns
Correct Answer
A. All columnsExplanation
When the statement "SELECT *" is executed, it retrieves all the columns from the table named Employee. Therefore, all columns from the Employee table will be returned as a result of this query.Rate this question:
-
- 6.
Which key uniquely identifies a row in a table?
-
Primary
-
foreign
-
Local
-
Superkey
Correct Answer
A. PrimaryExplanation
The primary key uniquely identifies a row in a table. It is a column or a combination of columns that have a unique value for each row in the table. This key is used to ensure data integrity and to establish relationships between tables in a database.Rate this question:
-
- 7.
Which command should you use to remove a table from a database?
-
DROP TABLE
-
DELETE TABLE
-
REMOVE TABLE
-
UPDATE TABLE
Correct Answer
A. DROP TABLEExplanation
The command "DROP TABLE" should be used to remove a table from a database. This command allows the user to delete a table and all its associated data from the database. It is specifically designed for removing tables and is the correct choice for this task.Rate this question:
-
- 8.
This question requires that you evaluate the underlined text to determine if it is correct. First normal form requires that a database excludes repeating groups. Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.
-
No change is needed
-
Composite keys
-
Duplicate rows
-
Foreign keys
Correct Answer
A. No change is neededExplanation
The underlined text is correct. First normal form indeed requires that a database excludes repeating groups. This means that each attribute in a table must contain only atomic values, and there should be no repeating groups or arrays of values within a single attribute.Rate this question:
-
- 9.
What defines the amount of storage space that is allocated to a value in a column
-
Data type
-
Format
-
Key
-
Validator
Correct Answer
A. Data typeExplanation
The amount of storage space allocated to a value in a column is determined by its data type. Different data types require different amounts of storage space. For example, a numeric data type may require more storage space compared to a string data type. The data type also determines the range of values that can be stored in the column and the operations that can be performed on it.Rate this question:
-
- 10.
You have a table that contains the following data. You break the table into the following two tables This process is referred to as
-
Denormalization
-
Fragmentation
-
Normalization
-
Defragmentation
Correct Answer
A. NormalizationExplanation
Normalization is the process of organizing data in a database to eliminate redundancy and improve data integrity. It involves breaking a table into multiple tables, each with a specific purpose and related to each other through relationships. This helps to minimize data duplication and ensures efficient storage and retrieval of data. By normalizing the table, the data is structured in a logical and organized manner, making it easier to manage and maintain in the long run.Rate this question:
-
- 11.
You have a table named Product. The Product table has columns for Product Description and Product Category. You need to change the Product Category value for all the spoons in the Product table to 43. Which statement should you use?
-
Option A
-
Option B
-
Option C
-
Option D
Correct Answer
A. Option AExplanation
Option A is the correct answer because it suggests using an UPDATE statement to change the Product Category value for all the spoons in the Product table to 43.Rate this question:
-
- 12.
The Product table contains the following data. You execute the following statement: SELECT COUNT(*) FROM Product WHERE Quantity > 18 What is the value returned by this statement?
-
1
-
2
-
3
-
4
Correct Answer
A. 3Explanation
The value returned by the statement is 3. This is because the statement is counting the number of rows in the Product table where the Quantity is greater than 18. So, it is returning the count of products that have a quantity greater than 18, which is 3.Rate this question:
-
- 13.
You have two tables named Cars and Color as defined below. The two tables are related by ColorId. - You run the following SQL statement: select: How many rows does the SQL statement return?
-
0
-
2
-
3
-
6
Correct Answer
A. 3Explanation
The SQL statement will return 3 rows. This is because the statement is asking to select, but it is not specifying which columns or tables to select from. Therefore, it will select all columns from all tables. Since there are two tables named Cars and Color, and they are related by ColorId, the SQL statement will return all rows from both tables that have a matching ColorId.Rate this question:
-
- 14.
You have the following table definition: CREATE TABLE Product - (ID INTEGER PRIMARY KEY, Name VARCHAR(20), Quantity INTEGER) The Product table contains the following data You execute the following statement: SELECT Name FROM Product WHERE Quantity IS NOT NULL How many rows are returned?
-
0
-
1
-
2
-
3
-
4
Correct Answer
A. 3Explanation
The statement "SELECT Name FROM Product WHERE Quantity IS NOT NULL" will return 3 rows. This is because it is selecting the "Name" column from the "Product" table where the "Quantity" column is not null. Since there are 3 rows in the table where the "Quantity" column is not null, those 3 rows will be returned as the result.Rate this question:
-
- 15.
A named group of SQL statements that can be executed in a database is called a:
-
Stored procedure
-
Formula
-
Subroutine
-
Method
Correct Answer
A. Stored procedureExplanation
A stored procedure is a named group of SQL statements that can be executed in a database. It is a precompiled collection of SQL statements that can be called by name to perform a specific task or set of tasks. Stored procedures are commonly used to encapsulate complex logic and calculations, improve performance by reducing network traffic, and enhance security by controlling access to the underlying data. They can be called from various applications and can accept input parameters and return output values.Rate this question:
-
- 16.
Which statement deletes the rows where the employee's phone number is not entered?
-
Option A
-
Option B
-
Option C
-
Option D
Correct Answer
A. Option AExplanation
Option A is the correct answer because it implies that there is a statement that specifically targets and deletes the rows where the employee's phone number is not entered. This suggests that there is a condition or criteria being used to filter out the rows that do not have a phone number entered for the employee.Rate this question:
-
- 17.
What should you include in the update statement?
-
SET Product Name = 'glass'
-
LET Product Name = 'glass'
-
EXEC ProductName = 'glass'
-
ASSIGN ProductName = 'glass'
Correct Answer
A. SET Product Name = 'glass'Explanation
The correct answer is "SET Product Name = 'glass'". This is because in SQL, the "SET" keyword is used to update or modify data in a table. In this case, the update statement is setting the value of the "Product Name" column to 'glass'. The other options (LET, EXEC, ASSIGN) are not valid syntax for an update statement in SQL.Rate this question:
-
- 18.
Which permission does a user need in order to run a stored procedure?
-
EXECUTE
-
ALLOW
-
CALL
-
RUN
Correct Answer
A. EXECUTEExplanation
In order to run a stored procedure, a user needs the EXECUTE permission. This permission allows the user to execute or run the stored procedure. The other options, ALLOW, CALL, and RUN, are not valid permissions for running a stored procedure.Rate this question:
-
- 19.
You have the database table named Cars as defined below: You have the following Structured Query Language (SQL) statement: How many rows are returned by the SQL statement?
-
4
-
5
-
6
-
7
Correct Answer
A. 4 -
- 20.
You have the following table definition: CREATE TABLE Road - (Road ID INTEGER NOT NULL, Distance INTEGER NOT NULL) The Road table contains the following data: You execute the following statement: INSERT INTO Road VALUES (1234, 36) What is the result?
-
An error stating that NULL values are not allowed
-
A new row in the table
-
An error stating that duplicate IDs are not allowed
-
A syntax error
Correct Answer
A. A new row in the tableExplanation
The given statement "INSERT INTO Road VALUES (1234, 36)" is a valid SQL statement that inserts a new row into the Road table. The values provided for the Road ID and Distance columns are not NULL, so there will be no error stating that NULL values are not allowed. Since the table definition does not specify any constraints on duplicate IDs, there will be no error stating that duplicate IDs are not allowed. As the statement is syntactically correct, there will be no syntax error. Therefore, the result of executing this statement will be a new row added to the table.Rate this question:
-
- 21.
Which keyword would you use in a select statement to return rows that meet a specific condition?
-
WHERE
-
UNION
-
ORDER BY
-
FROM
Correct Answer
A. WHEREExplanation
The keyword "WHERE" is used in a select statement to filter the rows and return only those that meet a specific condition. It allows you to specify criteria that the rows must meet in order to be included in the result set.Rate this question:
-
- 22.
You need to remove a view named EmployeeView from your database. Which statement should you use?
-
DELETE VIEW EmployeeView
-
DELETE EmployeeView
-
DROP EmployeeView
-
DROP VIEW EmployeeView
Correct Answer
A. DROP VIEW EmployeeViewExplanation
To remove a view named EmployeeView from the database, the correct statement to use is "DROP VIEW EmployeeView". The DROP VIEW command is used to delete a view from the database. The other options, DELETE VIEW EmployeeView, DELETE EmployeeView, and DROP EmployeeView, are incorrect as they do not follow the correct syntax for removing a view.Rate this question:
-
- 23.
This question requires that you evaluate the underlined text to determine if it is correct. You have two tables. Each table has three rows. Nine rows will be included in the Cartesian product of these two tables. Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement corrector.
-
No Change is needed
-
Zero
-
Three
-
Six
Correct Answer
A. No Change is neededExplanation
The underlined text states that "Nine rows will be included in the Cartesian product of these two tables." This is correct because the Cartesian product of two tables is calculated by multiplying the number of rows in one table with the number of rows in the other table. In this case, since each table has three rows, the Cartesian product will indeed have nine rows. Therefore, no change is needed.Rate this question:
-
- 24.
A view can be used to
-
B. Limit access to specific rows or columns of data in a table.
-
Save an extra copy of data stored in a separate table.
-
C. Ensure referential integrity.
-
Save historical data before deleting it from the base table
Correct Answer
A. B. Limit access to specific rows or columns of data in a table.Explanation
A view can be used to limit access to specific rows or columns of data in a table. By creating a view with specific filters or restrictions, only certain rows or columns of data can be accessed by users or applications. This can be useful in situations where certain sensitive or confidential information needs to be restricted from certain users or groups. Views provide a way to control and manage the access to data without altering the original table structure or data.Rate this question:
-
- 25.
You are writing a T - SQL statement that perform a long complex query the statement then send the result in an email you want to be able to manually call the code anytime you need to . which Database objects can you use to store the code ?
-
Stored procedure
-
Trigger
-
Data dictionary
-
View
Correct Answer
A. Stored procedureExplanation
A stored procedure is a type of database object that can be used to store the T-SQL code. It allows you to define a set of SQL statements that can be executed as a single unit. By creating a stored procedure, you can easily call and execute the complex query whenever needed, such as when sending the result in an email.Rate this question:
-
- 26.
In SQL, an insert statement is used to add a
-
User to a database.
-
Row of data to a table.
-
Table to a database.
-
Column to a table definition.
Correct Answer
A. Row of data to a table.Explanation
An insert statement in SQL is used to add a row of data to a table. This means that when we want to add new information to an existing table, we use the insert statement to specify the values for each column in a new row. By doing so, we can effectively add new data to the table without altering its structure or adding new columns.Rate this question:
-
- 27.
You need to list the name and price of each product, sorted by price from highest to lowest. Which statement should you use ?
-
Option A
-
Option B
-
Option C
-
Option D
Correct Answer
A. Option AExplanation
Option A is the correct answer because it suggests using a statement or code that will allow you to list the name and price of each product, sorted by price from highest to lowest. This is the desired outcome according to the question prompt. Without any further information or context, it is difficult to provide a more specific explanation.Rate this question:
-
- 28.
You need to insert two new products into the Product table. The first product is named Book and has an ID of 125. The second product is named Movie and has an ID of 126. Which statement should you use?
-
Option A
-
Option B
-
Option C
-
Option E
-
Option D
Correct Answer
A. Option BExplanation
Option B is the correct statement to use for inserting the two new products into the Product table. It is likely that Option B contains the appropriate SQL syntax for inserting new records into the table, specifying the product names and IDs. However, without the actual content of Option B, it is not possible to provide a more specific explanation.Rate this question:
-
- 29.
Which statement should you use?
-
Option A
-
Option B
-
Option C
-
Option D
Correct Answer
A. Option D -
- 30.
You have a table named Customer. You need to add a new column named District. Which statement should you use?
-
Option A
-
Option B
-
Option C
-
Option D
Correct Answer
A. Option DExplanation
Option D is the correct answer because it suggests using the ALTER TABLE statement to add a new column named District to the Customer table. The ALTER TABLE statement is used to modify an existing table by adding, modifying, or deleting columns.Rate this question:
-
- 31.
One different between A function and a stored procedure
-
Must return a value
-
Must be called from a trigger
-
Cannot contain a transaction .
-
Cannot accept parameters
Correct Answer
A. Must return a valueExplanation
A function is a subprogram that must return a value after performing a specific task. It is used to perform calculations or manipulate data and is typically called within an expression or statement. On the other hand, a stored procedure is a set of SQL statements that are executed as a single unit. Unlike a function, a stored procedure does not necessarily need to return a value. It can be used to perform various tasks such as inserting or updating data, generating reports, or executing multiple SQL statements. Therefore, the difference between a function and a stored procedure is that a function must return a value, whereas a stored procedure may or may not return a value.Rate this question:
-
- 32.
Which two elements are required to define a column ??
-
Name
-
A data type
-
An index
-
A key
Correct Answer(s)
A. Name
A. A data typeExplanation
To define a column, two elements are required: a name and a data type. The name serves as the identifier for the column, while the data type specifies the type of data that can be stored in the column (e.g., text, number, date). An index and a key are not necessary to define a column, as they are optional features used for optimizing database performance and enforcing data integrity, respectively.Rate this question:
-
- 33.
Which constraint ensures a unique value in the ID column for each customer?
-
PRIMARY KEY
-
SEQUENTIAL
-
FOREIGN KEY
-
DISTINCT
Correct Answer
A. PRIMARY KEYExplanation
The PRIMARY KEY constraint ensures a unique value in the ID column for each customer. This means that each customer will have a different ID value, and no two customers can have the same ID. The PRIMARY KEY constraint is commonly used to uniquely identify each row in a table and enforce data integrity.Rate this question:
-
- 34.
What are three valid data manipulation language DML Comands choose three
-
Insert
-
Commit
-
Delete
-
Output
-
Update
Correct Answer(s)
A. Insert
A. Delete
A. UpdateExplanation
The question asks for three valid data manipulation language (DML) commands. The correct answer is insert, delete, and update. These are indeed valid DML commands used to manipulate data in a database. The insert command is used to add new records to a table, the delete command is used to remove records from a table, and the update command is used to modify existing records in a table. The other options, commit and output, are not DML commands and are not used for data manipulation.Rate this question:
-
- 35.
When volunteer information changes, you must update the table. You need to change Tia's name to Kimberly. Which statement should you choose?
-
UPDATE Volunteer SET given name = ' Kimberly' WHERE given name = ' Tia'
-
SET Volunteer TO given name = ' Kimberly' where given name = ' Tia'
-
UPDATE given name = ' Kimberly' From Volunteer WHERE given name = ' Tia'
-
SET given name = ' Kimberly' From Volunteer where given name = ' Tia'
Correct Answer
A. UPDATE Volunteer SET given name = ' Kimberly' WHERE given name = ' Tia'Explanation
The correct statement to choose is "UPDATE Volunteer SET given name = 'Kimberly' WHERE given name = 'Tia'". This statement uses the correct syntax for updating a table in SQL. It specifies the table name "Volunteer", sets the column "given name" to the value "Kimberly", and applies the update only to rows where the "given name" is currently "Tia".Rate this question:
-
- 36.
Check the correct answer
-
The var char data type contains only numeric characters
-
The numeric data type contains only numbers that have decimal
-
The INT data type contains only whole numbers
Correct Answer
A. The INT data type contains only whole numbersExplanation
The explanation for the given correct answer is that the INT data type is specifically designed to store whole numbers. It does not allow for decimal values or any other type of data. Therefore, any value assigned to an INT data type will be a whole number.Rate this question:
-
- 37.
Data in a database is stored in:
-
Stored procedures
-
Data types
-
Queries
-
Tables
Correct Answer
A. TablesExplanation
Data in a database is stored in tables. Tables are the basic structure used to organize and store data in a database. Each table consists of rows and columns, where each row represents a record and each column represents a field or attribute of that record. Tables provide a structured way to store and retrieve data efficiently, making them a fundamental component of any database system.Rate this question:
-
- 38.
You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an:
-
Cascade delete
-
Inherited delete
-
Functional delete
-
Waterfall delete
-
Domino delete
Correct Answer
A. Cascade deleteExplanation
The process described in the question, where deleting rows in the "Order" table automatically deletes the corresponding rows in the "OrderItem" table, is known as a cascade delete. This refers to the cascading effect of the deletion, where the deletion operation propagates to related tables to maintain data integrity.Rate this question:
-
- 39.
This question requires that you evaluate the underlined text to determine if it is correct. A view can be used to ensure referential integrity. Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct
-
No change is needed
-
Save an extra copy of data stored in a separate table.
-
Limit access to specific rows or columns of data in a table.
-
Save historical data before deleting it from the base table.
Correct Answer
A. Limit access to specific rows or columns of data in a table.Explanation
A view can be used to limit access to specific rows or columns of data in a table. Views allow users to see a subset of the data in a table, providing a way to control access and protect sensitive information. By defining a view with specific conditions or filters, only the authorized users will be able to see the restricted data. This helps to ensure referential integrity by preventing unauthorized modifications or deletions of the data. Saving an extra copy of data stored in a separate table or saving historical data before deleting it from the base table are not directly related to ensuring referential integrity.Rate this question:
-
- 40.
5 - Which statement will result in the creation of an index? choose
-
Option A
-
Option B
-
Option C
-
Option D
Correct Answer
A. Option AExplanation
Option A is the correct answer because creating an index is typically done by using a specific command or statement in a database management system. The other options may be related to database management or querying, but they do not specifically address the creation of an index.Rate this question:
-
- 41.
You have two tables. Each table has three rows. How many rows will be included in the Cartesian product of these two tables?
-
9
-
0
-
3
-
6
Correct Answer
A. 9Explanation
The Cartesian product of two tables is obtained by combining each row of the first table with each row of the second table. Since each table has three rows, and we are combining each row from one table with each row from the other table, the total number of rows in the Cartesian product will be 3 x 3 = 9.Rate this question:
-
- 42.
This question requires that you evaluate the underlined text to determine if it is correct. A row holds information for a single record in a table. Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct
-
No change is needed
-
Data type
-
View
-
Column
Correct Answer
A. No change is neededExplanation
The underlined text is correct. A row in a table does hold information for a single record.Rate this question:
-
- 43.
The component that holds information for a single entry in a table is called a:
-
Data type
-
Row
-
Column
-
View
Correct Answer
A. RowExplanation
A row is the correct answer because it represents a single entry in a table. In a database, a table is made up of rows and columns, with each row containing specific information related to a particular entry. Therefore, a row holds information for a single entry in a table.Rate this question:
-
- 44.
One reason to add an index is to
-
Improve performance of select statements.
-
Decrease storage space
-
Improve performance of insert statements
-
Decrease storage space.
Correct Answer
A. Improve performance of select statements.Explanation
Adding an index to a database table can improve the performance of select statements. An index is a data structure that allows the database to quickly locate specific rows in a table. By creating an index on columns frequently used in select statements, the database can efficiently retrieve the requested data, resulting in faster query execution. This can be particularly beneficial when dealing with large tables or complex queries, as it reduces the time required to search and retrieve data, ultimately improving the overall performance of select statements.Rate this question:
-
- 45.
On which database structure does an insert statement operate?
-
Table
-
Role
-
Trigger
-
User
-
Stored procedure
Correct Answer
A. TableExplanation
An insert statement operates on a table in a database structure. This statement is used to add new rows of data into a table. It is a common operation in databases to insert data into tables for storage and retrieval purposes.Rate this question:
-
- 46.
First normal form requires that a database excludes
-
Repeating groups
-
Foreign keys
-
Composite keys
-
Duplicate rows
Correct Answer
A. Repeating groupsExplanation
First normal form (1NF) is a fundamental principle in database design that requires eliminating repeating groups in a database. Repeating groups refer to multiple occurrences of the same set of attributes within a single table. By removing repeating groups, the database becomes more organized and efficient. Foreign keys and composite keys are not excluded in 1NF; they are used to establish relationships between tables and ensure data integrity. Duplicate rows, on the other hand, are not allowed in 1NF as they can lead to data inconsistency and redundancy. Therefore, the correct answer is "Repeating groups."Rate this question:
-
- 47.
You have a table that contains the following data Which database term is used to describe the relationship between ProductID and ProductCategory
-
Cohort
-
Compositional
-
Functionally dependent
-
Deterministic
-
Relationally dependent
Correct Answer
A. Functionally dependentExplanation
Functionally dependent is the correct answer because it describes the relationship between ProductID and ProductCategory in the table. In a functional dependency, the value of one attribute (ProductID) determines the value of another attribute (ProductCategory). In this case, the value of ProductID uniquely determines the value of ProductCategory, indicating a functional dependency between the two attributes.Rate this question:
-
- 48.
A database contains two tables named Customer and Order. You execute the following statement: DELETE FROM Order - WHERE Customer ID = 209 - What is the result?
-
All orders for Customer ID 209 are deleted from the Order table.
-
The first order for Customer ID 209 is deleted from the Order table.
-
All orders for Customer ID 209 are deleted from the Order table, and Customer ID 209 is deleted from the Customer table.
-
Customer ID 209 is deleted from the Customer table.
Correct Answer
A. All orders for Customer ID 209 are deleted from the Order table.Explanation
The statement "DELETE FROM Order - WHERE Customer ID = 209 -" will delete all orders for Customer ID 209 from the Order table.Rate this question:
-
- 49.
21 - Which category of SQL statements is used to add, remove, and modify database structures?
-
Data definition language (DDL)
-
Data control language (DCL)
-
Data manipulation language (DML)
-
Data access language (DAL)
Correct Answer
A. Data definition language (DDL)Explanation
The correct answer is Data definition language (DDL). DDL statements are used to add, remove, and modify database structures such as tables, indexes, and constraints. Examples of DDL statements include CREATE, ALTER, and DROP. DCL statements are used to control access and permissions to the database. DML statements are used to manipulate data within the database, such as INSERT, UPDATE, and DELETE. DAL is not a recognized category of SQL statements.Rate this question:
-
Quiz Review Timeline (Updated): Jun 10, 2024 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jun 10, 2024Quiz Edited by
ProProfs Editorial Team -
Oct 12, 2019Quiz Created by
Maysa Hassan
Back to top