Description : What tools/utilities does Oracle provide to assist with performance tuning? (for DBA
Last Answer : Oracle provide the following tools/ utilities to assist with performance monitoring and tuning: . TKProf . UTLBSTAT.SQL and UTLESTAT.SQL - Begin and end stats monitoring . Statspack . Oracle Enterprise Manager - Tuning Pack
Description : How to Find Greats Tools for MySQL SQL Performance Tuning?
Last Answer : Say goodbye to changing queries manually and tuning them for better performance. At Tosska Technologies, we offer efficient tools for MySQL SQL performance tuning that help you save time and resources. With ... explore our tools and make the right selection, visit our website, and get a free trial.
Description : Is there accounting software that has ready-made compatibility with Oracle databases?
Last Answer : Microsoft Excel and Access offer the ability to interface with a Oracle database. This is provided through the Office Suite.
Description : Describe Oracle database's physical and logical structure
Last Answer : Physical : Data files, Redo Log files, Control file. Logical : Tables, Views, Tablespaces, etc.
Description : What schools offer courses on SQL & Databases?
Last Answer : There are a number of schools that offer online courses on SQL and databases. These courses range in price as well as content covered.
Description : Google cloud SQL Features a) Lets your application read files from and write files to buckets in Google cloud storage b) A Fully -managed web service that allows you to create , ... large applications into logical components that can be share stateful services and communicate in secure fashion.
Last Answer : A Fully –managed web service that allows you to create , configure , and use relational databases that live in Google’s cloud
Description : In distributed databases, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A SQL query with location transparency needs to specify: (A) Inheritances (B) Fragments (C) Locations (D) Local formats
Last Answer : (B) Fragments
Description : Where can I learn quickly the differences between using SQL Server 2008 and Toad for Oracle?
Last Answer : answer:The SQL code IS different. Oracle and SQL Server syntax can differ from the ANSI version of SQL. For example, when you write a JOIN in SQL, you MUST use the OUTER JOIN ON syntax, where ... can also use the Query Builder to write queries for you by dragging and dropping - just like Access.
Description : How many types of Sql Statements are there in Oracle
Last Answer : There are basically 6 types of sql statments.They are a) Data Defination Language(DDL) :: The DDL statments define and maintain objects and drop objects. b) Data Manipulation Language(DML) :: The DML ... e.g:: Using the Sql Statements in languages such as 'C', Open,Fetch, execute and close
Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
Last Answer : Procedures and Functions,Packages and Database Triggers.
Description : The most open source DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle
Last Answer : MySQL
Description : The most popular commercial DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle
Last Answer : Oracle
Description : Name three clients to connect with Oracle, for example, SQL Developer:
Last Answer : SQL Developer, SQL-Plus, TOAD, dbvisualizer, PL/SQL Developer… There are several, but an experienced dba should know at least three clients.
Description : Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 ... (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively
Last Answer : (D) 4 and 2 respectively
Description : Consider the following ORACLE relations: R(A,B,C) = {, , , , ,< 3,1,4>} S(B,C,D) = {, , , , } Consider the following two SQL queries SQ1 and SQ2: SQ1: SELECT R.B, AVG(S.B) FROM R, S WHERE R.A = S.C AND S.D ... tuples returned by SQ2 then (A) M=4, N=2 (B) M=5, N=3 (C) M=2, N=2 (D) M=3, N=3
Last Answer : (A) M=4, N=2
Description : What third party tools can be used with Oracle EBU/ RMAN? (for DBA
Last Answer : The following Media Management Software Vendors have integrated their media management software packages with Oracle Recovery Manager and Oracle7 Enterprise Backup Utility. The Media Management ... and Recovery Sterling Software's SAMS:Alexandria - formerly from Spectralogic Sun Solstice Backup
Description : What Functions,SP,tools are available within SQL for Creating XML?
Last Answer : have a look here… http://msdn.microsoft.com/en-us/library/ms190922.aspx
Description : List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?
Last Answer : SYSTEM - Data dictionary tables. DATA - Standard operational tables. DATA2- Static tables used for standard operations INDEXES - Indexes for Standard operational tables. INDEXES1 - Indexes of ... - Temporary purpose tablespace TEMP_USER - Temporary tablespace for users. USERS - User tablespace.
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
Description : What are your thoughts about using databases of DNA to solve serious crimes?
Last Answer : I think it's great for solving crimes. Having said that - it is intrusive as all get-out and it bugs the heck out of me that there are no controls over public DNA databases. Which is why I will ... your background through DNA things. My dad did, but I have no interest in doing it for my generation..
Description : Has anybody utilized genetic (DNA) databases in a genealogical search to find an ancestor successfully?
Last Answer : Yes soon after my Mother died in 2010 my sister asked my Eldest brother to do it. From ancestry.com we we received so much paper work dating back from like the stone age telling us our ancestors came ... masons . Than we received no more total cost $500 dollars for the kit. Yes we felt ripped off.
Description : What is feature-based security (as opposed to role-based) in computer databases?
Last Answer : It is software to keep lesser trusted persons out of a deeper loop. Kind of a’ need to know’ hierarchy.
Description : Besides JSTOR, what other databases are out there for finding academic articles?
Last Answer : Project Muse is another one I use quite often, but I’m a Literature major and can find pretty much whatever I need between those two databases. Is there a particular subject you have in mind? I can scan through my university’s website and see what other links they have provided.
Description : How do I Import/Export XMM Databases in eXtreme Movie Manager to another version?
Last Answer : I’ve never used it but perhaps there might be a “Save AS” option. Usually, Impot/Export is in the main “File” tab on the toolbar. Import/Export for most programs is specific to that software. To import, I think you just open the file, if it is not an eXtreme file.
Description : How does one add scripts to FMTouch databases on the iPhone?
Last Answer : This is not correct You do not remove scripts from your FM database before you transfer to FMTouch. The problem is only certain script steps are included at this time. Same with ... you will find all of the information you need. http://www.fmwebschool.com/reference/FMTouch_Reference#Documentation
Description : Can you direct me to some good online law or medical databases?
Last Answer : www.findlaw.com
Description : Do you know any good databases for material properties?
Last Answer : Hmm. Excellent question. My housemate is a Materials Engineer, so when I see her next, I will be sure to ask. In the meantime, how about this [via “Material Properties Database”] ?
Description : How did students write papers before major online journal databases existed?
Last Answer : Library.
Description : Facilities offered by databases are (a) The ability to store a large amount of data in a structured format, -Technology
Last Answer : (a) Databases have the ability to store a large amount of data in structured format, easy update, sort query, production of reports.
Description : What are corporate databases used for ?
Last Answer : Corporate Database is used for all the tasks - 1) to preserve pictures and information of National Identity Card. 2) In keeping information of house holding number , land tax , income tax etc. ... and operations of the military. 10) Preservation of information related to law , courts and cases etc.
Description : How do mobile phones use databases?
Last Answer : to keep a record of your contacts and phone numbers and alsoyour social network
Description : Web Databases?
Last Answer : form_title=Web Databases form_header=Improve your workflow with databases created specifically for your business! What do you want your database to be used for?=_ What specific features do you want in your database?=_ How many employees will be access this database?=_
Description : How does one list one's databases in the OEM Console? (for DBA
Last Answer : Follow these steps to discover databases and other services from the OEM Console: 1. Ensure the GLOBAL_DBNAME parameter is set for all databases in your LISTENER.ORA file (optional). ... OEM Discovery Wizard will guide you through the process of discovering your databases and other services.
Description : What are the benefits of distributed options in databases?
Last Answer : Database on other servers can be updated and those transactions can be grouped together with others in a logical unit. Database uses a two phase commit.
Description : Like relational databases there does exists fuzzy relational databases. a) True b) False
Last Answer : a) True
Description : Assurance services involve which of the following? a. Relevance as well as reliability. b. Nonfinancial information as well as traditional financial statements c. Electronic databases as well as printed reports. d. All of the above
Last Answer : All of the above
Description : Assurance services involve which of the following? a. Relevance as well as reliability. b. Nonfinancial information as well as traditional financial statements. c. Electronic databases as well as printed reports. d. All of the above
Description : __________ is theclear leader for personal databases. A) Microsoft Access B) Microsoft FoxPro C) Borland dBase D) MySQL
Last Answer : Microsoft Access
Description : In the Resource-based view (RBV) model, Intellectual capital does not include… A. Patents, brands B. Business systems C. Customer databases D. Includes all of the above
Last Answer : Includes all of the above
Description : Secondary data CANNOT be obtained from : 1. trade journals 2. government reports 3. Yellow pages 4. surveys 5. computerized databases
Last Answer : surveys
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
Description : The properties necessary to guarantee a reliable transaction in databases and other applications is referred to as _____________ a) BASE b) ACID c) ATOM d) All of the mentioned
Last Answer : ACID
Description : A sport/event organization that wants to obtain information about the population in a certain geographic location might use A. Government sources B. Primary Databases C. Personal Questionaires D. telephone surveys
Last Answer : B. Primary Databases
Description : In linux, how can we change which databases are started during a reboot?
Last Answer : - Edit /etc/oratab
Description : …………… database is used as template for all databases created. A) Master B) Model C) Tempdb D) None of the above
Last Answer : B) Model
Description : ………………… approach reduces time and effort required for design and lesser risk in database management. A) Single global database B) Top-down approach C) Multiple databases D) None of the above
Last Answer : C) Multiple databases
Description : Direct-marketing programs create ______ A. One-to-one contacts with customers B. Frequency programs C. Re-analysis of databases D. New mass media messages
Last Answer : A. One-to-one contacts with customers