In addition to eliminating all ____ integrity constraints, CASCADE CONSTRAINTS will also drop all other constraints.
1.Consecutive
2.Sequential
3.Referential
4.Relational
What does the table_name in syntax specifies?
1.Specifies the table name that you would like to create.
2.Specifies the table number that you would like to create.
3.Specifies the table row that you would like to create.
4.Specifies the table column that you would like to create.
What is the statement to modify the column in the table?
1.MODIFY
2.MODULE
3.UPDATE
4.ALTER
What is the syntax of CREATE TABLE AS?
1.CREATE TABLE table_name AS (SELECT*FROM previoustable_name)
2.CREATE TABLE table_name IN (SELECT*FROM previoustable_name)
3.CREATE TABLE table_name FROM (SELECT*FROM previoustable_name)
4.CREATE TABLE table_name AT (SELECT*FROM previoustable_name)
A new table is created in an Oracle database using the ____ TABLE statement.
1.CREATE
2.UPDATE
3.ALTER
4.NEW
A new table will contain records from the ___ table if it is created using the CREATE TABLE AS method.
1.Existing
2.New
3.Redundant
4.None of these
ALTER TABLE is also used to ____ the table.
1.Revert
2.Rename
3.Resize
4.Reuse
Around 20 different _____ protocols and over 100 different hardware platforms are supported by this database.
1.Networking
2.Repeating
3.Adhesive
4.Hardware
Backups can be performed ____ with RMAN.
1.Online
2.Archived
3.Continuously
4.All of the above
By copying the columns of an existing table, the CREATE TABLE __ statement creates a new table based on an existing table.
1.AS
2. IN
3.ON
4.FOR
By using the RMAN (_____ Manager) functionality of the Oracle database, it is very easy to recover quickly.
1.Remodule
2.Restore
3.Recovery
4.Recycle
For ____ programming, PL/SQL extension support is one of the biggest benefits of Oracle databases.
1.Procedural
2.Non-procedural
3.Structural
4.Non-structural
It is possible to manage services across multiple instances using ____ together.
1.Database Resource Management
2.Instane Caging
3.both (a) and (b)
4.None of these
Multiple database instances can be managed on ____ server with Oracle database.
1.One
2.Two
3.Three
4.Multiple
Oracle will ____ the table if there is a referential integrity constraint on table_name that is not specified as CASCADE CONSTRAINTS on the DROP TABLE statement.
1.Not Drop
2.Drop
3.Not Delete
4.Delete
Oracle's database can be ____ from one platform to another compared to other competitors.
1.Texted
2.Ported
3.Changed
4.Mixed
Oracle's temporary tables are local to the ____ in which they are created and cannot be accessed outside of that ____.
1.Session
2.Time
3.Date
4.None of these
Primary keys can only be found in ____ table at a time.
1.One
2.Two
3.Three
4.Multiple
SQL* ____ can also be used for recovery, which is also known as user-managed recovery.
1.MINUS
2.PLUS
3.MULTIPLY
4.DIVIDE
Tables are created by _____ types for each column.
1.Naming them
2. Defining their Columns
3.Specifying the Data
4.All of the above
The ALTER TABLE statement specifies whether a column should be ____ or deleted in a table in Oracle.
1.Added
2.Modified
3.Dropped
4.All of the above
The application manages CPU allocations on a database instance server using an instance ____ approach.
1.Caging
2.Gazing
3.Hazing
4.Wazing
The main difference between temporary tables and ordinary tables is that temporary tables cannot have ____ keys related to other tables
1.Primary
2.Foreign
3.Composite
4.Alternate
The schema owned by a table is specified by what?
1.Schema_name
2.Table_name
3.CASCADE CONSTRAINS
4.PURGE
The _____ and block types are all available to temporary tables.
1.Triggers
2.Join Cardinality
3.Information about rows
4.All of the above
Using performance optimization techniques in its database, we can reduce ____.
1.Query Execution Time
2. Increase Operations
3.both (a) and (b)
4.None of These
Using ____ technology, it is possible to recover those data that have been improperly deleted or lost due to human error. These include data that has been accidentally deleted, data that has been deleted in error, or data that has been dropped.
1.Backup
2.Recovery
3.Flashback
4.Deletion
What is the statement to drop a column in the table?
1.DROP ROW
2.DELETE ROW
3.DROP COLUMN
4.DELETE COLUMN
What is the statement to rename a column in the table?
1.RENAME COLUMN
2.RENAME ROW
3.RECHANGE COLUMN
4. UPDATE COLUMN NAME
What is the syntax of creating global temporary tables?
1.CREATE GLOBAL TEMPORARY TABLE
2.CREATE LOCAL TEMPORARY TABLE
3.CREATE TEMPORARY TABLE
4.None
What is the syntax to add column in the table?
1.ALTER TABLE table_name ADD column_name column-definition;
2.ALTER TABLE table_name ALTER column_name column-definition;
3.ALTER TABLE table_name UPDATE column_name column-definition;
4.ALTER TABLE table_name NEW column_name column-definition;
What is the syntax to create a table?
1.CREATE TABLE
2.CREATE COLUMN
3.CREATE ROW
4.CREATE DATABASE
What is the syntax to declare the local temporary tables?
1.DECLARE TABLES
2.DECLARE TEMPORARY TABLE
3.DECLARE LOCAL TEMPORARY TABLE
4.DECLARE GLOBAL TEMPORARY TABLE
What is the value of the column by default, if the value is left blank? NULL
1.NULL
2.NOT NULL
3.0
4.1
What is/are the disadvantage(s) of Oracle Database?
1.Complexity
2.Cost
3.Difficult to Manage
4.All of the above
What is/are the parameter(s) in DROP TABLE?
1.Schema_name and table_name
2.CASCADE CONSTRAINTS
3.PURGE
4.All of the above
What the column must have while creation?
1.Dataset
2.Datatype
3.Datalink
4.Database
While creating table, the column should be specified as ____.
1.NULL
2.NOT NULL
3.both (a) and (b)
4.None of the above
With Oracle database, data is managed in an ____ manner (1).
1.Open
2.Integrated
3.Complete
4.All of the above
With this database, you can easily write an Oracle application in a secure manner without having to make changes to your ____.
1.OS
2.Hardware
3.both (a) and (b)
4.None of these
With ____, the table and all its dependent objects are removed from the database and are not recoverable.
1.CASCADE
2.CASCADE CONSTRAINS
3.PURGE
4.None
You can drop a table from the Oracle database by using the ____ statement.
1.DROP COLUMN
2. DROP ROW
3.DROP DATABASE
4.DROP TABLE
___ temporary tables in Oracle are distinct from temporary tables within modules.
1.Global
2.Null
3.Local
4.Not Null