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
Correct Answer :
C. Composite Key
When two or more columns are combined to be used to uniquely identify each row in the table, it is known as Composite Key.
Related Questions
_____ variables are not supported by SQL Script.
Bind
Dynamic
Both A) and B)
None of the above
In the case of ____ Independence Rule, if using the SQL queries language to insert data into table's cells, the database must maintain integrity independence.
Interdependent
Intradependent
Integration
Integrity
____ function extract characters from the text field.
LEN()
NOW()
MID()
FORMAT()
A database does not need to be created in ____. A direct table creation option is provided in ____.
MySQL
Oracle
Both A and B
None of the above
You can also ____ the existing tables by using the UNIQUE constraint.
Change
Delete
Modify
Drop
What is the full form of GUID?
Guided Unique Identifier
Guided Unique Interpreter
Globally Unique Identifier
Globally Unique Interpreter
Which statement is TRUE about the HAVING Clause?
In order to group the rows, HAVING Clause is used.
In order to return the rows, HAVING Clause is used.
In order to select the defined groups by the GROUP BY Clause, HAVING Clause is used.
None of the above
In order to assign a random name to a column or table, which SQL SELECT Clause is used?
FROM
WHERE
HAVING
AS
To delete table definition and all data from the table, which statement is used?
DELETE
DROP
ALTER
None of the above
What does the ROLLBACK Statement do?
Specify the columns of the table in this SQL statement to return distinct values.
Changes made in the SQL database transaction are permanently saved using this SQL statement.
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
An index is created in a SQL database table with this SQL statement.
To get a record from one table, which is not present in another table, we can use the clause
CONCAT
COPY
EXCEPT
ALTER
What does the following statement do?
Finds any values that start with or
Finds any value that contains only four characters and second, third characters are 'o', 'r'
Finds any values that have or in any position
None of the above
In order to insert a row directly in the table, which command is used?
INSERT IN
INSERT INSIDE
INSERT UNDER
INSERT INTO
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 does the SELECT Statement do?
Data is read from the SQL database by this statement and displayed to the database user.
The stored data in the SQL database is changed or modified by this SQL statement.
By deleting the stored data, this SQL statement deletes the database.
A new table in SQL is created using this SQL statement.
Select the correct type(s) of SQL Comments.
Inline Comments
Single Line Comments
Multi-line Comments
All of the above
Name of the control in SQL Script
Script
Owner
Opinion
All of the above
The description in SQL Script, displays script in
One Line
Two Line
Three Line
Many Lines
What can be the maximum size of char(n) in SQL Server String Data Type?
7000
8000
9000
10000
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.
____ Clause is used in Parent-child relationship in order to join two or more tables.
FROM
TO
WHERE
IN
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;
Name of the data type categories are,
String Data types
Numeric Data types
Date and time Data types
All of the above
Which of the following is not the SQL Comparison Operator?
SQL Equal Operator (=)
SQL Less Than Operator (<)
SQL Greater Than Operator (>)
All of the above
The numerical values of two ___ of the ___ table can be easily subtracted using SQL Subtraction Operator.
Rows, same
Columns, same
Rows, different
Columns, different
What is Export Script by default?
Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl
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
SELECT INTO statement -
Select the content from a table.
Rename the content in a table.
Copy the content from one table into another existing table.
None of the above
Which of the following keyword is used to delete the Join?
DELETE
ON
WHERE
All of the above
What is SQL CREATE Table used for?
To Update table
To Create table
To Delete table
None of the above