In SQL, which statement can help in changing the name of the table?
RENAME
ALTER
Both A) and B)
None of the above
Correct Answer :
C. Both A) and B)
In SQL, RENAME and ALTER statement can help change the name of the table.
Related Questions
Using which clause, can SQL EXCEPT be used in single table?
TO
AS
WHERE
IN
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 of the following statement(s) is/are TRUE about DCL?
The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.
There will be certain privileges that each user has; consequently, the data can be accessed by them.
The DCL commands in SQL allow us to grant privileges to a user on the SQL database and its table(s), or revoke privileges that have already been granted.
All of the above
What is SQL CREATE Table used for?
To Update table
To Create table
To Delete table
None of the above
Using the ___ statement, a database can be renamed.
SQL CREATE DATABASE
SQL RENAME DATABASE
SQL DROP DATABASE
SQL SELECT DATABASE
Using the SQL last() function, one can return the ______ value of the selected column.
First
Second
Third
Last
Host-based IDS can be used to monitor
Web server logs
When something weird occurs
Both A) and B)
None of the above
Global Temp Variable is used with which sign?
###
####
#
##
For integer value, which data type is supported in Oracle?
INT
Number
Digit
None of the above
In more readable form, you can retrieve the date values, using ______ function?
DATE
DATE_FORM
DATE_FORMAT
DATE_VALUE
When the table is dropped:
Table structure is dropped
Integrity constraints are dropped
Relationship is dropped
All of the above
What is the difference between HAVING and WHERE clause?
HAVING clause is used in column operation whereas WHERE clause is used in row operation.
HAVING clause is post-filter whereas WHERE clause is pre-filter.
HAVING clause filters the groups whereas WHERE clauses filter the single record of the table.
All of the above
Full form of TCL is -
Transaction Common Language
Transaction Commit Language
Transaction Concatenate Language
Transaction Control Language
SQL DELETE can be used to delete,
Rows
Database
View
All of the above
What is the functionality of UCASE function?
To change the case of the string to lowercase characters.
To change the case of the string to uppercase characters.
To change the case of the string to numeric characters.
To change the case of the string to symbolic characters.
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
What is the meaning of Null Values in Systematic Treatment of Null Values in the 12 Codd's Rules?
No value in cell
Inappropriate Information
Unknown data
All 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
What is the work of CREATE command?
Using this command, you can remove or erase recorded information from a database table.
It enables you to create new databases, tables, table views, and other objects using this command.
Inserting records or data into the database tables is accomplished with this command. In addition to inserting records in single rows, we can insert records in multiple rows as well.
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.
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.
What is the symbol of Concatenation Operator?
|
||
//
\
In LIKE clause, to represent a single character, _____ is used.
-
_
!
&
In order to start the transaction, the command used is
Mysql > START COMMIT;
Mysql > START TRANSACTION;
Mysql > START ROLLBACK;
None of the above
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.
Which of the following statement is correct for SQL Multiplication Operator?
SELECT Operand1+Operand2;
SELECT Operand1*Operand2;
SELECT Operand1**Operand2;
SELECT Operand1
Output returned by the Scalar functions is/are -
Single Value
Multiple Value
Two Values
None of the above
What does task list consist of in SQL Script?
Import
Show Quotas
Manage Results
All of the above
TRUNCATE TABLE requires:
WHERE clause
HAVING clause
Both a and b
None of the above
We can create View in SQL using
CREATE statement
CREATE VIEW statement
VIEW CREATE statement
SQL VIEW statement
To rename the Index, we need to use which command?
RENAME
ALTER
UPDATE
ADD