What is Export Script by default?
Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl
Correct Answer :
C. Workspace_name_script/sql
Export script is by default Workspace_name_script/sql/.
Related Questions
What does the SELECT Statement do?
Data is read from the SQL database by this statement and displayed to the database user.
The stored data in the SQL database is changed or modified by this SQL statement.
By deleting the stored data, this SQL statement deletes the database.
A new table in SQL is created using this SQL statement.
It is possible to use LIKE clauses with
Strings
Numbers
Both A. and B.
None of the above
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;
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.
What does SQL is used to perform operations on?
Update Records
Insert Records
Both A and B
None of the above
What does the COMMIT Statement do?
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.
Specify the columns of the table in this SQL statement to return distinct values.
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
Which of the following are not MySQL Date and Time Data Type?
DATE
TIME(fsp)
YEAR
None of the above
In order to manage or store the data in the database, WEB SQL Database is used which is a
Web site
Web page
Web browser
None of the above
Which function returns the correct date and time?
DATE()
NOW()
TIME()
DATETIME()
Which of the following statement is TRUE for SQL Additional Operator?
SELECT operand1-operand2;
SELECT operand1*operand2;
SELECT operand1+operand2;
SELECT operand1>operand2;
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.
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
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.
Which function is used to obtain the month from the entire data stored in a table's column?
DATE
TIME
MONTH
DATE & TIME
What does AVG() function returns?
First value of the column
Last value of the column
Sum of rows of the table
Average value of the column
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
A database does not need to be created in ____. A direct table creation option is provided in ____.
MySQL
Oracle
Both A and B
None of the above
What is the difference between UNION & UNION ALL operators?
Combining the results of two select statements will be done using UNION whereas combined records from both queries are returned by UNION ALL operator.
Combining the results of two select statements will be done using UNION ALL whereas combined records from both queries are returned by UNION operator.
After performing the UNION operation, duplicate rows will not be removed whereas after performing the UNION ALL operation, duplicate rows will be removed.
None of the above
Which of the following is the feature(s) of SQL Auto Increment?
In some cases you may not have any unique identifying characteristics in data; therefore, it makes sense to create a Primary Key.
Explicitly initializing and modifying the auto-increment value is possible at any time.
Record identifiers can easily be created that are unique to each record.
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 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 TRUE?
A DATABASE name can be renamed.
A TABLE name can be renamed.
Both A and B
None of the above
The records and structure of a table may be removed or deleted from the database using which command?
REMOVE
DELETE
DROP
TRUNCATE
Which of the following clause cannot be optional in SQL SELECT Statement?
WHERE
GROUP BY
ORDER BY
None of the above
What is the work of UPDATE 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.
Using this command, you can remove or erase recorded information from a database table.
Database data can be updated or changed using this command.
It enables you to create new databases, tables, table views, and other objects using this command.
What does the DROP DATABASE Statement do?
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.
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.
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
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
A Sub query is an SQL expression that is placed ____ another SQL statement.
Before
After
Inside
Outside
SQL Indexes slows the execution time of which statement(s)?
UPDATE
INSERT
SELECT
Both A and B