For one table, there can be ____unique key constraint(s).
1
NULL
Many
None of the above
Correct Answer :
C. Many
For one table, there can be many unique key constraints.
Related Questions
In which clause does the BETWEEN operator is used?
IF
AS
WHERE
EXCEPT
What does the UPDATE Statement do?
By deleting the stored data, this SQL statement deletes the database.
A new table in SQL is created using this SQL statement.
The stored data in the SQL database is changed or modified by this SQL statement.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
The Web SQL API is supported by
Opera
Google Chrome
Android Browsers
All of the above
Full form of TCL is -
Transaction Common Language
Transaction Commit Language
Transaction Concatenate Language
Transaction Control Language
What is the difference between nvarchar and ntext?
nvarchar is fixed and ntext is variable.
nvarchar is variable and ntext is fixed.
nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 2GB of the text data.
nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 1GB of the text data.
With which of the following statement(s) can the SQL sub queries be used?
SELECT
UPDATE
INSERT
All of the above
Description allows the Script to load the
Owner of the script
Script name
Script Editor
All of the above
Which statement is true about the SQL?
SQL databases are vertically scalable.
SQL follows BASE Model.
SQL database cannot handle complex queries.
SQL database does not require object-relational mapping.
What is the work of DROP command?
Using this command, you can remove or erase recorded information from a database table.
Database objects such as tables, table views, and other objects can be deleted using this command.
One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.
It enables you to create new databases, tables, table views, and other objects using this command.
What is the difference between VARCHAR and VARCHAR2?
VARCHAR can store upto 4000 bytes and VARCHAR2 can store upto 8000 bytes.
VARCHAR can store upto 2000 bytes and VARCHAR2 can store upto 4000 bytes.
Both VARCHAR and VARCHAR2 are similar but use of VARCHAR2 is mostly recommended.
There is no similarity between VARCHAR and VARCHAR2.
In order to join N tables, minimum number of join statements required is
N
N-1
N-2
N+1
Network-based IDS can be used to monitor
Web server logs
When something weird occurs
All connections to the database server
None of the above
In order to format, how the column should be displayed, which function is used?
FORM()
DISPLAY()
COL()
FORMAT()
Which function returns the largest value of the column?
MIN()
MAX()
LARGE()
AVG()
You can also ____ the existing tables by using the UNIQUE constraint.
Change
Delete
Modify
Drop
Which of the following is TRUE about SQL Concatenate?
It is also possible to combine more than two strings into one string.
Two columns of the table may be used to store the strings that are to be combined, or they may just be stored individually without being stored into the table.
When the concatenated strings are stored in separate columns of a table, they are stored in the column in which they were initially stored.
All of the above
At which of the following stage does SQL Injection occurs?
When the user is asked to logout
When the user is asked to input password
When the user is asked to input captcha
When the user is asked to input username
Choose the correct syntax of NOW function?
SELECT ()NOW;
NOW() SELECT;
SELECT NOW();
SELECT OWN();
Select the correct statement which will return all the rows from the Table and then also deletes the Table_Add table?
SELECT * FROM Table; DROP TABLE Table_Add
SELECT * WHERE Table; DROP TABLE Table_Add
SELECT * FROM Table; DELETE TABLE Table_Add
SELECT * WHERE Table; DELETE TABLE Table_Add
What is the difference between MIN and MAX function?
MIN function is used to show the minimum data and MAX function is used to show the maximum data.
MIN function is used to show the maximum data and MAX function is used to show the minimum data.
Both of the above
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
____ and ____constraints form the core of the PRIMARY KEY constraint.
NOT NULL , CHECK
NOT NULL , DEFAULT
NOT NULL , FOREIGN KEY
NOT NULL , UNIQUE
The SQL Modulus Operator returns the,
Quotient
Percentage
Sum
Reminder
Which of the following statement is TRUE about Primary Key?
Table integrity is not enforced by the primary key.
The data in a primary key is always multiple.
900 bytes is the maximum length of a primary key.
Null values are allowed in primary keys.
BETWEEN operator is used with which SQL Statements
SELECT
DELETE
INSERT
All of the above
What is TRUE about UPDATE in SQL VIEW?
Views that depend on a single table can be updated.
An update of a view created from more than one table will not be allowed by SQL.
There should be no NULL values in the fields of view.
All of the above
____ value is returned by the SQL Aggregate functions?
Single
Twice
NULL
Infinite
In SQL, Like is a ____ operator.
Relational
Logical
Additional
Unique
Which statement is not true about SQL?
Using SQL in relational databases is all about inserting, updating, and deleting data.
Sample data can also be described with the aid of this tool.
It helps develop relational database functions, events, and views.
A SQL user can also set restrictions and permissions for a table column, a view, and a stored procedure.
SQL EXCEPT returns the record from -
First SELECT Query
Second SELECT Query
Third SELECT Query
None of the above