What is SQL CREATE Table used for?
To Update table
To Create table
To Delete table
None of the above
Correct Answer :
B. To Create table
SQL CREATE Table is used to create table in a database.
Related Questions
In SQL, which statement can help in changing the name of the table?
RENAME
ALTER
Both A) and B)
None of the above
Select the Aggregate function(s) among the following.
AVG()
FIRST()
LAST()
All of the above
Which function combines the two different columns?
ADD
MERGE
CONCAT
None of the above
Which function returns the largest value of the column?
MIN()
MAX()
LARGE()
AVG()
The ____ size of the result is shown by Script Quota.
Minimum
Maximum
Average
None of the above
Using the DELETE Query from the CRUD Operator, we can delete
Only one row
All the rows
Only two rows
None of the above
Name of the control in SQL Script
Script
Owner
Opinion
All of the above
By constraining a SQL statement, we limit the ____ according to certain conditions or restrictions.
Row
Column
Table
Database
What is TRUE about UNION ALL Operator?
The results of both queries are combined with this operator.
After performing the UNION ALL operation, duplicate rows will not be removed.
Both A and B
None of the above
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
Description allows the Script to load the
Owner of the script
Script name
Script Editor
All of the above
SQL became the standard of?
ASCII
ANSI
ISO
Both B and C
Scripts ____ from various workspaces can be imported through import.
Exported
Imported
Changed
Saved
Which of the following statement(s) is/are TRUE about DCL?
The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.
There will be certain privileges that each user has; consequently, the data can be accessed by them.
The DCL commands in SQL allow us to grant privileges to a user on the SQL database and its table(s), or revoke privileges that have already been granted.
All of the above
Local Temp Variable is used with which sign?
?
@
#
&
BETWEEN operator is used with which SQL Statements
SELECT
DELETE
INSERT
All of the above
What is the work of UPDATE command?
A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
Using this command, you can remove or erase recorded information from a database table.
Database data can be updated or changed using this command.
It enables you to create new databases, tables, table views, and other objects using this command.
When the table is dropped:
Table structure is dropped
Integrity constraints are dropped
Relationship is dropped
All of the above
Name of the data type categories are,
String Data types
Numeric Data types
Date and time Data types
All of the above
Select the correct statement.
With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
With the DML commands, any structural changes can be made to the table, including creation, deletion, and alteration.
With the DCL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
With the TCL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
TINYTEXT can hold the maximum length of ___ characters?
254
255
256
257
From the set of results, in order to remove the duplicate columns, ____ Clause is used.
DUPLICATE
DISTINCT
REMOVE
DROP
NOW function is used to return the current
Time
Date
Date & Time
Day
What is the shortcut key to open SQL Script?
Ctrl+Shift+S
Ctrl+Shift+Q
Ctrl+Shift+N
Ctrl+Shift+O
Which of the following is SQL Server String Data Type?
ntext
binary(n)
varbinary
All of the above
The character(s) which are used independently or in conjunction with SQL Like Operator:
%
_
Both A. and B.
None of the above
Which keyword is used in SQL Server to implement the auto increment?
UNIQUE
IDENTITY
INCREMENT
ADD
Which of the following statement is false?
There is no difference between a lower case and upper case keyword in SQL.
It is easier to read SQL queries when the keywords are in lowercase.
An SQL statement's syntax is determined by its text line.
One or more SQL statements can be placed on a single line of text.
By default, TIME data type stores time in which format?
MM:HH:SS;
SS:HH:MM;
HH:SS:MM;
HH:MM:SS;
When two or more columns are combined to be used to uniquely identify each row in the table, it is known as -
Primary Key
Unique Key
Composite Key
Foreign Key