In an E-R diagram attributes are represented by

square

ellipse

triangle

rectangle

Databases

Write a comment

Select differences between reference type and value type : 1. Memory allocated to ‘Value type’ is from heap and reference type is from ‘System. ValueType’
2. Memory allocated to ‘Value type’ is from ‘System. ValueType’ and reference type is from ‘Heap’
3. Structures, enumerated types derived from ‘System. ValueType’ are created on stack, hence known as ValueType and all ‘classes’ are reference type because values are stored on heap
Attempt Now
Which of the following is used to delete the entries in the referenced table when the tuple is deleted in course table? CREATE TABLE course
( . . .
FOREIGN KEY (dept name) REFERENCES department
. . . );
Attempt Now
Select appropriate difference between decimal, float and double data type in C# ? 1) Float and Double are floating binary point types while decimal is a floating decimal point type.
2) Precision difference for float is ‘7’ digit for double is ’15’ to ’16’ digit and for decimal is ’28’ to ’29’ digits.
3) Some values which cannot be exactly represented hence for those values float and double are more appropriate.
Attempt Now
The REMOTE_OS_AUTHENT parameter operates an externally-authenticated user and it can connect to the remote database using a connected user database link, Select the correct parameter to set.
Attempt Now
SELECT emp_name FROM department WHERE dept_name LIKE ' _____ Computer Science'; In the above-given Query, which of the following can be placed in the Query's blank portion to select the dept_name that also contains Computer Science as its ending string?
Attempt Now
A production database can use the Full recovery model and immediately before a large data load, the recovery model can be changed to Bulk-Logged to minimize logging and increase performance.
Attempt Now
Embedded SQL statements are used in COBOL programs to perform standard SQL operations. Embedded SQL statements are preprocessed by SQL processor before application program is compiled. State whether true or false?
Attempt Now
Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?
Attempt Now
Which statement is true concerning dropping a pluggable database (PDB)?

Attempt Now
Scope of variable is related to definition of variable as: 1. Region of code within which variable value is valid and hence can be accessed.
2. No, relation with region where variable is declared its value is valid in entire scope.
Attempt Now