Answer:
The Update statement in the DML is used for changing existing data in a table.
Explanation:
Their are following Sql statement in the DML.
Insert
This SQL statement is used for inserting data into the table.
select
This SQL statement is used for retrieving data from database
update
This SQL statement is used for updating data in a table.
delete
This SQL statement is used for delete data from database .
The "UPDATE" SQL statement in DML is used for Modify the data in the existing table .
Following are the syntax of Update SQL query
Update tablename
set column1=value1,column2=value2............column N=valueN
Where condition;
Example :Suppose we have student table and (rollno,name,age and add) are the field for that table we have to change the address of rollno 105
Then we use update query like that
UPDATE STUDENT
SET add='kalam nagar'
where rollno=105;
Answer:
Call showValue (12)
Explanation:
The function is a block of the statement which performs the special task.
if you define the function, then you have to call that function.
Then, program control moves to the function and start to execute otherwise not execute the function.
the syntax for calling the function:
name(argument_1, argument_2,....);
we can put any number of arguments in the calling.
check the options one by one for finding the answer:
Call showValue( Integer): this is valid calling but it passes the variable, not the 12. this is not correct.
Call showValue( Integer 12): This is not valid calling, because it passes the data type as well which is incorrect.
Call showValue( Real): this is valid calling but it passes the variable, not the 12. this is not correct.
Call showValue (12): this valid calling and also pass the value 12.
Therefore, the correct answer is option b.
Answer:
The answer is "Option D".
Explanation:
OLAP reports stands for Online Analytical Processing reports, These reports provide a platform that behind many application use in Business Intelligence. and other options are incorrect that can be described as follows:
- In option A, It is used to store the data into the OLAP report, that's why it is not correct.
- In option B, It is software that is used for analytics data, that's why it is not correct.
- In option C, It is used for finding index values in the 2D array that's why it is not correct.
Answer:
FFF4
Explanation:
Binary representation of 12 = 00001100
Expressing it in hexadecimal format : 0C
Binary representation of -12:
Step 1 : Computing 1's complement for 12 =11110011
Step 2 : Adding 1 to 1's complement to get the 2's complement =>
11110011+1 = 11110100
Converting the 2's complement representation to hexadecimal format:
F4 ( 8 bit representation) or FFF4 ( 16 bit representation)
Answer:
1. Multistage database.
2. Stationary database.
3. Virtual database.
4. Distributed database.
Explanation:
A database management system (DBMS) can be defined as a collection of software applications that typically enables computer users to create, store, modify, retrieve and manage data or informations in a database. Generally, it allows computer users to efficiently retrieve and manage their data with an appropriate level of security.
There are four (4) major types of database in a data warehouse and these are;
1. <u>Multistage database</u>: used for concise as well as detailed historical data. It provides summarized data which can be used by an employee for short-term decision making.
2. <u>Stationary database</u>: used where access to data is rare i.e business firms who do not access data frequently. In order to use this database, the users must have an access to metadata store and thus, directly having access to the data on a source system.
3. <u>Virtual database</u>: used for accessing data in diverse applications using middleware. This type of database is dependent on having access to information on various databases.
4. <u>Distributed database</u>: used by an organization that runs several businesses. Therefore, this type of database are usually located or situated in various geographical regions.
