Blog

What factors should be considered when determining the intensity of a client’s cardiorespiratory exercise program? 

Some of the rows the GRADES table are below: ​ CODE NAME GPA YEAR 938 ALEX 3.1 2 931 MICHELLE 2.3 1 182 JOE 3.1 3 918 ADELE 2.9 2   Which of the following queries returns the name of all the students that achieved the maximum GPA among all the students?  

 _____ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

Some rows of the tables SALESPERSON and SALES are shown below:   SALESPERSON VCODE NAME 7 Alex 8 Tony 9 Charles 11 Mary     SALES SCODE VCODE TOTAL 341 9 19.50 213 11 89.95 312 7 31.10 You want the name of all the salespersons that have made at least one sale with a total higher than 100.   Which of the following queries gives the desired result?  

Your database has become slow which has caused many transactions to be stopped, rescheduled, and restamped. There are increased memory needs along with database processing overhead that is caused by the ____________ of the transactions.

Consider the following table:   TABLE1 val1 val2 val3 3 129 10 2 391 30 12 89 30 5 129 20 90 12 10 12 10 20   What is the result of the query below?   SELECT * FROM TABLE1 WHERE val2 BETWEEN         (100, 400) AND val3 IN (10, 20)    

 Granularity refers to _____.

Consider the following tables   Name: CLIENTS Primary Key: CLIENT_ID CLIENT_ID NAME 19283 Jhon 19281 Mary 19272 Elizabeth   Name: SALES Primary Key: (SALE_ID, PROD_ID) Foreign Key: PROD_ID, CLIENT_ID SALE_ID PROD_ID CLIENT_ID DATE FGS12301 12930182 19281 2022-07-10 DEF28358 19283104 19272 2022-07-11 GHM3920 19283123 17913 2021-06-22   How many rows produces the following query?   SELECT * FROM CLIENTS RIGHT JOIN SALES ON CLIENTS.CLIENT_ID = SALES.CLIENT_ID ​

 The pet store where you work has transactions that have been processed. The database shows a permanent consistent state. The _________________ transaction property indicates the permanence of the database’s consistent state.

 A _____ derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence.