In the TRUNCATE statement, the ____ clause is omitted, as with the DELETE statement.
1.FROM
2.WHERE
3.FOR
4.WHAT
The rows can be inserted into one table or multiple tables through only ____ SQL statement.
1.One
2.Two
3.Three
4.Four
UNION ALL combines the results from multiple ____ statements in Oracle.
1.INSERT
2.SELECT
3.UPDATE
4.CREATE
. In the TRUNCATE statement, the ____ clause is omitted, as with the DELETE statement.
1.FROM
2.WHERE
3.FOR
4.WHAT
A record is inserted into a table using an Oracle ____ query.
1.Add
2.Insert
3.Alter
4.None
A table can be altered through an _____ query to add, delete, modify, or drop columns.
1.Drop
2.Delete
3.Modify
4.Alter
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
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
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
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
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
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
Data to be retrieved is specified by the ____ clause.
1.WHERE
2.FROM
3.WHAT
4.FOR
DISTINCT clauses can only be used in Oracle ____ statements.
1.SELECT
2.INSERT
3.UPDATE
4.DELETE
Dropping a table or view is done using an Oracle ____ query.
1.Drop
2.Delete
3.Read
4.Write
Duplicate records are removed from the result set using Oracle ____ clause.
1.DISTINCT
2.FROM
3.HAVING
4.ORDER BY
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
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
Multiple rows can be inserted using the Oracle ____ statement.
1.INSERT
2.INSERT ALL
3.INSERT FEW
4.INSERT MULTIPLE
Only the ____ statement uses the ORDER BY clause.
1.INSERT
2.UPDATE
3.SELECT
4.DELETE
Oracle database supports ____.
1.Inserting, Updating
2.Deleting, Altering Tables
3.Dropping, Creating and Selecting
4.None of these
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
Oracle lets you combine two ____ statements and remove duplicate rows between them using the UNION operator.
1.SELECT
2.DELETE
3.UPDATE
4.ALTER
SELECT expressions must contain a ____ clause.
1.FROM
2.WHERE
3.HAVING
4.FOR
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
Sort records in ascending order based on this parameter, which is an optional parameter -
1.ASC
2.DESC
3.DSC
4.AESC
The expression specifies the ____ you wish to retrieve.
1.Columns
2.Calculations
3.both (a) and (b)
4.None of these
The FROM clause must contain at least ____ table.
1.One
2.Two
3.Three
4.Four
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
The TRUNCATE method is usually used when _____ is not necessary.
1.Adding
2.Restoring
3.Reversing
4.Deleting
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
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
To update records within a table, Oracle ____ queries are used.
1.Update
2.Alter
3.Delete
4.Rename
To ___ records from a database, Oracle select queries are used.
1.Delete
2.Retrieve
3.Update
4.Add
To ____ a row from a table, you use the Oracle delete query.
1.Delete
2.Update
3.Drop
4.None
UPDATE information in an Oracle table is updated using the ____ statement. RENEW
1. UPDATE
2.ALTER
3.RENEW
4.RENAME
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
What is the parameter in HAVING clause?
1.Have_conditions
2.ASC
3.DESC
4.Having_conditions
What is/are the parameter in ORDER BY clause?
1.Expressions
2.ASC
3.DESC
4.All of the above
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
What is/are the parameter(s) in SELECT statement?
1.Expressions
2.Tables
3.Conditions
4.All of the above
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
You can create tables, views, sequences, procedures, and functions using Oracle _____ queries.
1.Create
2.Update
3.Alter
4.Delete
You can delete all records in an Oracle table using the ____ TABLE statement.
1.DELETE
2. DROP
3.TRUNCATE
4.None
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
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
__ are missing from Oracle drop queries.
1.Data
2.Structure
3.both (a) and (b)
4.None of the above
___ 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