Question: Please do not explain. Only answer A B C D What does the ALTER TABLE Statement do ? a ) . By deleting the stored

Please do not explain. Only answer A B C D
What does the ALTER TABLE Statement do?
a). By deleting the stored data, this SQL statement deletes the database.
b). Columns in the SQL database can be created, deleted, or modified with this SQL statement.
c). A new table in SQL is created using this SQL statement.
d). The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
What does the DISTINCT Clause do?
a). Specify the columns of the table in this SQL clause to return distinct values.
b). By executing this SQL statement, all records in the SQL database will be deleted.
c). The data specified in this table or view is reported in this SQL statement.
d). Changes made in the SQL database transaction are permanently saved using this SQL statement.
In the database table, data types describe the kind of ___ that it can contain.
a). Table
b). Data
c). Number
d). None of the above
Which of the following is SQL Server Numeric Data Type?
a). image
b). nchar
c). money
d). cursor
Which of the following is the feature(s) of SQL Auto Increment?
a). In some cases you may not have any unique identifying characteristics in data; therefore, it makes sense to create a Primary Key.
b). Explicitly initializing and modifying the auto-increment value is possible at any time.
c). Record identifiers can easily be created that are unique to each record.
d). All of the above
Which one of the following is not a valid constraints in SQL?*
a).NOT NULL
b).UNIQUE
c).IDENTITY
d).KEY VALUES

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!