Computer Science (P.E.Results) Part 4 !!!!!

In what year(s) did SQL become an ANSI standard? 1970's. Post-1987. 1986. 1987.

1986. SQL became an ANSI standard in 1986. 1986. SQL became an ANSI standard in 1986. 1986. SQL became an ANSI standard in 1986. 1986. SQL became an ANSI standard in 1986. 1986. SQL became an ANSI standard in 1986.

If you used the statement Float(5, 3) for the value 22.0009, what would SQL return? 22. 22.10. 23. 22.001.

22.001. 22.001. 22.001. 22.001. 22.001. 22.001. 22.001.

How many possible choices can be used in a BOOLEAN data type? 10 3 1 Infinite

3 only. True, False, or Null. 3 only. True, False, or Null. 3 only. True, False, or Null. 3 only. True, False, or Null. 3 only. True, False, or Null. 3 only. True, False, or Null. 3 only. True, False, or Null. 3 only. True, False, or Null.

Which of the following best describes the purpose of an object diagram? Detail unlimited relationships and values. A point in time view of interactions between objects. Show abstract class interactions and relationships. Detail states of given systems at a point in time.

A point in time view of interactions between objects. A point in time view of interactions between objects. A point in time view of interactions between objects. A point in time view of interactions between objects. A point in time view of interactions between objects.

The GROUP BY clause is: A programming language. A query clause. An update clause. An SQL language.

A query clause. A query clause. A query clause.

SELECT student.id, student.major, registration.course_name FROM student FULL OUTER JOIN registration ON student.id = registration.id WHERE student.major = "Chemistry"; Given the following SQL statement, please describe what results will be given. A table indicating the students who are not taking a chemistry course or registered as a chemistry major. A table indicating the chemistry majors who have registered for courses. Only the students who are chemistry majors taking chemistry courses. A table listing all students taking a chemistry course.

A table indicating the chemistry majors who have registered for courses. A table indicating the chemistry majors who have registered for courses. A table indicating the chemistry majors who have registered for courses. A table indicating the chemistry majors who have registered for courses.

SELECT isbn, title, author, pages FROM tblBooks; Examine the following query. What should be added/removed from it? Change the first line to SELECT *. Remove the tblBooks keyword. Add a WHERE clause. Add location to SELECT list.

Add a WHERE clause. Add a WHERE clause. As it stands, this will generate a lot of results as there is no filter. Add a WHERE filter to narrow the list.

A query can perform the following: UPDATE. INSERT INTO. All of the above. SELECT.

All of the above. Select, Insert Into, and Update. All of the above. Select, Insert Into, and Update. All of the above. Select, Insert Into, and Update. All of the above. Select, Insert Into, and Update. All of the above. Select, Insert Into, and Update.

Examine the following subquery: What is missing from this SQL statement? Semicolons after the WHERE clause An alias for the subquery It only queries one table: Need to query another Nothing

An alias for the subquery. An alias for the subquery. An alias for the subquery. An alias for the subquery. An alias for the subquery. An alias for the subquery.

How can an SQL script decrease errors? Choose the best answer. By allowing for periodic updates. By allowing the scripts to be saved and loaded as needed. By allowing for scheduled operations. By eliminating the need for manually entered commands.

By eliminating the need for manually entered commands. By eliminating the need for manually entered commands. By eliminating the need for manually entered commands. Manually entered commands are susceptible to human error. Manually entered commands are susceptible to human error.

_____ will remove data from the table or database. WIPE. ERASE. DELETE. REMOVE.

Delete will remove data from the table or database. Delete will remove data from the table or database. Delete will remove data from the table or database. Delete will remove data from the table or database. Delete will remove data from the table or database.

Real, float, and double are considered _____ numbers True. Decimal. Real. Approximate.

Each data type is considered an approximate. Each data type is considered an approximate. Each data type is considered an approximate. Each data type is considered an approximate. Each data type is considered an approximate.

What is an abstract data model? Something completely different than a data model. A data model with no subject. Something more simplified than a data model. Something more complex than a data model

Something more simplified than a data model. Something more simplified than a data model. Something more simplified than a data model. Something more simplified than a data model. Something more simplified than a data model.

Which types of data would be a good candidate for a Binary Large Object (BLOB)? Dates, times. Video, Audio, Images. Phone numbers, fax numbers. Integers, characters, decimal values.

Video, Audio, Images. Video, Audio, Images. Video, Audio, Images would use BLOB. Video, Audio, Images would use BLOB. Video, Audio, Images would use BLOB. Video, Audio, Images would use BLOB.

Which of the following keywords/elements is NOT required in an SQL query? FROM. SELECT. A table name. WHERE.

WHERE. Is not required in an SQL query. WHERE. Is not required in an SQL query. WHERE. Is not required in an SQL query. WHERE. Is not required in an SQL query. WHERE. Is not required in an SQL query.

Which of the following keywords/elements is NOT required in an SQL query? WHERE. SELECT. FROM. A table name.

WHERE. WHERE. WHERE. WHERE. WHERE. WHERE. WHERE is not required in a SQL query. WHERE is not required in a SQL query. WHERE is not required in a SQL query. WHERE is not required in a SQL query.

Under what circumstance would you select a full outer join SQL statement? When looking for specific data that will result in some rows being left out of the query. When you need all the rows from the tables you are joining. When you only want returned rows that contain data. When you need all the rows from the left table returned and only matching rows from the right.

When you need all the rows from the tables you are joining. When you need all the rows from the tables you are joining. When you need all the rows from the tables you are joining. When you need all the rows from the tables you are joining. When you need all the rows from the tables you are joining.

Which of these is a properly formatted CHAR(c,d,l) example? book_id CHAR(5). drivers_id (10)CHAR. CHAR college_code(13). CHAR(13) college_code.

book_id CHAR(5). book_id CHAR(5). book_id CHAR(5). The class comes first, then the data type, then the limit. The class comes first, then the data type, then the limit. The class comes first, then the data type, then the limit. The class comes first, then the data type, then the limit.

An object diagram is most closely related to a(n) _____ diagram. Statechart. Flat-file. Class. E/R.

class diagram. class diagram. class diagram. class diagram.

Which of these is a properly formatted example of VARCHAR? first_name CHAR(10). school_name CHAR(15). first_name VARCHAR(10). school_code (VARCHAR)6.

first_name VARCHAR(10). The class comes first, then the data type, then the limit. first_name VARCHAR(10). The class comes first, then the data type, then the limit.

Under schema theory, knowledge is organized into _____. Units. Rows. Tables. Databases.

knowledge is organized into units. knowledge is organized into units. knowledge is organized into units. knowledge is organized into units. knowledge is organized into units.

The _____ schema defines the database structure in terms of data, fields, and tables. Relational. ODBC. Physical. Logical.

logical schema, which is the layout and design of the data and tables in the database. logical schema, which is the layout and design of the data and tables in the database. logical schema, which is the layout and design of the data and tables in the database.

An object diagram shows a(n) _____ at a given point in time. Statechart. Instance. Prototype. Class.

shows an instance at a point in time. shows an instance at a point in time. shows an instance at a point in time. shows an instance at a point in time. shows an instance at a point in time.

What notation must be used to end a GROUP BY clause or any SQL statement? the period. The ORDER BY clause. the semicolon. the exclamation sign.

the semicolon. the semicolon. the semicolon. the semicolon. each statement must end with a semicolon. each statement must end with a semicolon. each statement must end with a semicolon. each statement must end with a semicolon.

To declare a BLOB in SQL Server, the following statement is used. BLOB = new BLOB(); var myBlob = new binary BLOB; declare BLOB; varbinary(MAX);

varbinary(MAX); varbinary(MAX); varbinary(MAX); varbinary(MAX); varbinary(MAX); varbinary(MAX); The maximum size for VARBINARY(Max) is 2GB. The maximum size for VARBINARY(Max) is 2GB. The maximum size for VARBINARY(Max) is 2GB.

How do data models and abstract data models differ? One simplifies an idea or concept, while the other doesn't. Data models represent some data and the relationship between that data, while abstract data models don't. Abstract data models have subjects, while data models don't. The amount of provided detail and scope varies.

The amount of provided detail and scope varies. The amount of provided detail and scope varies. The amount of provided detail and scope varies. The amount of provided detail and scope varies. The amount of provided detail and scope varies. The amount of provided detail and scope varies.

The basic database element is the _____. Row. Table. Field. Key.

The basic database unit is the table. A table is a unit consisting of rows of related information. The basic database unit is the table. A table is a unit consisting of rows of related information.

The _____ schema defines the layout of the database hardware and servers. Logical. Relational. ODBC. Physical.

The physical schema displays the hardware, servers, and connections that need to be set up to install the database. The physical schema displays the hardware, servers, and connections that need to be set up to install the database.

In the following class diagram, what are the items that have double parentheses, such as setSpecies(), called? Fields. Associations. Aggregations. Methods.

These are methods in the class. These are methods in the class. These are methods in the class. These are methods in the class. These are methods in the class.

How should DECIMAL and NUMERIC be used in the same database? They should not be used together. They can be used interchangeably. They should be on different parent-child levels. They should be used alternatingly.

They should not be used together. Because SQL does not recognize them as the same, choose one or the other and stick with it!

_____ can be used to change data in a record. INSERT. UPDATE. DELETE. SELECT.

UPDATE. UPDATE. UPDATE. UPDATE. UPDATE. UPDATE. UPDATE can be used to change data in a record. UPDATE can be used to change data in a record. UPDATE can be used to change data in a record. UPDATE can be used to change data in a record.

_____ can be used to change data in a record. DELETE INSERT SELECT UPDATE

UPDATE. UPDATE. UPDATE. UPDATE. UPDATE. UPDATE. Update can be used to change data in a record. Update can be used to change data in a record. Update can be used to change data in a record. Update can be used to change data in a record.

The SQL clause used to identify the table or tables containing the target data is the _____ clause. FROM. ORDER BY. WHERE. SELECT.

FROM. FROM. FROM. FROM. FROM. FROM. FROM. The FROM clause in an SQL statement is used to specify the table. The FROM clause in an SQL statement is used to specify the table. The FROM clause in an SQL statement is used to specify the table.

Using the float keyword, which statement will return all digits for the value 3.5872? Float(0,5). Float(3,7). Float(5, 4). Float(7,0).

Float(5, 4). Float(5, 4). Float(5, 4). Float(5, 4). Float(5, 4). Total numbers then numbers after the decimal. Total numbers then numbers after the decimal. Total numbers then numbers after the decimal. Total numbers then numbers after the decimal.

The GROUP By clause is always paired with _____ and must precede _____, if it is used. SELECT, ORDER BY. DELETE, SELECT. INSERT, SELECT. ORDER BY, SELECT.

GROUP BY is paired with the SELECT & ORDER BY. GROUP BY is paired with the SELECT & ORDER BY. GROUP BY is paired with the SELECT & ORDER BY. GROUP BY is paired with the SELECT & ORDER BY. GROUP BY is paired with the SELECT & ORDER BY.

What is the correct format for TIME? HH:MM:S MM:HH:SS HH:MM:SS.[nnnnnnn] nnnnnnn:SS:MM:HH

HH:MM:SS.[nnnnnnn] HH:MM:SS.[nnnnnnn] Hours, minutes, and seconds all have two spots, while the optional places for fractions of a second have 7.

In the diagram below, what type of association exists between Tree and Deciduous? 🔷 🔷🔷🔷🔷🔷 Negative association. Positive association. Composition. Aggregation.

Composition. Composition. Composition. Composition. Composition is similar to aggregation but means that the child class can't exist if the parent class is destroyed. This is denoted by a filled diamond on the parent side. 🔷🔷🔷🔷🔷

Which of the following is NOT a SQL command category? Transaction Control DDL. (Data Definition Language) DMA. DCL. (Data Control Language)

DMA is NOT a SQL command category. DMA is NOT a SQL command category. DMA is NOT a SQL command category. DMA is NOT a SQL command category. DMA is NOT a SQL command category.

Which of the following SQL command categories is concerned with auditing operations? Data Administration. DDL. DML. Query.

Data administration. Data administration. Data administration. Data administration is the SQL command category that is concerned with auditing operations. Data administration is the SQL command category that is concerned with auditing operations.

_____ will add a new row to the table. DELETE/ INSERT INTO. UPDATE. SELECT.

INSERT INTO. INSERT INTO. INSERT INTO. INSERT INTO. INSERT INTO will add a new row to the table. INSERT INTO will add a new row to the table. INSERT INTO will add a new row to the table. INSERT INTO will add a new row to the table.

What is the proper format for DATE? YY-MM-DD. MM-DD-YY. YYYY-MM-DD. MM-DD-YYYY.

In SQL use YYYY-MM-DD, or year, month, and day. In SQL use YYYY-MM-DD, or year, month, and day. In SQL use YYYY-MM-DD, or year, month, and day. In SQL use YYYY-MM-DD, or year, month, and day. In SQL use YYYY-MM-DD, or year, month, and day.

Which of the following is true of a class diagram? It is a requirement for all object-oriented design. It has many shortcomings. It can be used as a blueprint to build a system. It is only a model.

It can be used as a blueprint to build a system. It can be used as a blueprint to build a system. It can be used as a blueprint to build a system. It can be used as a blueprint to build a system. It can be used as a blueprint to build a system.

Based on the class diagram below, what is true of the Deciduous class? It is a superclass of Tree. It inherits from Tree. It is a parent class of Tree. Tree inherits from Deciduous.

It inherits from Tree. It inherits from Tree. It inherits from Tree. The symbol indicates that the Deciduous class inherits from the parent class, Tree. ⬅️⬅️⬅️⬅️⬅️⬅️⬅️⬅️⬅️⬅️⬅️⬅️⬅️⬅️

Consider the following object diagram. Based on the diagram, which of the following is true of the Maple class? It is a parent of the Tree class. Its ID is always 15. It is an instance of the Tree class. Its ID is always 10.

It is an instance of the Tree class. It is an instance of the Tree class. It is an instance of the Tree class. It is an instance of the Tree class. It is an instance of the Tree class.

The GROUP By clause is always paired with _____ and must precede _____, if it is used. ORDER BY, SELECT. INSERT, SELECT. DELETE, SELECT. SELECT, ORDER BY.

SELECT, ORDER BY. SELECT, ORDER BY. SELECT, ORDER BY. Paired with Select and must precede Order By. Paired with Select and must precede Order By. Paired with Select and must precede Order By. Paired with Select and must precede Order By.

In MySQL, the _____ can hold 4 gigabytes. LONGBLOB. MEDIUMBLOB. TINYBLOB. BLOB.

LONGBLOB. LONGBLOB. LONGBLOB. LONGBLOB. MySQL LONGBLOG equals BLOB in any other DBMS. MySQL LONGBLOG equals BLOB in any other DBMS. MySQL LONGBLOG equals BLOB in any other DBMS. MySQL LONGBLOG equals BLOB in any other DBMS.

What does the 's' stand for in a DECIMAL or NUMERIC value? Sequence. Scale. Sort. Size.

Meanwhile, the s stands for scale. Meanwhile, the s stands for scale. Meanwhile, the s stands for scale. Meanwhile, the s stands for scale. Meanwhile, the s stands for scale.

In Structured Query Language (SQL), about how many values can INT hold? More than 2 million. A quintillion. 256. More than 4 billion.

More than 4 billion. More than 4 billion. More than 4 billion. More than 4 billion. More than 4 billion. More than 4 billion. More than 4 billion. More than 4 billion. More than 4 billion. More than 4 billion. More than 4 billion. More than 4 billion.

Which of these data types allows for decimals? BIGINT. SMALLINT. INTEGER. NUMERIC.

NUMERIC. NUMERIC. NUMERIC. NUMERIC. NUMERIC. Only NUMERIC and DECIMAL allow for decimals. Only NUMERIC and DECIMAL allow for decimals. Only NUMERIC and DECIMAL allow for decimals. Only NUMERIC and DECIMAL allow for decimals.

BLOBS are _____ data types Primitive. Inherited. Neutral. Object.

Object data types. Object data types. Object data types. examples of BLOBs (Binary Large Objects) are complex files such as images, video, and audio.

If you want to view a maximum value from a table, in which part of the SQL statement should the subquery be placed? SELECT. ORDER BY. GROUP BY. FROM.

SELECT. SELECT. SELECT. SELECT. SELECT. SELECT. If you want to view a maximum value from a table use SELECT. If you want to view a maximum value from a table use SELECT. If you want to view a maximum value from a table use SELECT. If you want to view a maximum value from a table use SELECT.

What does the acronym SQL stand for? Structured Query Language. Simple Query Language. Structured Question Language. Structured Question List.

SQL is an acronym that stands for Structured Query Language. SQL is an acronym that stands for Structured Query Language. SQL is an acronym that stands for Structured Query Language. SQL is an acronym that stands for Structured Query Language.

What does the 'p' stand for in a DECIMAL or NUMERIC value? Partial. Precision. Portable. Politics.

Precision. Precision. Precision. Precision. Precision.

Which data type stores 4 bytes, or 7 digits after the decimal? Double. Real. Long. Float.

Real data can hold a value 4 bytes in size, meaning it has 7 digits of precision. Real data can hold a value 4 bytes in size, meaning it has 7 digits of precision. Real data can hold a value 4 bytes in size, meaning it has 7 digits of precision.

Which of the following is NOT a use for an object diagram? Provide understanding for the non-technical. Replace object-oriented design. Develop a prototype of the system. Model complex data.

Replace object-oriented design. Replace object-oriented design. Replace object-oriented design. Replace object-oriented design. Replace object-oriented design.

Which SQL statement would return ALL records from the artist table? SELECT *.* SELECT * FROM tblArtist WHERE artistID = 17 SELECT artistName FROM tblArtist WHERE artistName='Journey' SELECT * FROM tblArtist

SELECT * FROM tblArtist SELECT * FROM tblArtist SELECT * FROM tblArtist SELECT * FROM tblArtist SELECT * FROM tblArtist (*) All rows will be shown.

A database stores a value for vacation accrual. A sample value is 1.2533458. Which SQL statement will show a value of 1.253? SELECT CAST(vacation_accrual as Float(4,3)); SELECT CAST(vacation_accrual as Real(0)); SELECT CAST(vacation_accrual as Int(3)); SELECT CAST(vacation_accrual (4,3));

SELECT CAST(vacation_accrual as Float(4,3)); SELECT CAST(vacation_accrual as Float(4,3)); SELECT CAST(vacation_accrual as Float(4,3)); SELECT CAST(vacation_accrual as Float(4,3)); SELECT CAST(vacation_accrual as Float(4,3));