1) Which view provides the names of all the data dictionary views? DBA_NAMES DBA_TABLES ans)DICTIONARY DBA_DICTIONARY 2) Which view needs to be queried to find out how many database objects a user has created? DBA_USERS ans)DBA_OBJECTS DBA_TS_QUOTAS DBA_TAB_PRIVS 3) Dictionary Provides the names of all the DBA_NAMES ans)DATA DICTIONARY DBA_TABLES DBA_DICTIONARY 4) The DBA_OBJECTS view needs to be queried to find out how many __________________ a user has created ans)Database Objects Database Users Indexes Views ) Which data dictionary privileges stores the passowords of the users? DBA_PASSWORDS ans)DBA_USERS DBA_OBJECTS PASSWORD_USERS 6) Which data dictionary view shows the information about all the tables on which a user have privileges? DBA_TABLES DBA_OBJECTS ans)ALL_TABLES ALL_OBJECTS 7) Evaluate this SQL statement: SELECT text FROM user_source WHERE name=’UPDATE_EMP’; Which statement about this SQL statement is true?
If UPDATE_EMP is a view, this statement will display the data from the base table ans)If UPDATE_EMP is a stored procedure, this statement will display the text of this procedure If UPDATE_EMP is a table, this statement will display the text of the CREATE TABLE statemen If UPDATE_EMP is a database, this statement will display the text of the CREATE DATABASE statement 8) Which dynamic performance views could you query to display the names and status of the control files? V$SESSION V$INSTANCE V$CONTROLFILE_RECORD_SECTION ans)V$CONTROLFILE 9) Which statement about the data dictionary is true? ns)Information for the data dictionary views comes from underlying base tables created with the CREATE DATABASE statement The data dictionary views are created with the CREATE DATABASE statement The Oracle server modifies the data dictionary when DML statements are executed Users can use the data dictionary as a read-only reference, but DBAs can modify its content 10) You issue this SQL statement: SELECT * FROM user_tables; Which statement about the result returned by this SQL statement is true? The OWNER column displays your username ns)All the tables that you own will be displayed All the objects contained in your schema are displayed If you are connected with SYSDBA privileges, the display contains all the tables in all schema 11) Which data dictionary view would you query to check the status of a view based on a table that was dropped? USER_VIEWS DBA_SEGMENTS ans)DBA_OBJECTS USER_SEGMENTS 12) You issue this SQL statement: SELECT * FROM DICTIONARY; Which result will this statement provide? The names all the users who can access the data dictionary
The names of all the tables you can access will be displayed The names of all the views that you can access will be displayed ans)The names of all the data dictionary views will be displayed. DATABASE CREATION 13) What is the minimum recommended control file configuration? one control file two control files placed on the same disk ans)two control files placed on separate disks three control files placed on separate disks 14) When planning your database configuration, how should you organize the data storage? You should group objects together with different backup equirement You should group objects together with competing I/O requirment ans)You should separate objects by lifespans to minimize fragmentation You should separate objects thet are static in nature from each other 15) Which tablespace CANNOT be created with the CREATE DATABASE statement? TEMP SYSTEM UNDOTBS ans)USER_DATA 16) Which tablespace must be create with the CREATE DATABASE command? TEMP ans)SYSTEM UNDOTBS USER_DATA 17) What does the user who will create the WIPRO database need a control file the SYSTEM tablespace a username in the WIPRO database ans)a fully-privileged authenticated account 8) Which is the characteristics of the initSID. ora file? It is maintained by the Oracle server It is considered as persistengt parameter file It has the ability to make the changes persistent across startup and shutdown ans) It can be edited with a text editor 19) What are the steps involved in Database Startup ? ans) Start an instance, Mount the Database and Open the Database Close the Database, Dismount the Database and Shutdown the Instance. Both of them Neither of them 20) What are the steps involved in Database Shutdown?
Start an instance, Mount the Database and Open the Database ans)Close the Database, Dismount the Database and Shutdown the Instance. log out Neither of them 21) What is the last step involved in Database Shutdown? Close the database Dismount the database ans)Shutdown the instance Mount the database 22) What three tablespaces can be created using the CREATE DATABASE statement? ans)Undo,System,Temporary System,Datatbs,Indextbs Users,Temporary,Indextbs Temporary,Indextbs,Undotbs1 23) What should you not do if your database creation script fails?
Check the SQL Syntax. Make sure that there is sufficient space in the file system or directory or drive. ans)Rerun the script immediately. Delete existing files. 24) What starts the instance and allows users to access the database? STARTUP NOMOUNT ans)STARTUP OPEN STARTUP MOUNT STARTUP RESTRICT 25) You are using the DBCA and you need to change some of the templates that you have stored. What option from the first screen would you use to accomplish this? Create Database ans)Manage Templates Configure Database options in Database Change All Templates 6) What GUI tool is provided by Oracle to assist in the creation of databases? ans)DBCA OEM SQL Plus JAVA 27) Which is not a necessary decision to make at database creation time? Location of the control files Location of the redo log files Location of the SYSTEM tablespace’s data files ans)Location of all the data files that will belong to the database 28) In which stage the pfile is read ans)NOMOUNT OPEN RESTRICT MOUNT 29) What happens if the pfile is missing? The database will open ans)The NOMOUNT stage will fail Shows error message none of the above 0) KEEP cache and RECYCLE cache is a part of which buffer cache? Log Buffer cache ans)Database buffer cache Shared pool Java pool 31) Which state of the database is used for carrying out the maintenance work on the db? NOMOUNT OPEN ans)MOUNT RESTRICTED 32) Which statement about STARTUP RESTRICT command is true? Users can carry out normal transactions Users cannot get connected to the database ans)Users with RESTRICTED SESSION privilege can only get connected All of the above 33) What is the maximum value we can set for n in DB_CREATE_ONLINE_LOG_DEST_n 1 ans)5 unlimited 8 4) Information for day-to-day operation of the database is stored in which file User trace file Background trace file ans)Alert log file none of the above 35) User trace files grow dynamically and upto the max size set by____________ ans) MAX_DUMP_FILE_SIZE MAX_FILE_SIZE DUMP_FILE_SIZE MAX_DUMP_SIZE 36) The maximum size of the user trace file, if not specified explicitly, is limited to 5MB ans)10MB 8MB There is no limit for the file 37) You examine the alert log file and notice that the errors are generated from SQL *plus session.
Which files are best for providing you with information about the nature of problem? Control files Background trace file Initialization parameter files ans)User trace files 38) You decide to use OMF in your database. Which requirement with respect to the directories you specify in the DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_N initialization parameter? ans)The directories must exists The directory must be created in $ORACLE_HOME directory The directory must not contains any other files none of the above 9) You need to shutdown your database and want all of the users who are connected to be able to complete any current transactions. Which shutdown mode should you specify in shutdown? ABORT NORMAL ans)TRANSACTIONAL IMMEDIATE 40) Which privilege is required to create the database? SYSOPER ans)SYSDBA RESOURCE DBA 41) Which method is correct for starting an instance to create a database? STARTUP MOUNT STARTUP OPEN STARTUP ans)STARTUP NOMOUNT 42) Which type of file can be multiplexed? Only control files Only redo log files neither control files nor redolog files ans)both control files and redolog files 3) Which statement about SPFILE is true? Oracle server maintains the SPFILE SPFILE is in binary format Changes can be made in memory and/or in spfile with ALTER SYSTEM command ans)All of the above 44) Which script file need to be executed in order to create the data dictionary views? ans)CATALOG. SQL SQL. BSQ CATPROC. SQL VIEWS. SQL 45) Which utility is used to create a windows service for an oracle instance? ORAPWD INTPWD ans)ORADIM SETPWD 46) Which option you use to create a password file along with the ORADIM utility? ns)intpwd orapwd password pwdora 47) DBCA stands for Database creation assistant ans)Database configuration assistant Data creation assistant none of the above 48) Which statement about SPFILE is not true? Oracle server maintains the SPFILE SPFILE is in binary format Changes can be made in memory and/or in spfile with ALTER SYSTEM command ans)SPFILE parameters values can be modified using notepad 49) What is the significance of MAX_DUMP_FILE_SIZE Parameter? ans)Specifies he maximum file size for user trace file Specifies the maximum file size for alert log file Specifies the maximum file size for control file Specifies the maximum file size for redo file 50) Which utility is used to create a password file? Intpwd ans)orapwd password pwdora 51) ORAPWD utility is used for what? Creating a parameter file Creating an oracle service ans)Creating a password file dropping a service 52) Which option with ORAPWD utility decides the maximum number of distinct users to be allowed to connect as SYSDBA or SYSOPER?
PASSWORD FILE ans)ENTRIES none of the above 53) Which parameter during the database creation, specifies the maximum number of archived redo logs for automatic media recovery? MAXLOGMEMBERS MAXLOGFILES MAXARCHIVEFILES ans)MAXLOGHISTORY 54) which option while creating a database, specifies the existing controlfiles to be used? ans)CONTROLFILE REUSE CONTROLFILE USE CONTROL REUSE REUSE CONTROLFILE 55) What happens if the DEFAULT TEMPORARY TABLESPACE clause is mentioned while creating a database?
Oracle will assign the temporary tablespace if needed ans)Oracle will assign this temporary tablespace to any users from no specific temporary tablespace is assigned This temporary tablespace is used for recovery This tablespace is only used by the SYS user 56) Which script file creates the dictionary items necessary for PL/SQL functionality? CATALOG. SQL CATDICT. SQL ans)CATPROC. SQL SQL. BSQ 57) What is the size of an UNDO file that gets created while creating the database using OMF? ans)10MB 100MB 50MB The size is not defined 8) What is the size of an SYSTEM tablespace datafile that gets created while creating the database using OMF? 10MB ans)100MB 50MB The size is not defined 59) MAXLOGHISTORY is the parameter which specifies ________________ for automatic media recovery during database creation ans)the maximum number os archived redo logs Maximum numbers of users to be connected Amount of Tablespace required Size of Redolog file 60) This parameter Specifies the maximum file size for user trace file MAXLOGMEMBERS ans)MAX_DUMP_FILE_SIZE MAXLOGHISTORY REUSE CONTROLFILE 1) How to change the password of SYSDBA user? use ALTER USER command Once specified, SYSDBA password cannot be changed ans)Delete and recreate the password file There is no password for the SYSDBA user 62) What if the parameter file is not stored in the default location? The database can never be started The database will start normally ans)we have to use” STARTUP PFILE= “option The PFILE cannot be stored in any other path 63) Which statement about preparing to create a database is true?
You must specify at least two control files in the parameter file before creating a database you must have either SYSDBA or SYSOPER privileges to issue the CREATE DATABASE statement successfully ans)You must provide values for the ORACLE_SID and ORACLE_HOME environment variables before creating a database f you are creating a database with the US7ASCII character set, you must configure the ORA_NLS33 initialization parameter GLOBALIZATION SUPPORT 64) Which initialization paramater changes the language for date name abbreviations? ans)NLS_LANGUAGE NLS_TERRITORY NLS_DATE_FORMAT NLS_NUMERIC_CHARACTERS 5) Which method can be used to permanently change the default NLS settings for the oracle server? setting environment vaiables for the client side ans)setting initialization parameters on the server side modifying initialization parameters on the client side specifying ALTER DATABASE statement through sql *plus 66) What would happen if the database name in the parameter file does not match the control file? ans)An instance would start, but the database would not be mounted An instance would not be started An error message is displayed The database will start normally 7) Which command would you use to change the default sort order to French for a session? ans)ALTER SESSION SET NLS_SORT=FRENCH ALTER DATABASE SET NLS_SORT=FRENCH ALTER SESSION SET NLS_LANG=FRENCH. WE8Iso88591P1 ALTER SYSTEM SET NLS_LANG=FRENCH 68) Which statement is true about the national character set is true? ans)The national character set is declared when the database is created The national character set can only store varying-width multibyte character sets The national character set can be altered using the ALTER DATABASE command All of the above 9) Globalization support enables you to store, process and retrieve data in native language FALSE ans)TRUE 70) What is the NLS runtime library which is used for globalization support LSNRCTL SRTLNL ans)NLSRTL None of the above 71) The different encoding schemes that Oracle provides are: Single byte character sets Varying width multibyte character sets Fixed width multibyte character sets ans)All of the above 72) NLS_LANGUAGE PARAMETER CHANGES TERRITORY settings ans) language for date name abbreviations changes the date format changes the numberic format 3) NLSRTL is the NLS runtime Library which is used for setting environment vaiables for the client side setting initialization parameters on the server side ans)Globalization support None of the above 74) What happens when the NLS settings are done in the initialization parameter file on the server side? ans)This will permanently change the default NLS settings for the server You cannot set the NLS parameters in the parameter file NLS parameter are only set at the client side None of the above 75) The national character set can be declared anytime by the user? TRUE ans)FALSE
SERVER SIDE CONFIG 76) Which configuration file identifies the destination for clients and distributed database server? ans)tnsanmes. ora init. ora sqlnet. ora listener. ora 77) Which of the following does the service name best represent? Local address Connect descriptor Listener address ans)Destination address 78) Which of the following statements is true? listener is responsible for transferring data between the client and server ans)Listener is responsible for establishing connections between the client and server Listener is a router Listener is a protocol converter 9) Which command is used to invoke the listener control utility? ACTIVATE STARTUP INVOKE ans)START 80) Which of the following file should be configured for dynamic service registration? listener. ora sqlnet. ora ans)init. ora tnsnames. ora 81) For enabling dynamic service registration, which process or utility registers instance information ans)PMON SMON LSNRCTL NAMESCTL 82) Dedicated server configuration is One server process – Many user processes Many server processes – One user process ans)One server process – One user process Many server processes – Many user processes 3) Which process is responsible for establishing a connection between the client and the server? ans)Listener User process Server process tnsnames 84) What is true about dynamic service registration? The listener relies on SMON process ans)Does not require configuration in listerner. ora file Requires configuration in listener. ora file all of the above 85) Which file is used to configure the listener for static service registration? tnsnames. ora sqlnet. ora init. ora ans)listener. ora 86) What information does the listener. ra file contains? The listener name The listener address Databases that use the listener ans)All of the above 87) Which GUI tool is used for configuring Listener? Database configration assistant Oracle net configuration assistant Enterprise manager configuration assistant ans)Net manager 88) tnsanmes. ora a configuration file which identifies ___________ ans)the destination for clients and distributed database server The listener address Databases that use the listener all of the above 89) Net manager is used to ___________
Set Local Address Oracle net configuration assistant ans)Configure Listener all of the above 90) Listener is responsible for establishing connection between the client and server FALSE ans)TRUE None of above 91) PMON is used for __________ Activate ans)Enabling dynamic service registration Databases that use the listener none of the above 92) One server process – one user process is a behaviour of ans)Dedicated Server Mail Server Client server all of the above 93) Which command line utility is used to start, stop and check the status of the Listener?
TNSCTL CTLLSNR ans)LSNRCTL There is no command line utility available 94) Which of the file need to be configured at the client side? listener. ora ans)tnsnames. ora method. ora configuration. ora 95) Which among the following is a serverside file? tnsnames. ora hosts ans)listener. ora method. ora CLIENT SIDE CONFIG 96) Which of the following naming method requires you to modify the tnsnames. ora? ans)Local naming Oracle names Centralized naming Host naming 97) Which of the following client side configuration needs to be modified when configuring the local naming method ans)tnsnames. ora & sqlnet. ra services. ora & sqlnet. ora tnsnames. ora & listener. ora sqlnet. ora, tnsnames. ora & listener. ora 98) Which one of the following files includes the parameter NAMES. DIRECTORY_PATH? listener. ora tnsnames. ora ans)sqlnet. ora cman. ora 99) Which one of the following must the user explicitly specify while establishing a connection using CONNECT command of sql*plus utility? Service address Connect description ans)Net service name Port 100) Which naming method should be used if both Client and Server are connected using TCP/IP protocol? Local naming Oracle names Centralized naming ans)Host naming 01) Which file need to be configured for local naming method? listener. ora ans)tnsnames. ora hosts cman. ora 102) Which file controls the behaviour of the Oracle net services? listener. ora tnsnames. ora ans)sqlnet. ora cman. ora 103) Which naming method is most appropriate for simple distributed networks with a small number of services that change infrequently? ans)Local naming Oracle names Centralized naming Host naming 104) Which GUI tool is used for configuring Net service name? Database configration assistant ans)Oracle net configuration assistant Enterprise manager configuration assistant Net manager 05) Local naming is a method which is most appropriate for ____________ with a small number of services that change infrequently Service address Connect description ans) Simple Distributes Networks Host naming 106) sqlnet. ora controls the behaviour of ans)Oracle net services Oracle names Centralized naming none of the above 107) Which file is read to understand which naming method is used? tnsnames. ora ans)sqlnet. ora listener. ora method. ora 108) Which naming method is used if both the client and server uses the TCP/IP protocol? Local naming Oracle names ans)Host naming Centralized naming 09) Which file has to be configured for host naming method? tnsnames. ora sqlnet. ora listener. ora ans)hosts 110) Which file is to be modified for adding a new port for sending and receiving the request? tnsnames. ora sqlnet. ora ans)listener. ora method. ora AUDITING 111) Script that create the audit views is CATALOG. SQL CATRPOC. SQL ans)CATAUDIT. SQL None of the above 112) The default vaue for AUDIT_TRAIL parameter is DB OS FALSE ans)There is no default value for this parameter 113) Which is NOT a true characteristic of the oracle data dictionary?
The data dictionary is stored in the SYSTEM tablespace ans)The data dictionary is maintained by an Oracle DBA The data dictionary is owned by SYS user The data dictionary is made up of read-only tables and views 114) Which schema owns the data dictionary tables? ans)SYS SYSTEM SYSDBA SYSOPER 115) Audit trail information is stored in which of the following database object? SYS. SOURCE$ DBA_SOURCE ans)SYS. AUD$ DBA_AUDIT 116) What are the levels of auditing? Statement level Privilege level Object level ans)All of the above 17) Which parameter need to be set for deciding where to store the audit values? ans)AUDIT_TRAIL AUDIT_VALUES AUDITTRAIL No parameter need to be set 118) AUDIT DELETE ANY TABLE; Under which category this auditing falls? Statement level ans)Privilege level Object level Database level 119) Which command is used to disable auditing? AUDITNO DISABLE AUDIT ans)NOAUDIT There is no command to disable auditing 120) Which command will delete all records from the audit trail? ans)DELETE FROM sys. aud$; DELETE FROM audittrail; DELETE FROM aud. sys; DELETE FROM aud. sys$; 21) Which view gives the information about statement level auditing option? ALL_DEF_AUDIT_OPTS DBA_AUDIT_TRAIL DBA_AUDIT_EXISTS ans)DBA_STMT_AUDIT_OPTS 122) Who is the owner of the Audit trail? SYSTEM USER ans)SYS SYSOPER 123) CATAUDIT. SQL is a script that creates DB ans)Audit Views Object level SYSOPER 124) SYS schema owns the AUDITNO DBA_SOURCE ans)Data Dictionary Tables all of the above 125) DBA_STMT_AUDIT_OPTS gives the information about Statement level AUDIT_VALUES ans)Statement level Auditing Option all of the above SQL TUNING 126) What are the main benefits of Index-organized tables?
More concurrency Faster full table scans ans)Easy primary key-based access More storage is required 127) Which type of index is more efficient for queries using AND/OR predicates? B-Tree index ans)Bitmap Index Reverse key Index Compress Index 128) What is the main reason to create a reverse key index on a column? The column contains many different values The column is mainly used for value range scans. ans)The column contains sequential numbers The column implements an inverted list attributes 129) What is the level where Oracle optimize mode cannot be set?
Set at statement level by using hints Set at session level by using the ALTER SESSION command Set at the instance level by using the OPTIMIZER_MODE parameter ans)Set inside the SQL code by issuing the SET OPTMIZER command at the time of execution 130) How to set the OPTIMIZER_MODE for minimizing total response time? RULE ans)ALL_ROWS FIRST_ROWS_n FIRST_ROWS 131) To reduce unnecessary sorting, you can employ which of the following SQL techniques? Use the UNION instead of UNION ALL Use DISTINCT when selecting the primary key Use gourp by clause ans)Use the UNION ALL operatoe instead of UNION 132) ALTER INDEX sales. ustomers_id_idx MONITORING USAGE; Which view stores the information about the specified index? DBA_INDEXES INDEX_STATS ans)V$OBJECT_USAGE DBA_OBJECTS 133) Which of the following operations would NOT require a sort? A SELECT query using a GROUP BY clause A SELECT query using the DISTINCT clause A SELECT query using a ORDER BY clause ans) A standard SELECT query 134) Which index is suitable if the key columns have low cardinal values? ans)Bitmap Reverse key Function based Unique 135) Which statement requires a sort? ans)SELECT DISTINCT dept_id FROM emp;
UPDATE emp SET salary=salary*1. 1 WHERE id=7722; SELECT emp_id,name FROM emp; SELECT emp_id,name FROM emp WHERE emp_id BETWEEN 7722 and 7110; 136) Which script creates a plan table? utlplan. sql plantable. sql ans)utlxplan. sql utlplantable. sql 137) How can you define an execution plan? ans)Execution paln is a sequence of operations oracle performs to execute the statement Execution plan is a series of steps stored in database buffer cache Execution plan has nothing to do with the optimizers Execution plan is created after the statement gets executed 138) In which table the execution plan steps are stored?
PLANTABLE ans)PLAN_TABLE EXECUTION_TABLE STEPS_TABLE 139) Which statement about execution plans are true? Execution plan is a hierarchical listing of steps In an execution plan, the more heavily indented an access path is, the earlier it is executed If two steps are indented at the same level, the uppermost statement is executed first. ans)All of the above 140) What is TKPROF utility used for? ans)Used to format the trace files generated during the trace session Used for creating trace files Used by the optimizer for picking the best execution plans Stores the execution plan 41) What is the advantage of using AUTOTRACE over a TRACE FILE? It parses and also executes the statement Displays the execution plan for the select statement automatically No need of formating the trace file ans)All of the above 142) AUTOTRACE requires the existence of the plan table? ans)TRUE FALSE 143) At which level SQL_TRACE can be enabled? Only at session level Only at instance level ans)Both at session level or instance level Only at database level 144) The default optimizer mode is__________. RULE COST FIRST_ROWS_n ans)CHOOSE 45) Which special characters indicates the start of an hint? ans)/*+ /* /*- / 146) What does OPTIMIZER_MODE=CHOOSE mean? Always use rule based optimizer ans)If statistics are available, use COST based or else use RULE based Always use cost based optimizer Which ever optimizer mode is convenient, use it. 147) How many total number of RANKS are available in RBO ranking scheme? 10 13 ans)15 14 148) Which access path does the rule based optimizer chooses? ans)One with the lowest rank One with the highest rank 49) How does optimizer evaluate the FROM clause? Left to Right ans)Right to left In any order that is convenient Depends on the tables used 150) What is most important for the cost based optimizer to work? Data Ranking schemes ans)Statistics None of the above 151) Which option cannot be used with the ANALYZE command? COMPUTE DELETE ESTIMATE ans)GATHER 152) Which built_in package also helps in gathering the statistics? DBMS_OUPUT DBMS_ANALYZE ans)DBMS_STATS DBMS_GATHER 153) Which object statistics gives the information about “Number of chanined and Migrated rows”? ns)Table statistics Index statistics Column statistics Both table and column 154) What is the optimizer hint for Nested loop join? USE_NESTED ans)USE_NL USE_NESTEDLOOP There is not hint available 155) What is the optimizer hint for Sort-Merger join? ans)USE_MERGE USE_SORT USE_SORTMERGE There is not hint available 156) What is the optimizer hint for Hash join? USE_HASHJOIN ans)USE_HASH HASH_JOIN There is not hint available 157) Which of the join method is used with any Join? Sort Merge join Hash Join ans)Nested loop join Cluster join 58) Can a Function based index be based on an expression? ans)TRUE FALSE 159) Which parameter enables the function based indexes? QUERY_ENABLE_REWRITE ENABLE_FUNCTION_INDEX ans)QUERY_REWRITE_ENABLED FUNCTION_ENABLE_REWRITE 160) What privilege is needed for CREATE/ALTER of a Function based index? Execute ans)Query rewrite Create index Create function index 161) ANALYZE INDEX emp_idx VALIDATE STRUCTURE; Which view stores the information? DBA_INDEXES ans)INDEX_STATS V$OBJECT_USAGE DBA_OBJECTS 62) What is the restriction associated with an Index organized table? ans)Must have a primary key Must have a not null column Can be clustered Must have a unique key 163) Which option in Index organized table, ensures that all columns after the specified including column are stored in the overflow segment? USING WITH ans)INCLUDING TAKING 164) Which is not the correct Partition method? RANGE HASH COMPOSITE ans)CLUSTER 165) Composite partition is a combination of ____________ ans)Range and Hash Range and List List and Hash Hash and Hash 66) Range and Hash is a combination of Composite partition Sometimes ans)True FALSE None of the above 167) GATHER option cannot be used with the ___________command? COMPUTE DELETE ESTIMATE ans)ANALYZE 168) DBMS_STATS a built_in package also helps in _________ Execute Hash Join ans)gathering the statistics None of the above 169) USE_HASH is an optimizer hint used for Range and Hash ans)Hash Join None of the above Create function index 170) use_merger is an Optimizer hint for ans)Sort Merge join Hash Join nested loop join joins 71) Cluster is not a correct ______________ Method Index query rewrite ans) Partition Hashing ARCHITECTURE 172) Which memory structure is used by the server process to validate the privileges on an Object? Library cache Database buffer cache ans)Data Dictionary cache Redo log buffer cache 173) Which background process writes the dirty buffers from the database buffer cache to the data files? LGWR SMON PMON ans)DBWn 174) Which Oracle background process checks for consistency of the database and, if necessary, initiates instance recovery when the database is opened?
LGWR ans)SMON PMON DBWn 175) Which Oracle structure stores the most recently executed SQL statements, as well as the most recently accessed data definitions? PGA ans)Shared pool Redo log Buffer Database buffer cache 176) Which statement about the SGA is true? The SGA is NOT part of the Oracle server architecture The SGA is allocated when the server process is started The SGA is part of the physical structure of an Oracle database ans)The SGA is created in an Oracle database environment when an instance is started 77) If a user abnormally terminates a database connection, which background process will roll back the user’s current transaction and release the locks held by the user session? SMON ans)PMON CKPT DBWn 178) Which Oracle server component is a combination of the background processes and memory structures? the SGA ans)an Instance a redo log file a database file 179) The ______ is a memory area used to store all database information that is shared by database processes. PGA ans)SGA UGA 180) Which file(s) stores all changes made to the database for recovery purposes? ata files control files ans)redo log files parameter files 181) Which file is a part of the Oracle database? archive log file ans)control files password files parameter files 182) Which statement about data files is true? A data file can be associated with one or more database Data files are allocated a specific amount of space and CANNOT be increased ans)Data files contain user data, data dictionary data, and other types of structures A database can be created with no data file, but one can be added when it is needed 83) Which one of the following memory areas is not part of the SGA? Database buffer cache ans)PGA Redo log buffer cache Shared pool 184) Using the password utility ORAPWD, you create a password file with a password of ‘private’. What should you do to change the password ans)Delete and recreate the password file Use the ORAPWD utility to overwrite the password file Use the ALTER DATABASE statement to change the password Use the ALTER SYSTEM statement to change the appropriate initlialization parameter 185) You are configuring the PROD database.
You create a password file using the ORAPWD utility and set the REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. Which statement about the PROD database is true? You should be connected to the SYS schema when logging in using the SYSPER privilege You need to set the REMOTE_LOGIN_PASSWORDFILE parameter to SHARED to grant SYSDBA or SYSOPER privilege to individual users You should NOT administer the database remotely if you do NOT have a secure connection ans)You should NOT use operating system authentication to authenticate database administrators in your database 86) You need to administer the SALES database from a remote location, but you do not have access to a secure connection. Which authentication method should you use? remote authentication ans)password file authentication local database authentication operating system authentication 187) Which one of the following memory areas is used to cache the data dictionary information? Database buffer cache PGA Redo log buffer cache ans)Shared Pool 188) Which one of the following processes is available when an Oracle instance is started? ns)Background process User process Server process System process 189) The physical structure of ans Oracle database consists of Control files, datafiles and redo log files FALSE ans)TRUE 190) SGA memory is allocated and tracked in _________ Blocks Bytes ans)Granules none of the above 191) Which background process reduces instance recovery time in case of a db crash by ensuring that most latest changes are reflected to the physical disk, so that only minimal recovery effort/time is required. PMON ans)CKPT SMON ARCH 92) Which of the background process is optional? PMON CKPT SMON ans)ARCH 193) Minimum of _____ redo log files are required in an installation ONE FOUR ans)TWO EIGHT 194) Which of the following is not true? DBWR writes to the datafiles whenever Checkpoint occurs dirty buffer reach threshold table drop or truncate ans)commit occurs 195) Which component of the SGA contains the parsed SQL code? Dictionary cache ans)Library cache Buffer cache none of the above 96) What provides the recovery of the data that has not been written to the data files because of some failure? ans)Redo log shared pool data dictionary cache control file 197) Which would cause a user process to establish a connection with the Oracle server? exiting SQL*PLUS executing a SQL script in SQL *Plus issuing a SELECT statement in SQL *Plus ans)issuing the ‘CONNECT scott/tiger’ command in SQL *Plus 198) Which process is started by ‘CONNECT scott/tiger’ statement and interacts directly with the Oracle server?
User process ans)Server process Dispatcher process 199) KEEP cache and RECYCLE cache is a part of which buffer cache? Log Buffer cache ans)Database buffer cache Shared pool Java pool 200) Which among the following is an optional memory structure? Database buffer cache Library cache ans)Large pool Data dictionary cache 201) Which memory structure doesnot have LRU list? Database buffer cache Library cache ans)Large pool Data dictionary cache 202) How many databases can an oracle instance handle at a time? ns)one two as many as defined in the parameter file unlimited 203) _________ is the only medium through which user process can access the database? Oracle server ans)Oracle instance Background process Memory structures 204) Which of the file is not a part of oracle database? Redolog file Datafile Control file ans)Parameter file 205) DBWR writes dirty buffers from database buffer cache to datafiles and redolog files TRUE ans)FALSE 206) We can resize the library cache and data dictionary cache separately? ans)FALSE TRUE 07) Which background process performs a checkpoint in the database by writing modified blocks from the database buffer cache in the SGA to the data files? LGWR SMON ans)DBWn PMON 208) Which is a complete list of the logical component of the Oracle database? Tablespaces, segments, extents and data files ans) Tablespaces, segments, extents and Oracle blocks Tablespaces, databases, segments, extents and Oracle blocks Tablespaces, databases, segments, extents, data files and Oracle blocks 209) Which statement about Oracle database storage structure is not true?
A data block is a logical structure When a segment is created, it consists of atleat one extent ans)A single datafile belong to multiple tablespaces All of the above 210) What is ORAPWD utility used for? ans)To create a password file To create Oracle SID To create a control file Drop a password file 211) To enable the password file authentication, the value for the parameter REMOTE_LOGIN_PASSWORD_FILE must be set to NONE PASSFILE SHARED ans)EXCLUSIVE 212) Which authentication method is used when there is no secure connection from the client to the host where database is running?
Control file authentication ans)password file authentication Data dictionary authentication operating system authentication 213) The database writer (DBWn) background process writes the dirty buffers from the database buffer cache into the ___________. ans)Data files only Data files and control files Data files, redo log files only Data files, redo log files and control files 214) Which process is started whenever a user connects to the oracle server. DBWn PMON SMON ans)SERVER 15) When a chechpoint occurs, the CKPT process_____________ Writes the dirty buffers to the data files Cleans up the temporary segment that no longer in use Writes the redo entries from the log buffer to the log files ans)Updates the control files to record the details of the checkpoint 216) To create a Password file __________ utility is used ans)ORAPWD PASSFILE SMON PMON 217) Tablespaces, segments, extents and Oracle Block is a complete list of ans) logical component of the Oracle Databse password file Data Dictionary All of the above 18) Data Dictionary Cache memory structure is used by the server process to to create a Password File To create Oracle SID ans)validate the privileges on an Object Drop a password file 219) SERVER Process is started whenever a user connects to the ans) Oracle Server a Particular Schema To create a control file none of the above 220) Password file authentication method is used when there is___________ from the client to the host where database is running? Control file authentication ans) no secure connection Secure Connection operating system authentication 21) Oracle Instance can handle one database at a time NOT ALWAYS FALSE ans)TRUE none of the above 222) Large Pool memory structure doesnot have __________ Database buffer cache Library cache ans)LRU List Data dictionary cache 223) To which component of the SGA are changes made to the database for the current instance recorded? Shared pool ans)redo log buffer Database buffer cache Data dictionary cache 224) You need to turn off the buffer cache advisory. The memory for the advisory should still be allocated. Which statement should you use?
ALTER SYSTEM SET DB_CACHE_ADVICE = OFF ALTER SESSION SET DB_CACHE_ADVICE = OFF ans)ALTER SYSTEM SET DB_CACHE_ADVICE = READY ALTER SESSION SET DB_CACHE_ADVICE = READY 225) DBWn, ARCn, CKPT and LGWR are the background processes that performs I/O. ans)TRUE FALSE 226) The WIPRO database is in a dedicated server environment. You issue the CONNECT command to connect to the database. Which process is started by this statement and interacts directly with the oracle server? User process ans)Server process Dispatcher process shared server process 27) What will happen if an Oracle server process attempts to move a buffer to the dirty list and it is full? An error occurs A new dirty list is created ans)DBWn is signaled to write to disk LGWR is signaled to remove the contents of the dirty list 228) You issue this statement in SQL *PLUS: SELECT * FROM scott. emp; Which menory structure is used by the server process to validate your privileges? Library cache ans)data dictionary cache Database buffer cache Redo log buffer cache
ORACLE INSTANCE 229) Which SHUTDOWN mode will only wait for the pending transaction of a current user to end before ending the user’s session? ABORT NORMAL ans)TRANSACTIONAL IMMEDIATE 230) The SALES database is mounted, and you need to make it available for normal database operations. Which statement should you issue? ALTER SYSTEM OPEN; ans)ALTER DATABASE OPEN ALTER SESSION OPEN ALTER SYSTEM MOUNT 231) For which result would you set the DB_CREATE_ONLINE_LOG_DEST_n parameter? to specify the default location for the alert log files o specify a default location for all data, control, and online redo log file to specify different default locations for the control files and online redo log files ans)to specify the default location for control files when you want to multiplex the files in different directories 232) Which value does the BACKGROUND_DUMP_DEST initialization parameter specify ans)the location of the alert log file the location of the user trace files the locations for the archived redo logs the locations for the multiplexed online redo logs 233) or which information would you access a user trace file? nformation ablout the last log switch ans)statistics for traced SQL statements list of all non-default initialization parameters information on errors generated by the LGWR process 234) ALTER SYSTEM SET undo_tablespace = ‘UNDOTEMP’ SCOPE = SPFILE; Which statement about this statement is true? The change will only be made in the currently running instance The change will be made in both the currently running instance and SPFILE ans)The change will be persistent across instance shutdown and startup The statement will faile because the only SCOPE values are MEMORY and BOTH 35) Which statement about starting an instance without mounting the database (NOMOUNT) is true? Use this startup state for renaming data files Use this startup state to perform a full database recovery Use this startup state to open the online redo log files and online data files ans)Use this startup state for database creation or recreation of control files 236) What is stored in a trace file? block corruption errors ans)information about background processes the date and time of last full back up non-default initialization parametrs used at instance startup 37) Which view gives the information about various instance parameters and their current value in the instance ans)V$Parameter V$OBJECTS V$SESSION DBA_PARAMETERS 238) What starts the instance and allows users to access the database? STARTUP NOMOUNT ans) STARTUP OPEN STARTUP MOUNT STARTUP RESTRICT 239) Using the password utility ORAPWD, you create a password file with a password of ‘private’. How could you change the password? ans)Delete and recreate the password file Use the ORAPWD utility to overwrite the password file Use the ALTER DATABASE statement to change the password
Use the ALTER SYSTEM statement to change the appropriate initalization parameter 240) SYSDBA and SYSPER are the roles assgined to these users during database creation SCOTT and SYS ans)SYS and SYSTEM SYSTEM and SCOTT SYSADMIN and SYS 241) SYSDBA has all privileges of _____________ along with create and Drop database with admin options SYS SCOTT ans)SYSOPER SYSADMIN 242) Pass word file can also be set in the mode of ____________if we want to use the same password file across different instances. ans)SHARED EXCLUSIVE SHARE EXCLUSIVE NOMODE 243) What Constitues an ORACLE Instance
TableSpaces and User log ans) SGA and background processes Datadictionaries and User tables Users 244) The OS user of the server machine must belong to which group? SYSDBA SYSOPER ans)ORA_DBA He need not have to belong to any group 245) For OS level authentication, the REMOTE_LOGIN_PASSWORDFILE parameter should be set to _______ value Exclusive Shared ans)None No need of configuring this parameter 246) The default location of the parameterfile in OS is ans)%ORACLE_HOME%database %ORACLE_HOME%admin %ORACLE_HOME%
etwork none of the above 47) The SPFILE is in _____ format Text ans)Binary Hexadecimal Can be in any format 248) Which type of parameter file can be edited using a text editor SPFILE ans)PFILE both SPFILE and PFILE None of them can be edited 249) Which parameter limits maximum number of private SQL areas that a session can open concurrently ans)OPEN_CURSORS MAX_SESSIONS CONCURRENT_SESSIONS MAX_SQL_AREA 250) Which view is used to know various instance parameters and their current value in the instance? DBA_PARAMETERS ans)V$PAREMETER DBA_INSTANCES V$INSTANCES 51) When is the SGA created in an Oracle database environment? When the database is created ans)When the instance is started When the database is mounted When the server process is started 252) You have a database with the DB_NAME set to PROD. Which of the initializaion parameter order is true? init. ora, initPROD. ora, spfilePROD. ora spfile. ora, spfilePROD. ora, initPROD. ora ans)spfilePROD. ora, spfile. ora, initPROD. ora initPROD. ora, spfilePROD. ora, spfile. ora 253) You have issued the STARTUP command. Which file is checked to determine the state of the database? ns)The control file The first member of the redo log file group The datafile belonging to the SYSTEM tablespace The recent archive log file 254) Which initialization parameter determines the location of alert log file? USER_DUMP_DEST DB_CREATE_FILE_DEST CORE_DUMP_DEST ans)BACKGROUND_DUMP_DEST 255) Which statement about the shared pool is true? The shared pool cannot be dynamically resized ans)The shared pool stores the most recently executed SQL statements and data definitions The shared pool only contains fixed structures Shared pool consists of the library cacahe and redo buffer cache 56) Where can you find the nondefault parameters when the instance is started? ans)Alert log online redo log Archive log User trace files 257) What events are recorded in the alert log file? Database startup info All non-default init paramaters Creation/dropping of tablespaces and undo segments ans)all of the above 258) The user is trying to execute a SELECT statement. Which of the following process will read the data from the disk? User Process ans)Server Process LGWR DBWn 59) What is the default mode of the Open state of the database Read only Restrict ans)Read Write none of the above 260) Which is not the right option with the SHUTDOWN command Immediate transactional normal ans)force 261) OPEN_CURSORS parameter limits ans)maximum number of private SQL areas that a session can open concurrently SGA and background processes CONCURRENT_SESSIONS all the above 262) BACKGROUND_DUMP_DEST is an initialization parameter that determines the location of Online Redo Log File Server Process ans)Alert Log File User trace files 63) Read Write is the default mode of the __________ User Process All non-default init paramaters LGWR ans)Open State of the database 264) Database Startup info is recorded in ans)Alert Log File online redo log Archive log control file 265) The shared pool stores the most recently executed SQL Statements and data definitions FALSE ans) TRUE 266) What is true about SHUTDOWN ABORT? Next startup is a normal startup ans)Next startup requires instance recovery All users data is committed none of the above 267) Which statement is true about SHUTDOWN TRANSACTIONAL? ns)Waits for all current transactions to get completed New users can connect Rollbacks the users data Prompts user to complete the transactions 268) What happens when the DBA gives STARTUP RESTRICT? Any user can get connected ans)Only the user who have restricted session privilege can get connected Only the DBA can get connecte This startup option is only required for backups 269) If both SPFILE and PFILE is available in the database, which file is read first ? Both the files are read simultaneously Whichever file is located first ans)SPFILE PFILE 70) Which file type cannot be defined as Oracle Managed file (OMF)? Data files Control Files Redo log files ans)Password files 271) Evaluate this statement: CREATE SPFILE from PFILE; Which of the following statement is true? The statement will not execute because a name for the SPFILE was not specified This statement can only be issued after the database is opened ans)This statement will only execute if the PFILE is available on the server Any user can issue this command 272) The PROD2 database is mounted, and you need to make it available as a read-only database to offload query processing from the production database.
Which statement should you issue to prevent the users from generating redo log information? ALTER SYSTEM OPEN; ans)ALTER DATABASE OPEN READ ONLY; ALTER DATABASE OPEN READ WRITE; ALTER DATABASE OPEN; CONTROL FILES 273) If you rename a data file using O/S commands, which file(s) do you update with the ALTER DATABASE RENAME FILE statement? alter logs ans)control files parameter files redo log files 274) You have lost all the copies of the control file for the SALES database . Which statement about the SALES database is true? The database can be mounted, but NOT opened. ns)The database must be recovered before it can be opened You must open the database and create a new control file using the CREATE CONTROLFILE statement The database CANNOT be recovered 275) What is the maximum number of control files that you can specify in the CONTROL_FILES parameter? Two Four ans)Eight unlimited 276) Which dynamic performance view can be queried to obtain the total number of records used for data files in the control file? V$DATAFILE V$PARAMETER V$CONTROLFILE ans)V$CONTROLFILE_RECORD_SECTION 277) When strating an instance, during which state is the control file read?
NOMOUNT ans)MOUNT OPEN None of the above 278) Which statement about multiplexing an existing control file is true? Control files can be multiplexed upto 16 times When multiplexing the control file using SPFILE, it is not necessary to shutdown the database ans)You must copy the control file while the database is shutdown because the control file is synchronized with the other database files When multiplexing the control file using init. ora, the step is to issue the ALTER SYSTEM statement 279) Where does Oracle store the database creation time stamp? data files ans)control files redo log files parameter files 80) What should you do immediately after you add a data file to an existing database? Rename the data file Restart the instance ans)Backup the control file Update the parameter file 281) Which is a true statement about an Oracle control file? It is a text file ans) It can only be modified by the Orale server It can be linked to multiple databases It is only required after a database is opened 282) What is the minimum number of control files that Oracle suggests for a database? ans)TWO ONE ZERO THREE 283) What does a control file contain? ns)records the physical structure of the database User files are stored Contains Transactions done during Database Mounting Contains Log details 284) Control file is used to store used defined tables ans)maintain internal consistency and guide recovery operations Maintain recovery track Store system tables 285) You need to determine the placement of your multiplexed CONTROL FILES in the database that you are creating. With what parameter in the CREATE DATABASE script would you specify the location? ans)CONTROL_FILES controlfile logfile datafile 286) What happenes if the control file is lost?
Database will still open ans)database recovery has to be done before opening of the database Database will hang None of the above 287) Which parameter concerning OMF decides the location of the control files DB_CREATE_FILE_DEST DB_ONLINE_LOG_DEST DB_CREATE_CONTROL_DEST ans)DB_CREATE_ONLINE_LOG_DEST_n 288) Which view gives information about the controlfile names and their status? ans)V$CONTROLFILE DBA_CONTROL_FILES DBA_CONTROLFILE V$CONTROLFILE_RECORD_SECTION 289) V$CONTROLFILE gives information about the contro files ans)controlfile names and their status logfile datafile 90) Database recovery has to be done before opening of the database when ans)Control file is lost User files are stored Logfile is created None of the above 291) To maintain internal consistency and guide recovery operations we make use of Log Files User files ans)Control Files 292) Control file can be only modified by the DBA ans)Oracle Server Database User All of the above 293) DB_CREATE_ONLINE_LOG_DEST_n is a parameter which decides __________ Location of LOG Files Location Of Server instance Location of Redo Log File ans) Location of Control File 94) Evaluate this statement: SELECT name,status FROM v$controlfile; Why would you issue this command? to display the value of MAXDATAFILES to determine when the last checkpoint occurred ans)to display the name, status, and location of the control file to display the name and status of all the database files 295) Which file records the checkpoint information used during database recovery? alter log trace files ans)control file parameter files REDO LOG FILES 296) You query V$LOGFILE and find that the STATUS column for log3a. rdo in GROUP 3 is blank. What is true about this file? ns)It is in use It is incomplete It is inaccessible It is no longer needed for recovery 297) You set the LOG_CHECKPOINTS_TO_ALERT initialization parameter to TRUE. What will be the result of this action? The current log sequence number will be recorded in the alert log file ans)Information about the checkpoint will be recorded in the alert log file Information about each log switch will be recorded in the alert log file CKPT will be update the headers of all the alert log files during each checkpoint 298) What would happen if only one of the three members of the next redo log group is available at a log switch?
The database will hang The instance will shut down ans)LGWR will write to the available member Oracle will clear and replace the corrupt memebers 299) If you query V$LOG and find that GROUP 3 has a STATUS value of INACTIVE, what can be said about this group? The group has never been written to The files can currently be written to The group does NOT need to be archived ans)The group is no longer needed for instance recovery 300) What should you do if LGWR frequently has to wait for a redo log group because a checkpoint has not completed? ns)Add a new redo log group Add a new log member Clear the current redo log group Reduce the number of log members 301) Minimum of how many redo log group should exist in an Oracle database? Three One ans)Two four 302) What would happen if you attempted to add a member to an existing group using the SIZE option? ans)The statement will fail The oracle server will use the default redo member size The oracle server will user mulitiple of DB_BLOCK_SIZE parameter The orcale server will use the size of the existing members in the group 03) Dropping a log group / member will delete it logically from the database and not from the OS file system (if it is non OMF group) ans)TRUE FALSE 304) During a checkpoint, the background process that writes all the modified database buffer blocks to the appropriate datafile is LGWR CKPT ans)DBWn SERVER PROCESS 305) What does LGWR do ? Alter the Log Sequence Number Reads and Writes onto Redo log file reads the data from Log files ans)Log Writer (LGWR) writes redo log entries from redo buffer to online Redo Log File. 306) When does LGWR write to a Database ns)upon commit Whenever a paticular transaction is roll backed When ever Database Mounts When Database Shutdow process is going on 307) Which statement about redolog file is not true? Redo log files are used only for recovery Each redo log within a group is called a member ans)An oracle database requires atleast three online redo log members Redo log file provide the means to redo transactions in the event of an instance failure 308) Which action causes a log switch? A transaction completes The instance is started The instance is shut down ans)The current online redo log group is filled 09) What is the command to manually switch the log file? ALTER DATABASE SWITCH LOGFILE ans)ALTER SYSTEM SWITCH LOGFILE ALTER LOGFILE SWITCH ALTER SESSION SWITCH LOGFILE 310) When can a log member be deleted from the log group? ans)When the Log group state is active or inactive When the log group state is current We can never delete the log member from the log group We can delete the member anytime 311) Which view gives the entire history of log switches happened on the database system V$LOG V$LOGFILE ans)V$LOGHIST LOG_HISTORY 12) Which command is true about dropping a redolog group? alter system drop logfile group 2; drop logfile group 2; drop log group 2; ans)alter database drop logfile group 2; 313) To automatically archive the filled online redolog files, the database must be started in which mode? No archivelog mode ans)Archivelog mode Archive database mode none of the above 314) Which background process writes the redo entries from redo log buffer to redo log files? ans)LGWR CKPT DBWn SMON 315) What happenes when there is a Log Switch?
Redo entries cannot be written any longer Redo log files must be dropped and recreated ans)It redirects LGWR to start writing to the next group of online redo log files none of the above 316) What happens during checkpoint? redo entries are written instance recovery takes place log file contents are erased ans)DBWR writes all the dirty buffers 317) What is the command to induce a checkpoint manually? ALTER DATABASE CHECKPOINT; ans)ALTER SYSTEM CHECKPOINT; ALTER SYSTEM SWITCH CHECKPOINT; ALTER SESSION CHECKPOINT; 18) Find out the correct command to add a logfile to the existing group? ans)alter database add logfile member ‘c:
edo1. log’ to group 1 alter system add logfile member ‘c:
edo1. log’ to group 1 alter database add logfile member to to group 1 as ‘c:
edo1. log’ add logfile member ‘c:
edo1. log’ to group 1 319) Which data dictionary view needs to be queried to confirm whether the new log member is added to the group or not? V$LOG DBA_LOG_FILES ans)V$LOGFILE V$LOGHIST 320) What is true about dropping a logfile group in OMF setup? the logfile members will not be deleted from the OS level ns)the logfile members will be deleted both from the database and OS level the logfiles will only be deleted from the database level all are false 321) The time necessary to recover from an instance failure increases when more database checkpoint are set ans)FALSE TRUE 322) This writes redo log entries from redo buffer to online Redo Log File. ans)LGWR CKPT DBWn SMON 323) ALTER SYSTEM CHECKPOINT is the command to induce a ________________ redo entries instance recovery ans)CHECKPOINT Manually none of the above 324) DBWR writes all the Dirty Buffer during
Commit ans)checkpoint shutdown instance recovery 325) alter database drop logfile group 2; command will Drop Log File alter logfile All are false ans)Drop a RedoLog Group 326) The Logfile members will be deleted both from the databse and OS level when we drop Redo log file Group ans)LOG File Group Drop Control File none of the above 327) Which background process is invoked during COMMIT? DBWn SMON ans)LGWR PMON 328) Why is it best to set the FAST_START_MTTR_TARGET parameter to a small value?
To provide better query performance to minimize the frequency of backups to minimize the number of DBWn writes ans)to provide better recovery performance 329) What is the advantage of running a database in ARCHIVELOG mode? Mean-Time-Between-Failures is reduced the amount of required disk space is decreased. ans)Complete recovery is possible even after the online redo logs have been overwritten Disk contention is minimized during peak transaction times if the archived logs are placed in the DATA tablespace 30) How would you drop a redo log member from an active group when archiving is enabled? Issue the ALTER DATABASE DROP LOGFILE statement Issue the ALTER DATABASE DROP LOGFILE MEMBER statement before the next log switch Issue the ALTER DATABASE DROP LOGFILE MEMBER statement before the group is archived ans)Issue the ALTER SYSTEM SWITCH LOGFILE statement, then the ALTER DATABASE DROP LOGFILE MEMBER statement 331) If the PROD database has four redo log groups and each group has three members, how many disks does Oracle recommend to maintain the redo log files? ans)3 4 8 12 32) Where does the Oracle server record changed made to the data for recovery purpose? data files trace files ans)redo log files control files 333) What should you do if your database has two redo log groups and the current group, GROUP 2, is corrupt? Drop Group 2 and add a new group Drop all the groups and issue the ALTER DATABASE ADD LOGFILE statement ans)Reinitialize the log files in Group 2 with the ALTER DATABASE CLEAR LOGFILE statement Clear Group 2 by issuing the ALTER DATABASE CLEAR LOGFILE statement, drop the group, and create a new group 34) Which view can be queried to find the filenames, group numbers and states of redo log files V$LOG ans)V$LOGFILE V$LOGHISTORY none of the above 335) Complete recovery of the database is only possible if the database run in ______________ mode ans)ARCHIVELOG NOARCHIVELOG STANDBY Complete recovery of a database is not possible in oracle TABLESPACES 336) The maximum number of datafiles that can be created for one tablespace is ans)1023 1025 1024 Unlimited 337) Which two are physical structures and part of an Oracle database?
Extent and Segment Extent and Data file ans)Data file and Control file Data file and Tablespace 338) Which statement will allocate more space to an existing tablespace? ans)ALTER TABLESPACE ADD DATAFILE CREATE TABLESPACE DATAFILE SIZE ALTER TABLESPACE MINIMUM EXTENT ALTER TABLESPACE DEFUALT STORAGE 339) Which is a part of the logical database s