Managing Databases with Oracle - Database MCQ Questions and answers- Technical Aptitude

Home

Competitive Exams

Aptitude English Verbal Reasoning Non Verbal Reasoning General Knowledge(GK) General Science(GS) Data Interpretation(DI) Banking Awareness Current Affairs

Computer & Programming

Computer Fundamentals Networking SQL Database C Programming C++ Programming Java Python

Other Subjects

Commerce Management Law Political Science Psychology Agriculture

Exam Categories

SSC Exams Railway Exams All Exams

SSC Exams

SSC CGL SSC CHSL SSC MTS SSC CPO SSC GD SSC JHT SSC Selection Post SSC Stenographer SSC JE

Railway Exams

RRB ALP RRB Technician RRB Section Controller RRB JE RRB Paramedical RRB Group D

Popular Exams

SSC CGL SSC CHSL SSC MTS RRB Group D RRB ALP RRB Technician RRB Section Controller

Engineering Subjects

Computer Science Electronics & Communication Mechanical Engineering Civil Engineering Electrical Engineering

More Engineering

Chemical Engineering Automobile Engineering Biotechnology Mining Engineering Geological Engineering

Engineering Core

Engineering Mathematics Engineering Physics Engineering Chemistry Metallurgical Engineering

Computer Fundamentals

Computer Fundamentals Networking Database SQL MySQL

Programming

C Programming C++ Programming Java Python PHP JavaScript

Advanced

Artificial Intelligence Machine Learning Data Science Cloud Computing Hadoop IoT

Graduation & PG

Commerce Management Law Mass Communication Political Science Psychology

Resources

Current Affairs Interview Blog

Of the three ways to create an Oracle database, which one is the easiest and most recommended?

A) Using the Oracle Database Configuration Assistant. B) Using the Oracle-supplied database creation procedures. C) Using the SQL CREATE DATABASE command. D) None of the above is correct.

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

What Oracle backup and recover file contains user and system data?

A) Control file B) Datafile C) OnLine ReDo file D) Offline ReDo file

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

When using SQL*Plus, Oracle commands, column names, table names and all other database elements:

A) are case insensitive. B) are case sensitive. C) must always be in lower case. D) must always be in upper case.

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

Which SQL phrase is not supported by Oracle?

A) ON DELETE CASCADE B) ON UPDATE CASCADE C) CREATE SEQUENCE [SequenceName] D) DROP SEQUENCE [SequenceName]

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

A) Full backup B) Consistent backup C) Inconsistent backup D) Differential backup

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?

A) Open [FileName] B) Show [FileName] C) Alter [FileName] D) Edit [FileName]

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

The default extension for an Oracle SQL*Plus file is:

A) .txt B) .pls C) .ora D) .sql

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

An Oracle System Change Number (SCN):

A) is a value that is incremented whenever a dirty read occurs. B) is incremented whenever a deadlock occurs. C) is a value that keeps track of explicit locks. D) is a value that is incremented whenever database changes are made.

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

To obtain the structure of an Oracle table, the command to use is:

A) STRUCTURE [TableName]. B) DESCRIBE [TableName]. C) DESCRIBE STRUCTURE [TableName]. D) DESC TABLE [TableName].

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

To see the contents of the SQL*Plus buffer, type:

A) CONTENTS B) BUFFER C) CURRENT D) LIST

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

1 2 3 4