What Do You Know About Data Definition Language? Take This Quiz To Find Out More About Ddl.
10 Questions
| Total Attempts: 150
A data definition language (DDL), sometimes called data description language, is a syntax for defining data structures, especially database schemas. Take this quiz to find out more about DDL.
Questions and Answers
- 1.
![Which DDL statement creates a new object? - ProProfs]( "Which DDL statement creates a new object?")
Which DDL statement creates a new object?- A.
Create
- B.
Object
- C.
Vector
- D.
Statement
- 2.
![The DROP statement ___ an object. - ProProfs]( "The DROP statement ___ an object.")
The DROP statement ___ an object.- A.
Creates
- B.
Destroys
- C.
Deletes
- D.
Moves
- 3.
![In order to modify an existing database object, we use the ___ statement. - ProProfs]( "In order to modify an existing database object, we use the ___ statement.")
In order to modify an existing database object, we use the ___ statement.- A.
Move
- B.
Object
- C.
Alter
- D.
Change
- 4.
![This command "ALTER TABLE sink ADD bubbles INTEGER;" adds a... - ProProfs]( "This command \"ALTER TABLE sink ADD bubbles INTEGER;\" adds a...")
This command "ALTER TABLE sink ADD bubbles INTEGER;" adds a...- A.
Column
- B.
Object
- C.
Vector
- D.
Color
- 5.
![All of the following are DDL statements except... - ProProfs]( "All of the following are DDL statements except...")
All of the following are DDL statements except...- A.
Rename
- B.
Create
- C.
Alter
- D.
Object
- 6.
![Which of these statements begins with alter? - ProProfs]( "Which of these statements begins with alter?")
Which of these statements begins with alter?- A.
Rename
- B.
Revoke
- C.
Audit
- D.
Purge
- 7.
![Data definition language lets you create and alter ___ objects. - ProProfs]( "Data definition language lets you create and alter ___ objects.")
Data definition language lets you create and alter ___ objects.- A.
Rastar
- B.
Vector
- C.
Statement
- D.
Schema
- 8.
![Which of these statements requires an exclusive access to a specified object? - ProProfs]( "Which of these statements requires an exclusive access to a specified object?")
Which of these statements requires an exclusive access to a specified object?- A.
GRANT
- B.
CREATE
- C.
REVOKE
- D.
ANALYZE
- 9.
![Which of these SQL statements can be used to grant or revoke privileges? - ProProfs]( "Which of these SQL statements can be used to grant or revoke privileges?")
Which of these SQL statements can be used to grant or revoke privileges?- A.
PHP
- B.
DCL
- C.
DDL
- D.
DML
- 10.
![The rename statement is used to ___ an object. - ProProfs]( "The rename statement is used to ___ an object.")
The rename statement is used to ___ an object.- A.
Rename
- B.
Destroy
- C.
Clean
- D.
Drop
Questions: 11 | Attempts: 9711 | Last updated: Jul 12, 2021
-
Sample QuestionWhat is the range of numbers you can store in a variable of type byte?
Are you applying for a job, and they have required you to take essential computer skills exam when you show up for the interview? The quiz below covers the basics of what you are most likely to be asked. Give it a try and all the...
Questions: 8 | Attempts: 141404 | Last updated: Apr 30, 2021
-
Sample QuestionHow do you open a program such as Microsoft Word when there are no icons on the desktop?
Computers have been evolving in makeup and design ever since they were first introduced. Most people nowadays are expected to have at least basic knowledge of how to use one. How conversant are you with the basic components of a...
Questions: 15 | Attempts: 39427 | Last updated: Jun 11, 2020
-
Sample QuestionLet's start with an easy one. What does CPU stand for?
Back to top