FREEMANSHARP

A maximum of 20 alternative hours can be used as part of the 125 hour practicum requirement for each clinical course--> T/F Fasle- Can use only 15 Maddie has a history of asthma that is classified as mild, intermittent asthma. She comes to the office today with wheezing which is not improving with her inhaler. Which would be the best ICD-10 code to apply wiith only the information given? A. Severe persistent asthma (J45.5) B. Mild intermittent asthma with acute exacerbation (J45.2...

Define diagnostic reasoning Reflective thinking because the process involves questioning one's thinking to determine if all possible avenues have been explored and if the conclusions that are being drawn are based on evidence. Seen as a kind of critical thinking. What is subjective data? Anything the patient tells you or complains of regarding their symptoms Chief complaint HPI ROS What is objective data? Anything YOU can see, touch, feel, hear, or smell as part of your...

What are common causes of N/V associated with gastritis? Alcohol, NSAIDs, ASA, ABX, and illicit substances What is the most common cause of nausea and vomiting? Acute Gastroenteritis (AGE) What are some manifestations of AGE? Nausea, vomiting, and diarrhea, fever, abdominal pain. May also include fatigue, malaise, anorexia, tenesmus and borborygmus. How is the severity of AGE gauged? Dehydration secondary to profuse watery diarrhea, fever greater than 101ºF (38.3ºC), v...

Janet is a 30 year old woman who has been recently diagnosed with a herniated disc at the level of L5-S1. She is currently in the emergency room with suspician of cauda equna compression. Which of the following is a sign or symptom of cauda equina compression? a. gastrocnemius weakness b. reduced or absent ankle refles c. numbness of the lateral foot d. paresthesia of the perineum and buttocks d. paresthesia of the perineum and buttocks The patient has acute pancreatitis with 7 of ...

WGU C170 COMPILATION BUNDLE

Other Practice Tests C170 FJ01

A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? Many-to-many Which two examples are attributes? An employee number A meeting code Which delete rule sets column values in a child table to a missing value when the matching data is deleted from the parent table? Set-to-Null member_id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (member_id), last_name VAR...

1.1.1 - Conceptual Schema - ER Model Tables: Customer, DonutOrder, Donut Customer: PK - CustomerID Rest are customer related fields DonutOrder: FK - CustomerID, FK - DonutID Qty, SpecialNotes Donut: PK - DonutID Rest are donut fields Relationships: Customer - 1:n Identifying - DonutOrder DonutOrder - n:1 Identifying - Donut Why are the relationships in 1.1.1 Identifying? The PK's of Customer and Donut are included in the composite primary key of DonutOrder. ...

CREATE TABLE syntax DDL CREATE TABLE tableName ( colName dataType constraint INDEX indexName (colName) PRIMARY KEY (colName, colName) or colName dataType PRIMARY KEY FOREIGN KEY (colName, colName) REFERENCES tableName (colName) ); CREATE INDEX syntax DDL CREATE [UNIQUE] INDEX indexName ON tableName (colName); UNIQUE should only be used on a column that should not have duplicate values. DROP INDEX syntax DDL DROP INDEX indexName; DROP INDEX 'PRIMARY' ON tableName;...

AREA In DB2, a named section of permanent storage space that is reserved to store the database. associative entity See composite entity. bridge entity See composite entity. candidate key A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey. See key. closure A property of relational operators that permits the use of relational algebra operators on existing tables (relations) to produce new relations. comp...

The order of the rows and columns is important to the DBMS. True or False False PRODUCT yields all possible pairs of rows from two tables, also known as the _______ product. Cartesian According to Codd's ______ rule of relation database, "Application programs and ad hoc facilities are logically unaffected when changes are made to the table structures that preserve the original table values (changing order of columns or inserting columns)." A. comprehensive data sublangua...

A database model is a conceptual framework for database software The relational model is a database model based on mathematical principles, with three parts: 1. A data structure that prescribes how data is organized. 2. Operations that manipulate data structures. 3. Rules that govern valid relational data. A domain is a named set of possible database values, such as integers, dictionary words, or logical values TRUE and FALSE. A tuple is a finite sequence of values, e...

If integer values are relatively small, what should be used instead of INT? SMALLINT What is the SQL command that allows a user to list the contents of a table? SELECT What is the process the DBMS uses to verify that only registered users access the database? Authentication What command is used to list the contents of a table? SELECT T/F ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause True Some RDBMSs automaticall...

A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? One-to-one One-to-many Many-to-many One-to-one binary Many-to-many Which two examples are attributes? Choose 2 answers A person attending a meeting An employee number A sales meeting A meeting code An employee number A meeting code Which delete rule sets column values in a child table to a missing value...

Access plan A set of instructions generated at application compilation time that is created and managed by a DBMS. The access plan predetermines how an application's query will access the database at run time. Alias An alternative name for a column or table in a SQL statement. ALTER TABLE The SQL command used to make changes to table structure. When the command is followed by a keyword (ADD or MODIFY), it adds a column or changes column characteristics. AREA In DB2, a n...

A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? Many-to-many Refer to Diagram #2 Which kind of relationship is displayed in this entity-relationship diagram? Many-to-many unary Refer to Diagram #3 Which kind of relationship is displayed in this entity-relationship diagram? Unary one-to-one Refer to Diagram #4 How is this portion of the entity-relati...

Add New Row INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, value3, ...); Update Row UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; Delete Row DELETE FROM table_name WHERE condition; Inner Join SELECT column_name(s) FROM table1 INNER JOIN table2 ON n_name = n_name; CREATE VIEW CREATE VIEW viewname AS SELECT Col1, Col2 FROM table WHERE condition; Concatenate CONCAT(Col1, Col2) AS NewColumnNam...

Key they are used to ensure that each row in a table is uniquely identifiable. They are also used to establish relationships among tables and to ensure the integrity of the data. A key consists of one or more attributes that determine other attributes. For example, an invoice number identifies all of the invoice attributes, such as the invoice date and the customer name. Determination the state in which knowing the value of one attribute makes it possible to determine the value of anoth...

Create Database Syntax CREATE DATABASE db_name; Simple SFW query syntax SELECT * FROM db_name WHERE column_name operator value; Cardinality: Inside or outside? Outside Modality: Inside or outside? Inside What commands are used with data definition? create, alter, drop, truncate, comment, rename What commands are used with data manipulation? Select, Insert, Update, Delete, Merge, Call, Explain Plan, Lock Table Create Table Syntax CREATE TABLE table...

domain In data modeling, the construct used to organize and describe an attribute's set of possible values superkey An attribute or attributes that uniquely identify each entity in a table. Any composite key with this is also this. candidate key A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey entity integrity The property of a relational table that guarantees each entity has a unique value in a primary key and th...