.
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
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.
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.
2, 3, 1
4, 1, 5
1, 5, 4, 2
4, 2, 3, 1, 5
3, 2, 4, 1,5
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.
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
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.
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.
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.
Only data file
Data file and log file
Data file and dump file
Data file and control file
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.
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.
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.
Creation of new indexes
Refreshing optimizer statistic
Refreshing optimizer statistic
Creation or modification of a SQL Profile
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.
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)
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.
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.
ABORT
NORMAL
IMMEDIATE
TRANSACTIONAL
Large pool
Shared pool
Buffer Cache
Program Global Area
Redo logs
Undo tablespace
Flash recovery area
Temporary tablespace
It requires the SPFILE
It requires the control file.
It uses only online redo logs.
It uses both archivelog and online redo logs.
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.
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.
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.
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.
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
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.
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.
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.
SELECT: transaction control
DROP: data control language
ROLLBACK: transaction control
REVOKE: Data control language
ALTER: Data manipulation language
MERGE: Data manipulation language
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
It compacts data within the segment.
It decreases I he size of the tablespace.
It can be performed only on an offline tablespace.
It reclaims unused space and retains it within the tablespace.
Enabling Retenting Guarantee ensures that only long-running Queries do not fail.
Undo Retention Indicates the time period for which committed transaction data is retained.
Enabling Retention Guarantee ensures that long running queries and transactions do not fail.
Undo Retention indicates the time period or which uncommitted transaction data is retained.
Views contain no data
Views provide an additional level of security by restricting access to a predetermined set of rows and columns of a table
Views can be created only on tables in the same schema.
Views on one or more tables can be used to update the columns specified in the views.
1-c, 2-d, 3-b, 4-a
L-c, 2 b, 3-d, 4-a
L-a, 2-b, 3-d, 4-c
L-a, 2-d, 3-b, 4-c
Listener
User process
Service name
Server process
It gets created for a database, SALE, in the not work domain ACME on the SALESDATA server.
It generates an error because the server configuration mode-(-dedicated or shared is not specified.
It generates an error because the conned identifier name cannot be a part of the SERVICE_NAME.
It gets created for a database, SALESDATA, on the server SALES in the network domain called.
Enable the flash recovery area and specify it as the archived redo log destination
Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
Enable the flash recovery area but do not specify it as the archived redo log destination.
Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
OUI supports the installation of several of several active Oracle homes on the same host.
Operating system environment variables need to be set before running the OUI.
OUI can be used to uninstall only the complete Oracle software and not specific products.
OUI enables configuring of listener as part of the installation process but not the creation of Net.
A data file can span across tablespaces.
An extent contains one or more segments.
Table spaces contain one or more data files.
Data objects are stored as segments in tablespaces.
Segments can span across data files within a tablespace.
Advanced Security Option
Audit Vault
Database Vault
Data Masking Pack or Enterprise Manager
Label Security
Hide data complexity
Improve data storage
Provide additional level of security
Speed up query and data manipulation language (DML) operations
It can be used to delete only the logical structure of a database.
It can be used to delete Uu1 logical structure and physical files of a database.
It can be used to change the configuration of a database only if it has been created using DBCA.
It can be used to change the configurations of o database that has been created either manually or using DBCA.
Only the instance is started.
Instance is started and then database is mounted but not opened.
Instance is started, then the database is mounted and finally opened.
Instance is started, then the database is opened and finally mounted.
ORACLE_SID: specifies the instance name
ORACLE_SID: specifies the global database name
ORACLE_BASE: specifies the toot of the Oracle Database directory tree in all platforms
ORACLE_BASE: specifies the directory containing the Oracle software executables and network file
ORACLE_HOME: specifies the root of the Oracle Database directory tree only in UNIX and Linux platforms
ORACLE_HOME: specifies the directory containing only the Oracle software executables but not the network files
Indexes
Compression
Data recovery
Data block size
CPU usage
Availability
The database can be backed up only while it is closed.
The database can be completely recovered from Instance failure.
The database can be backed up when the database instance is running.
The database can be completely recovered from disk failure even after a log switch has happened and online redo logs are overwritten.
Check constraint on the COURSE_ID column
Foreign key constraint on the COURSE_ID column
Check constraint on the DATE_OF_BIRTH column
Unique key constraint on the STUDENT_ID column
Primary key constraint on the STUDENT_ID columns
Submit a job that queries the Automatic Workload Repository (AWK).
Create an alert that sends a notification when the threshold value is reached.
Invoke the Database Configuration Assistant (DBCA. to configure notifications and set threshold values.
Specify the users who should receive notifications in the Preferred Credential of the Enterprise Manager.
Run the Automatic Database Diagnostic Monitor (ADDM) to analyze disk space and display a warning message.
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.