Oracle APEX/Oracle Overview, Introduction MCQs Set 2 Sample Test,Sample questions

Question:
 In addition to eliminating all ____ integrity constraints, CASCADE CONSTRAINTS will also drop all other constraints.

1.Consecutive

2.Sequential

3.Referential

4.Relational

Posted Date:-2022-11-15 00:12:16


Question:
 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.

Posted Date:-2022-11-14 23:31:04


Question:
 What is the statement to modify the column in the table?

1.MODIFY

2.MODULE

3.UPDATE

4.ALTER

Posted Date:-2022-11-14 23:51:45


Question:
 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)

Posted Date:-2022-11-14 23:39:44


Question:
A new table is created in an Oracle database using the ____ TABLE statement.

1.CREATE

2.UPDATE

3.ALTER

4.NEW

Posted Date:-2022-11-14 23:27:41


Question:
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

Posted Date:-2022-11-14 23:38:44


Question:
ALTER TABLE is also used to ____ the table.

1.Revert

2.Rename

3.Resize

4.Reuse

Posted Date:-2022-11-14 23:41:11


Question:
Around 20 different _____ protocols and over 100 different hardware platforms are supported by this database.

1.Networking

2.Repeating

3.Adhesive

4.Hardware

Posted Date:-2022-11-14 22:18:47


Question:
Backups can be performed ____ with RMAN.

1.Online

2.Archived

3.Continuously

4.All of the above

Posted Date:-2022-11-14 22:20:57


Question:
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

Posted Date:-2022-11-14 23:36:57


Question:
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

Posted Date:-2022-11-14 22:20:18


Question:
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

Posted Date:-2022-11-14 22:30:06


Question:
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

Posted Date:-2022-11-14 23:22:32


Question:
Multiple database instances can be managed on ____ server with Oracle database.




1.One

2.Two

3.Three

4.Multiple

Posted Date:-2022-11-14 22:31:03


Question:
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

Posted Date:-2022-11-15 00:14:50


Question:
Oracle's database can be ____ from one platform to another compared to other competitors.

1.Texted

2.Ported

3.Changed

4.Mixed

Posted Date:-2022-11-14 22:18:01


Question:
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

Posted Date:-2022-11-15 00:21:06


Question:
Primary keys can only be found in ____ table at a time.

1.One

2.Two

3.Three

4.Multiple

Posted Date:-2022-11-14 23:36:14


Question:
SQL* ____ can also be used for recovery, which is also known as user-managed recovery.

1.MINUS

2.PLUS

3.MULTIPLY

4.DIVIDE

Posted Date:-2022-11-14 22:22:08


Question:
Tables are created by _____ types for each column.

1.Naming them

2. Defining their Columns

3.Specifying the Data

4.All of the above

Posted Date:-2022-11-14 23:28:31


Question:
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

Posted Date:-2022-11-14 23:40:23


Question:
The application manages CPU allocations on a database instance server using an instance ____ approach.

1.Caging

2.Gazing

3.Hazing

4.Wazing

Posted Date:-2022-11-14 23:16:25


Question:
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

Posted Date:-2022-11-15 00:16:06


Question:
The schema owned by a table is specified by what?

1.Schema_name

2.Table_name

3.CASCADE CONSTRAINS

4.PURGE

Posted Date:-2022-11-15 00:11:11


Question:
The _____ and block types are all available to temporary tables.

1.Triggers

2.Join Cardinality

3.Information about rows

4.All of the above

Posted Date:-2022-11-15 00:17:01


Question:
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

Posted Date:-2022-11-14 22:16:57


Question:
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

Posted Date:-2022-11-14 23:23:13


Question:
What is the statement to drop a column in the table?

1.DROP ROW

2.DELETE ROW

3.DROP COLUMN

4.DELETE COLUMN

Posted Date:-2022-11-14 23:52:36


Question:
What is the statement to rename a column in the table?

1.RENAME COLUMN

2.RENAME ROW

3.RECHANGE COLUMN

4. UPDATE COLUMN NAME

Posted Date:-2022-11-14 23:53:38


Question:
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

Posted Date:-2022-11-15 00:18:41


Question:
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;

Posted Date:-2022-11-14 23:42:38


Question:
What is the syntax to create a table?

1.CREATE TABLE

2.CREATE COLUMN

3.CREATE ROW

4.CREATE DATABASE

Posted Date:-2022-11-14 23:29:44


Question:
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

Posted Date:-2022-11-15 00:22:08


Question:
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

Posted Date:-2022-11-14 23:34:23


Question:
What is/are the disadvantage(s) of Oracle Database?

1.Complexity

2.Cost

3.Difficult to Manage

4.All of the above

Posted Date:-2022-11-14 23:24:14


Question:
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

Posted Date:-2022-11-14 23:56:26


Question:
What the column must have while creation?

1.Dataset

2.Datatype

3.Datalink

4.Database

Posted Date:-2022-11-14 23:31:50


Question:
While creating table, the column should be specified as ____.

1.NULL

2.NOT NULL

3.both (a) and (b)

4.None of the above

Posted Date:-2022-11-14 23:33:08


Question:
With Oracle database, data is managed in an ____ manner (1).

1.Open

2.Integrated

3.Complete

4.All of the above

Posted Date:-2022-11-15 00:17:39


Question:
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

Posted Date:-2022-11-14 22:19:29


Question:
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

Posted Date:-2022-11-15 00:13:40


Question:
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

Posted Date:-2022-11-14 23:54:28


Question:
___ temporary tables in Oracle are distinct from temporary tables within modules.

1.Global

2.Null

3.Local

4.Not Null

Posted Date:-2022-11-15 00:20:23


More MCQS

  1. Oracle Overview, Introduction MCQs Set 1
  2. Oracle Overview, Introduction MCQs Set 2
  3. Oracle Queries MCQs
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!