What does the %TYPE attribute instruct the system to do? Answers: a, retrieve the database column data type for the variable b. copy a variable c. retrieve data from the database d. use a Boolean data type

Database Systems please help me answer this question I will give you a good rating Thank you!

Looking Up Data- INDEX () & MATCH() Which of the following statements describes how the INDEX) and MATCH() functions are combined to lookup data?   A) MATCH() is used within the INDEX() function to return the relative position of the data in the lookup table B) INDEX) is used within the MATCH() function to return the relative position of the data in the lookup table C) MATCH() is used to match values from the lookup table and the source table, INDEX() returns the index of these values D) INDEX calculates the relative position of the data in the source table and returns values for MATCH() to lookup

Below is “Book Order,” the only table in library management system’s database. The design of “Book Order” as you may tell is in the zero normal formal form, you as the database designer want to convert the design into the third normal form.   Order ID Special order date Customer ID Customer last name Customer First name Customer birth date Book ISBN1 Book Title 1 Book Author 1 Book publication year 1 Book ISBN2 Book Title 2 Book Author 2 Book publication year 2 Store ID Store name Store location Special order status     Book Order(Order ID, Special order date, Customer ID, Customer last name, Customer First name, Customer birth date, Book ISBN1, Book Title 1, Book Author 1, Book publication year 1, Book ISBN2, Book Title 2, Book Author 2, Book publication year 2, Store ID, Store name, Store location, Special order status)

You may use an Oracle function to determine the number of days that have gone since your birthday and the current date.

SQL Query Relational Algebra select avg(customer.age) as "avg_age" from AVG(avg_age) (customer) customer; 1. Select customer phone, customer.address, customer.fullname from customer where exists (select * from billing where billing.cid = customer. Customer id); 2. Select * from customer where customer.address in ('Ibri'); 3. Select billing.bill id from billing Group by bill id Having count (case when billing.b status = 'REJWCTED' then 1 end) >1; select * from customer order by full name, age;

QUESTION 21 Code a chain of MongoDB methods that    retrieves documents from MondoDB collection named WEB322 the only documents that are selected are the ones with value 211 in the semester field  the only fields of the selected documents that are retrieved are firstName and lastName make sure the _id field is NOT retrieved sort the selected documents by lastName in ascending sequence store the result to an array named result assume the connection between the program and database had already been established and the name of the database object is db

SQL query question