In the TRUNCATE statement, the ____ clause is omitted, as with the DELETE statement.
1.FROM
2.WHERE
3.FOR
4.WHAT
Posted Date:-2022-11-15 07:56:40
The rows can be inserted into one table or multiple tables through only ____ SQL statement.
1.One
2.Two
3.Three
4.Four
Posted Date:-2022-11-15 07:47:02
UNION ALL combines the results from multiple ____ statements in Oracle.
1.INSERT
2.SELECT
3.UPDATE
4.CREATE
Posted Date:-2022-11-15 09:10:52
. In the TRUNCATE statement, the ____ clause is omitted, as with the DELETE statement.
1.FROM
2.WHERE
3.FOR
4.WHAT
Posted Date:-2022-11-15 10:03:30
A record is inserted into a table using an Oracle ____ query.
1.Add
2.Insert
3.Alter
4.None
Posted Date:-2022-11-15 07:34:26
A table can be altered through an _____ query to add, delete, modify, or drop columns.
1.Drop
2.Delete
3.Modify
4.Alter
Posted Date:-2022-11-15 07:39:23
A table can be truncated or removed via Oracle truncate queries.
1.Truncated
2.Removed
3.both (a) and (b)
4.None of the above
Posted Date:-2022-11-15 07:36:15
After the UNION, the result set would only contain a ____ instance of it because Oracle removes duplicates.
1.Single
2.Double
3. Triple
4.Multiple
Posted Date:-2022-11-15 09:07:27
As part of a UNION operation, individual SELECT statements must have ___ fields and similar types of data in their result sets.
1.Duplicate
2.Triplate
3.Identical
4.Multiple
Posted Date:-2022-11-15 09:05:58
By putting the ____ keyword in a database, you can insert an element into a database in the simplest way.
1.VALVE
2.VAULE
3.VALUE
4.VULEA
Posted Date:-2022-11-15 07:44:50
By using the INSERT ALL statement, multiple rows can be inserted into more than one table by a ____ command.
1.Single
2.Double
3.Triple
4. Multiple
Posted Date:-2022-11-15 07:47:39
By using the _____ clause with the GROUP BY Clause in Oracle, the condition TRUE is used to limit the rows returned which are grouped into groups.
1.HAVE
2.HAVIN
3.HAVING
4.None of These
Posted Date:-2022-11-15 08:56:12
Data to be retrieved is specified by the ____ clause.
1.WHERE
2.FROM
3.WHAT
4.FOR
Posted Date:-2022-11-15 08:49:55
DISTINCT clauses can only be used in Oracle ____ statements.
1.SELECT
2.INSERT
3.UPDATE
4.DELETE
Posted Date:-2022-11-15 08:46:56
Dropping a table or view is done using an Oracle ____ query.
1.Drop
2.Delete
3.Read
4.Write
Posted Date:-2022-11-15 07:36:52
Duplicate records are removed from the result set using Oracle ____ clause.
1.DISTINCT
2.FROM
3.HAVING
4.ORDER BY
Posted Date:-2022-11-15 08:31:05
having_conditions parameter specifies the conditions that will be applied only to ____ results so that the returned rows can be grouped accordingly.
1.Analytical
2.Relational
3.Aggregated
4.None of These
Posted Date:-2022-11-15 08:57:37
In the case of UNION Operations, there must be the ___ number of expressions in both statements of the SELECT statement.
1.Different
2.Multiple
3.Same
4.None
Posted Date:-2022-11-15 09:06:37
Multiple rows can be inserted using the Oracle ____ statement.
1.INSERT
2.INSERT ALL
3.INSERT FEW
4.INSERT MULTIPLE
Posted Date:-2022-11-15 07:46:15
Only the ____ statement uses the ORDER BY clause.
1.INSERT
2.UPDATE
3.SELECT
4.DELETE
Posted Date:-2022-11-15 08:51:18
Oracle database supports ____.
1.Inserting, Updating
2.Deleting, Altering Tables
3.Dropping, Creating and Selecting
4.None of these
Posted Date:-2022-11-15 07:32:42
Oracle has a _____ statement that is used to delete a record from a table or multiple records from a table.
1.DELETE
2.DROP
3.DELT
4.DROPOUT
Posted Date:-2022-11-15 07:52:56
Oracle lets you combine two ____ statements and remove duplicate rows between them using the UNION operator.
1.SELECT
2.DELETE
3.UPDATE
4.ALTER
Posted Date:-2022-11-15 09:05:14
SELECT expressions must contain a ____ clause.
1.FROM
2.WHERE
3.HAVING
4.FOR
Posted Date:-2022-11-15 08:48:38
SELECT statements in Oracle are used to group results by a single column or multiple columns by using the _____ clause.
1.GROUP
2.GROUP FOR
3.GROUP BY
4.GROUP TO
Posted Date:-2022-11-15 08:54:44
Sort records in ascending order based on this parameter, which is an optional parameter -
1.ASC
2.DESC
3.DSC
4.AESC
Posted Date:-2022-11-15 08:52:42
The expression specifies the ____ you wish to retrieve.
1.Columns
2.Calculations
3.both (a) and (b)
4.None of these
Posted Date:-2022-11-15 07:41:55
The FROM clause must contain at least ____ table.
1.One
2.Two
3.Three
4.Four
Posted Date:-2022-11-15 07:43:23
The Oracle _____ statement retrieves data from a table, an object table, a view, an object view, etc.
1.SELECT
2.CREATE
3.UPDATE
4.DELETE
Posted Date:-2022-11-15 07:40:11
The TRUNCATE method is usually used when _____ is not necessary.
1.Adding
2.Restoring
3.Reversing
4.Deleting
Posted Date:-2022-11-15 07:57:33
There is no effect on the _____ of the table with the TRUNCATE TABLE statement.
1.Indexes
2.Triggers
3.Dependencies
4.All of the above
Posted Date:-2022-11-15 07:58:30
There is no effect on the _____ of the table with the TRUNCATE TABLE statement. Indexes
1.Indexes
2.Triggers
3.Dependencies
4.All of the above
Posted Date:-2022-11-15 10:02:18
To update records within a table, Oracle ____ queries are used.
1.Update
2.Alter
3.Delete
4.Rename
Posted Date:-2022-11-15 07:35:01
To ___ records from a database, Oracle select queries are used.
1.Delete
2.Retrieve
3.Update
4.Add
Posted Date:-2022-11-15 07:33:28
To ____ a row from a table, you use the Oracle delete query.
1.Delete
2.Update
3.Drop
4.None
Posted Date:-2022-11-15 07:35:40
UPDATE information in an Oracle table is updated using the ____ statement. RENEW
1. UPDATE
2.ALTER
3.RENEW
4.RENAME
Posted Date:-2022-11-15 07:49:47
Using the ____ Clause in Oracle, records in a result set can be sorted or rearranged.
1.ORDER
2.ORDER TO
3.ORDER FOR
4.ORDER BY
Posted Date:-2022-11-15 08:50:40
What is the parameter in HAVING clause?
1.Have_conditions
2.ASC
3.DESC
4.Having_conditions
Posted Date:-2022-11-15 08:56:56
What is/are the parameter in ORDER BY clause?
1.Expressions
2.ASC
3.DESC
4.All of the above
Posted Date:-2022-11-15 08:51:59
What is/are the parameter(s) in GROUP BY clause?
1.Aggregate_function
2.Aggregate_expression
3.both (a) and (b)
4.None of these
Posted Date:-2022-11-15 08:55:26
What is/are the parameter(s) in SELECT statement?
1.Expressions
2.Tables
3.Conditions
4.All of the above
Posted Date:-2022-11-15 07:40:48
When two or more Oracle Select statements are combined with the ____ operator, the result sets are combined.
1.UNION
2.UNITE
3.UNIQUE
4.None
Posted Date:-2022-11-15 09:03:43
You can create tables, views, sequences, procedures, and functions using Oracle _____ queries.
1.Create
2.Update
3.Alter
4.Delete
Posted Date:-2022-11-15 07:38:25
You can delete all records in an Oracle table using the ____ TABLE statement.
1.DELETE
2. DROP
3.TRUNCATE
4.None
Posted Date:-2022-11-15 07:54:28
You can use the Oracle ____ operator if you don't want to remove duplicate data.
1.UNION NONE
2.UNION ALL
3.UNION ONE
4.UNION MULTIPLE
Posted Date:-2022-11-15 09:08:32
You specify the tables from which you want records to be retrieved by the ____ parameter.
1.Expressions
2.Tables
3.Conditions
4.None of these
Posted Date:-2022-11-15 07:42:41
__ are missing from Oracle drop queries.
1.Data
2.Structure
3.both (a) and (b)
4.None of the above
Posted Date:-2022-11-15 07:37:44
___ statements are used to insert a single record into a table or to insert multiple records at once.
1.SELECT
2.UPDATE
3.ADD
4.INSERT
Posted Date:-2022-11-15 07:44:02