Sustav za upravljanje bazom podataka
Oracle Database Administration Quiz
Test your knowledge of Oracle Database Administration with this comprehensive quiz designed for database administrators and IT professionals. Challenge yourself with a variety of questions that cover key concepts, tools, and operations related to Oracle databases.
- Over 30 detailed questions
- Focus on practical DBA skills
- Suitable for preparation and certification
Which two statements is true regarding the usage of tools in administering an Oracle database? (Choose two.)
Oracle Net Manager: configure a new or existing listener
Data Pump: transfer of data from one database to another
SQL*Loader: load data horn an Oracle database to an external file
Database Upgrade Assistant: upgrade only single-instance databases
Database configuration Assistant (DBCA): create new database user in an existing database
The DBA of your database informs you that the Oracle instance has started. What does this imply?
Users can access the data in the database
Only the SGA has been allocated for the database
Only the background and user processes are running
Memory areas have been allocated and background processes have been started
You issue the following command as a DBA:
SQL>SHUTDOWN
What would be the outcome of the above command?
It causes the instance to abort
It waits for all sessions to disconnect
It rolls back the current transactions and disconnects a/I sessions
It waits for the current transaction in each session to complete before disconnecting the sessions
Which actions would be performed and in what sequence by clicking the Startup button?
1) Control file is read.
2) Memory is allocated.
3) Background processes are started.
4) Initialization parameter file is read.
5) Redo log files and data files are opened
2, 3, 1
4, 1, 5
1, 5, 4, 2
4, 2, 3, 1, 5
3, 2, 4, 1,5
Which two statements are true regarding consistent backups? (Choose two)
Database can be opened immediately after the restore operation
Database can be opened only after the restore and recovery operations
Consistent backups can be taken only when the instance is running and the database is closed
Consistent backups can be taken only when the instance is shut clown and the database is closed
Consistent backup are taken before the changes in the online redo log files haw been applied to the data files
You are a performance-sensitive DBA, and you are nervous about gathering new statistics, since they may alter optimization plans in an unexpected way.
To avoid this potential outcome, your best course of action would be to
Refrains from collecting statistics
Use Real Application Testing to capture the workload and the worked and then run the
Use hints to create fixed plans for SQL statements
Use deferred publishing of statistics to allow you to test execution plans before making the statistics public
Use invisible indexes to dominate execution plans
Evaluate the following command:
$sqlplus / nolog
In which scenario would the above command execute successfully?
Only from the server if the database instance is not up
Either from the server or client even if the database instance is not up
Either from a client or server only if the database instance is up and the command connects the session to the instance
Either from a client or server only if the database instance is up but the command does not connect the session to the instance
Which statement is true regarding the management of tablespaces?
AUTOEXTEND can be enabled only for new data files
Dictionary-managed tablespaces can be converted to locally managed tablespaces
Space usage alert thresholds can be modified only if the tablespace contains no data
Locally managed temporary tablespaces can be converted to permanent tablespaces
You want to change your database by adding some new columns to a particular tale. These new columns represent new data that is not accessed by the current application. Which approach would be the simplest in making these changes?
Use edition-based redefinition to create a new version of the table
Add the columns to the table, since dependent objects will not be affected
Encompass all access to these columns in separate PL/SQL procedures to avoid dependency issues
Add the columns to a different table and create a view to access the joined result
You plan to load the customer information that has been brought from a non Oracle database in the CUSTOMERS table in your database using the "Enterprise Manager –Load Data From User File" option.
Which files should you create before using this option?
Only data file
Data file and log file
Data file and dump file
Data file and control file
There are two listeners, LISTENER1 and LISTENER2, an done service name ORCL available for your database. The database is running and currently only LISTENERI has been started. You issue the following command:
$Isnrctl start listener2
What would be the outcome?
It would start the second listener without affecting the current sessions
It would start the second listener and terminate all the current sessions
It would give an error because multiple listeners cannot run simultaneously
It would give an error because multiple listeners can run simultaneously only if there are multiple net service names
Which two statements are true regarding SQL*Plus? (Choose two.)
It has commands to perform database administration operations
It can be used in interactive hut not batch mode for SQL commands
It has to be installed separately after the Oracle database install installation
Operating system commands can be executed from the SOL*Plus command prompt
Which two statements are true regarding undo data records? (Choose two.)
They are required to support Flashback features
They are not required if Flashback features are enabled
They are retained until the session making the changes ends
Undo records contain copies of data as It appears after a change is made.
Undo records contain copies of data as it appears before a change is made
In your database, the SQL Tuning Advisors running automatically during the system maintenance window as a maintenance task.
Which of its recommendations would be implemented automatically?
Creation of new indexes
Refreshing optimizer statistic
Restructuring SQL statements
Creation or modification of a SQL Profile
Which two statements we true regarding the index creation recommendations given by SQL Tuning Advisor and SQL Access Advisor?(Choose two.)
SQL Tuning Advisor considers the impact of the indexes only queries
SQL Tuning Advisor considers the impact of the indexes on both queries and DML operations
SQL Tuning Advisor considers the impact of the new indexes on both queries and DML operations
SQL Tuning Advisor considers the impact of the indexes on only data manipulation language (DML) operations
Which three statements about the Automatic Database Diagnostic Monitor (ADDM) are true? (Choose three)
Requires the database to be open
Analyses the performance of specified objects
Implements all recommendations automatically
Recommends solutions and quantifies expected benefits
Retains snapshots in the SYSAUX tablespace until the database is restarted
Analyzes the snapshots stored in the Automatic Workload Repository (AWR)
Which three statements is true regarding an Oracle instance? (Choose three)
One instance is associated with only one database
Multiple database instances can run on one computer
Only one database instance can run on one computer
One instance can be associated with multiple databases
A database instance is created based on the information in the control file
A database instance is created based on the information in the SPFILE file
You have some operating system scripts on one server that need to run in response to certain changes in data in your Oracle Database. The most efficient way to implement this with Oracle Database 11g would be:
Write a PL/SQL routine that connects to the remote server and calls the script
Create a script on the database server to perform the remote action and that script from database trigger.
Modify the script on the remote server to periodically chock for these data change in your Oracle database
Install an Oracle Scheduler Agent on the remote server and create job to be called from Oracle scheduler in response to a database server event
Which mode of database shutdown requires an instance recovery at the time of the database startup?
ABORT
NORMAL
IMMEDIATE
TRANSACTIONAL
You want to Increase the number of SQL statements that are cached in memory. Which memory structure size should be increased?
Large pool
Shared pool
Buffer Cache
Program Global Area
User HR has made some modifications to the data in the HR.EMPLOYEES table. You need to now restore the data in the table to a previous version and use the Enterprise Manager. From which source dose the operation flash back the table data to the specified time?
Redo logs
Undo tablespace
Flash recovery area
Temporary tablespace
Which two statements are true regarding point-in-time recovery? (Choose two.)
It requires the SPFILE
It requires the control file
It uses only online redo logs
It uses both archivelog and online redo logs
Which two statements are true regarding the database control file? (Choose two.)
Control files must be multiplexed on different disks
It is used to create the instance when the database is started
The locations of control files are stored in the initialization parameter files
It stores the current names and locations of the data files and redo log files.
Examine the structure of the PRODUCTS table.
The PRODUCTS table contains 20 rows.
In the data that has been entered, the PROD_ID column contains only single digit values, PROD_NAMK has a maximum of 5 characters, and RATE has 4 digit values for all rows. Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table? (Choose two.)
PROD_NAME size can be reduced from 10 to 5 characters
PROD_IP can be changed from CHAR to NUMBER data type
Now columns can be added only if they have NOT NULL constraint
PROD_RATE size can be changed from NUMBER (4) to NUMBER (6, 2).
None of the existing columns can be dropped because they contain data
Which two statements are true regarding the structure of the redo logs? (Choose two.)
Each group must have a minimum of two members
Each group must have the same number of members.
The redo log groups in a database are written to in a cyclic fashion
A minimum of two redo log groups is required for a database to open
The members within a redo log group are written to in a cyclic fashion
Which three statements are true regarding inconsistent backup? (Choose three)
It can be used only for incomplete recovery
It can be taken only when the database is open
It can be taken only when the database is closed
It can be used for complete and incomplete recovery
The archived redo logs changes must be applied to the data files before the backup
Both online and archived redo logs can have changes that have not been applied before the backup
A customer is looking to upgrade to Oracle Database 11g Release 2 when they bring in a new database server. Which two features of the release can the customer use to ensure that the performance of their new Oracle Database is maintained through the upgrade?
Using Database Replay to capture the work load on the existing server, to be used in testing the new server environment
Adding 20% more memory to the new server to handle the increased requirements of Oracle Database 11g Release 2
Reproducing the current client environment on the new server to ensure that the new environment can deliver the same results with the same workload
Using SQL Performance Analyzer to compare the performance of SQL statements in the new and old server Environments
Running both systems in parallel during production usage
Which statement is true regarding accessing the Enterprise Manager Database Control?
It can be accessed through a Web browser or command line
It can be accessed only it the default preset port number 1158 is available
It can be accessed irrespective of whether the database instance shut down or running
It can be accessed only it the Net service names have been configured in the server thsnames.ora file.
Which three statements are true regarding database recovery operations? (Choose three.)
Complete recovery involves only rolling forward operations
Database recovery is not required after an instance recovery
Incomplete recovery applies changed only from archived redo logs
Complete database recovery must be performed after an instance recovery
Complete recovery involves both rolling forward and rolling backward operations
Incomplete recovery can apply changes from both online and archived redo logs
Which three statements are true regarding database recovery operations? (Choose three.)
Complete recovery involves only rolling forward operations
Database recovery is not required after an instance recovery
Incomplete recovery applies changed only from archived redo logs
Complete database recovery must be performed after an instance recovery
Complete recovery involves both rolling forward and rolling backward operations
Incomplete recovery can apply changes from both online and archived redo logs
Which statement describes the function of the Segment Advisor?
It advises on the usage frequency of the database objects
It advises on the currently validity status of the database
It identifies database objects that have unused space that can be reclaimed
It identifies the space requirements for the database objects based on their usage and growth statistics.
Which three options correctly map SQL commands with their categories?(Choose three)
SELECT: transaction control
DROP: data control language
ROLLBACK: transaction control
REVOKE: Data control language
ALTER: Data manipulation language
MERGE: Data manipulation language
You create an index, EMP_IDX, on the ENAME column in the EMP table. Identify the three operations in which FMP_IDX would be used? (Choose three.)
Addition of new data to the EMP table
Deletion of existing row from the EMP table
Modification of data in any column in the EMP table
All queries that display data from the ENAME column
Queries that search for data based on a condition on the ENAME column
{"name":"Sustav za upravljanje bazom podataka", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge of Oracle Database Administration with this comprehensive quiz designed for database administrators and IT professionals. Challenge yourself with a variety of questions that cover key concepts, tools, and operations related to Oracle databases.Over 30 detailed questionsFocus on practical DBA skillsSuitable for preparation and certification","img":"https:/images/course8.png"}