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.
Correct Answer :
B. It enables you to create new databases, tables, table views, and other objects using this command.
INSERT command enables you to create new databases, tables, table views, and other objects.
Related Questions
Which of the following statement is correct for SQL Multiplication Operator?
SELECT Operand1+Operand2;
SELECT Operand1*Operand2;
SELECT Operand1**Operand2;
SELECT Operand1
What does the UPDATE Statement do?
By deleting the stored data, this SQL statement deletes the database.
A new table in SQL is created using this SQL statement.
The stored data in the SQL database is changed or modified by this SQL statement.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
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.
Select the correct constraint in SQL?
NOT NULL
CHECK
DEFAULT
All of the above
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
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
In order to join N tables, minimum number of join statements required is
N
N-1
N-2
N+1
What does the INSERT INTO Statement do?
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.
A new database will be created through this SQL statement.
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
By executing this SQL statement, all records in the SQL database will be deleted.
Which of the following are not MySQL Date and Time Data Type?
DATE
TIME(fsp)
YEAR
None of the above
Select the correct order of precedence among the following?
OR > NOT > + > **
NOT > OR > ** > +
** > + > OR > NOT
** > + > NOT > OR
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key
Select the correct statement which will return all the rows from the Table and then also deletes the Table_Add table?
SELECT * FROM Table; DROP TABLE Table_Add
SELECT * WHERE Table; DROP TABLE Table_Add
SELECT * FROM Table; DELETE TABLE Table_Add
SELECT * WHERE Table; DELETE TABLE Table_Add
What does the CREATE INDEX Statement do?
An index is created in a SQL database table with this SQL statement.
Changes made in the SQL database transaction are permanently saved using this SQL statement.
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
The SQL database table's index is deleted using this SQL statement.
A Sub query is an SQL expression that is placed ____ another SQL statement.
Before
After
Inside
Outside
Which statement is used to select the database in SQL?
SELECT
USE
ALTER
CREATE
To get a record from one table, which is not present in another table, we can use the clause
CONCAT
COPY
EXCEPT
ALTER
What is Export Script by default?
Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl
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.
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.
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 clause to delete all rows from the table?
SQL DELETE ALL ROWS Table_Name;
SQL DELETE ROWS Table_Name;
DELETE FROM ALL ROWS Table_Name;
DELETE FROM Table_Name;
What does the TRUNCATE TABLE Statement do?
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
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.
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.
Select the correct syntax of SELECT TOP clause?
SELECT TOP name
SELECT TOP column
SELECT TOP FROM
SELECT TOP Number
SQL DELETE can be used to delete,
Rows
Database
View
All of the above
Which of the following keyword is used to delete the Join?
DELETE
ON
WHERE
All of the above
By constraining a SQL statement, we limit the ____ according to certain conditions or restrictions.
Row
Column
Table
Database
Which statement is used to select the database in Oracle?
USE
SELECT
RENAME
None of the above
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])
The scalar functions operate on each record ____ in SQL.
Dependently
Independently
Interdependently
Intradependently
In order to update one table using another table and join condition, which statement is used.
SQL UPDATE INTO
SQL UPDATE JOIN
SQL JOIN
SQL JOIN UPDATE