Aspire Faculty ID #18880 · Topic: UGC NET Computer Science Nov 2021 (Paper II) · Just now
UGC NET Computer Science Nov 2021 (Paper II)

 Which of the following is used to create a database schema?

Solution

Database schema means structure of database.

It includes tables, attributes, constraints and relationships.

DDL means Data Definition Language.

DDL commands like CREATE, ALTER and DROP are used to define or modify database schema.

DML is used to manipulate data, not create schema.

Previous 10 Questions — UGC NET Computer Science Nov 2021 (Paper II)

Nearest first
1
 A transaction may be in one of the following states during its execution life cycle in concurrent execution envir…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
2
A company is consuming parts in the manufacturing of other products. Each of the part is either manufactured within the…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
3
Given a relation scheme $R(x,y,z,w)$ with functional dependencies set$F=\{x\to y,\ z\to w\}$.All attributes take single…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
4
Suppose a B tree is used for indexing a database file. Consider the following information:size of the search key field …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
5
STUDENT(Rollno, Name, Courseno)COURSE(Courseno, Coursename, Capacity)where Rollno is the primary key of relation STUDEN…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
6
Given the following STUDENT-COURSE scheme:STUDENT(Rollno, Name, courseno)COURSE(courseno, coursename, capacity)where Ro…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
7
Given a fixed-length record file that is ordered on the key field. The file needs $B$ disk blocks to store $R$ number o…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
8
Consider following two statements:Statement I: Relational database schema represents the logical design of the database…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
9
Consider a domain consisting of three Boolean variables Toothache, Cavity, and Catch. The full joint distribution is a …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
10
Consider a domain consisting of three Boolean variables Toothache, Cavity, and Catch. The full joint distribution is a …
Topic: UGC NET Computer Science Nov 2021 (Paper II)

Next 10 Questions — UGC NET Computer Science Nov 2021 (Paper II)

Ascending by ID
1
Given memory access time as $p$ nanoseconds and additional $q$ nanoseconds for handling the page fault. What is the eff…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
2
In a file allocation system, the following allocation schemes are used:A. ContiguousB. IndexedC. Linked allocationWhich…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
3
Given below are three statements related to interrupt handling mechanism.A. Interrupt handler routine is not stored at …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
4
Match List I with List IIList-IList-IIA. fork()I. sends a signal from one process to particular processB. exec()II. Ind…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
5
Consider the following 3 processes with the length of the CPU burst time given in milliseconds:ProcessArrival TimeBurst…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
6
Consider a machine with $16\ GB$ main memory and $32$-bits virtual address space, with page size as $4KB$. Frame size a…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
7
Consider a machine with $16\ GB$ main memory and $32$-bits virtual address space, with page size as $4KB$. Frame size a…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
8
Consider a machine with $16\ GB$ main memory and $32$-bits virtual address space, with page size as $4KB$. Frame size a…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
9
Consider a machine with $16\ GB$ main memory and $32$-bits virtual address space, with page size as $4KB$. Frame size a…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
10
Consider a machine with $16\ GB$ main memory and $32$-bits virtual address space, with page size as $4KB$. Frame size a…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Ask Your Question or Put Your Review.

loading...