9645473
Descripción
Test por Hawerth Castro, actualizado hace más de 1 año
|
Creado por Hawerth Castro
hace casi 7 años
|
|
Pregunta 1
Respuesta
-
foreign key
-
clustered index
-
nonclustered index
-
foreign key
-
clustered index
-
nonclustered index
Pregunta 2
Pregunta
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?
Respuesta
-
Non-null constraint
-
Default constraint
-
Index
-
Foreign key
Pregunta 3
Pregunta
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:
Respuesta
-
No change is needed
-
DROP TABLE
-
TRUNCATE TABLE
-
ALTER TABLE
Pregunta 4
Pregunta
You have a table named Employee that includes four columns. You execute the following statement:
SELECT * FROM Employee
Which columns are returned?
Respuesta
-
all columns
-
only the last column
-
only the first column
-
only the first and last columns
Pregunta 5
Pregunta
Which keyword must be included in a create view statement?
Respuesta
-
WHERE
-
ORDER BY
-
UPDATE
-
SELECT
Pregunta 6
Pregunta
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?
Image:
1 (binary/octet-stream)
Respuesta
-
1
-
2
-
3
-
4
Pregunta 7
Pregunta
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?
Respuesta
-
UPDATE
-
CHANGE
-
SELECT
-
INSERT
Pregunta 8
Pregunta
Which keyword would you use in a select statement to return rows that meet a specific condition?
Respuesta
-
WHERE
-
UNION
-
ORDER BY
-
FROM
Pregunta 9
Pregunta
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?
Image:
2 (binary/octet-stream)
Respuesta
-
0
-
1
-
2
-
3
-
4
Pregunta 10
Pregunta
You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName FROM Employee,
Department This type of operation is called a/an:
Respuesta
-
Intersection
-
Outer join
-
Equi-join
-
Cartesian product
Pregunta 11
Pregunta
You are writing an SQL statement to retrieve rows from a table. Which data manipulation
language (DML) command should you use?
Respuesta
-
READ
-
SELECT
-
OUTPUT
-
GET
Pregunta 12
Pregunta
which command used to removes all rows from a table without logging the individual row deletions.
Respuesta
-
DROP TABLE
-
TRUNCATE TABLE
-
CREATE TABLE
-
ALTER TABLE
Pregunta 13
Pregunta
You need to delete a database table. Which data definition language (DDL) keyword should you use?
Respuesta
-
ALTER
-
DELETE
-
DROP
-
TRUNCATE
Pregunta 14
Pregunta
You need to rename a column in a database table. Which data definition language (DDL)
statement should you use?
Respuesta
-
ALTER
-
INSERT
-
CREATE
-
UPDATE
Pregunta 15
Pregunta
What are three valid data manipulation language (DML) commands? (Choose three.)
Respuesta
-
INSERT
-
COMMIT
-
DELETE
-
OUTPUT
-
UPDATE
Pregunta 16
Pregunta
You are writing an SQL statement to retrieve rows from a table. Which data manipulation
language (DML) command should you use?
Respuesta
-
READ
-
SELECT
-
OUTPUT
-
GET
Pregunta 17
Pregunta
17. 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?
Image:
3 (binary/octet-stream)
Respuesta
-
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
Pregunta 18
Pregunta
You need to enable a new employee to authenticate to your database. Which command should you use?
Respuesta
-
ALLOW USER
-
CREATE USER
-
ADD USER
-
INSERT USER
-
ALTER USER
Pregunta 19
Pregunta
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.
Respuesta
-
No change is needed
-
INSERT
-
REPLACE
-
SELECT
Pregunta 20
Pregunta
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:
Image:
4 (binary/octet-stream)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 21
Pregunta
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?
Respuesta
-
SET ProduetName = ‘glass’
-
LET ProduetName = ‘glass’
-
EXEC ProduetName = ‘glass’
-
ASSIGN ProduetName = ‘glass’
Pregunta 22
Pregunta
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?
Respuesta
-
THAT
-
WHERE
-
GROUP BY
-
HAVING
Pregunta 23
Pregunta
You need to list the name and price of each product, sorted by price from highest to lowest.
Which statement should you use?
Image:
5 (binary/octet-stream)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 24
Pregunta
You have a table named Customer. You need to add a new column named District. Which
statement should you use?
Image:
6 (binary/octet-stream)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 25
Pregunta
You need to remove a view named EmployeeView from your database. Which statement
should you use?
Respuesta
-
DELETE VIEW EmployeeView
-
DELETE EmployeeView
-
DROP EmployeeView
-
DROP VIEW EmployeeView
Pregunta 26
Pregunta
On which database structure does an update statement operate?
Respuesta
-
Table
-
User
-
Trigger
-
Role
Pregunta 27
Pregunta
You need to populate a table named EmployeeCopy with data from an existing table named Employee.
Which statement should you use?
Image:
7 (binary/octet-stream)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 28
Pregunta
You execute the following statement:
SELECT DepartamentName
FROM Departament
WHERE DepartamentID =
(SELECT DepartamentID
FROM Employee
WHERE EmployeeID = 1234
This statement is an example of a/an:
Respuesta
-
Subquery
-
Union
-
Outer join
-
Cartesian product
Pregunta 29
Pregunta
Which command should you use to add a column to an existing table?
Respuesta
-
MODIFY
-
ALTER
-
UPDATE
-
INSERT
-
CHANGE
Pregunta 30
Pregunta
Which keyword can be used in a create table statement?
Respuesta
-
ORDER BY
-
DISTINCT
-
GROUP BY
-
UNIQUE
Pregunta 31
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 32
Pregunta
You are creating a database object named Student to store the following data:
Which syntax should you use to create the object?
Image:
9 (binary/octet-stream)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 33
Pregunta
You have a database table named SongInformation as defined below:
Image:
10 (binary/octet-stream)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 34
Pregunta
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?
Image:
11 (binary/octet-stream)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 35
Pregunta
You have a database table that contains the following columns:
Which two Structured Query Language (SQL) statements can you use? (Choose two.)
Image:
12 (binary/octet-stream)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 36
Pregunta
You have the database table named Cars as defined below:
How many rows are returned by the SQL statement?
Image:
13 (binary/octet-stream)
Respuesta
-
4
-
5
-
6
-
7
Pregunta 37
Pregunta
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?
Image:
14 (binary/octet-stream)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 38
Pregunta
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?
Image:
15 (binary/octet-stream)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 39
Pregunta
Which statement deletes the rows where the employee’s phone number is not entered?
Image:
16 (binary/octet-stream)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 40
Pregunta
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?
Image:
17 (binary/octet-stream)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
-
Option E
Pregunta 41
Pregunta
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?
Image:
18 (binary/octet-stream)
Respuesta
-
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
Pregunta 42
Pregunta
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?
Image:
19 (binary/octet-stream)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 43
Pregunta
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?
Image:
21 (binary/octet-stream)
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.