test4

Q1.A ---------database architecture that is used for handling huge amounts of data that are highly scalable and fault-tolerant. Object Relational. Object Oriented. Not-only-SQL. Relational.

is a data storage paradigm designed for storing, retrieving, and managing. Key Value DB. Document DB. Graph DB. Column DB.

Is a data storage paradigm designed for storing data as key-value pairs and can have a complex nested structure. Key Value DB. Document DB. Graph DB. Column DB.

Data storage are based on a sparsely populated table whose rows can contain arbitrary columns and where keys provide for natural indexing. Key Value DB. Document DB. Graph DB. Column DB.

NoSQL database that uses relationship or edge structures for semantic queries with nodes, and properties to represent and store data. Key Value DB. Document DB. Graph DB. Column DB.

A view can restrict user access to specific rows in a table. True. False.

A view can restrict user access to specific columns in a table. True. False.

A view replicates data, from a table, in a new databaseviewobject. True. False.

A view can join columns from multiple tables so that the columns appear to be single table. True. False.

A named group of SQL statements that can be executed in a database is called. Formula. Procedure/Function. Method. Subroutines.

You need to disable UserX’s access to view the data in the Customer table. Which statement should you use?. REMOVEUserX FROM Customer. REVOKE UserX FROM Customer. REMOVE SELECT ON Customer FROM UserX. REVOKE SELECT ON Customer FROM UserX.

One difference between a function and a stored procedure is that a function: Must return a value. Cannot accept parameters. Cannot contain a transaction. Must be called from a trigger.

You need to remove a view named EmployeeView from your database. Which statement should you use?. DELETE EmployeeView. DELETE VIEW EmployeeView. DROP EmployeeView. DROP VIEW EmployeeView.

You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted. Forty rows will be deleted from the table. No rows will be deleted from the table. The transaction will restart. The table will be corrupted.

Which permission does a userXneed in order to run a stored procedurespX?. GRANT EXECUTE ON PROCEDURE spX TO userX;. GRANT EXECUTE ON spXTO userX;. AllowRunPROCEDURE spXTO userX;. AllowPROCEDUREspXTO userX;.

You assign to User2 a set of permissions that include the WITH GRANT OPTION. The WITH GRANT OPTION enables User2 to: Create new database users. Delegate permissions to other users. Request a log of permission use. View other user’s permission.

You need to establish a set of permissions that you can routinely assign to new users. What should you create?. Group. List. Resource. Role.

The phrase “greater than at least one” is represented in SQL by _____. < all. < any. > all. > any.

This statement IS erroneous because. Avg(salary) should not be selected. Dept_id should not be used in group by clause. Misplaced group by clause. Group by clause is not valid in this query.

You need to enable a new employee to authenticate to your database. Which command should you use?. ADD USER. ALLOW USER. INSERTUSER. CREATE USER.

Asub-query in an SQL SELECT statement is enclosed in: Braces --{...}. CAPITAL LETTERS. Parenthesis--(...). Brackets --[...].

Which of the following are the five built-in aggregation functions provided by SQL?. COUNT, SUM, AVG, MAX, MIN. SUM, AVG, MIN, MAX, LIKE. SUM, AVG, MULT, BETWEEN, MIN. SUM, AVG, MIN, MAX, IN.

The HAVING clause does which of the following. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for rows rather than columns. Acts like a WHERE clause but is used for columns rather than groups. Acts EXACTLY like a WHERE clause.

Which of the following is true concerning triggers?. You do not create them with SQL. They execute against only some applications that access a database. They have an event, condition, and action. They cannot cascade (cause another trigger to fire).

You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a database table named volunteer. When volunteers ask to be removed from mailing lists,the table must be updated. You need to use a transaction to ensure that the database has data integrityand referential integrity.Which statement should you use?. Start TRANSACTION VolunteerDelete;Delete FROM Volunteer WHERE Id=13;Commit VolunteerDelete;. Open TRANSACTION VolunteerDelete;Delete FROM Volunteer WHERE Id=13;Close VolunteerDelete;. StartTRANSACTION VolunteerDelete; Delete FROM Volunteer WHERE Id=13;End. While TRANSACTION VolunteerDelete;Delete FROM Volunteer WHERE Id=13;Catch TRANSACTIONVolunteerDelete;.

The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER-INSERTtrigger. Equi-join. Natural join. Outer join. All the mentioned.

How many tables may be included with a join?. One. Two. Three. All the mentioned.

Aggregate functions are functions that take a ___________ as input and return a single value. Collection of values. Single value. Aggregate value. Both Collection of values & Single value.

Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct.Q30.A view can used to ensure referential integrity. No change is needed. Save extra copy of data stored in a separate table. Limit access to specific rows or columns of data in a table. Save historical data before deleting it from base table.

Use the Allow SELECTcommand to give a user permission to read the data in a table. No change is needed. GRANT SELECT. LET SELECT. PERMIT SELECT.

The UNIONkeyword combines the results of two queries and returns only rows that appear in both result set. No change is needed. INTERSECT. ALL. JOIN.

Truncateis a database term used to describe the process of applying backup to a damaged or corrupt database. No Change is needed. Attach. Restore. Commit.

To call stored procedure must use EXECkeyword. No Change is needed. CALL. EXECUTE. RUN.

Use Indexingto create, remove, or change database object. No change is needed. Data Manipulate Language (DML). Data Definition Language (DDL). A unique constraint.

Transactionmakes columns faster to query by creating pointers to where data is stored within a table. No change is needed. Indexing. Integrity. A unique constraint.

Which of the following is used to provide delete authorization to instructor?. CREATEROLEinstructor ;GRANTDELETETOinstructor;. CREATEROLEinstructor;REVOKEDELETEFROMtableXFROMinstructor;. CREATEROLEinstructor;GRANTDELETEONtableXTOinstructor;.

Grand all privileges to a userXaccount on all databases. GRANT ALL PRIVILEGES ON *.* TO 'userX'@'localhost';. GRANT ALL ON *.* TO 'userX';. GRANT PRIVILEGES ON databaseNameTO 'userX';. None of the mentioned.

Find the privilege(s) granted to a userXaccount. SHOW GRANTS FOR 'userX'@'localhost';. SHOW GRANTS FOR 'userX';. A & b.

A function must have a return value. True. False.

You can delete data by using a stored procedure. True. False.

A stored procedure must have a return value. True. False.

Default type of parameter/argument of procedure “out”. True. False.

One reason to create a stored procedure is to: Improve performance. Minimize storage space. Bypass case sensitivity requirements. Give the user control of the query logic.

You have a table named Product that contains one million rows. You need to search for product information in the Product table by using the product’s unique ID. What will make thistype of search more efficient?. An index. A trigger. A subquery. A cursor.

On reason to add an index is to: Decrease strong space. Increase database security. Improve performance of INSERT statement. Improve performance of SELECT statement.

You create an index on a table that contains data. What is the result in the database?. More rows are added to the indexed table. More columns are added to the indexed table. A separate structure is created that contains the data from the indexed table. A separate structure is created that does not contain the data from the indexed table.

In MySQL to define a column whose hold JSON data, you use data type. LONGBLOB. LONGTEXT. JSON. None of the mentioned.

The CONNECTION_ID() function is used for return the connection ID for a current connection. True. False.

A trigger is a set of actions that are run automatically when a specific operation. INSERT, UPDATE, or DELETE. BEFORE or AFTER. SELECT, INSERT, UPDATE, or DELETE.

A ---------is a named database object that is associated with a table, and it activates when aeventoccurs for the table. Index. Trigger. View. Role.

In an INSERT trigger, you can use OLD.col_name to refer to the columns of arow before it is inserted. True. False.

A property by which subtype entities inherit values of all attributes and instances of all relationships of their supertype. Disjointness constraint. Completeness constraint. Attribute inheritance. Subtype discriminator.

The process of defining a more general entity type from a set of more specialized entity types. Specialization. Disjoint rule. Overlap rule. Generalization.

The process of defining one or more subtypes of the supertype and forming supertype/subtyperelationships. Specialization. Disjoint rule. Overlap rule. Generalization.

A type of constraint that addresses whether an instance of a supertype must also be a member of at least one subtype. Disjointness constraint. Completeness constraint. Attribute inheritance. Subtype discriminator.

A rule that specifies that each entity instance of a supertype must be a member of some subtype in the relationship. Partial specialization rule. Total specialization rule. Disjoint rule. Overlap rule.

A constraint that addresses whether an instance of a supertype may simultaneously be a member of two (or more) subtypes. Completeness constraint. Attribute inheritance. Disjointness constraint. Subtype discriminator.

A rule that specifies that an instance of a supertype may not simultaneously be a member oftwo (or more) subtypes. Total specialization rule. Disjoint rule. Partial specialization rule. Overlap rule.

A rule that specifies that an instance of a supertype may simultaneously be a member oftwo (or more) subtypes. Total specialization rule. Overlap rule. Disjoint rule. Partial specialization rule.

An attribute of a supertype whose values determine the target subtype or subtypes. Attribute inheritance. Disjointness constraint. Subtype discriminator. Completeness constraint.

The entity set person is classified as student and employee. This process is called _________. Generalization. Specialization. Inheritance. Constraint generalization.

A _____________ constraint requires that an entity belong to no more than one lower-level entity set. Disjointness. Uniqueness. Special. Relational.

Consider the employee work-team example andassume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is _____________. Overlapping. Disjointness. Uniqueness. Relational.