Filters
Question type
Study Flashcards

An Oracle Database tablespace is a logical subdivision of an Oracle database instance that is used to group related table,view,and other similar objects.

A) True
B) False

Correct Answer

verifed

verified

What is the Oracle Enterprise Manager 11g Database Control?

Correct Answer

verifed

verified

The Oracle Enterprise Manager 11g Databa...

View Answer

If T3 is a table with three columns C1,C2 and C3,where C1 is integer data,C2 is character data,and C3 is date data,which of the following would be the proper statement to have Oracle Database enter the date 02/10/03 into a row in table T3 while making sure that it is formatted correctly as shown?


A) SET INTO T3 VALUES (101,'Smith','02/10/03') ;
B) SET INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/03','DD/MM/YY') ) ;
C) INSERT INTO T3 VALUES (101,'Smith','02/10/2003') ;
D) INSERT INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/03','DD/MM/YY') ) ;
E) Any of the above will work correctly.

F) B) and E)
G) B) and C)

Correct Answer

verifed

verified

SOONER and LATER triggers are placed on tables.

A) True
B) False

Correct Answer

verifed

verified

Use the Edit Table table editor to create an index in Oracle Database.

A) True
B) False

Correct Answer

verifed

verified

Each Oracle Database tablespace has one or more datafiles associated with it.

A) True
B) False

Correct Answer

verifed

verified

Which of the following is true about stored procedures in Oracle Database?


A) They can be written using C++.
B) They must include the data type and length of parameters.
C) They can raise exceptions.
D) They do not contain variables.
E) They cannot invoke other procedures.

F) All of the above
G) C) and D)

Correct Answer

verifed

verified

Briefly explain the different types of files used by the Oracle Database recovery facilities.

Correct Answer

verifed

verified

The first type of file is the datafile.D...

View Answer

The Oracle SQL Developer has no facility for executing SQL statements.

A) True
B) False

Correct Answer

verifed

verified

What is SQL Developer?

Correct Answer

verifed

verified

SQL Developer is the GUI tool that is in...

View Answer

In Oracle Database,indexes are created using the ALTER command.

A) True
B) False

Correct Answer

verifed

verified

Oracle Database triggers are PL/SQL or Java procedures that are invoked when specified database activity occurs.

A) True
B) False

Correct Answer

verifed

verified

When creating tables,Oracle Database automatically converts the SQL standard data type "int" into:


A) number (38,0) .
B) integer (32) .
C) number (5,0) .
D) integer (16) .
E) number (64,0) .

F) None of the above
G) All of the above

Correct Answer

verifed

verified

Among its many functions,SQL*Plus is also a text editor.

A) True
B) False

Correct Answer

verifed

verified

Control files,as used by Oracle Database's backup and recovery features,contain records of database changes.

A) True
B) False

Correct Answer

verifed

verified

Which of the following is not true of stored procedures in Oracle Database?


A) They are programs.
B) They can have parameters.
C) They can be invoked remotely.
D) They can return values.
E) They can be written in C++.

F) A) and B)
G) A) and D)

Correct Answer

verifed

verified

Oracle Database provides only one method for creating an Oracle Database database.

A) True
B) False

Correct Answer

verifed

verified

The PL/SQL keyword BEGIN is used to define a group of PL/SQL statements.

A) True
B) False

Correct Answer

verifed

verified

The Oracle Database PL/SQL statement used to repeat a set of PL/SQL statements as long as some condition is true is:


A) DECLARE.
B) BEGIN.
C) IF...ELSE...END IF.
D) LOOP.
E) END;.

F) B) and D)
G) A) and E)

Correct Answer

verifed

verified

In Oracle Database security,a System Privilege is the right to general tasks such as performing some action on the database data.

A) True
B) False

Correct Answer

verifed

verified

Showing 81 - 100 of 100

Related Exams

Exam 1

Introduction

100 Questions

Exam 2

Introduction to Structured Query Language SQL

100 Questions

Exam 3

The Relational Model and Normalization

100 Questions

Exam 4

Database Design Using Normalization

100 Questions

Exam 5

Data Modeling With the Entity-Relationship Model

100 Questions

Exam 6

Transforming Data Models Into Database Designs

103 Questions

Exam 7

SQL for Database Construction and Application Processing

105 Questions

Exam 8

Database Redesign

101 Questions

Exam 9

Managing Multiuser Databases

102 Questions

Exam 10

Managing Databases With SQL Server 2008 R2

100 Questions

Exam 12

Managing Databases With MySQL 55

100 Questions

Exam 13

The Web Server Environment

110 Questions

Exam 14

Database Processing With XML

100 Questions

Exam 15

Database Processing for Business Intelligence Systems

101 Questions

Exam 16

Microsoft Access 2010

48 Questions

Exam 17

Getting Started With Systems Analysis and Design

35 Questions

Exam 18

E-R Diagrams and the Idef1x Standard

35 Questions

Exam 19

E-R Diagrams and the UML Standard

36 Questions

Exam 20

Getting Started With MySQL Workbench Data Modeling Tools

37 Questions

Exam 21

Getting Started With Microsoft Visio 2010

36 Questions

Exam 22

the Semantic Object Model

35 Questions

Exam 23

Data Structures for Database Processing

35 Questions

Exam 24

Getting Started With Web Servers php and the Eclipse PDT

35 Questions

Show Answer