null
US
Sign In
Sign Up for Free
Sign Up
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Next up
Copy and Edit
You need to log in to complete this action!
Register for Free
24714155
Structured Query Language (SQL) (Section 1)
Description
Chapter 1
No tags specified
c192
graduate
Quiz by
Craig Willey
, updated more than 1 year ago
More
Less
Created by
Craig Willey
about 4 years ago
14
0
0
Resource summary
Question 1
Question
When transforming an ERD into a relational database, you often use an entity to build a database's:
Answer
Table
Column
Attribute
Relationship
Question 2
Question
The unique identifier of a row in a database table is a(n):
Answer
ID
Primary Key
Primary Column
Column
Question 3
Question
Which of the following is true of SQL?
Answer
It is the most commonly used language for interacting with a database.
It is the only language you can use to create a database.
It is the only language you can use to interact with a database.
None of these
Question 4
Question
What can you use to submit SQL statements for execution? (Choose all that apply.)
Answer
PHP
Java
SQL Developer
SQL*Plus
Question 5
Question
What is one of the purposes of DCL? (Choose the best answer.)
Answer
Query data from a given table
Issue privileges to users
Remove existing data from a database table
None of these
Question 6
Question
What can DDL be used for? (Choose three.)
Answer
Add comments to a database table
Add columns to a database table
Add data to a database table
Add privileges for a user to a database table
Question 7
Question
Which one of the following is a DML statement?
Answer
ADD
ALTER
UPDATE
MODIFY
Question 8
Question
Which of the following can be used to remove data from a table? (Choose two.)
Answer
DELETE
UPDATE
MODIFY
ALTER
Question 9
Question
What can a SELECT statement be used to query? (Choose the best answer.)
Answer
Only one report
Only one table
One or more reports
One or more tables
Question 10
Question
Which of the following is not a capability of the SELECT statement?
Answer
It can transform queried data and display the results.
It can remove data from a table.
It can join data from multiple tables.
It can aggregate database data.
Show full summary
Hide full summary
Want to create your own
Quizzes
for
free
with GoConqr?
Learn more
.
Similar
Using DDL Statements to Create and Manage Tables ( Section 2)
Craig Willey
Manipulating Data (Section 3)
Craig Willey
Restricting and Sorting Data (Section 4)
Craig Willey
Key Paintings
Julia Lee
OCR GATEWAY CHEMISTRY C1 TEST
Olivia Farrow
Meriya Pinales & Malika Hurt
hurtmalika
Of Mice and Men Characters
Annalise Farrington
Korean Grammar Syllabus
Dxoxo
GCSE Chemistry C1.1 - Fundamental Ideas in Chemistry
chancice.branscombe
Metal Oxides, Metal Hydroxides & Ammonia
Tom Johnson
GCSE Subjects
KimberleyC
Browse Library