Managing Database with Oracle Questions and Answers
The Managing Database with Oracle questions with answers topic helps aspirants understand the fundamentals of Oracle database administration. Covering SQL commands, normalization, triggers, and PL/SQL, it offers key programming questions and answers relevant to database management. These questions are often asked in technical interviews and placement exams of companies like Infosys, Cognizant, and Accenture. Practicing these will prepare you for database-related programming interview questions with answers and improve your ability to design and optimize relational databases efficiently.
Managing Database with Oracle
Showing 10 of
20 questions
11. Of the three ways to create an Oracle database, which one is the easiest and most recommended?
- Using the Oracle Database Configuration Assistant.
- Using the Oracle-supplied database creation procedures.
- Using the SQL CREATE DATABASE command.
- None of the above is correct.
12. What Oracle backup and recover file contains user and system data?
- Control file
- Datafile
- OnLine ReDo file
- Offline ReDo file
13. When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
- are case insensitive.
- are case sensitive.
- must always be in lower case.
- must always be in upper case.
14. Which SQL phrase is not supported by Oracle?
- ON DELETE CASCADE
- ON UPDATE CASCADE
- CREATE SEQUENCE [SequenceName]
- DROP SEQUENCE [SequenceName]
15. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
- Full backup
- Consistent backup
- Inconsistent backup
- Differential backup
16. 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?
- Open [FileName]
- Show [FileName]
- Alter [FileName]
- Edit [FileName]
17. The default extension for an Oracle SQL*Plus file is:
- .txt.
- .pls.
- .ora.
- .sql.
18. An Oracle System Change Number (SCN):
- is a value that is incremented whenever a dirty read occurs.
- is incremented whenever a deadlock occurs.
- is a value that keeps track of explicit locks.
- is a value that is incremented whenever database changes are made.
19. To obtain the structure of an Oracle table, the command to use is:
- STRUCTURE [TableName].
- DESCRIBE [TableName].
- DESCRIBE STRUCTURE [TableName].
- DESC TABLE [TableName].
20. To see the contents of the SQL*Plus buffer, type:
- CONTENTS.
- BUFFER.
- CURRENT.
- LIST.