With export, you can ____ SQL Scripts from the SQL repositories in your workspace.
Export
Import
Save
Exchange
Correct Answer :
B. Import
With export, you can import SQL Scripts from the SQL repositories in your workspace.
Related Questions
Which of the following statement is TRUE about DISTINCT Clause?
Returns only Distinct values.
Only on the single column, it operates.
It can be used with the aggregates such as COUNT, AVG, etc.
All of the above
Which of the following is SQL Server String Data Type?
ntext
binary(n)
varbinary
All of the above
SQL Operator can be,
Unary
Binary
Both A and B
None of the above
ROUND function consists of ___ parameters?
One
Two
Three
Four
Which of the following statement is true?
SQL statements are used for most operations in a database.
Relational algebra and tuple relationship calculus are needed for SQL syntax.
All of the above
None of the above
Which function returns the largest value of the column?
MIN()
MAX()
LARGE()
AVG()
Which of the following statement is TRUE for SQL Additional Operator?
SELECT operand1-operand2;
SELECT operand1*operand2;
SELECT operand1+operand2;
SELECT operand1>operand2;
SQL has the disadvantage of?
SQL is cheap.
SQL interface is simple.
Both A and B.
None of the above.
Determine the correct SQL command?
CREATE
UPDATE
DELETE
All of the above
Which of the following statement is TRUE about Primary Key?
Table integrity is not enforced by the primary key.
The data in a primary key is always multiple.
900 bytes is the maximum length of a primary key.
Null values are allowed in primary keys.
An SQL ____ is a virtual table, whose contents are based on the SQL statement's results.
Concatenate
Virtual
View
None of the above
TRUNCATE TABLE requires:
WHERE clause
HAVING clause
Both a and b
None of the above
Which of the following statement is TRUE?
Web API is the part of HTML5
Web API is not the part of HTML5
Web API is the part of HTML
Web API is the part of XHTML
Combining the results of ___ select statements will be done using UNION.
One
Two
Three
Four
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
In case of ____ data, recursive CTE is used?
Round
Hierarchal
Linear
None of the above
To get a record from one table, which is not present in another table, we can use the clause
CONCAT
COPY
EXCEPT
ALTER
Which of the following is TRUE about the type of SQL Injection attack?
Install malicious program
Export valuable data
Get user login detail
All of the above
Which statement is TRUE about the WHERE Clause?
In order to retrieve rows, WHERE Clause is used.
In order to group the rows, WHERE Clause is used.
In order to select the defined groups, WHERE Clause is used.
In order to return the rows, WHERE Clause is used.
In order to insert a row directly in the table, which command is used?
INSERT IN
INSERT INSIDE
INSERT UNDER
INSERT INTO
The SQL Modulus Operator returns the,
Quotient
Percentage
Sum
Reminder
For integer value, which data type is supported in Oracle?
INT
Number
Digit
None of the above
Temporary variables use ____ resources than table variables.
More
Less
Equal
None of the above
To connect strings, which function is used
CONNECT
ADD
COMBINE
CONCAT
In how many categories data types has been classified?
2
3
4
5
It is possible to use LIKE clauses with
Strings
Numbers
Both A. and B.
None of the above
What is meant by 'SQL is an interactive language'?
Learning and understanding SQL is easy
It can also be used for communicating with the database.
In a few seconds, complex queries can also be answered using this language.
All of the above
Local Temp Variable is used with which sign?
?
@
#
&
SQL BETWEEN operators include
Starting Value
In Between Value
Ending Value
All of the above
At which of the following stage does SQL Injection occurs?
When the user is asked to logout
When the user is asked to input password
When the user is asked to input captcha
When the user is asked to input username