Nt1310 Unit 1 Quiz

C PROGRAMMING :

1.In which header file is the NULL macro defined?
A. stdio.h B. stddef.h
C. stdio.h and stddef.h D. math.h
Ans: c

2.Which bitwise operator is suitable for turning off a particular bit in a number?
A. && operator
B. & operator
C. || operator
D. ! operator ans: b

3.What does the following declaration mean? int (*ptr)[10];
A. ptr is array of pointers to 10 integers
B. ptr is an pointer to array
C. ptr is an array of 10 integers
D. ptr is a pointer to an array of 10 integers ans: d

4. Declare the following statement?
"An array of three pointers to chars".
A. char *ptr[3]; B char *ptr[3]();
C. char (*ptr[3])();
D. char **ptr[3]; ans: a

5. What do the following declaration signify?
DROP INDEX
B. DROP INDEX
C. ALTER TABLE ....... DROP CONSTRAINT
D. DROP TABLE
Answer :D

6 . For an unconditional approach to a particular part of a complex PL/SQL block, which of the following control structures can be used?
A. If-Then-Else
B. While loop
C. GoTo
D. Decode
Answer :C

7. Select the VALID trigger type(s)?
A. AFTER statement trigger
B. INSERT row trigger
C. DELETE row trigger
D. UPDATE row trigger
Answer : A
8. For what purposes are views used? A. To hide columns only
B. To hide rows only
C. To hide complicated SQL statements only
D. All of the above are uses for SQL views.
Ans : D
9. ODBC minimum SQL grammar contains which of the following? A. INSERT, UPDATE, DELETE only
B. Stored Procedures only
C. Literals for date, time and timestamp only
D. CREATE VIEW, DROP VIEW only
Ans :A
10. A foreign key is which of the following? A. Any attribute
B. The same thing as a primary key
C. An attribute that serves as the primary key of another relation
D. An attribute that serves no purpose
Ans : c

Data Structures;

1.The postfix equivalent of the prefix * + ab - cd is ?
A. ab + cd - *
B. abcd + - *
C. ab + cd * -
d. ab + - cd