Database Management System

1) Which SQL function is used to count the number of rows in a SQL query ?

Answer Is: (D) COUNT(*)

Explanation:

No answer description available for this question. Let us discuss.

2) ______is not a category of SQL command.

Answer Is: (B) SCL

Explanation:

No answer description available for this question. Let us discuss.

3) To collection, storage, manipulation, reporting and mining of available information is called?

Answer Is: (D) Database management

Explanation:

No answer description available for this question. Let us discuss.

4) Which of the following shortcut is used for displaying error list ?

Answer Is: (C) Ctrl + x

Explanation:

No answer description available for this question. Let us discuss.

5) _______function returns current date and time.

Answer Is: (D) GETDATE

Explanation:

No answer description available for this question. Let us discuss.

6) Object oriented databases are based on the concept of

Answer Is: (A) objects

Explanation:

No answer description available for this question. Let us discuss.

7) Which SQL keyword is used to sort the result-set ?

Answer Is: (A) ORDER BY

Explanation:

No answer description available for this question. Let us discuss.

8) Which of the following is not a field type in Access

Answer Is: (D) Lookup Wizard

Explanation:

No answer description available for this question. Let us discuss.

9) Who was proposed Relational database model?

Answer Is: (B) Edgar F codd

Explanation:

No answer description available for this question. Let us discuss.

10) Which of the SQL Server RTM included native support for managing XML data ?

Answer Is: (D) 9

Explanation:

No answer description available for this question. Let us discuss.

11) Which of the following is used to declare a record?

Answer Is: (A) %ROWTYPE

Explanation:

No answer description available for this question. Let us discuss.

12) Microsoft Access is a

Answer Is: (A) RDBMS

Explanation:

No answer description available for this question. Let us discuss.

13) Which of the following term is least related to database?

Answer Is: (D) Columns

Explanation:

No answer description available for this question. Let us discuss.

14) PL/SQL stands for -

Answer Is: (B) Procedural Language/SQL

Explanation:

No answer description available for this question. Let us discuss.

15) Full name RDBMS:

Answer Is: (B) Relational Data Base Management System

Explanation:

No answer description available for this question. Let us discuss.

16) When was the first version of Microsoft SQL Server released ?

Answer Is: (B) 1988

Explanation:

No answer description available for this question. Let us discuss.

17) When entering field name, how many characters you can type in maximum?

Answer Is: (B) 64

Explanation:

No answer description available for this question. Let us discuss.

18) Which is the valid data type in Access?

Answer Is: (D) All of the above

Explanation:

No answer description available for this question. Let us discuss.

19) Full name SQL:

Answer Is: (C) Structured Query Language

Explanation:

No answer description available for this question. Let us discuss.

20) Collection of related records in a database is known as

Answer Is: (C) Table

Explanation:

No answer description available for this question. Let us discuss.

21) ____is the first true GUI-based database server.

Answer Is: (A) SQL Server 7.0

Explanation:

No answer description available for this question. Let us discuss.

23) Full name DBMS:

Answer Is: (B) Database Management System

Explanation:

No answer description available for this question. Let us discuss.

24) Function cannot be used for______statement.

Answer Is: (D) Insert

Explanation:

No answer description available for this question. Let us discuss.

25) A good database table has contain which type of naming.

Answer Is: (C) unrelated

Explanation:

No answer description available for this question. Let us discuss.

26) What does DML stand for?

Answer Is: (D) Data Manipulation language

Explanation:

No answer description available for this question. Let us discuss.

27) Relational databases are…...oriente(d)

Answer Is: (D) table

Explanation:

No answer description available for this question. Let us discuss.

28) Text and Image Functions are____

Answer Is: (A) nondeterministic

Explanation:

No answer description available for this question. Let us discuss.

29) Syntax for creation of user defined function is:

Answer Is: (B) CREATE FUNCTION

Explanation:

No answer description available for this question. Let us discuss.

30) _____is not a category of SQL command.

Answer Is: (B) SCL

Explanation:

No answer description available for this question. Let us discuss.

31) Which of the following data type is used to store logical value in MS Access?

Answer Is: (C) Yes/No

Explanation:

No answer description available for this question. Let us discuss.

32) Which is not a view to display a table in Access?

Answer Is: (D) None of above

Explanation:

No answer description available for this question. Let us discuss.

33) Full name of OODB:

Answer Is: (A) Object Oriented Data Base

Explanation:

No answer description available for this question. Let us discuss.

34) Which SQL keyword is used to retrieve a maximum value ?

Answer Is: (C) MAX

Explanation:

No answer description available for this question. Let us discuss.

35) As a good practice, each user should have which type of user id and password.

Answer Is: (C) root

Explanation:

No answer description available for this question. Let us discuss.

36) The UPDATE SQL clause can

Answer Is: (B) update more than one row at a time

Explanation:

No answer description available for this question. Let us discuss.

37) In MS Access "Hyperlink" Data Type can store

Answer Is: (D) All of Above

Explanation:

No answer description available for this question. Let us discuss.

38) Which of the following function checks whether the expression is a valid date or not ?

Answer Is: (A) ISDATE

Explanation:

No answer description available for this question. Let us discuss.

39) A key that consists of more than one attribute to uniquely identify rows in a table is called

Answer Is: (A) Composite key

Explanation:

No answer description available for this question. Let us discuss.

40) To help management of information, a database contains

Answer Is: (D) all of them

Explanation:

No answer description available for this question. Let us discuss.

41) Which of the following is NOT a type of Microsoft Access database object?

Answer Is: (C) Worksheets

Explanation:

No answer description available for this question. Let us discuss.

42) Which of the following is not a database object in MS Access?

Answer Is: (D) Relationship

Explanation:

No answer description available for this question. Let us discuss.

43) What are the columns in a Microsoft Access table called?

Answer Is: (C) Fields

Explanation:

No answer description available for this question. Let us discuss.

44) Querying and selecting data from a table is called?

Answer Is: (A) data retrieval

Explanation:

No answer description available for this question. Let us discuss.

45) Full name ODMG:

Answer Is: (A) Object Data Management Group

Explanation:

No answer description available for this question. Let us discuss.

46) Which of the following is not database object ?

Answer Is: (B) Stored Procedures

Explanation:

No answer description available for this question. Let us discuss.

47) The UNION SQL clause can be used with

Answer Is: (A) SELECT clause only

Explanation:

No answer description available for this question. Let us discuss.

48) Creation and modification of databases and tables is called?

Answer Is: (D) data definition

Explanation:

No answer description available for this question. Let us discuss.

49) What do you call a primary key field included in another table

Answer Is: (A) Foreign key

Explanation:

No answer description available for this question. Let us discuss.

50) The relational database model and after that by a researcher at

Answer Is: (A) IBM

Explanation:

No answer description available for this question. Let us discuss.

Comments (0)

Leave your comment

Please enter comment.

Please enter name.
Please enter valid email address.
Please enter valid website URL.

Up