单选题You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tab

题目
单选题
You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key. You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?（）
A

CREATE TABLE student_grades (student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY student (student_id));

B

CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));

C

CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES student (student_id));

D

CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));

相似考题

1.You are developing WPF application for managing student information... btnSort and a DataGrid control named dgStudents on the design surface of the MainWindow.xaml properties : FirstName and LastName. You create the following code segment in the constructor of...The DataGrid control displays the list of students unsorted.You need to ensure that the list of students is sorted by last name.Which code segment should you add to the click event handler of the Button control？（）A.B.C.D.

2.You plan to use static database registration for a new listener when you create it.What could be the two reasons for this？（）A、More than one database is to be registered with the listener.B、The users will connect the database by using the host naming method.C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.D、The database that is to be registered with the listener is configured in shared server mode.E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

3.You need to design the retrieval of advertising statistics without compromising security. What should you do?（）A、Design a Notification Services solution that sends the advertising statistics to specified subscribers by e-mail.B、Design a SQL Server Web service that runs a stored procedure to return the statistics on a call from the advertisers application.C、Design a Database Mail solution that sends the advertising statistics to e-mail addresses that are specified in a table.D、Design a stored procedure to return the statistics on a call from the advertisers application.E、Design a user-defined function to return the statistics on a call from the advertisers application.

4.Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）A、SMON would automatically restore the lost file.B、You would need to restore the whole database from the last backup.C、You would need to restore the file from the last full database backup.D、You would need to use flashback technology to restore the lost redo log member.E、You would need to use Recovery Manager （RMAN） to restore the lost redo log member.F、You would need to restore the missing log file by copying one of the remaining files from the same group.

更多“You need to design a student registration database that cont”相关问题

  • 第1题：

    You need to design a configuration for Exchange Server storage that meets the business and technical requirements. What should you do？（）

    • A、Create a single storage group. Create one database for all users
    • B、Create two storage groups. In each storage group， create one database. Place mailboxes for remote users in one storage group database， and place all other mailboxes in the other storage group database
    • C、Create two storage groups. In each storage group， create one database. Place executive mailboxes in one storage group database， and place all other mailboxes in the other storage group database
    • D、Create two storage groups. In one storage group， create a database， and place all mailboxes for remote users and executives in the database. In the other storage group， create a database for all other mailboxes

    正确答案:C

  • 第2题：

    You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

    • A、renaming the control files
    • B、dropping a user in your database
    • C、enabling or disabling redo log archiving
    • D、dropping a tablespace in your database
    • E、re-creating the control files， after you lost all the control files in your database

    正确答案:C

  • 第3题：

    You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）

    • A、 You do not need to restore all the data files.
    • B、 You do not need to open the database with the RESETLOGS operation
    • C、 You do not need to perform a full backup after the RESETLOGS operation.
    • D、 You do not need to recover all the data files to the same system change number （SCN）.

    正确答案:C

  • 第4题：

    You need to design a strategy for managing the messages that are sent to the customer service mailboxes. What should you do？（）

    • A、Create a separate storage group and database to contain the customer service mailboxes. Enable circular logging for this storage group
    • B、Create a separate storage group and database to contain the customer service mailboxes. Set the deleted item retention period for this database to zero
    • C、Place the customer service mailboxes on a new mailbox store in the storage group that contains the main office user mailboxes. Enable circular logging for this storage group
    • D、Place the customer service mailboxes on a new mailbox store in the storage group that contains the branch office user mailboxes. Set the deleted item retention period for this database to zero

    正确答案:A

  • 第5题：

    You need to design the database permissions for access from the terminals to the database server. Which action or actions should you perform?（）

    • A、Create a database role named BankTerminals.
    • B、Grant the BankTerminals role the Execute permission for the WoodgroveBanking database.
    • C、Grant database access to the Windows Bank Terminals group， and add the group to the BankTerminals role.
    • D、Grant the BankTerminals role the Execute permission for the Bank schema.
    • E、Grant the Windows Bank Terminals group the Execute permission for the Bank schema.
    • F、Grant the BankTerminals role the Execute permission for all stored procedures and user-defined functions in the Bank schema.

    正确答案:A,C,D

  • 第6题：

    多选题
    You plan to use static database registration for a new listener when you create it.What could be the two reasons for this？（）
    A

    More than one database is to be registered with the listener.

    B

    The users will connect the database by using the host naming method.

    C

    The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.

    D

    The database that is to be registered with the listener is configured in shared server mode.

    E

    The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.


    正确答案： C,E
    解析： 暂无解析

  • 第7题：

    多选题
    You need to design the database permissions for access from the terminals to the database server. Which action or actions should you perform?（）
    A

    Create a database role named BankTerminals.

    B

    Grant the BankTerminals role the Execute permission for the WoodgroveBanking database.

    C

    Grant database access to the Windows Bank Terminals group， and add the group to the BankTerminals role.

    D

    Grant the BankTerminals role the Execute permission for the Bank schema.

    E

    Grant the Windows Bank Terminals group the Execute permission for the Bank schema.

    F

    Grant the BankTerminals role the Execute permission for all stored procedures and user-defined functions in the Bank schema.


    正确答案： B,F
    解析： 暂无解析

  • 第8题：

    单选题
    You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）
    A

     You do not need to restore all the data files.

    B

     You do not need to open the database with the RESETLOGS operation

    C

     You do not need to perform a full backup after the RESETLOGS operation.

    D

     You do not need to recover all the data files to the same system change number （SCN）.


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    You administer a SQL Server 2008 instance. You plan to deploy a new database that has the following capacity requirements: 275 GB for the database data file; 50 GB for the transaction log file. The storage array has six 100-GB disk drives available for the database. The disks are attached to a redundant array of independent disks (RAID) controller that supports RAID levels 0, 1, 5, and 10. The write performance of the transaction log needs to be maximized. The database and transaction log files must be protected in the event of a drive failure. You need to design the storage system. Which storage configuration should you use?（）
    A

    A single RAID 5 volume

    B

    A single RAID 10 volume

    C

    A RAID 0 volume and a RAID 5 volume

    D

    A RAID 1 volume and a RAID 5 volume


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）
    A

    You need to perform the restore and recover operations manually, because the backup was made manually. 

    B

    First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 

    C

    First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 

    D

    You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）
    A

     You will need to open the database with the resetlogs command.

    B

     All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.

    C

     You will use the resetlogs version of the create controlfile command.

    D

     You will use the noresetlogs version of the create controlfile command.

    E

     You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command


    正确答案： E
    解析： 暂无解析

  • 第12题：

    单选题
    You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key. You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?（）
    A

    CREATE TABLE student_grades (student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY student (student_id));

    B

    CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));

    C

    CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES student (student_id));

    D

    CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));


    正确答案： D
    解析： 暂无解析

  • 第13题：

    Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）

    • A、You need to perform the restore and recover operations manually, because the backup was made manually. 
    • B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 
    • C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 
    • D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

    正确答案:C

  • 第14题：

    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）  

    • A、 You will need to open the database with the resetlogs command.
    • B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
    • C、 You will use the resetlogs version of the create controlfile command.
    • D、 You will use the noresetlogs version of the create controlfile command.
    • E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command

    正确答案:D

  • 第15题：

    You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（） 

    • A、Create the database by using a single data file and a single log file.
    • B、Create the database by using a single data file and multiple log files.
    • C、Create the database by using a single log file and multiple filegroups.
    • D、Create the database by using a single log file and a filegroup that has multiple data files.

    正确答案:C

  • 第16题：

    You need to recommend a configuration design for the new VMs. The design must ensure that operating systems can be deployed to the new VMs. What should you include in the recommendation？（）

    • A、virtual machine queue （VMQ）
    • B、Virtual Machine Chimney
    • C、a synthetic network adapter
    • D、an emulated network adapter

    正确答案:D

  • 第17题：

    单选题
    You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do？（）
    A

    Decrease the amount of time between transaction log backups.

    B

    Configure the database to use the simple recovery model.

    C

    Configure the RECOVERY INTERVAL option to be a smaller value.

    D

    Run DBCC SHRINKFILE on the transaction log file.


    正确答案： B
    解析： 暂无解析

  • 第18题：

    单选题
    You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）
    A

    renaming the control files

    B

    dropping a user in your database

    C

    enabling or disabling redo log archiving

    D

    dropping a tablespace in your database

    E

    re-creating the control files， after you lost all the control files in your database


    正确答案： A
    解析： 暂无解析

  • 第19题：

    多选题
    You administer a SQL Server 2008 instance. You deploy a new database named Engineering. The Engineering database manages large documents that will be revised occasionally. You need to design a table structure that allows fast read access. You also need to minimize storage space requirements.  Which two actions should you perform?（）
    A

    Use NTFS file system compression on the volume.

    B

    Use row-level compression on the document table.

    C

    Use varbinary(MAX) data type with FILESTREAM storage.

    D

    Enable row-level compression on all columns that use the vardecimal() data type.


    正确答案： A,C
    解析： 暂无解析

  • 第20题：

    单选题
    You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）
    A

    Place each database in a separate instance running on SQL2.

    B

    Place each database in a separate instance running on SQL3.

    C

    Place both databases in a single instance running on SQL2.

    D

    Place both databases in a single instance running on SQL3.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    In which situation would you use static database registration for a listener（）
    A

    when multiple databases are to be registered with the listener

    B

    when DBAs need to connect remotely to start up the database instance

    C

    when users need to connect the database instance using the host naming method

    D

    when the database instance that is to be registered with the listener is configured in shared server mode


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility （LSNRCTL） would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications？（）
    A

    START

    B

    RELOAD

    C

    RESTART

    D

    REFRESH

    E

    START L1

    F

    RELOAD L1

    G

    RESTART L1

    H

    REFRESH L1


    正确答案： H
    解析： 暂无解析

  • 第23题：

    单选题
    You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table. Which set of statements accomplishes this? （）
    A

    CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

    B

    CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

    C

    CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3

    D

    CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;

    E

    CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;


    正确答案： D
    解析： 暂无解析

  • 第24题：

    多选题
    You work as a database administrator for Certkiller .com. Your listener process， L1，is currently listening to three databases：CertK INDB04，Certkiller DB05 and Certkiller DB06. Using Database Configuration Assistant （DBCA） you create one more database，Certkiller DB07，and enable dynamic registration.  Which two commands of Listener Control Utility （lsnrct1） would you use to determine whether the dynamic registration occurred for the database， Certkiller DB07， with the L1 listener process？（）
    A

    SHOW L1

    B

    SPAWN L1

    C

    STATUS L1

    D

    SERVICES L1

    E

    STATUS LISTENER

    F

    SERVICES LISTENER

    G

    SHOWcurrent_listener


    正确答案： B,G
    解析： 暂无解析

相关内容