All other columns other than the column which is termed as Primary Key, are known as
Unique Keys
Alternate Keys
Composite Keys
None of the above
Correct Answer :
B. Alternate Keys
All other columns other than the column which is termed as Primary Key, are known as Alternate Keys.
Related Questions
What is the difference between nchar and nvarchar?
nchar is fixed and nvarchar is variable.
nchar is variable and nvarchar is fixed.
nchar has the maximum size of 4000 characters and nvarchar has the maximum size of 8000 characters.
nchar has the maximum size of 800 characters and nvarchar has the maximum size of 4000 characters.
To get the table's previous permanent status, use the ____ command.
Commit
Transaction
Rollback
None of the above
What is the clause to delete all rows from the table?
SQL DELETE ALL ROWS Table_Name;
SQL DELETE ROWS Table_Name;
DELETE FROM ALL ROWS Table_Name;
DELETE FROM Table_Name;
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
Using TIME_FORMAT() function, time can be retrieved in
12-hour format
24-hour format
Both A. and B.
None of the above
What does the CREATE DATABASE Statement do?
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
A new database will be created through this SQL statement.
Which of the following is TRUE about SQL Auto Increment?
It increments the unique number automatically.
It decrements the unique number automatically.
It keeps the unique number constant
None of the above
Which of the following is SQL Server Date and Time Data Type?
timestamp
sql_variant
real
text
A single unit of work for all commands executed consecutively is known as-
Transaction
Commit
Rollback
Control
What is the shortcut key to open SQL Script?
Ctrl+Shift+S
Ctrl+Shift+Q
Ctrl+Shift+N
Ctrl+Shift+O
In how many parts are the SQL functions are divided into?
1
2
3
4
For integer value, which data type is supported in Oracle?
INT
Number
Digit
None of the above
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.
The SQL Modulus Operator returns the,
Quotient
Percentage
Sum
Reminder
SQL Indexes slows the execution time of which statement(s)?
UPDATE
INSERT
SELECT
Both A and B
____ value is returned by the SQL Aggregate functions?
Single
Twice
NULL
Infinite
For one table, there can be ____unique key constraint(s).
1
NULL
Many
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 UCASE() function do?
Converts database field to uppercase
Converts database field to lowercase
Returns the length of the text field
Returns the current date and time
Using the DELETE Query from the CRUD Operator, we can delete
Only one row
All the rows
Only two rows
None of the above
In order to merge two or more strings, which string function is used?
CHAR
ALTER
CONCAT
MERGE
What does the following statement do?
Finds any values that end with a
Finds any values whose second character is a
Find any values that contains only two characters ending with a
Mysql > Savepoint ini;
Select the correct syntax of SELECT TOP clause?
SELECT TOP name
SELECT TOP column
SELECT TOP FROM
SELECT TOP Number
SQL Division operator divides the operand on the ____ side by the operand on the ____ side.
Left, Left
Right, Left
Left, Right
Right, Right
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.
Which of the following is NOT the SQL Arithmetic Operator?
Addition
Subtraction
Unary
Modulus
TRUNCATE TABLE requires:
WHERE clause
HAVING clause
Both a and b
None of the above
Which of the following is a SQL Logical Operator?
SQL ALL Operator
SQL OR Operator
SQL LIKE Operator
All of the above
Numbers of operand used by Binary Operators are?
1
2
3
4
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.