databases Online Quiz - 86
|Description: databases Online Quiz - 86|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
Which character is used to continue a statement in SQL*Plus?
To answer this question, you need to understand how statements are executed in SQL*Plus.
In SQL*Plus, a statement can be continued onto the next line by using the hyphen ("-") character. This is known as a line continuation character.
Option A) * - This character is not used to continue a statement in SQL*Plus. Option B) / - This character is used to execute a statement in SQL*Plus, but it is not used to continue a statement onto the next line. Option C) - This character is the correct answer. It is used to continue a statement onto the next line in SQL*Plus. Option D) @ - This character is used to run a script or a file in SQL*Plus, but it is not used to continue a statement onto the next line.
The correct answer is Option C) -. This character is used to continue a statement in SQL*Plus.
To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?
Choose true option
Truncate is faster than delete
If base table does not exists, can we create a view?
If the base table of a view is deleted and we give SQL Select command on view table name
Which of the following data types are used in SQL?
Which of the following SQL statement create a sequence SE with starting value as 30 and in increments of 20?
Which of the following is TRUE about Primary Key?
Which of the following is not allowed while creating a table using CRRATE TABLE in SQL?
With SQL, how can you return the number of records in the "Persons" table?
Which SQL keyword is used to sort the result-set?
Which SQL statement is used to return only different values?