Foreign key is a field in a table that is _______ key in another table?
Primary
Unique
Composite
None of the above
Correct Answer :
A. Primary
Foreign key is a field in a table that is Primary Key in another table.
Related Questions
Select the correct method of Web SQL?
Execute SQL
Transaction
Open Database
All of the above
Which of the following clause cannot be used in SQL sub queries?
GROUP BY
ORDER BY
DELETE
FROM
Following the completion of a transaction, it must be executed to save all the operations performed in the transaction. Here we are talking about which command?
REVOKE
COMMIT
ROLLBACK
SAVE
We can create View in SQL using
CREATE statement
CREATE VIEW statement
VIEW CREATE statement
SQL VIEW statement
Full form of DCL is -
Data Control Language
Data Commit Language
Data Common Language
Data Concatenate Language
What is Export Script by default?
Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl
Command that comes under DCL is/are -
GRANT
REVOKE
Both A. and B.
None 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.
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.
Full form of DDL is
Data Describe Language
Definition Data Language
Data Definition Language
Data Distinct Language
NULL means
ZERO
-1
1
Empty
What is the full form of GUID?
Guided Unique Identifier
Guided Unique Interpreter
Globally Unique Identifier
Globally Unique Interpreter
What is the syntax of SQL CAST Function?
CAST (expression AS [data type])
CAST (expression IN [data type])
CAST (expression TO [data type])
CAST (expression FOR [data type])
Scripts ____ from various workspaces can be imported through import.
Exported
Imported
Changed
Saved
SQL ___ can be used to delete or drop existing databases in a SQL schema.
CREATE DATABASE
RENAME DATABASE
DROP DATABASE
SELECT DATABASE
Full form of TCL is -
Transaction Common Language
Transaction Commit Language
Transaction Concatenate Language
Transaction Control Language
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
Name of the data type categories are,
String Data types
Numeric Data types
Date and time Data types
All 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 SQL Server String Data Type?
ntext
binary(n)
varbinary
All of the above
Select the correct syntax for Multi-line Comments.
//*Line1
Line2*//
/*Line1
Line2/*
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.
SQL contains which component in its process?
Optimization Engines
SQL Query Engines
Query Dispatchers
All of the above
What does the DISTINCT Clause do?
Specify the columns of the table in this SQL clause to return distinct values.
By executing this SQL statement, all records in the SQL database will be deleted.
The data specified in this table or view is reported in this SQL statement.
Changes made in the SQL database transaction are permanently saved using this SQL statement.
Numbers of operand used by Binary Operators are?
1
2
3
4
Which of these are the types of operators?
Arithmetic
Comparison
Set
All of the above
A single unit of work for all commands executed consecutively is known as-
Transaction
Commit
Rollback
Control
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key
Which of the following is TRUE about TCL?
Transactions can be saved to the database and rolled back with the help of TCL commands in SQL.
There will be certain privileges that each user has; consequently, the data can be accessed by them using TCL.
Our data is stored in a table that is described by the schema, thus TCL commands deal with the schema.
SQL TCL commands can be used to perform any kind of retrieval or manipulation of the data present in SQL tables.
Transaction is able to control the following
Transaction
Commit
Rollback
All of the above