MTA 98-364

Este test está cronometrado.

Tienes 2 horas para completar 128 preguntas de este test.

Iniciar Test

Por favor espera - en proceso…

Pregunta 1 de 128

You have the following table definition:
CREATE TABLE Road
(RoadID 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?

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 2 de 128

A view can be used to:

Selecciona una de las siguientes respuestas posibles:

Save an extra copy of data stored in a separate table.
Limit access to specific rows or columns of data in a table.
Ensure referential integrity.
Save historical data before deleting it from the base table.

Explicación

Pregunta 3 de 128

You are creating a database object named Student to store the following data:

Which syntax should you use to create the object?

A. CREATE TABLE Student ( ID INT,
Name VARCHAR (100),
Age INT )
---
B. CREATE (
TABLE Student
ID INT,
Name VARCHAR(100),
Age INT )
---
C. CREATE Student (
ID INT,
Name VARCHAR(100),
Age INT )
---
D. CREATE TABLE (
ID INT,
Name VARCHAR(100),
Age INT )

Selecciona una de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 4 de 128

Which statement deletes the rows where the employee's phone number is not entered?

Selecciona una de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 5 de 128

You have the following SQL query
SELECT * FROM dbo.ProAthlete WHERE Salary > 500000
The query takes too much time to return data.
You need to improve the performance of the query.
Which item should you add to the Salary column?

Selecciona una de las siguientes respuestas posibles:

Non-null constraint
Default constraint
Index
Foreign key

Explicación

Pregunta 6 de 128

Which two keys establish a relationship between two tables? (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

candidate
foreign
superkey
local
primary

Explicación

Pregunta 7 de 128

This question requires that you evaluate the underlined text to determine if it is correct.
The UNION keyword combines the results of two queries and returns only rows that appear
in both result sets.
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

Selecciona una de las siguientes respuestas posibles:

No change is needed
INTERSECT
ALL
UOIN

Explicación

Pregunta 8 de 128

Your class project requires that you help a charity set up a website.
The website collects information about volunteers. Each volunteer record must be uniquely
identified.
The following information is stored for each volunteer:
✑ Given name
✑ Surname
✑ Date of birth
✑ Phone number
✑ Photo
You need to create a table to meet the requirements.
Match the Structured Query Language SQL statements to the SQL query.
Instructions: To answer, drag the appropriate SQL statement from the column on the left to
its place in the SQL query on the right. Each SQL statement may be used once, more than
once, or not at all. Each correct match is worth one point.

Arrastra la opción correcta a cada uno de los puntos naranjas

INNT NOT NULL PRIMARY KEY,

TIMESTAMP NULL,

DATE NULL,

IMAGE NULL,

XML NULL,

INT NOT NULL FOREIGN KEY,

Explicación

Pregunta 9 de 128

This question requires that you evaluate the underlined text to determine if it is correct.
Ports 20 and 21 are the default ports to secure a SQL Server.
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.

Selecciona una de las siguientes respuestas posibles:

No change is needed
1433 and 1434
411 and 412
67 and 68

Explicación

Pregunta 10 de 128

Selecciona la opción correcta de los menús desplegables para completar el texto.

Instructions: For each of the following statements, select Yes if the statement is true.
Otherwise, select No. Each correct selection is worth one point.

Description of Behavior:

A clustered index sorts and stores the data columns of a table or view in order, based on the clustered index key. ( Yes, No )

A non-clustered index is defined on a table or view by using a clustered index or heap. ( Yes, No )

A unique index ensures that the index key contains no duplicate values and that every row in the table or view is unique. ( Yes, No )

A filtered index is a clustered index that is optimized for queries that select a small percentage of rows from a table. ( Yes, No )

Explicación

Pregunta 11 de 128

One reason to add an index is to:

Selecciona una de las siguientes respuestas posibles:

Decrease storage space.
Increase database security.
Improve performance of select statements.
Improve performance of insert statements.

Explicación

Pregunta 12 de 128

You have a table named Student that contains 100 rows. Some of the rows have a NULL
value in the FirstName column.
You execute the following statement:
DELETE FROM Student
What is the result?

Selecciona una de las siguientes respuestas posibles:

All rows in the table will be deleted.
All rows containing a NULL value in the FirstName column will be deleted.
You will receive an error message.
All rows and the table definition will be deleted.

Explicación

Pregunta 13 de 128

Your class project requires that you help a charity to create a website that registers
volunteers.
The website must store the following data about the volunteers:
✑ Given name
✑ Surname
✑ Telephone number
✑ Email address
You need to recommend a correct way to store the data.
What do you recommend?

Selecciona una de las siguientes respuestas posibles:

Create a table that contains columns that are named given name, surname, phone number, and email.
Create a table that contains rows that are named given name, surname, phone number, and email.
Create a view that contains columns that are named given name surname, phone number, and email.
Create a view that contains rows that are named given name surname, phone number, and email

Explicación

Pregunta 14 de 128

Which keyword would you use in a select statement to return rows that meet a specific
condition?

Selecciona una de las siguientes respuestas posibles:

WHERE
UNION
ORDER BY
FROM

Explicación

Pregunta 15 de 128

You have a table named Product that contains one million rows.
You need to search for product information in the Product table by using the product's
unique ID.
What will make this type of search more efficient?

Selecciona una de las siguientes respuestas posibles:

A cursor
A subquery
A trigger
An index

Explicación

Pregunta 16 de 128

You need to remove a view named EmployeeView from your database.
Which statement should you use?

Selecciona una de las siguientes respuestas posibles:

DELETE VIEW EmployeeView
DELETE EmployeeView
DROP EmployeeView
DROP VIEW EmployeeView

Explicación

Pregunta 17 de 128

Which category of SQL statements is used to add, remove, and modify database
structures?

Selecciona una de las siguientes respuestas posibles:

Data access language (DAL)
Data manipulation language (DML)
Data control language (DCL)
Data definition language (DDL)

Explicación

Pregunta 18 de 128

You need to delete a database table.
Which data definition language (DDL) keyword should you use?

Selecciona una de las siguientes respuestas posibles:

ALTER
DELETE
DROP
TRUNCATE

Explicación

Pregunta 19 de 128

You have the following table definition:
CREATE TABLE Product
(ProductID INTEGER,
Name VARCHAR(20))
You need to insert a new product. The product's name is Plate and the product's ID is
12345.
Which statement should you use?

Selecciona una de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 20 de 128

One difference between a function and a stored procedure is that a function:

Selecciona una de las siguientes respuestas posibles:

Must be called from a trigger.
Must return a value.
Cannot contain a transaction.
Cannot accept parameters.

Explicación

Pregunta 21 de 128

Selecciona la opción correcta de los menús desplegables para completar el texto.

Instructions: For each of the following statements, select Yes if the statement is true.
Otherwise, select No. Each correct selection is worth one point.

The VARCHAR data type contains only numeric characters. ( Yes, No )

The NUMERIC data type contains only numbers that have decimal places. ( Yes, No )

The INT data type contains only whole numbers ( Yes, No )

Explicación

Pregunta 22 de 128

At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600
hours), you create a table named Customer and import data into the table. At 5:00 P.M.
(1700 hours), your server fails.
You run a script to apply only the 3:00 P.M. backup to your database. What is the result of
the script?

Selecciona una de las siguientes respuestas posibles:

The Customer table no longer exists.
The Customer table is unaffected.
The Customer table exists but has no data.
The script fails.

Explicación

Pregunta 23 de 128

You have a database table named SongInformation as defined below:

You need to create a Structured Query Language (SQL) query to retrieve only the names
of songs that sold more than 1000 compact discs (CDs).
Which query should you use?

Selecciona una de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 24 de 128

The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?

Needs to be rechecked on ExamLabs, one person asked why is C correct and it had three likes on that comment

Selecciona una de las siguientes respuestas posibles:

View
Function
Index
Stored procedure
Trigger

Explicación

Pregunta 25 de 128

While attending college, you accept an IT internship at a local charity. The charity needs to
report on data that is related and exists in two tables.
You need to establish a relationship between the data that is in the two tables.
Which constraint should you define?

Selecciona una de las siguientes respuestas posibles:

Foreign key
Index key
Link key
Default key

Explicación

Pregunta 26 de 128

You have a Department table and an Employee table in your database.
You need to ensure that an employee can be assigned to only an existing department.
What should you apply to the Employee table?

Selecciona una de las siguientes respuestas posibles:

A primary key
An index
A foreign key
A unique constraint
A data type

Explicación

Pregunta 27 de 128

The component that holds information for a single entry in a table is called a:

Selecciona una de las siguientes respuestas posibles:

Data type
Row
Column
View

Explicación

Pregunta 28 de 128

On which database structure does an insert statement operate?

Selecciona una de las siguientes respuestas posibles:

Role
Trigger
User
Stored procedure
Table

Explicación

Pregunta 29 de 128

Selecciona la opción correcta de los menús desplegables para completar el texto.

You have a user that has server roles as defined below:

Instructions: Use the drop-down menus to select the answer choice that completes each
statement. Each correct selection is worth one point.

The user can perform ( no, read-only, unlimited ) actions on data that is on the server.

The user can perform ( no, unlimited, configuration ) actions on database objects that are on the server.

Explicación

Pregunta 30 de 128

You need to disable User1's access to view the data in the Customer table.
Which statement should you use?

Selecciona una de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 31 de 128

You need to store product names that vary from three to 30 characters. You also need to
minimize the amount of storage space that is used.
Which data type should you use?

Selecciona una de las siguientes respuestas posibles:

VARCHAR (3, 30)
CHAR (3, 30)
VARCHAR (30)
CHAR (30)

Explicación

Pregunta 32 de 128

This question requires that you evaluate the underlined text to determine if it is correct.
You combine data from three tables into one table. The new table includes redundancy to
optimize read performance.
The data in the new table has been denormalized.
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.

Selecciona una de las siguientes respuestas posibles:

No change is needed
Normalized
Truncated
Indexed

Explicación

Pregunta 33 de 128

You have a table that contains information about all students in your school.
Which SQL keyword should you use to change a student's first name in the table?

Selecciona una de las siguientes respuestas posibles:

UPDATE
CHANGE
SELECT
INSERT

Explicación

Pregunta 34 de 128

Selecciona la opción correcta de los menús desplegables para completar el texto.

Instructions: For each of the following statements, select Yes if the statement is true.
Otherwise, select No. Each correct selection is worth one point.

A SQL Server Login can use Windows Authentication. ( Yes, No )

A SQL Server Role provides permissions at the same level. ( Yes, No )

A SQL Server Login is granted permissions to database views only. ( Yes, No )

Explicación

Pregunta 35 de 128

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?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 36 de 128

You have two tables named Salesperson and Sales.
You need to ensure that each record in the Sales table has a valid associated salesperson
record in the Salesperson table.
Which database object should you add to the Sales table?

Selecciona una de las siguientes respuestas posibles:

Nonclustered index
Primary key
Foreign key
Clustered index

Explicación

Pregunta 37 de 128

You work at a coffee shop. They ask you to set up a website that stores charges on
purchases.
You need to recommend a data type in a database table to run financial functions against
the charged amounts.
Which data type should you recommend?

Selecciona una de las siguientes respuestas posibles:

Money
Bit
Varchar
Binary

Explicación

Pregunta 38 de 128

You have a table named Employee that includes four columns.
You execute the following statement:
SELECT *
FROM Employee
Which columns are returned?

Selecciona una de las siguientes respuestas posibles:

all columns
only the last column
only the first column
only the first and last columns

Explicación

Pregunta 39 de 128

This question requires that you evaluate the underlined text to determine if it is correct.
ALTER TABLE removes all rows from a table without logging the individual row deletions.
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.

Selecciona una de las siguientes respuestas posibles:

No change is needed
DROP TABLE
TRUNCATE TABLE
CREATE TABLE

Explicación

Pregunta 40 de 128

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?

Selecciona una de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 41 de 128

You accept an IT internship at a local charity. The charity has two tables in their data model
named Chapter and Language, as defined below:

You create a third table named ChapterLanguage to relate the Chapter table and the
Language table.
You need to select columns from the Chapter and Language tables to create a composite
primary key for the ChapterLanguage table.
Which two columns should you select? (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

ChapterId
LanguageId
Country
Region
City
LanguageName

Explicación

Pregunta 42 de 128

A database contains two tables named Customer and Order.
You execute the following statement:
DELETE FROM Order
WHERE CustomerID = 209
What is the result?

Selecciona una de las siguientes respuestas posibles:

The first order for CustomerID 209 is deleted from the Order table.
All orders for CustomerID 209 are deleted from the Order table, and CustomerID 209 is deleted from the Customer table.
All orders for CustomerID 209 are deleted from the Order table.
CustomerID 209 is deleted from the Customer table.

Explicación

Pregunta 43 de 128

Selecciona la opción correcta de los menús desplegables para completar el texto.

You have two database tables as defined below. The StateID column is unique in the State
table. The AddressID column is unique in the Address table. The two tables are related by
the StateID column.

StateID is a/an ( index, union, foreign key, primary key ) in the State table.

StateID is a/an ( index, union, foreign key, primary key ) in the Address table.

Explicación

Pregunta 44 de 128

Which keyword must be included in a create view statement?

Selecciona una de las siguientes respuestas posibles:

WHERE
ORDER BY
UPDATE
SELECT

Explicación

Pregunta 45 de 128

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 InStock field to Yes for a
specific ProductID.
Which clause should you use in your update statement?

Selecciona una de las siguientes respuestas posibles:

THAT
WHERE
GROUP BY
HAVING

Explicación

Pregunta 46 de 128

You have a table named Customer. You need to add a new column named District.
Which statement should you use?

Selecciona una de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 47 de 128

Which keyword can be used in a create table statement?

Selecciona una de las siguientes respuestas posibles:

ORDER BY
DISTINCT
GROUP BY
UNIQUE

Explicación

Pregunta 48 de 128

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.

Selecciona una de las siguientes respuestas posibles:

No change is needed
Zero
Three
Six

Explicación

Pregunta 49 de 128

You need to store the contact information for each student in your school database.
You should store each student's information in a:

Selecciona una de las siguientes respuestas posibles:

Stored procedure
Function
Row
Variable

Explicación

Pregunta 50 de 128

You have a table that contains the following data.

Which database term is used to describe the relationship between ProductID and
ProductCategory?

Selecciona una de las siguientes respuestas posibles:

Cohort
Relationally dependent
Deterministic
Functionally dependent
Compositional

Explicación

Pregunta 51 de 128

You execute the following statement:

This statement is an example of a/an:

Selecciona una de las siguientes respuestas posibles:

Subquery
Union
Outer join
Cartesian product

Explicación

Pregunta 52 de 128

You need to set up a database to provide a view of North American mammals.
Match the Structured Query Language (SQL) statements to the SQL query.
Instructions: To answer, drag the appropriate SQL statement from the column on the left to
its place in the SQL query on the right Each SQL statement may be used once, more than
once, or not at all. Each correct match is worth one point.

Arrastra la opción correcta a cada uno de los puntos naranjas

CREATE VIEW [dbo] . [NorthAmericanMammal

GENERATE VIEW [dbo] . [NorthAmericanMamm

AS JOIN a.Id, a.Name

JOIN Animal a

AS SELECT a.Id, a.Name

FROM Animal a

Explicación

Pregunta 53 de 128

Which statement will result in the creation of an index?

Selecciona una de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 54 de 128

Your database contains a table named Customer.
You need to delete the record from the Customer table that has a CusromerID of 12345.
Which statement should you use?

Selecciona una de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 55 de 128

Selecciona la opción correcta de los menús desplegables para completar el texto.

The following illustration shows the structure of a clustered index in a single partition:

Instructions: Use the drop-down menus to select the answer choice that completes each
statement Each correct selection is worth one point.

A clustered index improves the performance of queries that ( return large result sets, return a range of values by using the =, do not use ODER BY or GROUP BY clauses ).

A clustered index improves the performance of queries on columns that ( are accessed randomly, are accessed sequentially, are not unique or contain many common va ).

Explicación

Pregunta 56 de 128

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:
SELECT =
FROM Cars
LEFT OUTER JOIN Colors
ON Cars.ColorID = Colors.ColorID

How many rows does the SQL statement return?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 57 de 128

You have a table named Product. You create a view that includes all the products from the
Product table that are in the Furniture category.
You execute a statement on the Product table that deletes all the products in the Furniture
category.
After you execute the statement, the result set of the view is:

Selecciona una de las siguientes respuestas posibles:

Empty
Deleted
Unchanged
Archived

Explicación

Pregunta 58 de 128

Which command should you use to add a column to an existing table?

Selecciona una de las siguientes respuestas posibles:

MODIFY
ALTER
UPDATE
INSERT
CHANGE

Explicación

Pregunta 59 de 128

A named group of SQL statements that can be executed in a database is called a:

Selecciona una de las siguientes respuestas posibles:

Subroutine
Formula
Stored procedure
Method

Explicación

Pregunta 60 de 128

What defines the amount of storage space that is allocated to a value in a column?

Selecciona una de las siguientes respuestas posibles:

format
key
data type
validator

Explicación

Pregunta 61 de 128

You accept an IT internship at a local charity. The charity asks you to keep a record of its
volunteers by using a database table named Volunteer.
The table has the following columns and rows:

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 62 de 128

You accept an IT internship at a local charity. The charity wants you to help them with
compliance and auditing requirements.
You need to ensure that a column or combination of columns uniquely identifies each row
of a table.
Which constraint should you define?

Selecciona una de las siguientes respuestas posibles:

Primary key
Secondary key
Foreign key
Default key

Explicación

Pregunta 63 de 128

Selecciona la opción correcta de los menús desplegables para completar el texto.

Instructions: For each of the following statements, select Yes if the statement is true.
Otherwise, select No. Each correct selection is worth one point.

A full database backup is a copy of all of the data in the entire database. ( Yes, No )

A transaction log backup backs up all the data in the database. ( Yes, No )

A differential backup copies only data that was changed before the last full backup. ( Yes, No )

A file or filegroup restore specifies a portion of the database to recover. ( Yes, No )

Explicación

Pregunta 64 de 128

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?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 65 de 128

You need to enable a new employee to authenticate to your database.
Which command should you use?

Selecciona una de las siguientes respuestas posibles:

ALLOW USER
CREATE USER
ADD USER
INSERT USER
ALTER USER

Explicación

Pregunta 66 de 128

You have a table named Product. The Product table has columns for ProductDescription
and ProductCategory.
You need to change the ProductCategory value for all the spoons in the Product table to
43.
Which statement should you use?

Selecciona una de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 67 de 128

You need to combine the results of two queries into a single result that contains all of the
rows from both queries.
Which Structured Query Language (SQL) statement should you use?

Selecciona una de las siguientes respuestas posibles:

TRUNCATE
JOIN
EXCEPT
UNION

Explicación

Pregunta 68 de 128

This question requires that you evaluate the underlined text to determine if it is correct.
The CREATE TABLE command removes one or more table definitions and all data,
indexes, triggers, constraints, and permission specifications for those 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 correct

Selecciona una de las siguientes respuestas posibles:

No change is needed
DROP TABLE
TRUNCATE TABLE
ALTER TABLE

Explicación

Pregunta 69 de 128

You execute a statement inside a transaction to delete 100 rows from a table. The
transaction fails after only 40 rows are deleted.
What is the result in the database?

Selecciona una de las siguientes respuestas posibles:

The table will be corrupted.
Forty (40) rows will be deleted from the table.
The transaction will restart.
No rows will be deleted from the table.

Explicación

Pregunta 70 de 128

You need to rename a column in a database table.
Which data definition language (DDL) statement should you use?

Selecciona una de las siguientes respuestas posibles:

ALTER
INSERT
CREATE
UPDATE

Explicación

Pregunta 71 de 128

This question requires that you evaluate the underlined text to determine if it is correct.
Use the ALTER statement to add a new table in a database.
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.

Selecciona una de las siguientes respuestas posibles:

No change is needed
UPDATE
INSERT
CREATE

Explicación

Pregunta 72 de 128

This question requires that you evaluate the underlined text to determine if it is correct.
In a database table, each column represents a unique record.
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

Selecciona una de las siguientes respuestas posibles:

No change is needed
Table
Index
Row

Explicación

Pregunta 73 de 128

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

Selecciona una de las siguientes respuestas posibles:

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.

Explicación

Pregunta 74 de 128

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.

Selecciona una de las siguientes respuestas posibles:

No change is needed.
Composite keys
Duplicate rows
Foreign keys

Explicación

Pregunta 75 de 128

This question requires that you evaluate the underlined text to determine if it is correct.
Views are database objects that contain all of the data in a database.
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

Selecciona una de las siguientes respuestas posibles:

No change is needed
Queries
Stored procedures
Tables

Explicación

Pregunta 76 de 128

You develop a database to store data about textbooks. The data must be stored to process
at a later time.
Which database object should you use to store the data?

Selecciona una de las siguientes respuestas posibles:

View
Table
Function
Stored procedure

Explicación

Pregunta 77 de 128

You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName
FROM Employee, Department
This type of operation is called a/an:

Selecciona una de las siguientes respuestas posibles:

Intersection
Outer join
Equi-join
Cartesian product

Explicación

Pregunta 78 de 128

Which statement creates a composite key?

Selecciona una de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 79 de 128

What is one difference between an update statement and a delete statement?

Selecciona una de las siguientes respuestas posibles:

An update statement can change only one row.
A delete statement cannot use a where clause.
An update statement does not remove rows from a table.
A delete statement works only within a stored procedure.

Explicación

Pregunta 80 de 128

You work at a restaurant and they ask you to help them with a data issue.
They provide you with the following recipe data:

You need to normalize the data to third normal form.
How many tables should you create?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 81 de 128

Which command should you use to give a user permission to read the data in a table?

Selecciona una de las siguientes respuestas posibles:

ALLOW SELECT
LET READ
PERMIT READ
GRANT SELECT

Explicación

Pregunta 82 de 128

You need to store the first name, last name, and student ID for 100 students.
This information will be stored in a table as:

Selecciona una de las siguientes respuestas posibles:

100 items and three cells.
100 rows and three columns.
three rows and 100 columns.
three items and 100 cells.

Explicación

Pregunta 83 de 128

You have a Customer table and an Order table. You join the Customer table with the Order
table by using the CusromerID column.
The results include:
✑ All customers and their orders
✑ Customers who have no orders
Which type of join do these results represent?

Selecciona una de las siguientes respuestas posibles:

Complete join
Partial join
Inner join
Outer join

Explicación

Pregunta 84 de 128

This question requires that you evaluate the underlined text to determine if it is correct.
Use the ALLOW SELECT command to give a user permission to read the data 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

Selecciona una de las siguientes respuestas posibles:

No change is needed
GRANT SELECT
LET HEAD
PERMIT READ

Explicación

Pregunta 85 de 128

This question requires that you evaluate the underlined text to determine if it is correct.
Use the FROM keyword in a SELECT statement to return rows that meet a specific
condition.
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

Selecciona una de las siguientes respuestas posibles:

No change is needed
ORDER BY
UNION
WHERE

Explicación

Pregunta 86 de 128

First normal form requires that a database excludes:

Selecciona una de las siguientes respuestas posibles:

Foreign keys
Composite keys
Duplicate rows
Repeating groups

Explicación

Pregunta 87 de 128

You have a database table that contains the following columns:

Selecciona una o más de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 88 de 128

On which database structure does an update statement operate?

Selecciona una de las siguientes respuestas posibles:

Table
User
Trigger
Role

Explicación

Pregunta 89 de 128

You need to establish a set of permissions that you can routinely assign to new users.
What should you create?

Selecciona una de las siguientes respuestas posibles:

Resource
Group
List
Role

Explicación

Pregunta 90 de 128

You need to retrieve data from two related database tables based on a column that exists
in both tables.
Which command should you use in a query?

Selecciona una de las siguientes respuestas posibles:

INTERSECT
UNION
JOIN
TRUNCATE

Explicación

Pregunta 91 de 128

You have a table named Product that contains the following data.

The PrcducrID column is the primary key. The CategoryID column is a foreign key to a
separate table named Category.
You execute the following statement:
INSERT INTO Product
VALUES (3296, 'Table', 4444)
What is the result?

Selecciona una de las siguientes respuestas posibles:

a foreign key constraint violation
a syntax error
a new row in the Product table
a primary key constraint violation
a new row in the Category table

Explicación

Pregunta 92 de 128

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

Selecciona una de las siguientes respuestas posibles:

No change is needed
Column
Data type
View

Explicación

Pregunta 93 de 128

You have two tables. Each table has three rows.
How many rows will be included in the Cartesian product of these two tables?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 94 de 128

In SQL, an insert statement is used to add a:

Selecciona una de las siguientes respuestas posibles:

User to a database.
Row of data to a table.
Table to a database.
Column to a table definition.

Explicación

Pregunta 95 de 128

Which type of index changes the order in which the data is stored in a table?

Selecciona una de las siguientes respuestas posibles:

non-sequential
sequential
non-clustered
clustered

Explicación

Pregunta 96 de 128

You assign User1 a set of permissions that include the WITH GRANT OPTION.
The WITH GRANT OPTION enables User1 to:

Selecciona una de las siguientes respuestas posibles:

request a log of permission use.
delegate permissions to other users.
create new database users.
view other users' permissions.

Explicación

Pregunta 97 de 128

You are creating a table to store customer data. The AccountNumber column uses values
that always consist of one letter and four digits. Which data type should you use for the
AccountNumber column?

Selecciona una de las siguientes respuestas posibles:

CHAR
BYTE
DOUBLE
SMALLINT

Explicación

Pregunta 98 de 128

You accept an IT internship at a local charity. The charity asks you to keep a record of its
volunteers by using a database table named Volunteer.
When volunteers ask to be removed from mailing lists, the table must be updated.
You need to use a transaction to ensure that the database has data integrity and referential
integrity.
Which statement should you use?

Selecciona una de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 99 de 128

Selecciona la opción correcta de los menús desplegables para completar el texto.

The following graphic shows the components of a SQL Server application. You access the
SQL Server application through Internet Explorer.

The ( client, www.contoso.com, s01.contoso.com ) computer is the first line of defense against SQL injections and weak input validation.

The ( client, www.contoso.com, s01.contoso.com ) computer should be formatted with NTFS to protect program, database, and log files from unauthorized access.

Explicación

Pregunta 100 de 128

In which situation do you need to perform a restore on a database?

Selecciona una de las siguientes respuestas posibles:

when data becomes corrupted in the database
when you need to roll back a transaction
when you encounter an error in your application
when data needs to be deleted from the database

Explicación

Pregunta 101 de 128

You have a database table that stores information about school attendance.
You have a data set that is defined as follows:

Arrastra la opción correcta a cada uno de los puntos naranjas

BIT

DATETIME

VARCHAR

CHAR

INT

DECIMAL

Explicación

Pregunta 102 de 128

Which database term is used to describe the process of applying a backup to a damaged
or corrupt database?

Selecciona una de las siguientes respuestas posibles:

Recover
Restore
Commit
Attach

Explicación

Pregunta 103 de 128

You need to store product quantities, and you want to minimize the amount of storage
space that is used. Which data type should you use?

Selecciona una de las siguientes respuestas posibles:

INTEGER
DOUBLE
COUNT
FLOAT

Explicación

Pregunta 104 de 128

Which statement should you use to remove a foreign key?

Selecciona una de las siguientes respuestas posibles:

ALTER TABLE
DELETE TABLE
DELETE FOREIGN KEY
ALTER FOREIGN KEY

Explicación

Pregunta 105 de 128

Selecciona la opción correcta de los menús desplegables para completar el texto.

You have the following table:

Adding a ( foreign key, clustered index, nonclustered index ) on the FlightNumber column physically sorts rows in the table by FlightNumber.

Adding a ( foreign key, clustered index, nonclustered index ) on the Airline column retrieves data faster, but will not physically sort rows in the table by Airline.

Explicación

Pregunta 106 de 128

What are three valid data manipulation language (DML) commands? (Choose three.)

Selecciona una o más de las siguientes respuestas posibles:

INSERT
COMMIT
DELETE
OUTPUT
UPDATE

Explicación

Pregunta 107 de 128

Denormalization is performed in order to:

Selecciona una de las siguientes respuestas posibles:

Reduce redundancy.
Eliminate repeating groups.
Create smaller tables.
Improve query performance.

Explicación

Pregunta 108 de 128

You need to add rows to a database table.
Which Structured Query Language (SQL) keyword should you use?

Selecciona una de las siguientes respuestas posibles:

JOIN
INSERT
CREATE
UPDATE

Explicación

Pregunta 109 de 128

Which permission does a user need in order to run a stored procedure?

Selecciona una de las siguientes respuestas posibles:

EXECUTE
ALLOW
CALL
RUN

Explicación

Pregunta 110 de 128

Which command should you use to remove a table from a database?

Selecciona una de las siguientes respuestas posibles:

REMOVE TABLE
UPDATE TABLE
DROP TABLE
DELETE TABLE

Explicación

Pregunta 111 de 128

This question requires that you evaluate the underlined text to determine if it is correct.
Create a query that returns a set of table data by using the UPDATE statement.
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.

Selecciona una de las siguientes respuestas posibles:

No change is needed
INSERT
REPLACE
SELECT

Explicación

Pregunta 112 de 128

Selecciona la opción correcta de los menús desplegables para completar el texto.

Instructions: For each of the following statements, select Yes if the statement is true.
Otherwise, select No. Each correct selection is worth one point.

You can delete data by using a stored procedure. ( Yes, No )

A function must have a return value. ( Yes, No )

A stored procedure must have a return value. ( Yes, No )

Explicación

Pregunta 113 de 128

Which key uniquely identifies a row in a table?

Selecciona una de las siguientes respuestas posibles:

foreign
primary
local
superkey

Explicación

Pregunta 114 de 128

You have a table that contains the following data.

Selecciona una de las siguientes respuestas posibles:

defragmentation
normalization
fragmentation
denormalization

Explicación

Pregunta 115 de 128

Which constraint ensures a unique value in the ID column for each customer?

Selecciona una de las siguientes respuestas posibles:

DISTINCT
FOREIGN KEY
SEQUENTIAL
PRIMARY KEY

Explicación

Pregunta 116 de 128

You have a table that contains product IDs and product names.
You need to write an UPDATE statement to change the name of a specific product to
glass.
What should you include in the update statement?

Selecciona una de las siguientes respuestas posibles:

SET ProduetName = 'glass'
LET ProduetName = 'glass'
EXEC ProduetName = 'glass'
ASSIGN ProduetName = 'glass'

Explicación

Pregunta 117 de 128

You need to populate a table named EmployeeCopy with data from an existing table
named Employee.
Which statement should you use?

Selecciona una de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 118 de 128

You are writing a select statement to find every product whose name contains a specific
character.
Which keyword should you use in your where clause?

Selecciona una de las siguientes respuestas posibles:

FIND
BETWEEN
INCLUDES
LIKE

Explicación

Pregunta 119 de 128

This question requires that you evaluate the underlined text to determine if it is correct.
Use indexing to create, remove, or change database objects.
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.

Selecciona una de las siguientes respuestas posibles:

No change is needed
Data manipulation language (DML) statements
Data definition language (DDL) statements
A unique constraint

Explicación

Pregunta 120 de 128

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:

Selecciona una de las siguientes respuestas posibles:

Inherited delete
Cascade delete
Functional delete
Waterfall delete
Domino delete

Explicación

Pregunta 121 de 128

You are writing an SQL statement to retrieve rows from a table.
Which data manipulation language (DML) command should you use?

Selecciona una de las siguientes respuestas posibles:

READ
SELECT
OUTPUT
GET

Explicación

Pregunta 122 de 128

You need to list the name and price of each product, sorted by price from highest to lowest.
Which statement should you use

Selecciona una de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 123 de 128

Data in a database is stored in:

Selecciona una de las siguientes respuestas posibles:

Tables
Queries
Data types
Stored procedures

Explicación

Pregunta 124 de 128

You have a table named Employee that includes the following columns:
EmployeeID
Smp1oyeeName
Which statement should you use to return the number of rows in the table?

Selecciona una de las siguientes respuestas posibles:

Option A
Option B
Option C
Option D

Explicación

Pregunta 125 de 128

Which two elements are required to define a column? (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

A name
A key
An index
A data type

Explicación

Pregunta 126 de 128

This question requires that you evaluate the underlined text to determine if it is correct.
Truncate is a database term used to describe the process of applying a backup to a
damaged or corrupt database.
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.

Selecciona una de las siguientes respuestas posibles:

No Change is needed
Commit
Attach
Restore

Explicación

Pregunta 127 de 128

Selecciona la opción correcta de los menús desplegables para completar el texto.

The following illustration shows backup strategies that use the simple recovery model and
the full recovery model:

Using the simple recovery model for database backups provides ( less, more, the same ) work-loss exposure than the full recovery model.

Using the simple recovery model for database backups provides ( less, more, the same ) log file backups than the full recovery model.

Explicación

Pregunta 128 de 128

One reason to create a stored procedure is to:

Selecciona una de las siguientes respuestas posibles:

Improve performance.
Minimize storage space.
Bypass case sensitivity requirements.
Give the user control of the query logic.

Explicación

Revisar respuesta

["https://cdn.goconqr.com/uploads/media/image/15364976/desktop_f3c37443-e839-43e2-b09d-bece9cd89bfc.png","https://cdn.goconqr.com/uploads/media/image/15365027/desktop_7331a2b3-c0aa-47d2-a831-54430af3c058.png","https://cdn.goconqr.com/uploads/media/image/15365175/desktop_f631a125-9058-462a-b4af-c5f7085646ad.png","https://cdn.goconqr.com/uploads/media/image/15365277/desktop_5eabe565-1574-4d63-8ead-475ea2f5ac2b.png","https://cdn.goconqr.com/uploads/media/image/15390173/desktop_0742e265-d544-4b4a-8d13-14821575bcec.png","https://cdn.goconqr.com/uploads/media/image/15390331/desktop_dc45a037-2a42-4c54-a14c-aa6be5afd7cd.png","https://cdn.goconqr.com/uploads/media/image/15390559/desktop_9d748894-2b17-4698-8dea-6924688a6443.png","https://cdn.goconqr.com/uploads/media/image/15390615/desktop_5fc2ad98-89d5-4ccb-b339-64b3cb87f764.png","https://cdn.goconqr.com/uploads/media/image/15390767/desktop_5d317ca5-7217-4dbd-8a5c-751139d5b7af.png","https://cdn.goconqr.com/uploads/media/image/15482824/desktop_c4b0cd43-6828-44d7-a350-cb2496ec17d6.png","https://cdn.goconqr.com/uploads/media/image/15482894/desktop_4390dfb1-2e4d-4325-a0c4-2d7cd7e4a40d.png","https://cdn.goconqr.com/uploads/media/image/15482916/desktop_101a3e5a-1472-4414-b85c-a2501ef002be.png","https://cdn.goconqr.com/uploads/media/image/15482963/desktop_0b299714-4185-4943-bd69-9e8f9028025a.png","https://cdn.goconqr.com/uploads/media/image/15483039/desktop_0bd3c5c8-df0c-4089-90e0-0ec187607c9b.png","https://cdn.goconqr.com/uploads/media/image/15483049/desktop_b918a817-760e-4009-816c-5dba05e10cf1.png","https://cdn.goconqr.com/uploads/media/image/15483071/desktop_b6b7954a-e279-4947-adbf-a1a77fc77a6b.png","https://cdn.goconqr.com/uploads/media/image/15483128/desktop_ac5977d6-5805-4aed-8587-2ff88ab15994.png","https://cdn.goconqr.com/uploads/media/image/15483140/desktop_8b9c33e2-31cf-445a-b4a4-b4cca67f5a50.png","https://cdn.goconqr.com/uploads/media/image/15483163/desktop_f2ae836a-aa5a-4b5b-a5bc-971a8d979795.png","https://cdn.goconqr.com/uploads/media/image/15501209/desktop_009ac923-02ca-42d5-9841-151149ffd2c7.png","https://cdn.goconqr.com/uploads/media/image/15501551/desktop_77f85da6-44be-4359-b75d-86ce15f89b39.png","https://cdn.goconqr.com/uploads/media/image/15501722/desktop_5169a93c-817b-4003-9b56-f89ab366eff3.png","https://cdn.goconqr.com/uploads/media/image/15501889/desktop_8ce3a5e7-db91-4da9-aa84-bc59823e24ef.png","https://cdn.goconqr.com/uploads/media/image/15502068/desktop_f5eb5ece-773b-46c6-a394-02a271cb4bad.png","https://cdn.goconqr.com/uploads/media/image/15502086/desktop_3c01e440-158f-4b97-82a0-0dd25115a716.png","https://cdn.goconqr.com/uploads/media/image/15518543/desktop_4b82b231-1932-4412-a6a2-7030555e1192.PNG","https://cdn.goconqr.com/uploads/media/image/15518602/desktop_6e1d3bce-6abb-44b0-ab7a-d36edc0daa69.png","https://cdn.goconqr.com/uploads/media/image/15518742/desktop_1044264f-9891-489e-9206-992992924b9f.png","https://cdn.goconqr.com/uploads/media/image/15518898/desktop_c0a42485-9df8-4ab4-bfcf-284945f1e286.png","https://cdn.goconqr.com/uploads/media/image/15518949/desktop_25dab97f-ba77-49f0-b789-a12174b61250.PNG","https://cdn.goconqr.com/uploads/media/image/15518998/desktop_5117a2b0-34d0-4c99-b6d4-cb869bb42c97.png","https://cdn.goconqr.com/uploads/media/image/15519109/desktop_4fee6031-baaa-42e9-961d-0248bda6bea6.PNG","https://cdn.goconqr.com/uploads/media/image/15519128/desktop_25e55f59-9cf5-4951-a585-e1d381b1babd.png","https://cdn.goconqr.com/uploads/media/image/15519194/desktop_db1a3ed9-cf61-422d-986e-4d7daa43982d.png","https://cdn.goconqr.com/uploads/media/image/15519212/desktop_31c5bc31-fffb-4d9b-8062-2baeda4c649f.png","https://cdn.goconqr.com/uploads/media/image/15519227/desktop_ea28f3ee-a5be-411d-9829-f95b549c419b.png","https://cdn.goconqr.com/uploads/media/image/15390394/desktop_61c159b9-7a0f-4b7a-8bb8-b3801c7eeacb.PNG","https://cdn.goconqr.com/uploads/media/image/15390418/desktop_d88c5099-0ca6-4437-bb61-2586e1e090b7.PNG","https://cdn.goconqr.com/uploads/media/image/15390435/desktop_658ecb9a-7c0a-492d-b488-f83a410f97c3.PNG","https://cdn.goconqr.com/uploads/media/image/15390445/desktop_3db5c036-d9f0-4c36-8c4a-724bc5eb8fa7.PNG","https://cdn.goconqr.com/uploads/media/image/15501581/desktop_c70b18d7-ceb0-485e-9cbb-521fcb6f08b3.PNG","https://cdn.goconqr.com/uploads/media/image/15501583/desktop_47513c00-efa5-45a4-9850-fff2c1392e2b.PNG","https://cdn.goconqr.com/uploads/media/image/15501595/desktop_4e340b14-503a-4021-8249-9e0c58e21275.PNG","https://cdn.goconqr.com/uploads/media/image/15501594/desktop_e4b97b53-6dc2-4369-bdd1-a6a4948754cc.PNG"]

	Creado por JOSHUA BEKIARIS hace alrededor de 6 años

https://www.exam-labs.com/exam/98-364 MTA 98-364

MTA 98-364

Pregunta 1 de 128

You have the following table definition: CREATE TABLE Road (RoadID 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?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 2 de 128

A view can be used to:

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 3 de 128

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 4 de 128

Which statement deletes the rows where the employee's phone number is not entered?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 5 de 128

You have the following SQL query SELECT * FROM dbo.ProAthlete WHERE Salary > 500000 The query takes too much time to return data. You need to improve the performance of the query. Which item should you add to the Salary column?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 6 de 128

Which two keys establish a relationship between two tables? (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 7 de 128

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 8 de 128

Arrastra la opción correcta a cada uno de los puntos naranjas

Explicación

Pregunta 9 de 128

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 10 de 128

Selecciona la opción correcta de los menús desplegables para completar el texto.

Explicación

Pregunta 11 de 128

One reason to add an index is to:

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 12 de 128

You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column. You execute the following statement: DELETE FROM Student What is the result?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 13 de 128

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 14 de 128

Which keyword would you use in a select statement to return rows that meet a specific condition?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 15 de 128

You have a table named Product that contains one million rows. You need to search for product information in the Product table by using the product's unique ID. What will make this type of search more efficient?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 16 de 128

You need to remove a view named EmployeeView from your database. Which statement should you use?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 17 de 128

Which category of SQL statements is used to add, remove, and modify database structures?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 18 de 128

You need to delete a database table. Which data definition language (DDL) keyword should you use?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 19 de 128

You have the following table definition: CREATE TABLE Product (ProductID INTEGER, Name VARCHAR(20)) You need to insert a new product. The product's name is Plate and the product's ID is 12345. Which statement should you use?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 20 de 128

One difference between a function and a stored procedure is that a function:

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 21 de 128

Selecciona la opción correcta de los menús desplegables para completar el texto.

Explicación

Pregunta 22 de 128

You have the following table definition:
CREATE TABLE Road
(RoadID 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?

You have the following SQL query
SELECT * FROM dbo.ProAthlete WHERE Salary > 500000
The query takes too much time to return data.
You need to improve the performance of the query.
Which item should you add to the Salary column?

You have a table named Student that contains 100 rows. Some of the rows have a NULL
value in the FirstName column.
You execute the following statement:
DELETE FROM Student
What is the result?

Which keyword would you use in a select statement to return rows that meet a specific
condition?

You have a table named Product that contains one million rows.
You need to search for product information in the Product table by using the product's
unique ID.
What will make this type of search more efficient?

You need to remove a view named EmployeeView from your database.
Which statement should you use?

Which category of SQL statements is used to add, remove, and modify database
structures?

You need to delete a database table.
Which data definition language (DDL) keyword should you use?

You have the following table definition:
CREATE TABLE Product
(ProductID INTEGER,
Name VARCHAR(20))
You need to insert a new product. The product's name is Plate and the product's ID is
12345.
Which statement should you use?

You have a database table named SongInformation as defined below:

You need to create a Structured Query Language (SQL) query to retrieve only the names
of songs that sold more than 1000 compact discs (CDs).
Which query should you use?

The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?

Needs to be rechecked on ExamLabs, one person asked why is C correct and it had three likes on that comment

While attending college, you accept an IT internship at a local charity. The charity needs to
report on data that is related and exists in two tables.
You need to establish a relationship between the data that is in the two tables.
Which constraint should you define?

You have a Department table and an Employee table in your database.
You need to ensure that an employee can be assigned to only an existing department.
What should you apply to the Employee table?

You need to disable User1's access to view the data in the Customer table.
Which statement should you use?

You need to store product names that vary from three to 30 characters. You also need to
minimize the amount of storage space that is used.
Which data type should you use?

You have a table that contains information about all students in your school.
Which SQL keyword should you use to change a student's first name in the table?

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?

You have two tables named Salesperson and Sales.
You need to ensure that each record in the Sales table has a valid associated salesperson
record in the Salesperson table.
Which database object should you add to the Sales table?

You work at a coffee shop. They ask you to set up a website that stores charges on
purchases.
You need to recommend a data type in a database table to run financial functions against
the charged amounts.
Which data type should you recommend?