SQL Server MTA 98-364

Das ist ein zeitlich begrenztes Quiz.

Du hast 2 Stunden um die 145 Fragen in diesem Quiz zu beantworten.

Starte das Quiz

Bitte warte - es wird geladen…

Frage 1 von 145

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

Wähle eine der folgenden:

View
Functon
Index
Stored procedure
Trigger

Erklärung

Frage 2 von 145

One reason to add an index is to:

Wähle eine der folgenden:

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

Erklärung

Frage 3 von 145

You have a table that contains the following data.

You break the table into the following two tables.

This process is referred to as:

Wähle eine oder mehr der folgenden:

defragmentaton
normalizaton
fragmentaton
denormalizaton

Erklärung

Frage 4 von 145

You have a table that contains the following data.

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

Wähle eine der folgenden:

Cohort
Relatonally dependent
Deterministc
Functonally dependent
Compositonal

Erklärung

Frage 5 von 145

Which key uniquely identies a row in a table?

Wähle eine der folgenden:

foreiqn
primary
local
superkey

Erklärung

Frage 6 von 145

Which statement creates a composite key?

Wähle eine der folgenden:

Opton A
Opton B
Opton C
Opton D

Erklärung

Frage 7 von 145

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?

Wähle eine der folgenden:

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

Erklärung

Frage 8 von 145

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

Wähle eine der folgenden:

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

Erklärung

Frage 9 von 145

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

Wähle eine der folgenden:

ALLOW SELECT
LET READ
PERMIT READ
GRANT SELECT

Erklärung

Frage 10 von 145

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

Wähle eine der folgenden:

ALLOW USER
CREATE USER
ADD USER
INSERT USER
ALTER USER

Erklärung

Frage 11 von 145

Which keyword can be used in a create table statement?

Wähle eine der folgenden:

ORDER BY
DISTINCT
GROUP BY
UNIQUE

Erklärung

Frage 12 von 145

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

Wähle eine der folgenden:

INTEGER
DOUBLE
COUNT
FLOAT

Erklärung

Frage 13 von 145

Which statement will result in the creaton of an index?

Wähle eine der folgenden:

Option A
Option B
Option C
Option D

Erklärung

Frage 14 von 145

You have the following table deiniton:
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?

Wähle eine der folgenden:

an error statng that NULL values are not allowed
a new row in the table
an error statng that duplicate IDs are not allowed
a syntax error

Erklärung

Frage 15 von 145

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?

Wähle eine der folgenden:

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

Erklärung

Frage 16 von 145

One reason to create a stored procedure is to:

Wähle eine der folgenden:

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

Erklärung

Frage 17 von 145

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

Wähle eine der folgenden:

EXECUTE
ALLOW
CALL
RUN

Erklärung

Frage 18 von 145

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.
Afer you execute the statement, the result set of the view is:

Wähle eine der folgenden:

Empty
Deleted
Unchanged
Archived

Erklärung

Frage 19 von 145

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

Wähle eine der folgenden:

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

Erklärung

Frage 20 von 145

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

Wähle eine der folgenden:

Erklärung

Frage 21 von 145

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

Wähle eine der folgenden:

READ
SELECT
OUTPUT
GET

Erklärung

Frage 22 von 145

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

Wähle eine der folgenden:

DISTINCT
FOREIGN KEY
SEQUENTIAL
PRIMARY KEY

Erklärung

Frage 23 von 145

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

Wähle eine der folgenden:

Data type
Row
Column
View

Erklärung

Frage 24 von 145

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

Wähle eine der folgenden:

Intersection
Outer join
Equi-join
Cartesian product

Erklärung

Frage 25 von 145

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

Wähle eine der folgenden:

MODIFY
ALTER
UPDATE
INSERT
CHANGE

Erklärung

Frage 26 von 145

You have the following table deiniton:
CREATE TABLE Product
(ID INTEGER PRIMARY KEY,
Name VARCHAR(20),
Quantty INTEGER)
The Product table contains the following data.

You execute the following statement:
SELECT Name FROM Product WHERE Quantty IS NOT NULL
How many rows are returned?

Wähle eine der folgenden:

Erklärung

Frage 27 von 145

You are writng a select statement to ind every product whose name contains a speciic character.
Which keyword should you use in your where clause?

Wähle eine der folgenden:

FIND
BETWEEN
INCLUDES
LIKE

Erklärung

Frage 28 von 145

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

Wähle eine der folgenden:

The irst 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.

Erklärung

Frage 29 von 145

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

Wähle eine der folgenden:

Opton A
Opton B
Opton C
Opton D

Erklärung

Frage 30 von 145

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

Wähle eine der folgenden:

UPDATE
CHANGE
SELECT
INSERT

Erklärung

Frage 31 von 145

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

Wähle eine der folgenden:

Option A
Option B
Option C
Option D

Erklärung

Frage 32 von 145

You execute the following statement:

Wähle eine der folgenden:

Subquery
Union
Outer join
Cartesian product

Erklärung

Frage 33 von 145

Which keyword would you use in a select statement to return rows that meet a speciic conditon?

Wähle eine der folgenden:

WHERE
UNION
ORDER BY
FROM

Erklärung

Frage 34 von 145

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?

Wähle eine der folgenden:

Option A
Option B
Option C
Option D

Erklärung

Frage 35 von 145

The Product table contains the following data.

You execute the following statement:
SELECT COUNT(*)
FROM Product WHERE Quantty > 18
What is the value returned by this statement?

Wähle eine der folgenden:

Erklärung

Frage 36 von 145

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

Wähle eine der folgenden:

REMOVE TABLE
UPDATE TABLE
DROP TABLE
DELETE TABLE

Erklärung

Frage 37 von 145

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

Wähle eine der folgenden:

Stored procedure
Function
Row
Variable

Erklärung

Frage 38 von 145

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

Wähle eine der folgenden:

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

Erklärung

Frage 39 von 145

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?

Wähle eine der folgenden:

Complete join
Partial join
Inner join
Outer join

Erklärung

Frage 40 von 145

Data in a database is stored in:

Wähle eine der folgenden:

Tables
Queries
Data types
Stored procedures

Erklärung

Frage 41 von 145

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?

Wähle eine der folgenden:

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 deiniton will be deleted.

Erklärung

Frage 42 von 145

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

Wähle eine der folgenden:

Resource
Group
List
Role

Erklärung

Frage 43 von 145

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

Wähle eine der folgenden:

Recover
Restore
Commit
Atach

Erklärung

Frage 44 von 145

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

Wähle eine der folgenden:

Option A
Option B
Option C
Option D

Erklärung

Frage 45 von 145

Denormalizaton is performed in order to:

Wähle eine der folgenden:

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

Erklärung

Frage 46 von 145

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

Wähle eine der folgenden:

A cursor
A subquery
A trigger
An index

Erklärung

Frage 47 von 145

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?

Wähle eine der folgenden:

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

Erklärung

Frage 48 von 145

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

Wähle eine oder mehr der folgenden:

candidate
foreign
superkey
local
primary

Erklärung

Frage 49 von 145

One diference between a functon and a stored procedure is that a functon:

Wähle eine der folgenden:

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

Erklärung

Frage 50 von 145

Which keyword must be included in a create view statement?

Wähle eine der folgenden:

WHERE
ORDER BY
UPDATE
SELECT

Erklärung

Frage 51 von 145

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

Wähle eine der folgenden:

Option A
Option B
Option C
Option D

Erklärung

Frage 52 von 145

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

Wähle eine der folgenden:

DELETE VIEW EmployeeView
DELETE EmployeeView
DROP EmployeeView
DROP VIEW EmployeeView

Erklärung

Frage 53 von 145

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

Wähle eine der folgenden:

Subroutine
Formula
Stored procedure
Method

Erklärung

Frage 54 von 145

A view can be used to:

Wähle eine der folgenden:

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

Erklärung

Frage 55 von 145

On which database structure does an update statement operate?

Wähle eine der folgenden:

Table
User
Trigger
Role

Erklärung

Frage 56 von 145

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

Wähle eine der folgenden:

Option A
Option B
Option C
Option D

Erklärung

Frage 57 von 145

You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatcally deleted.
This process is an example of a/an:

Wähle eine der folgenden:

Inherited delete
Cascade delete
Functional delete
Waterfall delete
Domino delete

Erklärung

Frage 58 von 145

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

Wähle eine der folgenden:

Option A
Option B
Option C
Option D

Erklärung

Frage 59 von 145

You need to insert two new products into the Product table. The irst 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?

Wähle eine der folgenden:

OptIon A
OptIon B
OptIon C
OptIon D

Erklärung

Frage 60 von 145

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

Wähle eine der folgenden:

all columns
only the last column
only the First column
only the First and last columns

Erklärung

Frage 61 von 145

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

Wähle eine oder mehr der folgenden:

A name
A key
An index
A data type

Erklärung

Frage 62 von 145

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

Wähle eine der folgenden:

format
key
data type
validator

Erklärung

Frage 63 von 145

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

Wähle eine der folgenden:

CHAR
BYTE
DOUBLE
SMALLINT

Erklärung

Frage 64 von 145

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

Wähle eine der folgenden:

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.

Erklärung

Frage 65 von 145

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 existng department.
What should you apply to the Employee table?

Wähle eine der folgenden:

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

Erklärung

Frage 66 von 145

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

Wähle eine der folgenden:

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

Erklärung

Frage 67 von 145

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

Wähle eine oder mehr der folgenden:

INSERT
COMMIT
DELETE
OUTPUT
UPDATE

Erklärung

Frage 68 von 145

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

Wähle eine der folgenden:

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

Erklärung

Frage 69 von 145

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

Wähle eine der folgenden:

non-sequental
sequental
non-clustered
clustered

Erklärung

Frage 70 von 145

Which statement should you use to remove a foreign key?

Wähle eine der folgenden:

ALTER TABLE
DELETE TABLE
DELETE FOREIGN KEY
ALTER FOREIGN KEY

Erklärung

Frage 71 von 145

First normal form requires that a database excludes:

Wähle eine der folgenden:

Foreign keys
Composite keys
Duplicate rows
Repeatng groups

Erklärung

Frage 72 von 145

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

Wähle eine der folgenden:

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

Erklärung

Frage 73 von 145

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

Wähle eine der folgenden:

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

Erklärung

Frage 74 von 145

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?

Wähle eine der folgenden:

OptIon A
OptIon B
OptIon C
OptIon D

Erklärung

Frage 75 von 145

On which database structure does an insert statement operate?

Wähle eine der folgenden:

Role
Trigger
User
Stored procedure
Table

Erklärung

Frage 76 von 145

You have a table of products with ields for ProductID, Name, and Price.
You need to write an UPDATE statement that sets the value in the InStock ield to Yes for a speciic ProductID.
Which clause should you use in your update statement?

Wähle eine der folgenden:

THAT
WHERE
GROUP BY
HAVING

Erklärung

Frage 77 von 145

You have the following table deiniton:
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?

Wähle eine der folgenden:

Option A
Option B
Option C
Option D

Erklärung

Frage 78 von 145

Wähle von der Dropdown-Liste, um den Text zu vervollständigen.

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

A full database backup is a copy of all of the data in the entire database ( Verdadero, Falso )

A transaction log backup baciks up all the data in the database ( Verdadero, Falso )

A differential backup copies only data that was changed before tje last full backup ( Verdadero, Falso )

A file or filegroup restore specifies a portion of the database to recover ( Verdadero, Falso )

Erklärung

Frage 79 von 145

Wähle von der Dropdown-Liste, um den Text zu vervollständigen.

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

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

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

Erklärung

Frage 80 von 145

You have the database table named Cars as deined below:

Wähle eine der folgenden:

Erklärung

Frage 81 von 145

You have a database table named SongInformaton as deined 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?

Wähle eine der folgenden:

Erklärung

Frage 82 von 145

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:

Wähle eine der folgenden:

Erklärung

Frage 83 von 145

This queston 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 deletons.
Instructons: 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.

Wähle eine der folgenden:

No change is needed
DROP TABLE
TRUNCATE TABLE
CREATE TABLE

Erklärung

Frage 84 von 145

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?

Wähle eine der folgenden:

TRUNCATE
JOIN
EXCEPT
UNION

Erklärung

Frage 85 von 145

Wähle von der Aufklappliste, um den Text zu vervollständigen.

This queston requires that you evaluate the underlined text to determine if it is correct.
( No change is needed, DROP TABLE, TRUNCATE TABLE, ALTER TABLE ) command removes one or more table deinitons and all data, indexes, triggers, constraints, and
permission speciicatons for those tables.
Instructons: 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

Erklärung

Frage 86 von 145

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?

Wähle eine der folgenden:

Primary key
Secondary key
Foreign key
Default Key

Erklärung

Frage 87 von 145

HOTSPOT
You have the following table:
Adding a [answer choice] on the FlightNumber column physically sorts rows in the by FlightNumber

Wähle eine der folgenden:

foreing key
clustered index
noclustered index

Erklärung

Frage 88 von 145

HOTSPOT
You have the following table:
Adding a [answer choice] on the Airline column retrieves data faster, but will not physically sort rows in the table by Airline

Wähle eine der folgenden:

foreing key
clustered index
noclustered index

Erklärung

Frage 89 von 145

While atending 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?

Wähle eine der folgenden:

Foreing Key
Index Key
Link Key
Default Key

Erklärung

Frage 90 von 145

This question requires that you evaluate the underlined text to determine if it is correct.
A view [can be used to ensure referental integrity].
Instructons: 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.

Wähle eine der folgenden:

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.

Erklärung

Frage 91 von 145

DRAG DROP
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 lef 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.

Ziehe eine Antwort zum richtigen orangen Punkt.

CREATE VIEW dbo.NorthAmericanMammal_View

GENERATE VIEW dbo.NorthAmericanMammal_Vi

AS JOIN a.Id , a.Name

AS SELECT a.Id, a.Name

FROM Animal a

JOIN Animal a

Erklärung

Frage 92 von 145

DRAG DROP
You have a database table that stores information about school atendance.
You have a data set that is defined as follows:
You have the following requirements:
StudentName must consist of a string of characters.
GradeLevel must be only a whole number.
DaysAbsent can have one number after the decimal.
Match the data types to the column names.

Ziehe eine Antwort zum richtigen orangen Punkt.

VARCHAR

CHAR

INT

BIT

DECIMAL

DATETIME

Erklärung

Frage 93 von 145

The VARCHAR data type contains only numeric characters.

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 94 von 145

The NUMERIC data type contains only numbers that have decimal places.

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 95 von 145

The INT data type contains only whole numbers.

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 96 von 145

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.
Instructons: 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.

Wähle eine der folgenden:

No change is needed
Table
Index
Row

Erklärung

Frage 97 von 145

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.

Instructons: 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.

Wähle eine der folgenden:

No change is needed
Zero
Three
Six

Erklärung

Frage 98 von 145

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?

Wähle eine der folgenden:

Nonclustered index
Primary key
Foreign key
Clustered index

Erklärung

Frage 99 von 145

DRAG DROP
Your class project requires that you help a charity set up a website.
The website collects informaton about volunteers. Each volunteer record must be uniquely identied.
The following informaton 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.
Instructons: To answer, drag the appropriate SQL statement from the column on the lef 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.

Ziehe eine Antwort zum richtigen orangen Punkt.

INT NOT NULL PRIMARY KEY

INT NOT NULL FOREING KEY

DATE NULL

TIMESTAMP NULL

IMAGE NULL

XML NULL

Erklärung

Frage 100 von 145

This queston 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.
Instructons: 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.

Wähle eine der folgenden:

No change is needed
UPDATE
INSERT
CREATE

Erklärung

Frage 101 von 145

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

Wähle eine der folgenden:

ALTER
INSERT
CREATE
UPDATE

Erklärung

Frage 102 von 145

Klicke auf jeden orangenen Punkt und wähle die korrekte Antwort.

DRAG DROP
You have two database tables as deined below. The First table contains informaton about students. The second table
contains informaton about courses. The two tables are related by CourseID.

Match the CourseName to the StudentName.
Instructons: To answer, drag the appropriate CourseName from the column on the lef to its StudentName on the
right. Each CourseName may be used once, more than once, or not at all. Each correct match is worth one point.

Erklärung

Frage 103 von 145

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

Wähle eine der folgenden:

No change is needed.
Data manipulaton language (DML) statements
Data deiniton language (DDL) statements
A unique constraint

Erklärung

Frage 104 von 145

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

Wähle eine der folgenden:

JOIN
INSERT
CREATE
UPDATE

Erklärung

Frage 105 von 145

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?

Wähle eine der folgenden:

INTERSECT
UNION
JOIN
TRUNCATE

Erklärung

Frage 106 von 145

You have a database table that contains the following columns, Which two Structured Query Language (SQL) statements can you use? (Choose two.)

Wähle eine oder mehr der folgenden:

Erklärung

Frage 107 von 145

This queston 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.
Instructons: 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

Wähle eine der folgenden:

No change is needed
INTERSECT
ALL
EXCEPT

Erklärung

Frage 108 von 145

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

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

Wähle eine der folgenden:

Erklärung

Frage 109 von 145

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

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.)

Wähle eine oder mehr der folgenden:

ChapterId
LanguageId
Country
Region
City
LanguageName

Erklärung

Frage 110 von 145

HOT SPOT Instructons: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selecton is worth one point.

A clustered index sorts and stores the data columns of a table or view in order, based on the clustered index hey.

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 111 von 145

HOT SPOT Instructons: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selecton is worth one point.

A non-clustered index is defined on a table or view by using a clustered index or heap

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 112 von 145

HOT SPOT Instructons: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selecton is worth one point.

A unique index ensures that the index key contains no duplicate values and that every row in the table or view in unique

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 113 von 145

HOT SPOT Instructons: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selecton is worth one point.

A filtered index is a clustered index that is optimized for queries that select a small percentage of rows from a table

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 114 von 145

This queston requires that you evaluate theu nderlined text todetermine if it is correct.
You combine data from three tables into one table. The new table includes redundancy to optmize read performance. The data in the new table has been denormalized.
Instructons: Review the under lined text. If it makes the statement correct, select "Nochangeisneeded." If the statementisincorrect, select the answer choice that makes the statement correct.

Wähle eine der folgenden:

No change is needed
Normalized
Truncated
Indexed

Erklärung

Frage 115 von 145

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

Wähle eine der folgenden:

ALTER
DELETE
DROP
TRUNCATE

Erklärung

Frage 116 von 145

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.]
Instructons: 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.

Wähle eine oder mehr der folgenden:

No change is needed
INSERT
REPLACE
SELECT

Erklärung

Frage 117 von 145

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?

Wähle eine der folgenden:

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

Erklärung

Frage 118 von 145

This queston 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.
Instructons: 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.

Wähle eine der folgenden:

Change is needed
Commit
Attach
Restore

Erklärung

Frage 119 von 145

This queston 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.
Instructons: 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

Wähle eine der folgenden:

No change is needed
GRANT SELECT
LET HEAD
PERMIT READ

Erklärung

Frage 120 von 145

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

The user can perfect [answer choice] actions on data that is on the serve

Wähle eine der folgenden:

no
read-only
unlimited

Erklärung

Frage 121 von 145

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

The user can perfect [answer choice] actions on data that is on the serve

Wähle eine der folgenden:

no
unlimited
configuration

Erklärung

Frage 122 von 145

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

Using the simple recovery model for database backups provides [answer choice] works-loss exposure than the full recovery model

Wähle eine der folgenden:

less
more
the same

Erklärung

Frage 123 von 145

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

Using the simple recovery model for database backups provides [answer choice] log file backups than the full recovery model

Wähle eine der folgenden:

less
more
the same

Erklärung

Frage 124 von 145

You can delete data by using a stored procedure

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 125 von 145

A function must have a return value

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 126 von 145

A stored procedure must have a return value

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 127 von 145

This queston 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.
Instructons: 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

Wähle eine oder mehr der folgenden:

No change is needed
Queries
Stored procedures
Tables

Erklärung

Frage 128 von 145

You have two tables named Cars and Color as deined below. The two tables are related by ColorId.

Wähle eine der folgenden:

Erklärung

Frage 129 von 145

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 transacton to ensure that the database has data integrity and referental integrity.
Which statement should you use?

Wähle eine der folgenden:

Erklärung

Frage 130 von 145

This queston 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 deletons.
Instructons: 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.

Wähle eine der folgenden:

No change is needed
DROP TABLE
TRUNCATE TABLE
CREATE TABLE

Erklärung

Frage 131 von 145

You work at a cofee 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 inancial functons against the charged amounts.
Which data type should you recommend?

Wähle eine der folgenden:

Money
Bit
Varchar
Binary

Erklärung

Frage 132 von 145

This queston requires that you evaluate the underlined text to determine if it is correct.
[ A row holds informaton for a single record in a table.]
Instructons: 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

Wähle eine der folgenden:

No change is needed
Column
Data type
View

Erklärung

Frage 133 von 145

A SQL Server Login can use Windows Authentication

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 134 von 145

A SQL Server Role provides permissions at the server level

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 135 von 145

A SQL Server Login is granted permissions to database views only

Wähle eins der folgenden:

WAHR
FALSCH

Erklärung

Frage 136 von 145

This queston 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.]
Instructons: 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.

Wähle eine der folgenden:

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

Erklärung

Frage 137 von 145

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

Wähle eine der folgenden:

Erklärung

Frage 138 von 145

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

Wähle eine der folgenden:

View
Table
Function
Stored procedure

Erklärung

Frage 139 von 145

This question requires that you evaluate the underlined text to determine if it is correct.
[First normal form requires that a database excludes repeatng groups]
Instructons: 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.

Wähle eine der folgenden:

No change is needed.
Composite keys
Duplicate rows
Foreign keys

Erklärung

Frage 140 von 145

Wähle von der Aufklappliste, um den Text zu vervollständigen.

HOTSPOT
You have two database tables as deined 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, Foreing key, Primary key ) in the State table

Erklärung

Frage 141 von 145

Wähle von der Aufklappliste, um den Text zu vervollständigen.

HOTSPOT
You have two database tables as deined 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 ( Primary Key, Foreing Key, UNION, Index ) in the Address table

Erklärung

Frage 142 von 145

Wähle von der Aufklappliste, um den Text zu vervollständigen.

This queston requires that you evaluate the underlined text to determine if it is correct.
Use the ( No change is needed, ORDER BY, UNION, WHERE ) statement to return rows that meet a speciic conditon.
Instructons: 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

Erklärung

Frage 143 von 145

A cluestered Index improves the perfomance of queries that [answer choice]

Wähle eine der folgenden:

return large result set
return a range of values by using the = operator
do not use ORDER BY or GROUP BY clauses

Erklärung

Frage 144 von 145

A Clustered index improves the perfomances of queries on column that [answer choice]

Wähle eine der folgenden:

are accessed randomly
are accessed sequentially
are not unique or contain many common values

Erklärung

Frage 145 von 145

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

Wähle eine der folgenden:

Non-null constraint
Default constraint
Index
Foreign key

Erklärung

Antwort prüfen

["https://cdn.goconqr.com/uploads/media/image/9799289/image_primary_23cd724a-92ec-467b-8670-3ced5de53958.JPG","https://cdn.goconqr.com/uploads/media/image/9799310/image_primary_90f9e2f9-e026-4760-bed5-88c42068e392.JPG","https://cdn.goconqr.com/uploads/media/image/9799395/image_primary_3be7485d-e58a-44cd-97c2-ac91bf31b029.JPG","https://cdn.goconqr.com/uploads/media/image/9799492/image_primary_9c7ddbea-ef1a-4e2e-bb7a-ea540ae39aff.JPG","https://cdn.goconqr.com/uploads/media/image/9799542/image_primary_f74e8708-9f9a-4aae-9c03-723d12bd3c6c.JPG","https://cdn.goconqr.com/uploads/media/image/9811002/image_primary_4e31961f-63f6-43e6-9a5a-7009e5fc34b7.PNG","https://cdn.goconqr.com/uploads/media/image/9859204/image_primary_177e7359-f2fa-46b7-8542-82c2f7f871bf.JPG","https://cdn.goconqr.com/uploads/media/image/9859285/image_primary_072f748b-97a3-408a-9e53-45c121e7c7a4.JPG","https://cdn.goconqr.com/uploads/media/image/9859343/image_primary_6654acf8-be09-440b-995a-1cef50583dd3.JPG","https://cdn.goconqr.com/uploads/media/image/9859476/image_primary_4ac11b79-bc1e-4268-afeb-c89320d583b1.JPG","https://cdn.goconqr.com/uploads/media/image/9859969/image_primary_5a59796c-52dd-40a1-9501-eca9373aa59a.JPG","https://cdn.goconqr.com/uploads/media/image/9860126/image_primary_2ea516aa-48b1-4a65-b1e1-5821be20574c.JPG","https://cdn.goconqr.com/uploads/media/image/9860467/image_primary_f07ebd80-dd0e-47c2-84ab-85e2eb133a3b.JPG","https://cdn.goconqr.com/uploads/media/image/9860745/image_primary_261dd2a6-f317-455f-9e60-96e0502a7a96.JPG","https://cdn.goconqr.com/uploads/media/image/9860960/image_primary_664c2820-ced3-418e-971e-0453ac257f63.JPG","https://cdn.goconqr.com/uploads/media/image/9861079/image_primary_38296c6e-efa0-45bd-bd85-b5430f505ccd.JPG","https://cdn.goconqr.com/uploads/media/image/9861399/image_primary_20bd6399-f411-4691-a310-46b0afb9ab75.JPG","https://cdn.goconqr.com/uploads/media/image/9861442/image_primary_3818394e-aedb-404b-838a-4918c8dc3e61.JPG","https://cdn.goconqr.com/uploads/media/image/9861964/image_primary_fa9c06c3-1333-4c52-8d5e-429b42a48208.jpg","https://cdn.goconqr.com/uploads/media/image/9861882/image_primary_845a330c-9393-4065-ae0d-221ec18368ed.PNG","https://cdn.goconqr.com/uploads/media/image/9862053/image_primary_820ea898-fcc8-4a17-9f54-faf5f122f6a8.PNG","https://cdn.goconqr.com/uploads/media/image/9862152/image_primary_a10c15d4-0cba-4f95-9573-ab2fede1aa84.jpg","https://cdn.goconqr.com/uploads/media/image/9861896/image_primary_481b98ec-3e42-4231-85d8-2b992b8b5cd5.PNG","https://cdn.goconqr.com/uploads/media/image/9863471/image_primary_6f6d0f93-96a9-412d-bbd0-5721f886dd09.png","https://cdn.goconqr.com/uploads/media/image/9863507/image_primary_8bed07ce-bbf8-40e8-9915-1d62be96a585.png","https://cdn.goconqr.com/uploads/media/image/9863567/image_primary_a19ac21d-0aef-4a61-9610-f1f54f0a0fb8.png","https://cdn.goconqr.com/uploads/media/image/9863611/image_primary_0367dd5d-9a5f-4c56-be3b-6edfd32c6959.png","https://cdn.goconqr.com/uploads/media/image/9864946/image_primary_8665b20f-b145-473c-b632-1a39598be678.JPG","https://cdn.goconqr.com/uploads/media/image/9864934/image_primary_0c666a80-2989-4633-a5d0-6a07e6d53d1a.JPG","https://cdn.goconqr.com/uploads/media/image/9864934/image_primary_0c666a80-2989-4633-a5d0-6a07e6d53d1a.JPG","https://cdn.goconqr.com/uploads/media/image/9865273/image_primary_6f56b54a-afb4-4ceb-8c10-82840a8b5a4a.JPG","https://cdn.goconqr.com/uploads/media/image/9865273/image_primary_6f56b54a-afb4-4ceb-8c10-82840a8b5a4a.JPG","https://cdn.goconqr.com/uploads/media/image/9865453/image_primary_f8a39fe5-bfc6-4132-ae59-e184bc4425dc.JPG","https://cdn.goconqr.com/uploads/media/image/9865524/image_primary_831ae595-b6e8-4901-80f1-7998c8092ab7.JPG","https://cdn.goconqr.com/uploads/media/image/9876909/image_primary_222b278d-474c-416c-841b-2b1f0e6acffc.jpg","https://cdn.goconqr.com/uploads/media/image/9877057/image_primary_34927447-f8fc-42fc-8aa1-eece27d72383.png","https://cdn.goconqr.com/uploads/media/image/9877086/image_primary_d931465d-846a-44e1-8deb-175d7428edce.png","https://cdn.goconqr.com/uploads/media/image/9892195/image_primary_f75cddfc-461d-47f6-8bf4-f8fed3fc07b3.png","https://cdn.goconqr.com/uploads/media/image/9892380/image_primary_6704051f-6bbd-45b4-a8fa-4c62c92fceb2.png","https://cdn.goconqr.com/uploads/media/image/9892437/image_primary_1cb42832-0c6d-458e-90b3-621f9779774c.png","https://cdn.goconqr.com/uploads/media/image/9892810/image_primary_cfb4b9e9-80c0-409d-af1b-9550ab96eacf.jpg","https://cdn.goconqr.com/uploads/media/image/9861999/image_primary_ba15a25e-e0ee-49d5-9f3c-ee40b568a5fc.jpg","https://cdn.goconqr.com/uploads/media/image/9862014/image_primary_40440d64-1ec0-4b8c-aea3-ad10a0ca5c4d.jpg","https://cdn.goconqr.com/uploads/media/image/9862036/image_primary_bc944fbc-856a-4e52-b94c-f34f200c90f9.jpg","https://cdn.goconqr.com/uploads/media/image/9862070/image_primary_dd0bf592-9c55-459f-b483-004d1a18e4da.jpg","https://cdn.goconqr.com/uploads/media/image/9862171/image_primary_0c9c3a1b-ef92-4238-a3b6-52fc552153e5.jpg","https://cdn.goconqr.com/uploads/media/image/9862216/image_primary_437ddcde-5504-4da9-8863-9fd756739910.jpg","https://cdn.goconqr.com/uploads/media/image/9862238/image_primary_bdbafb5e-d14e-412e-8532-8d37d144982b.jpg","https://cdn.goconqr.com/uploads/media/image/9862258/image_primary_dc80d6b5-4536-40c8-99bc-053a4bdeea67.jpg","https://cdn.goconqr.com/uploads/media/image/9876968/image_primary_6b97183c-5cfc-42ac-b604-6ff061986d94.png","https://cdn.goconqr.com/uploads/media/image/9876974/image_primary_1b2768c6-58db-4556-bde6-a61c0428a77a.png","https://cdn.goconqr.com/uploads/media/image/9876984/image_primary_dd72f83d-83c2-442b-96c7-81ffc5627bdd.png","https://cdn.goconqr.com/uploads/media/image/9877001/image_primary_715875e4-c71c-4f33-82fb-afb46dd56d23.png","https://cdn.goconqr.com/uploads/media/image/9892508/image_primary_fb9bae9a-ba77-4abc-a5a5-a8b7a7908270.jpg","https://cdn.goconqr.com/uploads/media/image/9892511/image_primary_983bc61f-6d6d-491f-9696-996817d9ea4a.jpg","https://cdn.goconqr.com/uploads/media/image/9892512/image_primary_a6c30042-c0fe-44a4-86cc-ba3a56a114d1.jpg","https://cdn.goconqr.com/uploads/media/image/9892513/image_primary_f7cd2e12-78f0-43f3-b26c-2325cfeee3e1.jpg","https://cdn.goconqr.com/uploads/media/image/9892664/image_primary_816d7888-3844-4e5b-b719-a00c54053630.jpg","https://cdn.goconqr.com/uploads/media/image/9892666/image_primary_520d09f5-06da-4592-920c-b8306b40dd57.jpg","https://cdn.goconqr.com/uploads/media/image/9892667/image_primary_c020b35b-9ee5-4ee5-945d-8a8f1a174f39.jpg","https://cdn.goconqr.com/uploads/media/image/9892665/image_primary_00171c6b-6a8e-4dbd-b280-ee6cb885105c.jpg"]

	Erstellt von Kelvin Rivas vor etwa 7 Jahre

Quiz am SQL Server MTA 98-364, erstellt von Kelvin Rivas am 19/05/2017.

GoConqr Rezension

SQL Server MTA 98-364

Frage 1 von 145

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

Wähle eine der folgenden:

Erklärung

Frage 2 von 145

One reason to add an index is to:

Wähle eine der folgenden:

Erklärung

Frage 3 von 145

You have a table that contains the following data. You break the table into the following two tables. This process is referred to as:

Wähle eine oder mehr der folgenden:

Erklärung

Frage 4 von 145

You have a table that contains the following data. Which database term is used to describe the relatonship between ProductID and ProductCategory?

Wähle eine der folgenden:

Erklärung

Frage 5 von 145

Which key uniquely identies a row in a table?

Wähle eine der folgenden:

Erklärung

Frage 6 von 145

Which statement creates a composite key?

Wähle eine der folgenden:

Erklärung

Frage 7 von 145

Wähle eine der folgenden:

Erklärung

Frage 8 von 145

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

Wähle eine der folgenden:

Erklärung

Frage 9 von 145

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

Wähle eine der folgenden:

Erklärung

Frage 10 von 145

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

Wähle eine der folgenden:

Erklärung

Frage 11 von 145

Which keyword can be used in a create table statement?

Wähle eine der folgenden:

Erklärung

Frage 12 von 145

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

Wähle eine der folgenden:

Erklärung

Frage 13 von 145

Which statement will result in the creaton of an index?

Wähle eine der folgenden:

Erklärung

Frage 14 von 145

You have the following table deiniton: 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?

Wähle eine der folgenden:

Erklärung

Frage 15 von 145

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?

Wähle eine der folgenden:

Erklärung

Frage 16 von 145

One reason to create a stored procedure is to:

Wähle eine der folgenden:

Erklärung

Frage 17 von 145

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

Wähle eine der folgenden:

Erklärung

Frage 18 von 145

Wähle eine der folgenden:

Erklärung

Frage 19 von 145

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

Wähle eine der folgenden:

Erklärung

Frage 20 von 145

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

Wähle eine der folgenden:

You have a table that contains the following data.

You break the table into the following two tables.

This process is referred to as:

You have a table that contains the following data.

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

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

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

You have the following table deiniton:
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 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 two tables. Each table has three rows.
How many rows will be included in the Cartesian product of these two tables?

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

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

You have the following table deiniton:
CREATE TABLE Product
(ID INTEGER PRIMARY KEY,
Name VARCHAR(20),
Quantty INTEGER)
The Product table contains the following data.

You execute the following statement:
SELECT Name FROM Product WHERE Quantty IS NOT NULL
How many rows are returned?

You are writng a select statement to ind every product whose name contains a speciic character.
Which keyword should you use in your where clause?

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

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

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

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

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?

The Product table contains the following data.

You execute the following statement:
SELECT COUNT(*)
FROM Product WHERE Quantty > 18
What is the value returned by this statement?

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