Database Management System

51) Defining the users, passwords and roles for users in a database is called?

Answer Is: (C) database administration

Explanation:

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

52) Inserting data and modifying values in database is called?

Answer Is: (C) data update

Explanation:

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

53) Which of the following SQL clauses is used to DELETE tuples from a database table ?

Answer Is: (A) Delete

Explanation:

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

54) Which of the following is large object data type ?

Answer Is: (D) image

Explanation:

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

55) How many rules in "CODD'S RULES" of Relational Model of database systems?

Answer Is: (B) 12

Explanation:

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

56) Which types of joins are used in SQL?

Answer Is: (D) All of the above

Explanation:

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

57) in MS Access, OLE Object Data type can store

Answer Is: (D) All of the Above

Explanation:

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

58) Full name of API:

Answer Is: (C) Application Programming Interface

Explanation:

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

59) ______removes all rows from a table without logging the individual row deletion,

Answer Is: (D) TRUNCATE

Explanation:

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

60) The appropriate Data Type to store Time in MS Access?

Answer Is: (A) Date/tirne

Explanation:

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

61) Full name OMG:

Answer Is: (D) Object Management Group

Explanation:

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

62) The database language that allows you to access or maintain data in a database

Answer Is: (B) DM

Explanation:

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

63) Which of the following is not conversion function?

Answer Is: (D) TRY_CASE

Explanation:

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

64) _____first proposed the process of normalization in DBMS.

Answer Is: (B) Edgar F. Codd

Explanation:

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

65) The minimal set of super key is called

Answer Is: (C) Candidate key

Explanation:

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

66) What are constraints are used in SQL?

Answer Is: (D) all of the above

Explanation:

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

67) Which of the following is not a mathematical function ?

Answer Is: (D) CEIL

Explanation:

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

68) 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.

69) Oracle, MySQL, Microsoft SQL server, MariaDB & SQLite are which type of tool.

Answer Is: (B) database management

Explanation:

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

70) The term attribute refers to a _____ of a table

Answer Is: (B) Column

Explanation:

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

71) Full name ORM:

Answer Is: (B) Object Relational Mapping

Explanation:

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

72) HSAM stands for____

Answer Is: (A) Hierarchic Sequential Access Method

Explanation:

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

73) _____is free database software running free SQL Server technology

Answer Is: (A) SOL Server Express

Explanation:

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

74) An organized collection of logically related data is known as

Answer Is: (C) Database

Explanation:

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

75) Oracle, MySQL, Microsoft SQL server are following which type of database management tool.

Answer Is: (D) professional (paid)

Explanation:

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

76) Which of the following is not a valid Data Type in MS Access?

Answer Is: (B) Picture

Explanation:

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

77) SMO in SQL Server stands for______

Answer Is: (D) SQL Server Management Object

Explanation:

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

78) Ifyou don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default

Answer Is: (A) ASC

Explanation:

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

79) Which of the following is not a DDL command?

Answer Is: (A) UPDATE

Explanation:

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

80) PostgreSQL, MariaDB and SQLite are following which type of database management tool.

Answer Is: (A) free/ open source

Explanation:

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

81) A_____in a table represents a relationship among a set of values.

Answer Is: (C) Row

Explanation:

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

82) Which of the following companies originally worked together to create and market the first version of SQL Server?

Answer Is: (D) All of the above

Explanation:

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

83) The key selected from the sets of candidate keys by database designer is called

Answer Is: (A) Primary key

Explanation:

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

84) A relational database consists of a collection of

Answer Is: (A) Tables

Explanation:

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

85) ______is not available on standard toolbar.

Answer Is: (A) Error List

Explanation:

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

86) Codename for SQL Server 2012 is____

Answer Is: (C) Denali

Explanation:

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

87) The task of arranging data in order is called

Answer Is: (B) Sorting

Explanation:

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

88) Which of the following are TCL commands?

Answer Is: (D) ROLLBACK and SAVEPOINT

Explanation:

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

89) Full name of SQL is____

Answer Is: (A) Structured Query Language

Explanation:

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

90) XQuery is which type f language?

Answer Is: (C) XML based Query

Explanation:

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

91) _____removes all rows from a table without logging the individual row deletions.

Answer Is: (D) TRUNCATE

Explanation:

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

92) Which of following is database object?

Answer Is: (D) All of the above

Explanation:

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

93) ______is a spatial data type.

Answer Is: (B) sql_ variant

Explanation:

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

94) Data types in SQL Server are organized into how many categories ?

Answer Is: (A) 6

Explanation:

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

95) _____is a classical approach to database design?

Answer Is: (C) Top – Down approach

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