La lecture à portée de main
Vous pourrez modifier la taille du texte de cet ouvrage
Découvre YouScribe en t'inscrivant gratuitement
Je m'inscrisDécouvre YouScribe en t'inscrivant gratuitement
Je m'inscrisVous pourrez modifier la taille du texte de cet ouvrage
Description
Sujets
Informations
Publié par | Vibrant Publishers |
Date de parution | 29 novembre 2016 |
Nombre de lectures | 0 |
EAN13 | 9781946383013 |
Langue | English |
Informations légales : prix de location à la page 0,0650€. Cette information est donnée uniquement à titre indicatif conformément à la législation en vigueur.
Extrait
Oracle Database Administration
Interview Questions
You'll Most Likely Be Asked
Job Interview Questions Series
www.vibrantpublishers.com
*****
Oracle Database Administration Interview QuestionsYou'll Most Likely Be Asked
Copyright 2021, By Vibrant Publishers, USA. All rights reserved. No part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without the prior permission of the publisher.
This publication is designed to provideaccurate and authoritative information in regard to the subjectmatter covered. The author has made every effort in the preparationof this book to ensure the accuracy of the information. However,information in this book is sold without warranty either expressedor implied. The Author or the Publisher will not be liable for anydamages caused or alleged to be caused either directly orindirectly by this book.
Vibrant Publishers books are available atspecial quantity discount for sales promotions, or for use incorporate training programs. For more information please write to bulkorders@vibrantpublishers.com
Please email feedback / corrections(technical, grammatical or spelling) to spellerrors@vibrantpublishers.com
To access the complete catalogue of VibrantPublishers, visit www.vibrantpublishers.com
*****
Table ofContents
1. Basic Administration
2. Creating andConfiguring an Oracle Database
3. Database States andDatabase Operations
4. Oracle BackgroundProcesses
5. Patches and Upgrades
6. Database ExternalUtilities
7. Sessions and Processes
8. Schemas and SchemaObjects
9. Data Integrity
10. DataDictionary and Dynamic Performance Views
11. SQL
12. Programming
13. Data Concurrencyand Consistency
14. Transactions
15. StorageStructures
16. Oracle InstanceArchitecture
17. Oracle DatabaseMemory Structures
18. Application and NetworkingArchitecture
19. Oracle DatabaseSecurity .
20. MaximumAvailability Architecture
HR Questions
Index
*****
Oracle Database Administration
Interview Questions
Review these typical interviewquestions and think about how you would answer them. Read theanswers listed; you will find best possible answers along withstrategies and suggestions.
*****
Basic Administration
1: You as a DBA just gathered the statisticson schema A. Schema A has 1500 tables. You want to know the name ofthe table with the highest number of records without running acount on each. How do you do this?
Answer:
You query the NUM_ROWS column in the DBA_TABLEStable. After running the statistics, this field is populated withcurrent and updated data, and it is simple and quick method forgetting this information without going to every table and countingthe records.
2: List four possible ways (direct orindirect) to execute an SQL query against an Oracle Database.
Answer:
a) Using the SQL*Plus command line tool. With this tool, you can directly execute SQL commands.
b) Using a GUI (Graphical User Interface)tool like SQL Developer. You can directly execute SQL commandswith such tools.
c) Using Oracle Enterprise Manager. Thisis an indirect way of executing an SQL query. When you performcertain operations with Oracle Enterprise Manager, they areconverted to SQL queries implicitly and these SQL queries areexecuted against the database.
d ) Writing your own program. This is nota conventional way of executing your queries but actually it iswidely used. Any web or windows program that uses Oracle databaseat backend, executes SQL queries. These programs are written usinga programming language like .NET or JAVA and they use a driver toconnect to database.
3: What is SQL*Plus? How can one acquire itand what kind of operations can be performed with it?
Answer:
a) SQL*Plus is a command line tool developed byOracle Corporation.
b) It is freely distributed. It is shipped withOracle client installations or Oracle database installations as adefault. So, if Oracle client or Oracle database software isinstalled on a computer, you can find it under “$ORACLE_HOME/bin/”directory. The name of the executable is “sqlplus” on Linux systemsand “sqlplus.exe” on Microsoft Window Systems.
c) You can connect to an Oracle database withit. Once connected, you can execute Oracle commands or SQL queriesagainst the connected database. SQL*Plus has also its own commandsfor formatting the output so that you can display the results in aneat way.
4: A user is logged on to a Linux server asroot where Oracle database is running. The Oracle is installed at“/u01/app/oracle/product/11.2.0.4/dbhome” and the name of the SIDis “ORCL”. The user wants to connect to the database locally usingoperating system authentication with SYSDBA privileges. Show thecommand that the user has to execute.
Answer:
a) First he needs to switch to “oracle”user:
# su - oracle
b) Later he needs to set required environmentvariables:
$ export ORACLE_SID=ORCL
$ exportORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome
c) Finally he needs to execute the followingcommand to connect to database:
$/u01/app/oracle/product/11.2.0.4/dbhome/bin/sqlplus
/ as sysdba
5: In our organization, we’re using anOracle database whose version is 11.2.0.4. Explain what each digitshows.
Answer:
“11”: This first digit shows the major databaseversion. Oracle usually publishes a major release once a 4 year.This digit is usually followed by a character describing the natureof the release. For example: 9i (internet), 10g (grid), 11g (grid),12c (cloud).
“2”: This second digit shows the maintenancerelease number of the software. Oracle publishes the major releaseas maintenance release 1 and then usually publishes a secondmaintenance release during the life time of the software. Newfeatures are added to database software with maintenancereleases.
“0”: This third digit is Fusion MiddlewareNumber. This will be 0 for database software.
“4”: This fourth digit is calledComponent-Specific Release Number and it shows the path set updatethat was applied to the software. Patch set updates are published 4times a year by Oracle and as you apply them to your databasesoftware, this fourth digit advances.
6: You’re at a client’s office and you areexpected to solve a problem in their database. The client is notsure about their database version and you want to find out theversion of their existing database. Describe three differentmethods you can use to find the version of database software.
Answer:
a) You can find the version by connecting to thedatabase with SQL*Plus. SQL*Plus will print the name and theversion of the database software once you’re connected to thedatabase. A sample output will look like below:
“Connected to:
Oracle Database 11g Enterprise EditionRelease 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining andReal Application Testing options”
b) You can find the version by querying the“v$version” view. You can execute the SQL query below to find theversion of the database:
SQL> SELECT * FROM v$version;
A sample output would look like below:
BANNER
Oracle Database 11g Enterprise EditionRelease 11.2.0.4.0 - Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 - Production
TNS for Linux: Version 11.2.0.4.0 -Production
NLSRTL Version 11.2.0.4.0 - Production
c) You can find the version from EnterpriseManager. If you logon to Oracle Enterprise Manager, the version ofthe database software will be listed at the home page under“General” web part.
7: Your client said that he forgot thepassword for “SYSTEM” user of his database and he no longer couldconnect. How would you recover this admin password?
Answer:
a) If there are other users who have “DBA”privileges, you can connect with those users and change thepassword for “SYSTEM” user. The users who have DBA privileges havethe privileges to change any user’s password. This option is theeasiest method but this may not be the case in all scenarios.
b) If there are no other users with “DBA”privileges then the only way to connect to the database is toconnect using operating system privileges. The oracle software runsunder a specific user at operating system. This user is usuallynamed “oracle”. Also, there needs to be a user group that “oracle”user belongs. This user group is usually named “dba”. The operatingsystem users who belong to “dba” group can connect to database with“SYSDBA” privileges. So, you need to ask the system administratorto logon to server as “oracle” user or any user who belongs to this“dba” group. Once logged on to operating system, you can connect todatabase locally using operating system authentication with SYSDBAprivileges. After connecting to the database, you can change thereset the password for this system user.
8: What is a password file and why is itneeded?
Answer:
Passwords for database users are stored in thedata dictionary of the database. When a user wants to login to thedatabase, the username and password provided by the user is checkedagainst the values stored in the database. If the username andpassword match, the user is granted access to database. The datadictionary is part of the database and it will be accessible aslong as the database is open. The passwords for administrators arestored in the dictionary as well.
When the database is closed, the data dictionarywill be inaccessible. There needs to be a mechanism foradministrators to logon to database even when it is closed, becauseit is one of the administrator’s tasks to start up a down database.A password file is a separate operating system file that is storedon disk outside of the database. The username and password for theusers who have SYSDBA or SYSOPER privileges are stored in it.Administrators who have those privileges are authenticated usingthis password file even when the database is down.
9: You want to find out how many users aredefined in the password file and what privileges those user have.How would you accomplish this?
Answer:
You