Select the correct syntax of SELECT TOP clause?
SELECT TOP name
SELECT TOP column
SELECT TOP FROM
SELECT TOP Number
Correct Answer :
D. SELECT TOP Number
The correct syntax of SELECT TOP clause is SELECT TOP Number.
Related Questions
Whenever a sub query appears in SQL, it is enclosed within ____ and placed to the ____ of the SQL operators.
Brackets, Left
Brackets, Right
Parenthesis, Left
Parenthesis, Right
Which of the following is TRUE about UNIQUE constraint?
In columns that are subject to the UNIQUE constraint, duplicate values are not allowed.
Unique values will always be present in the column containing the unique constraint.
A single table can have more than one unique constraint, since it can be applied to more than one column.
All of the above
What is TRUE about SAVEPOINT?
Following the completion of a transaction, it must be executed to save all the operations performed in the transaction.
A transaction can be rolled back to its last saved state.
A specific part of a transaction can be given a name
None of the above
Which function returns the correct date and time?
DATE()
NOW()
TIME()
DATETIME()
SQL INSERT is used to insert a
Single or Multiple record
Single or Multiple database
Single or Multiple table
None of the above
By constraining a SQL statement, we limit the ____ according to certain conditions or restrictions.
Row
Column
Table
Database
In the database table, data types describe the kind of ___ that it can contain.
Table
Data
Number
None of the above
What is the difference between DELETE and TRUNCATE statements?
DELETE statement free up the space kept in check by the table whereas TRUNCATE statement does not free up the space kept in check by the table.
DELETE statement does not free up the space kept in check by the table whereas TRUNCATE statement free up the space kept in check by the table.
DELETE statement only deletes rows from the table whereas TRUNCATE statement can only delete columns from the table.
DELETE statement only deletes columns from the table whereas TRUNCATE statement can only delete rows from the table.
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.
The scalar functions operate on each record ____ in SQL.
Dependently
Independently
Interdependently
Intradependently
Full form of DCL is -
Data Control Language
Data Commit Language
Data Common Language
Data Concatenate Language
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])
Which command will remove the records from the table, but not affect the structure of the table?
REMOVE
DELETE
DROP
TRUNCATE
What does the DELETE Statement do?
A new table in SQL is created using this SQL statement.
By deleting the stored data, this SQL statement deletes the database.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
By executing this SQL statement, you remove the table and all the information that it contains, including the structure, views, permissions, and triggers.
Which of the following statement is correct?
Comparison Operator has higher precedence than Conjuction Operator.
Identity Operator has higher precedence than Multiplication Operator.
Both A and B
None of the above
Which of the following is the type of SQL Injection attack?
It inserts the data
It updates the data
It deletes the data
All of the above
Which clause is used to retrieve a unique element from the table?
SELECT UNIQUE
SELECT DISTINCT
Both A) and B)
None of the above
BETWEEN operator is used with which SQL Statements
SELECT
DELETE
INSERT
All of the above
Which of the following statement is false?
There is no difference between a lower case and upper case keyword in SQL.
It is easier to read SQL queries when the keywords are in lowercase.
An SQL statement's syntax is determined by its text line.
One or more SQL statements can be placed on a single line of text.
Full form of TCL is -
Transaction Common Language
Transaction Commit Language
Transaction Concatenate Language
Transaction Control Language
In the case of ____ Independence Rule, Physical independence of data to access the database is a requirement for a database or an application.
Physical Data
Logical Data
Integrity
Distribution
Select the function which is not the Scalar Function(s)?
UCASE()
LEN()
SUM()
NOW()
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
Full form of DDL is
Data Describe Language
Definition Data Language
Data Definition Language
Data Distinct Language
GROUP BY clause is placed before which clause in SQL?
HAVING
WHERE
ORDER BY
FROM
Which of the following are not MySQL Date and Time Data Type?
DATE
TIME(fsp)
YEAR
None of the above
What does the following statement do?
Finds any values that start with a
Finds any values that start with a%
Finds any values that start with a and are at least 2 characters in length
All of the above
SQL BETWEEN is a ______ operator.
Relational
Logical
Arithmetic
Assignment
Which syntax is correct for RENAME DATABASE in SQL?
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;
Which one of the syntaxes given below is of Binary Operator?
Operator SQL _Operand
Operand2 SQL _Operator Operand1
Operand1 SQL _Operator Operand1
Operand1 SQL _Operator Operand2