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
Correct Answer :
C. Both A and B
A database does not need to be created in Oracle. A direct table creation option is provided in Oracle.
Related Questions
What does the following statement do?
Finds any values that start with a
Finds any values that start with a%
Finds any values that contains only two characters starting with a
All 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 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.
Select the correct method of Web SQL?
Execute SQL
Transaction
Open Database
All of the above
In order to join N tables, minimum number of join statements required is
N
N-1
N-2
N+1
Select the correct statement about SQL Scripts?
At the run time, the SQL*Plus commands are ignored.
SQL Scripts and SQL Commands in the SQL Scripts have no interaction.
Through the SQL Script editor, SQL Commands are cut and pasted.
All of the above
What is TRUE about NOT NULL Constraint?
In columns that are subject to the NOT NULL constraint, duplicate values are not allowed.
When a table's column is declared as NOT NULL, no record in the table can have an empty value for that column.
By applying the NOT NULL constraint, we will always ensure that the column contains a unique value and won't allow nulls.
The value will first be checked for certain conditions before inserting it into the column when a NOT NULL constraint applies to a column in the table.
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key
Savepoint command is used with _____ command.
Commit
Transaction
Rollback
None of the above
Rules that are needed to be followed in SET Operators in SQL are
All columns must be identical in number and order.
There must be compatibility between data types.
Both A and B
None 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
Which of the following is TRUE about SQL Auto Increment?
It increments the unique number automatically.
It decrements the unique number automatically.
It keeps the unique number constant
None of the above
Which of the following is not MySQL Numeric Data Type?
BIT(Size)
CHAR(Size)
INTEGER(Size)
INT(Size)
Which statement is true about the No-SQL?
No-SQL follows ACID Model.
No-SQL does require object-relational mapping.
Dynamic schemas for unstructured data are used in No-SQL databases.
No-SQL databases are not preferable for storage of hierarchal data.
Which of the following keyword is used to delete the Join?
DELETE
ON
WHERE
All of the above
What is the difference between nchar and nvarchar?
nchar is fixed and nvarchar is variable.
nchar is variable and nvarchar is fixed.
nchar has the maximum size of 4000 characters and nvarchar has the maximum size of 8000 characters.
nchar has the maximum size of 800 characters and nvarchar has the maximum size of 4000 characters.
To connect strings, which function is used
CONNECT
ADD
COMBINE
CONCAT
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.
A SELECT statement is intersected to use it as a join, but it only returns the records that are ________ between both statements.
Distinct
Common
Shared
Both B and C
Which of the following is NOT the SQL Arithmetic Operator?
Addition
Subtraction
Unary
Modulus
What does UCASE() function do?
Converts database field to uppercase
Converts database field to lowercase
Returns the length of the text field
Returns the current date and time
TRUNCATE TABLE requires:
WHERE clause
HAVING clause
Both a and b
None of the above
In order to execute a query in Web SQL, which function is used?
open()
translate()
transaction()
execute()
SQL has the advantage of?
SQL require a lot of programming.
SQL provides High-Speed Query Processing.
SQL follows the standard languages of ANSI and ISO.
SQL is easily portable.
In LIKE clause, to represent a zero, a character, or a number of characters ___ is used.
/
_
*
%
In how many categories data types has been classified?
2
3
4
5
SQL Operator can be,
Unary
Binary
Both A and B
None of the above
To delete table definition and all data from the table, which statement is used?
DELETE
DROP
ALTER
None of the above
Which of the following is supported in Comprehensive Data SubLanguage Rule in the 12 Codd's Rules?
Data Definition
View Definition
Data Manipulation
All of the above
With export, you can ____ SQL Scripts from the SQL repositories in your workspace.
Export
Import
Save
Exchange