managing-databases-with-oracle database question and answers -Page 3

CuriousTab

CuriousTab

C Programming C# Programming C++ Programming Database Java Programming Networking

Biochemical Engineering Biochemistry Biotechnology Chemical Engineering Civil Engineering Computer Science Digital Electronics Electrical Engineering Electronics Electronics and Communication Engineering Mechanical Engineering Microbiology Technical Drawing

Current Affairs General Knowledge

Data Interpretation Logical Reasoning Non Verbal Reasoning Verbal Ability Verbal Reasoning

AIEEE Bank Exams CAT GATE IIT JEE TOEFL

Analyst Bank PO Database Administrator IT Trainer Network Engineer Project Manager Software Architect

Managing Databases with Oracle problems

1. Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.
Options
A. True
B. False

Correct Answer: False

2. The left-leaning slash tells Oracle to execute whatever statement is in the buffer.
Options
A. True
B. False

Correct Answer: False

3. Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.
Options
A. True
B. False

Correct Answer: True

4. Money is defined in Oracle with the Currency data type.
Options
A. True
B. False

Correct Answer: False

5. Oracle commands, column names, table names, view names and all other database elements are case sensitive.
Options
A. True
B. False

Correct Answer: False

6. When you type Start FILENAME, the statement in your file will be executed automatically.
Options
A. True
B. False

Correct Answer: True

7. If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.
Options
A. True
B. False

Correct Answer: True

8. The only time that case matters is inside quotation marks of strings.
Options
A. True
B. False

Correct Answer: True

9. Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.
Options
A. True
B. False

Correct Answer: True

10. Oracle does NOT support a CASCADE UPDATE constraint.
Options
A. True
B. False

Correct Answer: True

First 2 3

More in Database:

Advanced SQL Data and Database Administration Data Modeling with ER Model Data Models into Database Designs Data Warehousing Database Design Using Normalization Database Processing for BIS Database Redesign Distributed Databases ER Model and Business Rules Introduction to Database Introduction to SQL JDBC, Java Server Pages, and MySQL Logical Database Design Managing Databases with Oracle Managing Multiuser Databases Modeling Data in the Organization Object-Oriented Data Modeling Object-Oriented Database ODBC, OLE DB, ADO, and ASP Physical Database Design SQL for Database Construction SQL Server 2000 The Client-Server Database The Database Development Process The Database Environment The Internet Database Environment The Relational Model and Normalization XML and ADO.NET

Aptitude

Time and Distance
Volume and Surface Area
Problem on Trains
Permutation and Combination

Engineering

Civil Engineering
Computer Science
Mechanical Engineering
Technical Drawing

Programming

C Programming
C# Programming
C++ Programming
Java Programming

Reasoning

Logical Reasoning
Non Verbal Reasoning
Verbal Ability
Verbal Reasoning

Links

About Us
Contact Us
Privacy Policy
Sitemap

Social

Copyright �CuriousTab. All rights reserved.