Which of the following is SQL Server String Data Type?
ntext
binary(n)
varbinary
All of the above
Correct Answer :
D. All of the above
SQL Server String Data Types are ntext, binary(n), and varbinary.
Related Questions
Number of operands used by Unary Operator is?
1
2
3
4
Which statement is TRUE about the WHERE Clause?
In order to retrieve rows, WHERE Clause is used.
In order to group the rows, WHERE Clause is used.
In order to select the defined groups, WHERE Clause is used.
In order to return the rows, WHERE Clause is used.
Using the SQL first() function, one can return the ____ value of the selected column.
First
Second
Third
Last
Using a WHERE clause in a SQL query is used to specify SQL reserved words and characters, known as ____?
Operators
Data Types
Numbers
Syntax
What is TRUE about the Active/Dynamic Online Catalog based on the relational model in the 12 Codd's Rules?
The primary key value, table name, and column name are characteristics that allow us to access the precise data (atomic value) logically from a relational database.
Null values are treated in database records according to this rule.
Database dictionaries represent the complete logic of all descriptive data, which must be stored online.
None of the above
A Key which uniquely identifies each row in the table is known as?
Primary Key
Unique Key
Composite Key
Foreign Key
For one table, there can be ____unique key constraint(s).
1
NULL
Many
None of the above
Select the syntax of Single Line Comment.
.
!
--
#
Rules that are needed to be followed in SET Operators in SQL are
All columns must be identical in number and order.
There must be compatibility between data types.
Both A and B
None of the above
Which of the following is the type of SQL Injection attack?
It inserts the data
It updates the data
It deletes the data
All of the above
The SELECT TOP statement shows the limited number of:
Rows
Columns
Tables
None of the above
Select the correct rule of SQL EXCEPT.
There must be the same number of columns in each table and the same order in every select statement.
It is desirable that the columns have similar or compatible data types.
Both SELECT statements must have the same fields in their respective columns.
All of the above
Foreign key is a field in a table that is _______ key in another table?
Primary
Unique
Composite
None of the above
What is the difference between HAVING and WHERE clause?
HAVING clause is used in column operation whereas WHERE clause is used in row operation.
HAVING clause is post-filter whereas WHERE clause is pre-filter.
HAVING clause filters the groups whereas WHERE clauses filter the single record of the table.
All of the above
What does SQL stand for?
SQL stands for Sample Query Language
SQL stands for Structured Query List
SQL stands for Structured Query Language
SQL stands for Sample Query List
What is the full form of CTE in SQL?
Character Table Expressions
Character Table Evaluator
Common Table Evaluator
Common Table Expressions
_____ variables are not supported by SQL Script.
Bind
Dynamic
Both A) and B)
None of the above
Why index is important in SQL?
The large database can be searched quickly with SQL Indexes.
The concept below is a quick way to include different values in those columns.
A smaller table may not recognize the performance of an index when used with an index.
All of the above
What does the following statement do?
Finds any values that start with a and ends with o
Finds any values whose first character is a and third character is o
Both A. and B.
None of the above
To get a record from one table, which is not present in another table, we can use the clause
CONCAT
COPY
EXCEPT
ALTER
In order to sort the records according to the columns, which clause is used?
HAVING
GROUP BY
ORDER BY
None of the above
What is the shortcut key to open SQL Script?
Ctrl+Shift+S
Ctrl+Shift+Q
Ctrl+Shift+N
Ctrl+Shift+O
It is possible to use LIKE clauses with
Strings
Numbers
Both A. and B.
None of the above
Full form of DCL is -
Data Control Language
Data Commit Language
Data Common Language
Data Concatenate Language
Select the statement which is TRUE?
In a table, there could be any number of rows and any number of columns.
In a table, there could be any number of rows and specified number of columns.
In a table, there could be any number of columns and specified number of rows.
In a table, there could be specified number of rows and specified number of columns.
For integer value, which data type is supported in Oracle?
INT
Number
Digit
None of the above
Read in CRUD Operator means
To retrieve data
To fetch data
Both A. and B.
None of the above
What is TRUE about NOT IN clause?
The result is purged of duplicates
Duplicate records are not removed
Performs column-by-column comparisons
None of the above
Output returned by the Scalar functions is/are -
Single Value
Multiple Value
Two Values
None of the above
Which statement is used to select the database in SQL?
SELECT
USE
ALTER
CREATE