Blog

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.

The table STUDENT has the attributes STUDENT_ID, NAME, SCHOOL_ID, and ADDR. The table SCHOOL has the attributes SCHOOL_ID, NAME, and STATE_CODE. Assume that there is a 1:N relation between SCHOOL and STUDENT. Which of the following creates a table that shows the STUDENT attributes and the corresponding SCHOOL attributes?

The idea that all living things are composed of cells and all cells come from other cells is called

Choose the cell structure that is best described by the following definitions: