An Assertion is a predicate expressing a condition we wish database to always satisfy. The correct syntax for Assertion is : (A) CREATE ASSERTION ‘ASSERTION Name’ CHECK ‘Predicate’ (B) CREATE ASSERTION ‘ASSERTION NAME’ (C) CREATE ASSERTION, CHECK Predicate (D) SELECT ASSERTION

An Assertion is a predicate expressing a condition we wish database to always satisfy. The correct syntax for Assertion is : (A) CREATE ASSERTION ‘ASSERTION Name’ CHECK ‘Predicate’ (B) CREATE ASSERTION ‘ASSERTION NAME’ (C) CREATE ASSERTION, CHECK Predicate (D) SELECT ASSERTION
by

1 Answer

Answer :

(A) CREATE ASSERTION ‘ASSERTION Name’ CHECK ‘Predicate’ 
by

Related questions

Relational database schema normalization is NOT for: (A) reducing the number of joins required to satisfy a query. (B) eliminating uncontrolled redundancy of data stored in the database. (C) eliminating number of anomalies that could otherwise occur with inserts and deletes. (D) ensuring that functional dependencies are enforced.

Description : Relational database schema normalization is NOT for: (A) reducing the number of joins required to satisfy a query. (B) eliminating uncontrolled redundancy of data stored in the database. (C) ... could otherwise occur with inserts and deletes. (D) ensuring that functional dependencies are enforced. 

Last Answer : reducing the number of joins required to satisfy a query.

Consider the following database table : Create table test( one integer, two integer, primary key(one), unique(two), check(one≥1 and ≤10), check(two≥1 and ≤5) ); How many data records/tuples atmost can this table contain ? (A) 5 (B) 10 (C) 15 (D) 50

Description : Consider the following database table : Create table test( one integer, two integer, primary key(one), unique(two), check(one≥1 and ≤10), check(two≥1 and ≤5) ); How many data records/tuples atmost can this table contain ?  (A) 5 (B) 10 (C) 15 (D) 50

Last Answer : (A) 5 

What is the output of the following piece of code when executed in Python shell? >>> a=("Check")*3 >>> a a) (‘Check’,’Check’,’Check’) b) * Operator not valid for tuples c) (‘CheckCheckCheck’) d) Syntax erro

Description : What is the output of the following piece of code when executed in Python shell? >>> a=("Check")*3 >>> a a) (‘Check’,’Check’,’Check’) b) * Operator not valid for tuples c) (‘CheckCheckCheck’) d) Syntax erro

Last Answer : c) (‘CheckCheckCheck’)

To select all column from the table the syntax is: A) select all from table_name B) select * from table_name C) select from table_name D) Non of the above

Description : To select all column from the table the syntax is: A) select all from table_name B) select * from table_name C) select from table_name D) Non of the above

Last Answer : B) select * from table_name

Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values> A) i-only B) ii-only C) Both of them D) None of them

Description : Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list) values A) i-only B) ii-only C) Both of them D) None of them

Last Answer : C) Both of them

Suppose list1 is [4, 2, 2, 4, 5, 2, 1, 0], which of the following is correct syntax for slicing operation? a) print(list1[0]) b) print(list1[:2]) c) print(list1[:-2]) d) all of the mentioned

Description : Suppose list1 is [4, 2, 2, 4, 5, 2, 1, 0], which of the following is correct syntax for slicing operation? a) print(list1[0]) b) print(list1[:2]) c) print(list1[:-2]) d) all of the mentioned

Last Answer : d) all of the mentioned

Consider the following statements related to compiler construction: I. Lexical Analysis is specified by context-free grammars and implemented by pushdown automata. II. Syntax Analysis is specified by regular expressions and implemented by finite-state machine. Which of the above statement(s) is/are correct? (1) Only l (2) Only ll (3) Both I and II (4) Neither I nor Il

Description : Consider the following statements related to compiler construction: I. Lexical Analysis is specified by context-free grammars and implemented by pushdown automata. II. Syntax Analysis is specified by regular expressions and implemented by ... Only l (2) Only ll (3) Both I and II (4) Neither I nor Il

Last Answer : Answer: 4

Suppose d = {“john”:40, “peter”:45}, what happens when we try to retrieve a value using the expression d[“susan”]? a) Since “susan” is not a value in the set, Python raises a KeyError exception b) It is executed fine and no exception is raised, and it returns None c) Since “susan” is not a key in the set, Python raises a KeyError exception d) Since “susan” is not a key in the set, Python raises a syntax error

Description : Suppose d = { john :40, peter :45}, what happens when we try to retrieve a value using the expression d[ susan ]? a) Since susan is not a value in the set, Python raises a KeyError ... Python raises a KeyError exception d) Since susan is not a key in the set, Python raises a syntax error

Last Answer : c) Since “susan” is not a key in the set, Python raises a KeyError exception

Consider a “CUSTOMERS” database table having a column “CITY” filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have “GAR” somewhere in its name, is: (A) Select *from customers where city=’%GAR%’; (B) Select *from customers where city=’$GAR$’; (C) Select *from customers where city like ‘%GAR%’; (D) Select *from customers where city as ’%GAR’;

Description : Consider a CUSTOMERS database table having a column CITY filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have GAR somewhere in its name, ... *from customers where city like %GAR%'; (D) Select *from customers where city as '%GAR';

Last Answer : Answer: C

Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ? (A) SELECT A FROM R; (B) SELECT A, COUNT(*) FROM R; (C) SELECT A, COUNT(*) FROM R GROUP BY A; (D) SELECT A, B, COUNT(*) FROM R GROUP BY A, B;

Description : Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ? (A) SELECT A FROM R; (B) SELECT A, COUNT(*) FROM R; (C) SELECT A, COUNT(*) FROM R GROUP BY A; (D) SELECT A, B, COUNT(*) FROM R GROUP BY A, B;

Last Answer : (B) SELECT A, COUNT(*) FROM R;

For like predicate which of the following is true. i) % matches zero of more characters. ii) _ matches exactly one character. A) i-only B) ii-only C) Both of them D) None of them

Description : For like predicate which of the following is true. i) % matches zero of more characters. ii) _ matches exactly one character. A) i-only B) ii-only C) Both of them D) None of them

Last Answer : C) Both of them

The ..................... is essentially used to search for patterns in target string. A) Like Predicate B) Null Predicate C) In Predicate D) Out Predicate

Description : The ..................... is essentially used to search for patterns in target string. A) Like Predicate B) Null Predicate C) In Predicate D) Out Predicate

Last Answer : A) Like Predicate

…………….. is the complex search criteria in the where clause. A) Substring B) Drop Table C) Predict D) Predicate

Description : …………….. is the complex search criteria in the where clause. A) Substring B) Drop Table C) Predict D) Predicate

Last Answer : D) Predicate

…………….. is used to determine whether of a table contains duplicate rows. A) Unique predicate B) Like Predicate C) Null predicate D) In predicate

Description : …………….. is used to determine whether of a table contains duplicate rows. A) Unique predicate B) Like Predicate C) Null predicate D) In predicate

Last Answer : A) Unique predicate

Given a flow graph with 10 nodes, 13 edges and one connected components, the number of regions and the number of predicate (decision) nodes in the flow graph will be (A) 4, 5 (B) 5, 4 (C) 3, 1 (D) 13, 8

Description : Given a flow graph with 10 nodes, 13 edges and one connected components, the number of regions and the number of predicate (decision) nodes in the flow graph will be (A) 4, 5 (B) 5, 4 (C) 3, 1 (D) 13, 8

Last Answer : (B) 5, 4

.............. predicate calculus allows quantified variables to refer to objects in the domain of discourse and not to predicates or functions. (A) Zero-order (B) First-order (C) Second-order (D) High-order

Description : .............. predicate calculus allows quantified variables to refer to objects in the domain of discourse and not to predicates or functions. (A) Zero-order (B) First-order (C) Second-order (D) High-order

Last Answer : (B) First-order

Which one of the following is used to compute cyclomatic complexity ? (A) The number of regions – 1 (B) E – N + 1, where E is the number of flow graph edges and N is the number of flow graph nodes. (C) P – 1, where P is the number of predicate nodes in the flow graph G. (D) P + 1, where P is the number of predicate nodes in the flow graph G.

Description : Which one of the following is used to compute cyclomatic complexity ? (A) The number of regions - 1 (B) E - N + 1, where E is the number of flow graph edges and N is the number of flow graph nodes. (C) ... in the flow graph G. (D) P + 1, where P is the number of predicate nodes in the flow graph G.

Last Answer : (D) P + 1, where P is the number of predicate nodes in the flow graph G.

The cyclomatic complexity of a flow graph V(G), in terms of predicate nodes is: (A) P + 1 (B) P - 1 (C) P - 2 (D) P + 2 Where P is number of predicate nodes in flow graph V(G).

Description : The cyclomatic complexity of a flow graph V(G), in terms of predicate nodes is: (A) P + 1 (B) P - 1 (C) P - 2 (D) P + 2 Where P is number of predicate nodes in flow graph V(G).

Last Answer : (A) P + 1 

Pick up the correct statement from the following: (A) Plain cement concrete is equally strong in compression as well as in tension (B) Slump test is performed to check concrete strength (C) Curing of concrete is done for proper compaction of cement (D) Fineness modulus is the index number expressing the relative sizes of both coarse and fine aggregates

Description : Pick up the correct statement from the following: (A) Plain cement concrete is equally strong in compression as well as in tension (B) Slump test is performed to check concrete strength (C ... D) Fineness modulus is the index number expressing the relative sizes of both coarse and fine aggregates

Last Answer : Option D

What is the output of the following code? a={1:"A",2:"B",3:"C"} print(a.get(5,4)) a) Error, invalid syntax b) A c) 5 d) 4

Description : What is the output of the following code? a={1:"A",2:"B",3:"C"} print(a.get(5,4)) a) Error, invalid syntax b) A c) 5 d) 4

Last Answer : d) 4

What is the output of the following piece of code? >>> a=(0,1,2,3,4) >>> b=slice(0,2) >>> a[b] a) Invalid syntax for slicing b) [0,2]. c) (0,1) d) (0,2)

Description : What is the output of the following piece of code? >>> a=(0,1,2,3,4) >>> b=slice(0,2) >>> a[b] a) Invalid syntax for slicing b) [0,2]. c) (0,1) d) (0,2)

Last Answer : c) (0,1)

Process of removing errors called a) Error Free b) Debug c) Syntax Error d) Exception

Description : Process of removing errors called a) Error Free b) Debug c) Syntax Error d) Exception

Last Answer : b) Debug

What will be the output of the following segment of the program? main( ) { char *s = “hello world”; int i = 7; printf(“%, *s”, i, s); } (A) Syntax error (B) hello w (C) hello (D) o world

Description : What will be the output of the following segment of the program? main( ) { char *s = “hello world”; int i = 7; printf(“%, *s”, i, s); } (A) Syntax error (B) hello w (C) hello (D) o world

Last Answer : Answer: Marks given to all

The syntax of capturing events method for document object is (A) CaptureEvents() (B) CaptureEvents(Orgs eventType) (C) CaptureEvents(eventType) (D) CaptureEvents(eventVal)

Description : The syntax of capturing events method for document object is (A) CaptureEvents() (B) CaptureEvents(Orgs eventType) (C) CaptureEvents(eventType) (D) CaptureEvents(eventVal)

Last Answer : (C) CaptureEvents(eventType)

Which one of the following describes the syntax of prolog program ? I. Rules and facts are terminated by full stop (.) II. Rules and facts are terminated by semicolon (;) III. Variables names must start with upper case alphabets. IV. Variables names must start with lower case alphabets. Codes : (A) I, II (B) III, IV (C) I, III (D) II, IV

Description : Which one of the following describes the syntax of prolog program ? I. Rules and facts are terminated by full stop (.) II. Rules and facts are terminated by semicolon (;) III. Variables names must start with upper case alphabets. ... alphabets. Codes : (A) I, II (B) III, IV (C) I, III (D) II, IV

Last Answer : (C) I, III

Which phase of compiler generates stream of atoms ? (A) Syntax analysis (B) Lexical Analysis (C) Code generation (D) Code optimization

Description : Which phase of compiler generates stream of atoms ? (A) Syntax analysis (B) Lexical Analysis (C) Code generation (D) Code optimization 

Last Answer : (A) Syntax analysis

What is the output of the following program ? (Assume that the appropriate pre-processor directives are included and there is no syntax error) main() { char S[ ] = "ABCDEFGH"; printf ("%C",* (& S[3])); printf ("%s", S+4); printf ("%u", S); /* Base address of S is 1000 */ } (A) ABCDEFGH1000 (B) CDEFGH1000 (C) DDEFGHH1000 (D) DEFGH1000

Description : What is the output of the following program ? (Assume that the appropriate pre-processor directives are included and there is no syntax error) main() { char S[ ] = "ABCDEFGH"; printf ("%C",* (& ... Base address of S is 1000 */ } (A) ABCDEFGH1000 (B) CDEFGH1000 (C) DDEFGHH1000 (D) DEFGH1000

Last Answer : (D) DEFGH1000

Javascript and Java has similar name because ........... is/are true. (a) Javascripts syntax is loosely based on Java’s syntax (b) Javascript is stripped down version of Java (c) Java and Javascript are originated from Island of Java Codes : (A) (a) only (B) (a), (b) and (c) (C) (a) and (b) (D) (a) and (c)

Description : Javascript and Java has similar name because ........... is/are true. (a) Javascripts syntax is loosely based on Java's syntax (b) Javascript is stripped down version of Java (c) Java and Javascript are originated from Island of Java ... only (B) (a), (b) and (c) (C) (a) and (b) (D) (a) and (c)

Last Answer : Answer: A

A t-error correcting q-nary linear code must satisfy: Image Where M is the number of code words and X is (1) qn (2) qt (3) q-n (4) q-t

Description : A t-error correcting q-nary linear code must satisfy:  Where M is the number of code words and X is (1) qn (2) qt (3) q-n (4) q-t

Last Answer : (1) qn 

Assertion A : Paints with white lead base are not recommended for painting of iron works. Reason R : Paints with white lead base do not check rusting of iron. Select your answer according to the coding system given below: (A) Both A and R is true and, R is the correct explanation of A (B) Both A and R is true but R is not the correct explanation of A (C) A is true but R is false (D) A is false but R is true

Description : Assertion A : Paints with white lead base are not recommended for painting of iron works. Reason R : Paints with white lead base do not check rusting of iron. Select your answer according to the coding system given below: ... of A (C) A is true but R is false (D) A is false but R is true

Last Answer : Answer: Option A

The statement in SQL which allows to change the definition of a table is (A) Alter. (B) Update. (C) Create. (D) select.

Description : The statement in SQL which allows to change the definition of a table is (A) Alter. (B) Update. (C) Create. (D) select

Last Answer : (A) Alter.

An attestation engagement is one in which a CPA is engaged to: a. Assemble prospective financial statements based on the assumptions of the entity's management without expressing any Testify as an expert witness in accounting, auditing or tax matters, given certain stipulated facts. b. assurance. c. Issue a written communication expressing a conclusion about the reliability of a written assertion that is the responsibility of another party. d. Provide tax advice or prepare a tax return based on financial information the CPA has not audited or reviewed.

Description : An attestation engagement is one in which a CPA is engaged to: a. Assemble prospective financial statements based on the assumptions of the entity's management without expressing any Testify as an expert ... or prepare a tax return based on financial information the CPA has not audited or reviewed.

Last Answer : Issue a written communication expressing a conclusion about the reliability of a written assertion that is the responsibility of another party

Every postmaster or record clerk, as the case may be, should at least once in every _______, count and examine the bags of his office and satisfy himself that they are correct and in once in serviceable condition and that bags of suitable sizes are kept in stock a) Month b) Quarter c) Six month d) Year

Description : Every postmaster or record clerk, as the case may be, should at least once in every _______, count and examine the bags of his office and satisfy himself that they are correct and in once in serviceable ... that bags of suitable sizes are kept in stock a) Month b) Quarter c) Six month d) Year

Last Answer : b) Quarter

Consider the following statements regarding Coulomb’s theory of earth pressure: 1. It is based on wedge theory of earth pressure. 2. It assumes the wall surface to be rough. 3. It may or may not satisfy the static equilibrium condition occurring in nature. Which of these statements are correct? (a) 1, 2 & 3 (b) 1 & 2 only (c) 2 & 3 only (d) 1 & 3 only

Description : Consider the following statements regarding Coulomb's theory of earth pressure: 1. It is based on wedge theory of earth pressure. 2. It assumes the wall surface to be rough. 3. It may or may not satisfy the static equilibrium condition ... 1, 2 & 3 (b) 1 & 2 only (c) 2 & 3 only (d) 1 & 3 only

Last Answer : (b) 1 & 2 only

The DBMS utility, ...................... allows to reconstruct the correct state of database from the backup and history of transactions. A) Backup B) Recovery C) Monitoring D) Data loading

Description : The DBMS utility, ...................... allows to reconstruct the correct state of database from the backup and history of transactions. A) Backup B) Recovery C) Monitoring D) Data loading

Last Answer : B) Recovery

Choose the correct syntax to create an E_mail link. (a) <a href = “[emailprotected]”> -Technology

Description : Choose the correct syntax to create an E_mail link. (a) -Technology

Last Answer : (b)

Suppose you are hurriedly rushing to your school in the morning. Meanwhile your eyes go across the road, where your student met an accident. What decision will you take under this critical condition of the student> Options: A) You will go away from the accident's site in anonymity B) You reach the site, look after the student, after giving him first-aid, report to the police station and rush towards hospital C) You are escaping because you do not want to take risk unnecessarily D) You are expressing the accident as an adventurous game

Description : Suppose you are hurriedly rushing to your school in the morning. Meanwhile your eyes go across the road, where your student met an accident. What decision will you take under this critical condition ... want to take risk unnecessarily D) You are expressing the accident as an adventurous game

Last Answer : B) You reach the site, look after the student, after giving him first-aid, report to the police station and rush towards hospital

Select the ‘False’ statement from the following statements about Normal Forms: (A) Lossless preserving decomposition into 3NF is always possible (B) Lossless preserving decomposition into BCNF is always possible (C) Any relation with two attributes is in BCNF (D) BCNF is stronger than 3NF

Description : Select the ‘False’ statement from the following statements about Normal Forms: (A) Lossless preserving decomposition into 3NF is always possible (B) Lossless preserving decomposition into BCNF is always possible (C) Any relation with two attributes is in BCNF (D) BCNF is stronger than 3NF

Last Answer : (B) Lossless preserving decomposition into BCNF is always possible

What is the simple predicate for: In the back of the shed, sits a mint-condition Model T?

Description : What is the simple predicate for: In the back of the shed, sits a mint-condition Model T?

Last Answer : Simple Predicate: sits

Which of the following provides the best description of an entity type? (A) A specific concrete object with a defined set of processes (e.g. Jatin with diabetes) (B) A value given to a particular attribute (e.g. height-230 cm) (C) A thing that we wish to collect data about zero or more, possibly real world examples of it may exist. (D) A template for a group of things with the same set of characteristics that may exist in the real world

Description : Which of the following provides the best description of an entity type? (A) A specific concrete object with a defined set of processes (e.g. Jatin with diabetes) (B) A value given to a ... template for a group of things with the same set of characteristics that may exist in the real world

Last Answer : Answer: D

Assertion: Warm and moist environment can enhance the rate of decomposition Reason: Warm and moist climate leads to create anaerobic condition which p

Description : Assertion: Warm and moist environment can enhance the rate of decomposition Reason: Warm and moist climate leads to create anaerobic condition which p

Last Answer : Assertion: Warm and moist environment can enhance the rate of decomposition Reason: Warm and moist climate ... and Reason are false, then mark (4)

Which one of the following is not a definition of error ? (A) It refers to the discrepancy between a computed, observed or measured value and the true, specified or theoretically correct value. (B) It refers to the actual output of a software and the correct output. (C) It refers to a condition that causes a system to fail. (D) It refers to human action that results in software containing a defect or fault.

Description : Which one of the following is not a definition of error ? (A) It refers to the discrepancy between a computed, observed or measured value and the true, specified or theoretically correct value. (B) It ... to fail. (D) It refers to human action that results in software containing a defect or fault. 

Last Answer : The input, or clock pulse.

Let G(x) be generator polynomial used for CRC checking. The condition that should be satisfied by G(x) to correct odd numbered error bits, will be: (1) (1+x) is factor of G(x) (2) (1-x) is factor of G(x) (3) (1+x2) is factor of G(x) (4) x is factor of G(x)

Description : Let G(x) be generator polynomial used for CRC checking. The condition that should be satisfied by G(x) to correct odd numbered error bits, will be: (1) (1+x) is factor of G(x) (2) (1-x) is factor of G(x) (3) (1+x2) is factor of G(x) (4) x is factor of G(x)

Last Answer : (1+x) is factor of G(x)

The ratio of the rens digit and the units digit of a two digit number is ` 1 : 2` .How many two digit number satisfy this condition?

Description : The ratio of the rens digit and the units digit of a two digit number is ` 1 : 2` .How many two digit number satisfy this condition?

Last Answer : The ratio of the rens digit and the units digit of a two digit number is ` 1 : 2` .How many two digit number satisfy this condition?

Uniform fluid flow occurs, when the derivative of the flow variables satisfy the following condition. (A) ∂/∂t = 0 (B) ∂/∂t = constant (C) ∂/∂s = 0 (D) ∂/∂s = constant

Description : Uniform fluid flow occurs, when the derivative of the flow variables satisfy the following condition. (A) ∂/∂t = 0 (B) ∂/∂t = constant (C) ∂/∂s = 0 (D) ∂/∂s = constant

Last Answer : (C) ∂/∂s = 0

Steady fluid flow occurs, when the derivative of flow variables satisfy the following condition. (A) ∂/∂s = 0 (B) ∂/∂t = 0 (C) ∂/∂s = constant (D) ∂/∂t = constant

Description : Steady fluid flow occurs, when the derivative of flow variables satisfy the following condition. (A) ∂/∂s = 0 (B) ∂/∂t = 0 (C) ∂/∂s = constant (D) ∂/∂t = constant

Last Answer : (B) ∂/∂t = 0

What is the condition for the impulse response of FIR filter to satisfy for constant phase delay or linear phase?

Description : What is the condition for the impulse response of FIR filter to satisfy for constant phase delay or linear phase?

Last Answer : For linear phase FIR filter to have constant phase delay θ ω α ω ( ) For satisfying above condition, h(n)=h(N-1-n) i.e., the impulse response must be symmetrical about n=(N-1)/2

To be an Ordinarily resident in India, an individual must satisfy ………………………. A) Both Basic Conditions and One Additional Condition B) One Basic Condition and Both Additional Conditions C) One Basic Condition and One Additional Condition D) Both Basic Conditions and Both Additional Conditions

Description : To be an Ordinarily resident in India, an individual must satisfy ………………………. A) Both Basic Conditions and One Additional Condition B) One Basic Condition and Both Additional Conditions C) One Basic Condition and One Additional Condition D) Both Basic Conditions and Both Additional Conditions

Last Answer : B) One Basic Condition and Both Additional Conditions