Functions of a dbms - Study guides, Class notes & Summaries

The syntax of the DECODE function starts with _____. correct answers DECODE(e, x, y, d) String manipulation functions are rarely used in programming correct answers False If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause. correct answers JOIN ON An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value correct answers True In Oracle, the _____ function...

WGU C170 - Data Management – Applications Latest 2024 Already Graded A Domain In data modeling, the construct used to organize and describe an attribute's set of possible values. Primary key (PK) An identifier composed of one or more attributes that uniquely identifies a row. Also, a candidate key selected as a unique entity identifier. A minimal superkey. Key One or more attributes that determine other attributes. Determination The role of a key. In the context of a database...

DB Administrator Secures the database from un-authencated access. DB Designer Determines the format and the structure of the database DB Programmer Develops programs or applications that will use the database DB Users Consumers of the data no the Database. Can access the DB through the app or query the database directly. Transactions - Ensures transaction are process completely or not at all - Prevents conflict between concurrent transactions - Ensure transacti...

Associative Entity - An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute - An attribute is a property or characteristic of an entity. Binary relationship - A binary relationship is a relationship between two entity types. Candidate Key - Is any column or a combination of columns that can qualify as unique key in database. Cardinality - Cardinality represents the maximum number of entities that can be i...

What is a getter/setter? What is their purpose? - Functions that modify private variables. How do you select all tables in a database? - SELECT* FROM sys.Tables or SELECT*FROMinformation_s How do you link a style sheet to an html document? - By using the link element <link rel="stylesheet" type="text/css" href="css/"> Can we overload or override static methods in java? - Yes, we can overload static methods by having the same method but with different parameters in the su...

What is data redundancy, and which characteristics of the file system can lead to it? - -Unnecessarily duplicated data resulting from a file system's inability to represent and manage data relationships. What is data independence, and why is it lacking in file systems? - -data independence exists when changes to a file's data characteristics don't affect data access programs and is therefore lacking in file systems because file access is dependent on a file's data characteristics What i...

MIS 290 Exam 1What are the component of a management information system - correct answer Data, Database, Process, Information Name Michael Porter's 3 strategies - correct answer Low Cost Leadership, Differentiation, FOCUS List the steps in designing and MIS. - correct answer Define objectives, Collect and analyze data, display info in cohesive intuitive manner What is the purpose of a DBMS? - correct answer To create, store, maintain, and access database files. Know the difference b...

Object-oriented programming (OOP) Ans: a programming language model organized around objects that have data and methods that form the object. It's an instance of a class. four main concepts: 1. Encapsulation 2. Abstraction 3. Inheritance 4. Polymorphism. Variables Ans: A structure for temporarily storing data in your computers memory 1. primitive variables - data types like integers, decimals, and alphanumeric characters 2. reference variables- store memory addresses where object...

A tuple is one record or data set in a row - Answer-What are tuples and how are they used in databases? a.) A tuple is a collection of sequenced data fields b.) A tuple is one record or data set in a row c.) A tuple is a database field The flat file design is a single table database - Answer-What is the best description of a flat file database? a.) Flat file databases are hierarchical in nature. b.) Flat file databases are prevalent today because they provide relational functions. c.) T...

Google, DropBox, and Microsoft are company examples of what type of providers? - Cloud Service Providers (CSP) Using data visualization instead of _______________________, makes business programming much easier to understand. - Structured Query Language (SQL) Business Intelligence - Can be described as computer applications that change data into significant, meaningful information that helps organizations make better decisions. A well thought-out collection of computer files - Database ...