How can you increase the capacity of an Oracle tablespace? Note: there are 2 correct answers in this question A. Resize the existing data file B. Add a new data file to the existing tablespace C. Enable compression of backup data using Oracle advanced compression D. Increase the value of the database parameter DB_BLOCK_SIZE

How can you increase the capacity of an Oracle tablespace? Note: there are 2  correct answers in this question
A. Resize the existing data file
B. Add a new data file to the existing tablespace
C. Enable compression of backup data using Oracle advanced compression D. Increase the value of the database parameter DB_BLOCK_SIZE
by

1 Answer

Answer :

B. Add a new data file to the existing tablespace
by

Related questions

What are the advantages of activating the automatic Program Global Area (PGA) inSAP system that have an Oracle database? Note: there are 2 correct answered to this question A. Higher system performance is gained B. Shorter response time for queries is achieved C. Large sort processes will use more memory for efficient sorting D. Less PGA memory is allocated in advance

Description : What are the advantages of activating the automatic Program Global Area (PGA) inSAP system that have an Oracle database? Note: there are 2 correct answered to this question A. Higher system ... sort processes will use more memory for efficient sorting D. Less PGA memory is allocated in advance

Last Answer : A. Higher system performance is gained

Which instances of an SAP system require a running database during their startup? Note: there are 2 correct answered to this question. ? A. Java Central Services Instance B. Additional Application Server Instance C.ABAP Central Services Instance D. Primary Application Server Instance

Description : Which instances of an SAP system require a running database during their startup? Note: there are 2 correct answered to this question. ? A. Java Central Services Instance B. Additional Application Server Instance C.ABAP Central Services Instance D. Primary Application Server Instance

Last Answer : B. Additional Application Server Instance

You want to provide authorizations to a new user in an SAP system based on ASJava 7.10 or higherHow can you do this with the user management engine (UME)? Note: there are 2 correct answered to this question A. Add some actions to the user directly B. Add some actions to a role, then assign this role to the user C. Add some actions to a role, assign this role to a group, then assign thisgroup to the user D. Add some actions to a group, then assign this group to the use

Description : You want to provide authorizations to a new user in an SAP system based on ASJava 7.10 or higherHow can you do this with the user management engine (UME)? Note: there are 2 correct answered to this ... assign thisgroup to the user D. Add some actions to a group, then assign this group to the use

Last Answer : B. Add some actions to a role, then assign this role to the user C. Add some actions to a role, assign this role to a group, then assign thisgroup to the user

What are the advantages of using logical spool servers? Note: there are 2 correct answered to this question A. You can create more output devices B. You can balance the load across multiple physical spool servers C. You can minimize the load on physical devices D. You can minimize the manual adjustment of output device definitions after the transport

Description : What are the advantages of using logical spool servers? Note: there are 2 correct answered to this question A. You can create more output devices B. You can balance the load across ... on physical devices D. You can minimize the manual adjustment of output device definitions after the transport

Last Answer : B. You can balance the load across multiple physical spool servers C. You can minimize the load on physical devices

Which of the following settings can you make during the installation of an AS ABAP-based SAP ECC 6.06 system? Note: there are 2 correct answered to this question A. The number of clients in the SAP system B. The number and types of work processes C. The master password for some default users in this SAP system D. The ABAP message server port

Description : Which of the following settings can you make during the installation of an AS ABAP-based SAP ECC 6.06 system? Note: there are 2 correct answered to this question A. The number of clients in the ... C. The master password for some default users in this SAP system D. The ABAP message server port

Last Answer : C. The master password for some default users in this SAP system D. The ABAP message server port

During the installation of SAP XSS you have to select the Usage Types that should be installedWhich Usage Types are necessary for the installation of SAP XSS? Note: there are 2 correct answered to this question A. Utilities Customer E-Services B. Enterprise Portal C. Adobe Document Services D. Self Services

Description : During the installation of SAP XSS you have to select the Usage Types that should be installedWhich Usage Types are necessary for the installation of SAP XSS? Note: there are 2 correct answered ... . Utilities Customer E-Services B. Enterprise Portal C. Adobe Document Services D. Self Services

Last Answer : D. Self Services

What are the options to directly raise an event to trigger an event-dependent job? Note: there are 2 correct answered to this question A. Execute program sapxpg on operating system level B. Execute program sapevt on operating system level C. Execute transaction CCMS Control Panel (RZ03) D. Execute the ABAP program BTC_EV,NT_RAISE

Description : What are the options to directly raise an event to trigger an event-dependent job? Note: there are 2 correct answered to this question A. Execute program sapxpg on operating system level B. ... level C. Execute transaction CCMS Control Panel (RZ03) D. Execute the ABAP program BTC_EV,NT_RAISE

Last Answer : D. Execute the ABAP program BTC_EV,NT_RAISE

Which post-installations activities are recommended by SAP after the installation of an SAP ECC 6.06 system? Note: there are 2 correct answered to this question A. Restart your SAP system and check logs for errors B. Install a valid license key C. Copy the user SAP* in client 000 for the number of users involved in the implementation project D. Confirm the installation in an SAP Support ticket

Description : Which post-installations activities are recommended by SAP after the installation of an SAP ECC 6.06 system? Note: there are 2 correct answered to this question A. Restart your SAP system ... of users involved in the implementation project D. Confirm the installation in an SAP Support ticket

Last Answer : A. Restart your SAP system and check logs for errors B. Install a valid license key

Which information is stored in a monitoring segment of the alert monitoring infrastructure within the Computing Center Management System (CCMS)? Note: there are 2 corrects answered to this questions A. Current monitoring data of monitored components B. The coding of data collectors C. Open alerts within CCMS D. Monitoring definitions

Description : Which information is stored in a monitoring segment of the alert monitoring infrastructure within the Computing Center Management System (CCMS)? Note: there are 2 corrects answered to this questions A. ... B. The coding of data collectors C. Open alerts within CCMS D. Monitoring definitions

Last Answer : A. Current monitoring data of monitored components B. The coding of data collectors

On operating system level in the log subdirectory of the transport directory, you find the file DEVI990123 QAS What is this file? A. This is the log for the export of transport request DEVK990123 from system QAS B. This is the tp system log of the QAS system from January 23, 1999 C. This is the log file for the main import of transport request DEVI990123into system SAP D. This is the data file of transport request DEVI990123 which is to be imported into QAS system

Description : On operating system level in the log subdirectory of the transport directory, you find the file DEVI990123 QAS What is this file? A. This is the log for the export of transport request DEVK990123 ... D. This is the data file of transport request DEVI990123 which is to be imported into QAS system

Last Answer : C. This is the log file for the main import of transport request DEVI990123into system SAP

Consider an SAP system based on AS ABAP How many monitoring segments are used for the CCMS Monitoring Infrastructure? A. There is one monitoring segment for each host B. There is one monitoring segment for each database used by an SAP system C. There is one monitoring segment for each application server D. There is one monitoring segment for each central services instance

Description : Consider an SAP system based on AS ABAP How many monitoring segments are used for the CCMS Monitoring Infrastructure? A. There is one monitoring segment for each host B. There is ... segment for each application server D. There is one monitoring segment for each central services instance

Last Answer : A. There is one monitoring segment for each host

Your task is to install an additional application server for an SAP system Which rule applies for the installation work? A. The additional application server has to be installed on a separated host from the primary application server B. The additional application server can be installed using the user sapadm C. The additional application server can be installed using an instance number proposed y the installation tool D. The additional number of the additional application server has to be identical to the instance number of the primary application server.

Description : Your task is to install an additional application server for an SAP system Which rule applies for the installation work? A. The additional application server has to be installed on a ... additional application server has to be identical to the instance number of the primary application server.

Last Answer : A. The additional application server has to be installed on a separated host from the primary application server

What are the prerequisites to assigning Printing Assistant for Landscapes (PAL) printers to a printer group? A. Distribute the printer group to a target system group. B. Check the distribution log C. Create a target system. D. Assign the target system to a target system group E. Create a system user. F. Create an RFC connection G. Create the output device using transaction Spool Administration(SPAD) H. Create the output device as a PAL printer

Description : What are the prerequisites to assigning Printing Assistant for Landscapes (PAL) printers to a printer group? A. Distribute the printer group to a target system group. B. Check the ... output device using transaction Spool Administration(SPAD) H. Create the output device as a PAL printer

Last Answer : D. Assign the target system to a target system group

In SQL, the CREATE TABLESPACE isused A. to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace B. to createa database trigger C. to add/rename data files, to change storage D. All of theabove E. None of the above

Description : In SQL, the CREATE TABLESPACE isused A. to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace B. to createa database trigger C. to add/rename data files, to change storage D. All of theabove E. None of the above

Last Answer : to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace

Which services build the SAP Java Central Services Instance for AS Java 7.10 and higher? A. Message Server and EnqueueServer B. Message Server, Enqueue Server and Gateway Service C. Message Server, Enqueue Server and ICM D. Message Server, Enqueue replicated Server and Gateway Service E.

Description : Which services build the SAP Java Central Services Instance for AS Java 7.10 and higher? A. Message Server and EnqueueServer B. Message Server, Enqueue Server and Gateway Service C. Message Server, Enqueue Server and ICM D. Message Server, Enqueue replicated Server and Gateway Service E.

Last Answer : B. Message Server, Enqueue Server and Gateway Service

You have changed parameters for AS Java of your SAP system based on AS ABAP+ Java. A restart of AS Java is requiredHow can you stop and start the Java stack without restarting the ABAP stack? A. Use the Config tool B. Use transaction, SAP Servers (SM51) C. Use transaction, ICM Monitors (SMICM) D. Use transaction CCMS Control panel: Display Statuses and alerts (RZ03)

Description : You have changed parameters for AS Java of your SAP system based on AS ABAP+ Java. A restart of AS Java is requiredHow can you stop and start the Java stack without restarting the ABAP ... transaction, ICM Monitors (SMICM) D. Use transaction CCMS Control panel: Display Statuses and alerts (RZ03)

Last Answer : C. Use transaction, ICM Monitors (SMICM)

A company wants to manage job scheduling centrally and has the requirements toexecute job chains across different SAP systems. Which batch scheduling tool do you recommend? A. SAP Central Process Scheduling (basic version) B. CCMS Batch Job Scheduling C. SAP Central Process Scheduling (full version) D. The Job Management work center in SAP Solution Manager

Description : A company wants to manage job scheduling centrally and has the requirements toexecute job chains across different SAP systems. Which batch scheduling tool do you recommend? A. SAP Central Process ... Process Scheduling (full version) D. The Job Management work center in SAP Solution Manager

Last Answer : C. SAP Central Process Scheduling (full version)

A developer wants to process all transactions in the sequence specified by the application. Which type of Remote Function Call (RFC) implementation do you recommend? A. Background RFC (bgRFC) B. Asynchronous RFC (aRFC) C. Synchronous RFC (sRFC) D. Transactional RFC (tRFC)

Description : A developer wants to process all transactions in the sequence specified by the application. Which type of Remote Function Call (RFC) implementation do you recommend? A. Background RFC (bgRFC) B. Asynchronous RFC (aRFC) C. Synchronous RFC (sRFC) D. Transactional RFC (tRFC)

Last Answer : D. Transactional RFC (tRFC)

Assuming that you have all required authorizations, which functions can you access in SAP GUI for Java? A. Functions provided by SAP business One B. Functions provided by transactions in AS ABAP based SAP system C. Functions provided by SAP NetWeaver Developer Studio D. Functions provided by AS Java SAP systems

Description : Assuming that you have all required authorizations, which functions can you access in SAP GUI for Java? A. Functions provided by SAP business One B. Functions provided by transactions in AS ... C. Functions provided by SAP NetWeaver Developer Studio D. Functions provided by AS Java SAP systems

Last Answer : B. Functions provided by transactions in AS ABAP based SAP system

Which interface is used to connect SAP Central Process Scheduling in an SAP ECC system? A. Platform Agent B. XBP C. JXBP D. BW-SCH

Description : Which interface is used to connect SAP Central Process Scheduling in an SAP ECC system? A. Platform Agent B. XBP C. JXBP D. BW-SCH

Last Answer : B. XBP

Which user with administration authorizations is available right after the installation of SAP Solution Manager 7.1 to log A. DDIC B. Administrator C. J2EE_ADMIN D. EARLYWATCH

Description : Which user with administration authorizations is available right after the installation of SAP Solution Manager 7.1 to log A. DDIC B. Administrator C. J2EE_ADMIN D. EARLYWATCH

Last Answer : C. J2EE_ADMIN

What does an authorization profile in an AS ABAP based SAP system contains? A. collection of authorizations B. The user menu C. Profile parameters, such as the password expiration time(login/password_expiration_time) D. The collection of the authorizations checks that a user has passed successfully

Description : What does an authorization profile in an AS ABAP based SAP system contains? A. collection of authorizations B. The user menu C. Profile parameters, such as the password ... (login/password_expiration_time) D. The collection of the authorizations checks that a user has passed successfully

Last Answer : A. collection of authorizations

Explain the relationship among Database, Tablespace and Data file.?

Description : Explain the relationship among Database, Tablespace and Data file.?

Last Answer : Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace

Explain the relationship among database, tablespace and data file.

Description : Explain the relationship among database, tablespace and data file.

Last Answer : Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace.

Explain the relationship among Database, Tablespace and Data file.?

Description : Explain the relationship among Database, Tablespace and Data file.?

Last Answer : Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace

How do you add a data file to a tablespace

Description : How do you add a data file to a tablespace

Last Answer : ALTER TABLESPACE ADD DATAFILE SIZE

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

Does Oracle write to data files in begin/hot backup mode? (for DBA

Description : Does Oracle write to data files in begin/hot backup mode? (for DBA

Last Answer : Oracle will stop updating file headers, but will continue to write data to the database files even if a tablespace is in backup mode.In backup mode, Oracle will write out complete changed blocks ... ). Because of this, one should notice increased log activity and archiving during on-line backups.

How do you resize a data file?

Description : How do you resize a data file?

Last Answer : ALTER DATABASE DATAFILE RESIZE ;

The kernel configuration file is normally changed only when you wish to: A. Produce a smaller, more efficient kernel by removing unneeded items. B. Add a new device C. Modify a system parameter D. all of the above.

Description : The kernel configuration file is normally changed only when you wish to: A. Produce a smaller, more efficient kernel by removing unneeded items. B. Add a new device C. Modify a system parameter D. all of the above.

Last Answer : D. all of the above.

The DBMS utility, ...................... allows to reconstruct the correct state of database from the backup and history of transactions. A) Backup B) Recovery C) Monitoring D) Data loading

Description : The DBMS utility, ...................... allows to reconstruct the correct state of database from the backup and history of transactions. A) Backup B) Recovery C) Monitoring D) Data loading

Last Answer : B) Recovery

Name a tablespace automatically created when you create a database.

Description : Name a tablespace automatically created when you create a database.

Last Answer : The SYSTEM tablespace.

What is cold backup and hot backup (in case of Oracle)?

Description : What is cold backup and hot backup (in case of Oracle)?

Last Answer : ∙ Cold Backup: It is copying the three sets of files (database files, redo logs, and control file) when the instance is shut down. This is a straight file copy, usually from the disk ... was done. The database is restored to the most consistent state without any loss of committed transactions.

Name two utilities that Oracle provides, which are use for backup and recovery.

Description : Name two utilities that Oracle provides, which are use for backup and recovery.

Last Answer : Along with the RDBMS software, Oracle provides two utilities that you can use to back up and restore the database. These utilities are Export and Import. The Export utility dumps the definitions and data ... best you can do is recover the database to the time when the export was last performed.

Which of the following cannot be treated as revenue expenditure? A. Cost of goods purchased for resale. B. Wages paid for the erection of plant and machinery. C. Obsolescence cost. D. Expenses incurred by way of repairs of existing assets which do not in any way add to their earning capacity.

Description : Which of the following cannot be treated as revenue expenditure? A. Cost of goods purchased for resale. B. Wages paid for the erection of plant and machinery. C. Obsolescence cost. D. Expenses incurred by way of repairs of existing assets which do not in any way add to their earning capacity.

Last Answer : B. Wages paid for the erection of plant and machinery.

How does one backup a database using the export utility? (for DBA

Description : How does one backup a database using the export utility? (for DBA

Last Answer : Oracle exports are "logical" database backups (not physical) as they extract data and logical definitions from the database into a file. Other backup strategies normally back-up the physical data ... exports include more information about the database in the export file than user level exports.

How does one backup a database using RMAN? (for DBA

Description : How does one backup a database using RMAN? (for DBA

Last Answer : The biggest advantage of RMAN is that it only backup used space in the database. Rman doesn't put tablespaces in backup mode, saving on redo generation overhead. RMAN will re-read database ... directly to tape. Alternatively one can backup to disk and then manually copy the backups to tape.

How do I enable single sign in to WordPress backend from my already existing website backend?

Description : How do I enable single sign in to WordPress backend from my already existing website backend?

Last Answer : As far as I’m concerned, just keep yourself logged in

An enterprise needs highly controlled storage and access to their databases as well as managing the infrastructure for web front ends and other applications. They have a large existing IT infrastructure and they are continually expanding the capabilities. Which cloud computing model will satisfy all their current needs and enable them to reduce cost? A. public cloud B. hybrid cloud C. private cloud D. internal cloud

Description : An enterprise needs highly controlled storage and access to their databases as well as managing the infrastructure for web front ends and other applications. They have a large existing IT infrastructure and they ... to reduce cost? A. public cloud B. hybrid cloud C. private cloud D. internal cloud

Last Answer : hybrid cloud

Which of these is NOT a way to decrease image blurriness? A. Use compatible file formats B. Increase the size of thumbails C. Save images using loseless compression D. Check if raster or vector graphics work better

Description : Which of these is NOT a way to decrease image blurriness? A. Use compatible file formats B. Increase the size of thumbails C. Save images using loseless compression D. Check if raster or vector graphics work better

Last Answer : A. Use compatible file formats

What is the main function of bracing? a. To correct any incorrect measurements b. To enable easy inspection of the scaffold c. To make the scaffold square d. To add rigidity to the scaffold

Description : What is the main function of bracing? a. To correct any incorrect measurements b. To enable easy inspection of the scaffold c. To make the scaffold square d. To add rigidity to the scaffold

Last Answer : d. To add rigidity to the scaffold

What is the main function of bracing? a. To correct any incorrect measurements b. To enable easy inspection of the scaffold c. To make the scaffold square d. To add rigidity to the scaffold

Description : What is the main function of bracing? a. To correct any incorrect measurements b. To enable easy inspection of the scaffold c. To make the scaffold square d. To add rigidity to the scaffold

Last Answer : d. To add rigidity to the scaffold

Table Space,Data Files,Parameter File, Control Files

Description : Table Space,Data Files,Parameter File, Control Files

Last Answer : Table Space :: The table space is useful for storing the data in the database.When a database is created two table spaces are created. a) System Table space :: This data file stores all the tables ... They contain the Db name, name and location of dbs, data files ,redo log files and time stamp.

Intercooling in multistage compression is done A. To cool the air during compression B. To cool the air at delivery C. To enable compression in two stages D. To minimize the work of compression

Description : Intercooling in multistage compression is done A. To cool the air during compression B. To cool the air at delivery C. To enable compression in two stages D. To minimize the work of compression

Last Answer : ANSWER : D

What responsibilities does an Oracle Database Administrator have?

Description : What responsibilities does an Oracle Database Administrator have?

Last Answer : The responsibilities are quite important. Interacting with consumers and employees is a main responsibility. Database design and repair are also other main responsibilities.

Oracle Database Administrator Job Tips?

Description : Oracle Database Administrator Job Tips?

Last Answer : Oracle is one of the leading producers of servers and business databases, used by thousands of businesses to run websites, manage inventory and supply chains, and keep customer records. These ... , as well as creating a well-crafted resume that highlights job experience, can significantly improv

How does one manage Oracle database users? (for DBA

Description : How does one manage Oracle database users? (for DBA

Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the DB ... locked users account ALTER USER scott PASSWORD EXPIRE; -- Force user to choose a new password

How does one manage Oracle database users? (for DBA

Description : How does one manage Oracle database users? (for DBA

Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the ... from SYS.V$BH log buffer spaces Increase LOG_BUFFER parameter or move log files to faster disks