Using the SQL last() function, one can return the ______ value of the selected column.
First
Second
Third
Last
Correct Answer :
D. Last
Using the SQL last() function, one can return the last value of the selected column.
Related Questions
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
Which of the following is TRUE about Information Rule in the 12 Codd's Rules?
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.
Null values are treated in database records according to this rule.
Database systems must update all views tables on a regular basis.
Databases contain a wide variety of information, and each row and column of each table must hold this information.
SQL BETWEEN operators can be used to select the
Dates
Texts
Numbers
All of the above
In LIKE clause, to represent a single character, _____ is used.
-
_
!
&
In the case of the ____ Independence Rule, It shouldn't make a difference what the user sees (application) if the logical structure changes.
Physical Data
Logical Data
Integrity
Distribution
Which of the following clause cannot be used in SQL sub queries?
GROUP BY
ORDER BY
DELETE
FROM
In order to start the transaction, the command used is
Mysql > START COMMIT;
Mysql > START TRANSACTION;
Mysql > START ROLLBACK;
None of the above
Select the correct syntax for Savepoint.
Mysql > Transaction ini;
Mysql > &Savepoint;
Mysql > START Transaction;
Mysql > Savepoint ini;
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
Using which SQL Comparison Operator can we find the data that matches our query?
SQL Not Equal Operator (!=)
SQL Equal Operator (=)
SQL Greater Than Operator (>)
SQL Less Than Operator (<)
What is the difference between Column Level and Table Level Constraints?
Constraints are applied to a single row using Column Level Constraints whereas Multiple rows can be constrained using a Table Level Constraint.
Constraints are applied to multiple rows using Column Level Constraints whereas a single row can be constrained using a Table Level Constraint.
Constraints are applied to a single column using Column Level Constraints whereas Multiple columns can be constrained using a Table Level Constraint.
Constraints are applied to multiple columns using Column Level Constraints whereas only a single column can be constrained using a Table Level Constraint.
Primary keys can be contained in a table only ____?
Once
Twice
Thrice
None of the above
Which function combines the two different columns?
ADD
MERGE
CONCAT
None of the above
A Key which uniquely identifies each row in the table is known as?
Primary Key
Unique Key
Composite Key
Foreign Key
How can we prevent SQL Injection attack?
We should pre-define the input type, input field and length of the user data to validate the input for the user authentication.
Access privileges should be restricted for the users
Administrator accounts should not be used.
All of the above
A Primary Key is basically a
Row
Column
Table
Database
Which of the following statement is TRUE?
At run time, temporary tables can be created.
Temporary table can do similar operations to normal table.
Both A) and B)
None of the above
Full form of DCL is -
Data Control Language
Data Commit Language
Data Common Language
Data Concatenate Language
What is TRUE about SQL EXCEPT clause?
The result is purged of duplicates
Duplicate records are not removed
Only one column can be compared by a clause
None of the above
In the relational database, in order to modify index, we need to use which command?
ALTER
MODIFY
UPDATE
ADD
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
Full form of LCASE is -
Low case
Letter case
Light case
Lower case
What is the difference between VARCHAR and VARCHAR2?
VARCHAR can store upto 4000 bytes and VARCHAR2 can store upto 8000 bytes.
VARCHAR can store upto 2000 bytes and VARCHAR2 can store upto 4000 bytes.
Both VARCHAR and VARCHAR2 are similar but use of VARCHAR2 is mostly recommended.
There is no similarity between VARCHAR and VARCHAR2.
By constraining a SQL statement, we limit the ____ according to certain conditions or restrictions.
Row
Column
Table
Database
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
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
Select the correct rule of SQL EXCEPT.
There must be the same number of columns in each table and the same order in every select statement.
It is desirable that the columns have similar or compatible data types.
Both SELECT statements must have the same fields in their respective columns.
All of the above
SQL indexes speed up the execution time of which statement(s)?
SELECT
WHERE
Both A and B
None of the above
What is the work of DELETE command?
A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
Database data can be updated or changed using this command.
Database objects such as tables, table views, and other objects can be deleted using this command.
Using this command, you can remove or erase recorded information from a database table.
What is the difference between nvarchar and ntext?
nvarchar is fixed and ntext is variable.
nvarchar is variable and ntext is fixed.
nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 2GB of the text data.
nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 1GB of the text data.