What is the full form of GUID?
Guided Unique Identifier
Guided Unique Interpreter
Globally Unique Identifier
Globally Unique Interpreter
Correct Answer :
C. Globally Unique Identifier
Full form of GUID is Globally Unique Identifier.
Related Questions
What does task list consist of in SQL Script?
Import
Show Quotas
Manage Results
All of the above
Using the SQL first() function, one can return the ____ value of the selected column.
First
Second
Third
Last
The numerical values of two ___ of the ___ table can be easily subtracted using SQL Subtraction Operator.
Rows, same
Columns, same
Rows, different
Columns, different
Which function returns the correct date and time?
DATE()
NOW()
TIME()
DATETIME()
Which of the following states the correct situation in which Indexes should not be used in SQL?
When the table is small, it is possible to avoid using SQL indexes.
Updates need to be made frequently to the table.
When there are a lot of NULL values in a column, indexed should not be used.
All of the above
Which of the following is SQL Server Date and Time Data Type?
timestamp
sql_variant
real
text
To add a Primary Key constraint after table is created, which clause is used?
UPDATE
ADD
ALTER
JOIN
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
Which command will remove the records from the table, but not affect the structure of the table?
REMOVE
DELETE
DROP
TRUNCATE
We can create View in SQL using
CREATE statement
CREATE VIEW statement
VIEW CREATE statement
SQL VIEW statement
In order to prevent multiple records from being returned by the sub query, ____ must be used before the sub query.
Many Value Operators
Multiple Value Operators
Single Value Operator
Unique Value Operator
What is the keyword of the Ascending and Descending?
ASCE, DESC
ASC, DES
ASCE, DES
ASC, DESC
Full form of LCASE is -
Low case
Letter case
Light case
Lower case
Which syntax is correct for RENAME DATABASE in MySQL?
RENAME old_database_name TO new_database_name;
RENAME DATABASE old_database_name TO new_database_name;
ALTER old_database_name MODIFY NAME = new_database_name;
ALTER DATABASE old_database_name MODIFY NAME = new_database_name;
In case of ____Rule, 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.
Systematic Treatment of Null Values
Guaranteed Access
View Updating
Physical Data Independence
In SQL SELECT COUNT, one needs to specify the
Column Name
Row Name
Table Name
None of the above
To get the table's previous permanent status, use the ____ command.
Commit
Transaction
Rollback
None of the above
Determine the correct SQL command?
CREATE
UPDATE
DELETE
All of the above
What can be the maximum size of char(n) in SQL Server String Data Type?
7000
8000
9000
10000
Commands that come under TCL is/are -
COMMIT
ROLLBACK
SAVEPOINT
All of the above
Comments whose starting and ending lines are different are known as
Inline Comments
Multi-line Comments
Single Line Comments
Varied line Comments
It is possible to retrieve time in a more readable format, using which function?
TIME
TIME_FORM
TIME_FORMAT
TIME & DATE
What does the DROP DATABASE Statement do?
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.
In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.
Which statement is TRUE about the GROUP BY Clause?
In order to retrieve rows, GROUP BY Clause is used.
In order to group the rows that share the same property, GROUP BY Clause is used.
In order to select the defined groups, GROUP BY Clause is used.
In order to return the rows, GROUP BY Clause is used.
Difference between GRAND & REVOKE command is/are?
The GRANT command can be used to grant a user access to databases and tables whereas The REVOKE command can be used to revoke all access privileges already assigned to the user.
The REVOKE command can be used to grant a user access to databases and tables whereas The GRANT command can be used to revoke all access privileges already assigned to the user.
A transaction can be rolled back to its last saved state.
None of the above
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
ROUND function consists of ___ parameters?
One
Two
Three
Four
The scalar functions operate on each record ____ in SQL.
Dependently
Independently
Interdependently
Intradependently
SQL contains which component in its process?
Optimization Engines
SQL Query Engines
Query Dispatchers
All of the above
What is Export Script by default?
Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl